3dtopos to survexpos + comments

1 files changed, 544 insertions, 0 deletions

diff --git a/troggle-inspectdb.py b/troggle-inspectdb.py
index e77c5d9..266077a 100644
--- a/troggle-inspectdb.py
+++ b/troggle-inspectdb.py
@@ -1,9 +1,12 @@
 *  importing troggle/settings.py
  * importing troggle/localsettings.py
+ + finished importing troggle/localsettings.py
 +  finished importing troggle/settings.py
 *  importing troggle/settings.py
 +  finished importing troggle/settings.py
 ** importing troggle/core/views_other.py
+ -  newFile() is next in troggle/core/views_other.py
+** Finished importing troggle/core/views_other.py
 # This is an auto-generated Django model module.
 # You'll have to do the following manually to clean this up:
 #   * Rearrange models' order
@@ -14,3 +17,544 @@
 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 CoreScansfolder(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 CoreSinglescan(models.Model):
+    id = models.IntegerField(primary_key=True)  # AutoField?
+    ffile = models.CharField(max_length=200)
+    name = models.CharField(max_length=200)
+    scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING, blank=True, null=True)
+
+    class Meta:
+        managed = False
+        db_table = 'core_singlescan'
+
+
+class CoreSurvexblock(models.Model):
+    id = models.IntegerField(primary_key=True)  # AutoField?
+    name = models.CharField(max_length=100)
+    title = 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)
+    legslength = 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)
+    scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING, blank=True, null=True)
+    survexfile = models.ForeignKey('CoreSurvexfile', 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'
+# 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
+# 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'
+
+
+class CoreTunnelfileManyscansfolders(models.Model):
+    id = models.IntegerField(primary_key=True)  # AutoField?
+    tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING)
+    scansfolder = models.ForeignKey(CoreScansfolder, models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'core_tunnelfile_manyscansfolders'
+        unique_together = (('tunnelfile', 'scansfolder'),)
+
+
+class CoreTunnelfileScans(models.Model):
+    id = models.IntegerField(primary_key=True)  # AutoField?
+    tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING)
+    singlescan = models.ForeignKey(CoreSinglescan, models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'core_tunnelfile_scans'
+        unique_together = (('tunnelfile', 'singlescan'),)
+
+
+class CoreTunnelfileSurvexfiles(models.Model):
+    id = models.IntegerField(primary_key=True)  # AutoField?
+    tunnelfile = models.ForeignKey(CoreTunnelfile, models.DO_NOTHING)
+    survexfile = models.ForeignKey('CoreSurvexfile', models.DO_NOTHING)
+
+    class Meta:
+        managed = False
+        db_table = 'core_tunnelfile_survexfiles'
+        unique_together = (('tunnelfile', 'survexfile'),)
+
+
+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'