diff options
Diffstat (limited to 'troggle-inspectdb.py')
| -rw-r--r-- | troggle-inspectdb.py | 553 |
1 files changed, 0 insertions, 553 deletions
diff --git a/troggle-inspectdb.py b/troggle-inspectdb.py index a605324..c7a2514 100644 --- a/troggle-inspectdb.py +++ b/troggle-inspectdb.py @@ -15,556 +15,3 @@ from __future__ import unicode_literals from django.db import models - - -class AuthGroup(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - name = models.CharField(unique=True, max_length=80) - - class Meta: - managed = False - db_table = 'auth_group' -# Unable to inspect table 'auth_group_permissions' -# The error was: list index out of range - - -class AuthPermission(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING) - codename = models.CharField(max_length=100) - name = models.CharField(max_length=255) - - class Meta: - managed = False - db_table = 'auth_permission' - unique_together = (('content_type', 'codename'),) - - -class AuthUser(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - password = models.CharField(max_length=128) - last_login = models.DateTimeField(blank=True, null=True) - is_superuser = models.BooleanField() - first_name = models.CharField(max_length=30) - last_name = models.CharField(max_length=30) - email = models.CharField(max_length=254) - is_staff = models.BooleanField() - is_active = models.BooleanField() - date_joined = models.DateTimeField() - username = models.CharField(unique=True, max_length=150) - - class Meta: - managed = False - db_table = 'auth_user' -# Unable to inspect table 'auth_user_groups' -# The error was: list index out of range -# Unable to inspect table 'auth_user_user_permissions' -# The error was: list index out of range - - -class CoreArea(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - short_name = models.CharField(max_length=100) - name = models.CharField(max_length=200, blank=True, null=True) - description = models.TextField(blank=True, null=True) - parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_area' - - -class CoreCave(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - official_name = models.CharField(max_length=160) - kataster_code = models.CharField(max_length=20, blank=True, null=True) - kataster_number = models.CharField(max_length=10, blank=True, null=True) - unofficial_number = models.CharField(max_length=60, blank=True, null=True) - explorers = models.TextField(blank=True, null=True) - underground_description = models.TextField(blank=True, null=True) - equipment = models.TextField(blank=True, null=True) - references = models.TextField(blank=True, null=True) - survey = models.TextField(blank=True, null=True) - kataster_status = models.TextField(blank=True, null=True) - underground_centre_line = models.TextField(blank=True, null=True) - notes = models.TextField(blank=True, null=True) - length = models.CharField(max_length=100, blank=True, null=True) - depth = models.CharField(max_length=100, blank=True, null=True) - extent = models.CharField(max_length=100, blank=True, null=True) - survex_file = models.CharField(max_length=100, blank=True, null=True) - description_file = models.CharField(max_length=200, blank=True, null=True) - url = models.CharField(max_length=200, blank=True, null=True) - filename = models.CharField(max_length=200) - - class Meta: - managed = False - db_table = 'core_cave' - - -class CoreCaveArea(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - area = models.ForeignKey(CoreArea, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cave_area' - unique_together = (('cave', 'area'),) - - -class CoreCaveandentrance(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - entrance_letter = models.CharField(max_length=20, blank=True, null=True) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - entrance = models.ForeignKey('CoreEntrance', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_caveandentrance' - - -class CoreCavedescription(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - short_name = models.CharField(unique=True, max_length=50) - long_name = models.CharField(max_length=200, blank=True, null=True) - description = models.TextField(blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_cavedescription' - - -class CoreCavedescriptionLinkedEntrances(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - entrance = models.ForeignKey('CoreEntrance', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_entrances' - unique_together = (('cavedescription', 'entrance'),) - - -class CoreCavedescriptionLinkedQms(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - qm = models.ForeignKey('CoreQm', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_qms' - unique_together = (('cavedescription', 'qm'),) - - -class CoreCavedescriptionLinkedSubcaves(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - cavedescription = models.ForeignKey(CoreCavedescription, models.DO_NOTHING) - newsubcave = models.ForeignKey('CoreNewsubcave', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_cavedescription_linked_subcaves' - unique_together = (('cavedescription', 'newsubcave'),) - - -class CoreCaveslug(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - slug = models.CharField(unique=True, max_length=50) - primary = models.BooleanField() - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_caveslug' - - -class CoreDataissue(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - date = models.DateTimeField() - parser = models.CharField(max_length=50, blank=True, null=True) - message = models.CharField(max_length=400, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_dataissue' - - -class CoreEntrance(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - name = models.CharField(max_length=100, blank=True, null=True) - entrance_description = models.TextField(blank=True, null=True) - explorers = models.TextField(blank=True, null=True) - map_description = models.TextField(blank=True, null=True) - location_description = models.TextField(blank=True, null=True) - approach = models.TextField(blank=True, null=True) - underground_description = models.TextField(blank=True, null=True) - photo = models.TextField(blank=True, null=True) - marking = models.CharField(max_length=2) - marking_comment = models.TextField(blank=True, null=True) - findability = models.CharField(max_length=1, blank=True, null=True) - findability_description = models.TextField(blank=True, null=True) - alt = models.TextField(blank=True, null=True) - northing = models.TextField(blank=True, null=True) - easting = models.TextField(blank=True, null=True) - tag_station = models.TextField(blank=True, null=True) - exact_station = models.TextField(blank=True, null=True) - other_station = models.TextField(blank=True, null=True) - other_description = models.TextField(blank=True, null=True) - bearings = models.TextField(blank=True, null=True) - url = models.CharField(max_length=200, blank=True, null=True) - filename = models.CharField(max_length=200) - cached_primary_slug = models.CharField(max_length=200, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_entrance' - - -class CoreEntranceslug(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - slug = models.CharField(unique=True, max_length=50) - primary = models.BooleanField() - entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_entranceslug' - - -class CoreExpedition(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - year = models.CharField(unique=True, max_length=20) - name = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'core_expedition' - - -class CoreExpeditionday(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - date = models.DateField() - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_expeditionday' - - -class CoreLogbookentry(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - date = models.DateField() - title = models.CharField(max_length=200) - cave_slug = models.CharField(max_length=50, blank=True, null=True) - place = models.CharField(max_length=100, blank=True, null=True) - text = models.TextField() - slug = models.CharField(max_length=50) - filename = models.CharField(max_length=200, blank=True, null=True) - entry_type = models.CharField(max_length=50, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING, blank=True, null=True) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_logbookentry' - - -class CoreNewsubcave(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - name = models.CharField(unique=True, max_length=200) - - class Meta: - managed = False - db_table = 'core_newsubcave' - - -class CoreOthercavename(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - name = models.CharField(max_length=160) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_othercavename' - - -class CorePerson(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - first_name = models.CharField(max_length=100) - last_name = models.CharField(max_length=100) - fullname = models.CharField(max_length=200) - is_vfho = models.BooleanField() - mug_shot = models.CharField(max_length=100, blank=True, null=True) - blurb = models.TextField(blank=True, null=True) - orderref = models.CharField(max_length=200) - user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_person' - - -class CorePersonexpedition(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - slugfield = models.CharField(max_length=50, blank=True, null=True) - is_guest = models.BooleanField() - expo_committee_position = models.CharField(max_length=200, blank=True, null=True) - nickname = models.CharField(max_length=100, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING) - person = models.ForeignKey(CorePerson, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_personexpedition' - - -class CorePersontrip(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - time_underground = models.FloatField() - is_logbook_entry_author = models.BooleanField() - logbook_entry = models.ForeignKey(CoreLogbookentry, models.DO_NOTHING) - personexpedition = models.ForeignKey(CorePersonexpedition, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_persontrip' - - -class CoreQm(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - new_since_parsing = models.BooleanField() - non_public = models.BooleanField() - number = models.IntegerField() - grade = models.CharField(max_length=1) - location_description = models.TextField() - nearest_station_description = models.CharField(max_length=400, blank=True, null=True) - nearest_station_name = models.CharField(max_length=200, blank=True, null=True) - area = models.CharField(max_length=100, blank=True, null=True) - completion_description = models.TextField(blank=True, null=True) - comment = models.TextField(blank=True, null=True) - found_by = models.ForeignKey(CoreLogbookentry, models.DO_NOTHING, blank=True, null=True) - nearest_station = models.ForeignKey('CoreSurvexstation', models.DO_NOTHING, blank=True, null=True) - ticked_off_by = models.ForeignKey(CoreLogbookentry, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_qm' - - -class CoreSurvexblock(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - name = models.CharField(max_length=100) - date = models.DateField(blank=True, null=True) - survexpath = models.CharField(max_length=200) - legsall = models.IntegerField(blank=True, null=True) - legssplay = models.IntegerField(blank=True, null=True) - legssurfc = models.IntegerField(blank=True, null=True) - totalleglength = models.FloatField(blank=True, null=True) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING, blank=True, null=True) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - survexfile = models.ForeignKey('CoreSurvexfile', models.DO_NOTHING, blank=True, null=True) - scansfolder = models.ForeignKey('CoreSurvexscansfolder', models.DO_NOTHING, blank=True, null=True) - parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexblock' - - -class CoreSurvexdirectory(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - path = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - primarysurvexfile = models.ForeignKey('CoreSurvexfile', models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexdirectory' - - -class CoreSurvexequate(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexequate' -# Unable to inspect table 'core_survexfile' -# The error was: list index out of range -# Unable to inspect table 'core_survexpersonrole' -# The error was: list index out of range - - -class CoreSurvexscansfolder(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - fpath = models.CharField(max_length=200) - walletname = models.CharField(max_length=200) - - class Meta: - managed = False - db_table = 'core_scansfolder' - - -class CoreSurvexscansingle(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - ffile = models.CharField(max_length=200) - name = models.CharField(max_length=200) - scansfolder = models.ForeignKey(CoreSurvexscansfolder, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexscansingle' -# Unable to inspect table 'core_survexstation' -# The error was: list index out of range -# Unable to inspect table 'core_survextitle' -# The error was: list index out of range - - -class CoreTunnelfile(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - tunnelpath = models.CharField(max_length=200) - tunnelname = models.CharField(max_length=200) - bfontcolours = models.BooleanField() - filesize = models.IntegerField() - npaths = models.IntegerField() - - class Meta: - managed = False - db_table = 'core_tunnelfile' -# Unable to inspect table 'core_tunnelfile_survexblocks' -# The error was: list index out of range - - -class CoreTunnelfileSurvexscans(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - survexscansingle = models.ForeignKey(CoreSurvexscansingle, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_survexscans' - unique_together = (('tunnelfile', 'survexscansingle'),) - - -class CoreTunnelfileSurvexscansfolders(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - scansfolder = models.ForeignKey(CoreSurvexscansfolder, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_scansfolders' - unique_together = (('tunnelfile', 'scansfolder'),) - - -class CoreTunnelfileSurvextitles(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - survextitle = models.ForeignKey('CoreSurvextitle', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_survextitles' - unique_together = (('tunnelfile', 'survextitle'),) - - -class CoreTunnelfileTunnelcontains(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - from_tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - to_tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_tunnelfile_tunnelcontains' - unique_together = (('from_tunnelfile', 'to_tunnelfile'),) -# Unable to inspect table 'django_admin_log' -# The error was: list index out of range - - -class DjangoContentType(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - app_label = models.CharField(max_length=100) - model = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'django_content_type' - unique_together = (('app_label', 'model'),) - - -class DjangoMigrations(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - app = models.CharField(max_length=255) - name = models.CharField(max_length=255) - applied = models.DateTimeField() - - class Meta: - managed = False - db_table = 'django_migrations' - - -class DjangoSession(models.Model): - session_key = models.CharField(primary_key=True, max_length=40) - session_data = models.TextField() - expire_date = models.DateTimeField() - - class Meta: - managed = False - db_table = 'django_session' - - -class FlatpagesEntranceredirect(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - originalurl = models.CharField(db_column='originalURL', max_length=200) # Field name made lowercase. - entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'flatpages_entranceredirect' - - -class FlatpagesRedirect(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - originalurl = models.CharField(db_column='originalURL', unique=True, max_length=200) # Field name made lowercase. - newurl = models.CharField(db_column='newURL', max_length=200) # Field name made lowercase. - - class Meta: - managed = False - db_table = 'flatpages_redirect' - - -class RegistrationRegistrationprofile(models.Model): - id = models.IntegerField(primary_key=True) # AutoField? - activation_key = models.CharField(max_length=40) - user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True) - - class Meta: - managed = False - db_table = 'registration_registrationprofile' |