diff options
| -rw-r--r-- | core/migrations/0001_initial.py | 456 | ||||
| -rw-r--r-- | flatpages/migrations/0001_initial.py | 34 | ||||
| -rw-r--r-- | lines-of-python.txt | 54 | ||||
| -rw-r--r-- | troggle-inspectdb.py | 595 |
4 files changed, 0 insertions, 1139 deletions
diff --git a/core/migrations/0001_initial.py b/core/migrations/0001_initial.py deleted file mode 100644 index 7e5aa0f..0000000 --- a/core/migrations/0001_initial.py +++ /dev/null @@ -1,456 +0,0 @@ -# -*- coding: utf-8 -*- -# Generated by Django 1.11.29 on 2020-07-20 22:29 -from __future__ import unicode_literals - -from django.conf import settings -from django.db import migrations, models -import django.db.models.deletion - - -class Migration(migrations.Migration): - - initial = True - - dependencies = [ - migrations.swappable_dependency(settings.AUTH_USER_MODEL), - ] - - operations = [ - migrations.CreateModel( - name='Area', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('short_name', models.CharField(max_length=100)), - ('name', models.CharField(blank=True, max_length=200, null=True)), - ('description', models.TextField(blank=True, null=True)), - ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Area')), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='Cave', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('official_name', models.CharField(max_length=160)), - ('kataster_code', models.CharField(blank=True, max_length=20, null=True)), - ('kataster_number', models.CharField(blank=True, max_length=10, null=True)), - ('unofficial_number', models.CharField(blank=True, max_length=60, 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(blank=True, max_length=100, null=True)), - ('depth', models.CharField(blank=True, max_length=100, null=True)), - ('extent', models.CharField(blank=True, max_length=100, null=True)), - ('survex_file', models.CharField(blank=True, max_length=100, null=True)), - ('description_file', models.CharField(blank=True, max_length=200, null=True)), - ('url', models.CharField(blank=True, max_length=200, null=True)), - ('filename', models.CharField(max_length=200)), - ('area', models.ManyToManyField(blank=True, to='core.Area')), - ], - options={ - 'ordering': ('kataster_code', 'unofficial_number'), - }, - ), - migrations.CreateModel( - name='CaveAndEntrance', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('entrance_letter', models.CharField(blank=True, max_length=20, null=True)), - ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')), - ], - ), - migrations.CreateModel( - name='CaveDescription', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('short_name', models.CharField(max_length=50, unique=True)), - ('long_name', models.CharField(blank=True, max_length=200, null=True)), - ('description', models.TextField(blank=True, null=True)), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='CaveSlug', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('slug', models.SlugField(unique=True)), - ('primary', models.BooleanField(default=False)), - ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')), - ], - ), - migrations.CreateModel( - name='DataIssue', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('date', models.DateTimeField(auto_now_add=True)), - ('parser', models.CharField(blank=True, max_length=50, null=True)), - ('message', models.CharField(blank=True, max_length=400, null=True)), - ], - options={ - 'ordering': ['date'], - }, - ), - migrations.CreateModel( - name='Entrance', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('name', models.CharField(blank=True, max_length=100, 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(choices=[('P', 'Paint'), ('P?', 'Paint (?)'), ('T', 'Tag'), ('T?', 'Tag (?)'), ('R', 'Needs Retag'), ('S', 'Spit'), ('S?', 'Spit (?)'), ('U', 'Unmarked'), ('?', 'Unknown')], max_length=2)), - ('marking_comment', models.TextField(blank=True, null=True)), - ('findability', models.CharField(blank=True, choices=[('?', 'To be confirmed ...'), ('S', 'Coordinates'), ('L', 'Lost'), ('R', 'Refindable')], max_length=1, 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(blank=True, max_length=200, null=True)), - ('filename', models.CharField(max_length=200)), - ('cached_primary_slug', models.CharField(blank=True, max_length=200, null=True)), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='EntranceSlug', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('slug', models.SlugField(unique=True)), - ('primary', models.BooleanField(default=False)), - ('entrance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Entrance')), - ], - ), - migrations.CreateModel( - name='Expedition', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('year', models.CharField(max_length=20, unique=True)), - ('name', models.CharField(max_length=100)), - ], - options={ - 'ordering': ('-year',), - 'get_latest_by': 'year', - }, - ), - migrations.CreateModel( - name='ExpeditionDay', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('date', models.DateField()), - ('expedition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')), - ], - options={ - 'ordering': ('date',), - }, - ), - migrations.CreateModel( - name='LogbookEntry', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('date', models.DateField()), - ('title', models.CharField(max_length=200)), - ('cave_slug', models.SlugField(blank=True, null=True)), - ('place', models.CharField(blank=True, help_text="Only use this if you haven't chosen a cave", max_length=100, null=True)), - ('text', models.TextField()), - ('slug', models.SlugField()), - ('filename', models.CharField(max_length=200, null=True)), - ('entry_type', models.CharField(choices=[('wiki', 'Wiki style logbook'), ('html', 'Html style logbook')], default='wiki', max_length=50, null=True)), - ('expedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Expedition')), - ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.ExpeditionDay')), - ], - options={ - 'verbose_name_plural': 'Logbook Entries', - 'ordering': ('-date',), - }, - ), - migrations.CreateModel( - name='NewSubCave', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('name', models.CharField(max_length=200, unique=True)), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='OtherCaveName', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('name', models.CharField(max_length=160)), - ('cave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Cave')), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='Person', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('first_name', models.CharField(max_length=100)), - ('last_name', models.CharField(max_length=100)), - ('fullname', models.CharField(max_length=200)), - ('is_vfho', models.BooleanField(default=False, help_text='VFHO is the Vereines für Höhlenkunde in Obersteier, a nearby Austrian caving club.')), - ('mug_shot', models.CharField(blank=True, max_length=100, null=True)), - ('blurb', models.TextField(blank=True, null=True)), - ('orderref', models.CharField(max_length=200)), - ('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)), - ], - options={ - 'verbose_name_plural': 'People', - 'ordering': ('orderref',), - }, - ), - migrations.CreateModel( - name='PersonExpedition', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('slugfield', models.SlugField(blank=True, null=True)), - ('is_guest', models.BooleanField(default=False)), - ('expo_committee_position', models.CharField(blank=True, choices=[('leader', 'Expo leader'), ('medical', 'Expo medical officer'), ('treasurer', 'Expo treasurer'), ('sponsorship', 'Expo sponsorship coordinator'), ('research', 'Expo research coordinator')], max_length=200, null=True)), - ('nickname', models.CharField(blank=True, max_length=100, null=True)), - ('expedition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Expedition')), - ('person', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Person')), - ], - options={ - 'ordering': ('-expedition',), - }, - ), - migrations.CreateModel( - name='PersonTrip', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('time_underground', models.FloatField(help_text='In decimal hours')), - ('is_logbook_entry_author', models.BooleanField(default=False)), - ('logbook_entry', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.LogbookEntry')), - ('personexpedition', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='core.PersonExpedition')), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='QM', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('new_since_parsing', models.BooleanField(default=False, editable=False)), - ('non_public', models.BooleanField(default=False)), - ('number', models.IntegerField(help_text='this is the sequential number in the year')), - ('grade', models.CharField(choices=[('A', 'A: Large obvious lead'), ('B', 'B: Average lead'), ('C', 'C: Tight unpromising lead'), ('D', 'D: Dig'), ('X', 'X: Unclimbable aven')], max_length=1)), - ('location_description', models.TextField(blank=True)), - ('nearest_station_description', models.CharField(blank=True, max_length=400, null=True)), - ('nearest_station_name', models.CharField(blank=True, max_length=200, null=True)), - ('area', models.CharField(blank=True, max_length=100, null=True)), - ('completion_description', models.TextField(blank=True, null=True)), - ('comment', models.TextField(blank=True, null=True)), - ('found_by', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='QMs_found', to='core.LogbookEntry')), - ], - options={ - 'abstract': False, - }, - ), - migrations.CreateModel( - name='ScansFolder', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('fpath', models.CharField(max_length=200)), - ('walletname', models.CharField(max_length=200)), - ], - options={ - 'ordering': ('walletname',), - }, - ), - migrations.CreateModel( - name='SingleScan', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('ffile', models.CharField(max_length=200)), - ('name', models.CharField(max_length=200)), - ('scansfolder', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.ScansFolder')), - ], - options={ - 'ordering': ('name',), - }, - ), - migrations.CreateModel( - name='SurvexBlock', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('name', models.CharField(max_length=100)), - ('title', models.CharField(max_length=200)), - ('date', models.DateField(blank=True, null=True)), - ('survexpath', models.CharField(max_length=200)), - ('legsall', models.IntegerField(null=True)), - ('legslength', models.FloatField(null=True)), - ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Cave')), - ('expedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Expedition')), - ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.ExpeditionDay')), - ('parent', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexBlock')), - ('scansfolder', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.ScansFolder')), - ], - options={ - 'ordering': ('id',), - }, - ), - migrations.CreateModel( - name='SurvexDirectory', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('path', models.CharField(max_length=200)), - ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Cave')), - ], - options={ - 'ordering': ('id',), - }, - ), - migrations.CreateModel( - name='SurvexFile', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('path', models.CharField(max_length=200)), - ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Cave')), - ('survexdirectory', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexDirectory')), - ], - options={ - 'ordering': ('id',), - }, - ), - migrations.CreateModel( - name='SurvexPersonRole', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('nrole', models.CharField(blank=True, choices=[('insts', 'Instruments'), ('dog', 'Other'), ('notes', 'Notes'), ('pics', 'Pictures'), ('tape', 'Tape measure'), ('useless', 'Useless'), ('helper', 'Helper'), ('disto', 'Disto'), ('consultant', 'Consultant')], max_length=200, null=True)), - ('personname', models.CharField(max_length=100)), - ('expeditionday', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.ExpeditionDay')), - ('person', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Person')), - ('personexpedition', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.PersonExpedition')), - ('persontrip', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.PersonTrip')), - ('survexblock', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.SurvexBlock')), - ], - ), - migrations.CreateModel( - name='SurvexStation', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('name', models.CharField(max_length=100)), - ('x', models.FloatField(blank=True, null=True)), - ('y', models.FloatField(blank=True, null=True)), - ('z', models.FloatField(blank=True, null=True)), - ('block', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexBlock')), - ], - ), - migrations.CreateModel( - name='SurvexTitle', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('title', models.CharField(max_length=200)), - ('cave', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.Cave')), - ('survexblock', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexBlock')), - ], - ), - migrations.CreateModel( - name='TunnelFile', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('tunnelpath', models.CharField(max_length=200)), - ('tunnelname', models.CharField(max_length=200)), - ('bfontcolours', models.BooleanField(default=False)), - ('filesize', models.IntegerField(default=0)), - ('npaths', models.IntegerField(default=0)), - ('manyscansfolders', models.ManyToManyField(to='core.ScansFolder')), - ('scans', models.ManyToManyField(to='core.SingleScan')), - ('survexfiles', models.ManyToManyField(to='core.SurvexFile')), - ('tunnelcontains', models.ManyToManyField(to='core.TunnelFile')), - ], - options={ - 'ordering': ('tunnelpath',), - }, - ), - migrations.AddField( - model_name='survexdirectory', - name='primarysurvexfile', - field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='primarysurvexfile', to='core.SurvexFile'), - ), - migrations.AddField( - model_name='survexblock', - name='survexfile', - field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexFile'), - ), - migrations.AddField( - model_name='qm', - name='nearest_station', - field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='core.SurvexStation'), - ), - migrations.AddField( - model_name='qm', - name='ticked_off_by', - field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='QMs_ticked_off', to='core.LogbookEntry'), - ), - migrations.AddField( - model_name='cavedescription', - name='linked_entrances', - field=models.ManyToManyField(blank=True, to='core.Entrance'), - ), - migrations.AddField( - model_name='cavedescription', - name='linked_qms', - field=models.ManyToManyField(blank=True, to='core.QM'), - ), - migrations.AddField( - model_name='cavedescription', - name='linked_subcaves', - field=models.ManyToManyField(blank=True, to='core.NewSubCave'), - ), - migrations.AddField( - model_name='caveandentrance', - name='entrance', - field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Entrance'), - ), - ] diff --git a/flatpages/migrations/0001_initial.py b/flatpages/migrations/0001_initial.py deleted file mode 100644 index e521a5a..0000000 --- a/flatpages/migrations/0001_initial.py +++ /dev/null @@ -1,34 +0,0 @@ -# -*- coding: utf-8 -*- -# Generated by Django 1.11.29 on 2020-07-20 22:29 -from __future__ import unicode_literals - -from django.db import migrations, models -import django.db.models.deletion - - -class Migration(migrations.Migration): - - initial = True - - dependencies = [ - ('core', '0001_initial'), - ] - - operations = [ - migrations.CreateModel( - name='EntranceRedirect', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('originalURL', models.CharField(max_length=200)), - ('entrance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Entrance')), - ], - ), - migrations.CreateModel( - name='Redirect', - fields=[ - ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), - ('originalURL', models.CharField(max_length=200, unique=True)), - ('newURL', models.CharField(max_length=200)), - ], - ), - ] diff --git a/lines-of-python.txt b/lines-of-python.txt deleted file mode 100644 index 4e6fe45..0000000 --- a/lines-of-python.txt +++ /dev/null @@ -1,54 +0,0 @@ -4 ./core/context.py -4 ./flatpages/admin.py -6 ./core/templatetags/link.py -6 ./core/views.py -8 ./core/templatetags/csrffaker.py -10 ./flatpages/models.py -10 ./wsgi.py -14 ./helper/__init__.py -16 ./manage.py -26 ./core/management/commands/reset_db.py -26 ./export/toqms.py -33 ./localsettingswindows.py -37 ./localsettingsubuntu.py -38 ./profiles/urls.py -38 ./profiles/utils.py -39 ./localsettingsdocker.py -39 ./localsettingsserver.py -41 ./localsettingspotatohut.py -43 ./middleware.py -48 ./core/templatetags/survex_markup.py -48 ./parsers/imports.py -48 ./parsers/subcaves.py -54 ./dump.py -58 ./reset-django.py -69 ./logbooksdump.py -73 ./localsettings.py -73 ./settings.py -77 ./core/views_statistics.py -79 ./urls.py -82 ./localsettingsWSL.py -97 ./core/forms.py -97 ./core/view_surveys.py -98 ./core/admin.py -102 ./parsers/people.py -105 ./parsers/QMs.py -108 ./core/TESTS/tests.py -124 ./core/templatetags/wiki_markup.py -142 ./core/models_survex.py -148 ./parsers/surveys.py -153 ./utils.py -164 ./flatpages/views.py -164 ./modelviz.py -170 ./core/models.py -181 ./core/views_other.py -190 ./core/views_logbooks.py -247 ./parsers/caves.py -262 ./core/views_survex.py -276 ./profiles/views.py -309 ./databaseReset.py -401 ./core/views_caves.py -497 ./parsers/logbooks.py -593 ./core/models_caves.py -1059 ./parsers/survex.py -6873 diff --git a/troggle-inspectdb.py b/troggle-inspectdb.py deleted file mode 100644 index 4c3d1dc..0000000 --- a/troggle-inspectdb.py +++ /dev/null @@ -1,595 +0,0 @@ -* importing troggle/settings.py - * 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 -# * Make sure each model has one field with primary_key=True -# * Make sure each ForeignKey has `on_delete` set to the desired behavior. -# * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table -# Feel free to rename the models, but don't rename db_table values or field names. -from __future__ import unicode_literals - -from django.db import models - - -class AuthGroup(models.Model): - name = models.CharField(unique=True, max_length=80) - - class Meta: - managed = False - db_table = 'auth_group' - - -class AuthGroupPermissions(models.Model): - group = models.ForeignKey(AuthGroup, models.DO_NOTHING) - permission = models.ForeignKey('AuthPermission', models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_group_permissions' - unique_together = (('group', 'permission'),) - - -class AuthPermission(models.Model): - name = models.CharField(max_length=255) - content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING) - codename = models.CharField(max_length=100) - - class Meta: - managed = False - db_table = 'auth_permission' - unique_together = (('content_type', 'codename'),) - - -class AuthUser(models.Model): - password = models.CharField(max_length=128) - last_login = models.DateTimeField(blank=True, null=True) - is_superuser = models.IntegerField() - username = models.CharField(unique=True, max_length=150) - first_name = models.CharField(max_length=30) - last_name = models.CharField(max_length=30) - email = models.CharField(max_length=254) - is_staff = models.IntegerField() - is_active = models.IntegerField() - date_joined = models.DateTimeField() - - class Meta: - managed = False - db_table = 'auth_user' - - -class AuthUserGroups(models.Model): - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - group = models.ForeignKey(AuthGroup, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_user_groups' - unique_together = (('user', 'group'),) - - -class AuthUserUserPermissions(models.Model): - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - permission = models.ForeignKey(AuthPermission, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'auth_user_user_permissions' - unique_together = (('user', 'permission'),) - - -class CoreArea(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - 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): - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - 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): - 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): - 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): - slug = models.CharField(unique=True, max_length=50) - primary = models.IntegerField() - cave = models.ForeignKey(CoreCave, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_caveslug' - - -class CoreDataissue(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - slug = models.CharField(unique=True, max_length=50) - primary = models.IntegerField() - entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_entranceslug' - - -class CoreExpedition(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - date = models.DateField() - expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_expeditionday' - - -class CoreLogbookentry(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - name = models.CharField(unique=True, max_length=200) - - class Meta: - managed = False - db_table = 'core_newsubcave' - - -class CoreOthercavename(models.Model): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - first_name = models.CharField(max_length=100) - last_name = models.CharField(max_length=100) - fullname = models.CharField(max_length=200) - is_vfho = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - slugfield = models.CharField(max_length=50, blank=True, null=True) - is_guest = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - time_underground = models.FloatField() - is_logbook_entry_author = models.IntegerField() - 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): - new_since_parsing = models.IntegerField() - non_public = models.IntegerField() - 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): - fpath = models.CharField(max_length=200) - walletname = models.CharField(max_length=200) - - class Meta: - managed = False - db_table = 'core_scansfolder' - - -class CoreSinglescan(models.Model): - 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): - name = models.CharField(max_length=100) - title = models.CharField(max_length=200) - 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) - parent = models.ForeignKey('self', 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) - - class Meta: - managed = False - db_table = 'core_survexblock' - - -class CoreSurvexdirectory(models.Model): - 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 CoreSurvexfile(models.Model): - path = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - survexdirectory = models.ForeignKey(CoreSurvexdirectory, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexfile' - - -class CoreSurvexpersonrole(models.Model): - nrole = models.CharField(max_length=200, blank=True, null=True) - personname = models.CharField(max_length=100) - expeditionday = models.ForeignKey(CoreExpeditionday, models.DO_NOTHING, blank=True, null=True) - person = models.ForeignKey(CorePerson, models.DO_NOTHING, blank=True, null=True) - personexpedition = models.ForeignKey(CorePersonexpedition, models.DO_NOTHING, blank=True, null=True) - persontrip = models.ForeignKey(CorePersontrip, models.DO_NOTHING, blank=True, null=True) - survexblock = models.ForeignKey(CoreSurvexblock, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'core_survexpersonrole' - - -class CoreSurvexstation(models.Model): - name = models.CharField(max_length=100) - x = models.FloatField(blank=True, null=True) - y = models.FloatField(blank=True, null=True) - z = models.FloatField(blank=True, null=True) - block = models.ForeignKey(CoreSurvexblock, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survexstation' - - -class CoreSurvextitle(models.Model): - title = models.CharField(max_length=200) - cave = models.ForeignKey(CoreCave, models.DO_NOTHING, blank=True, null=True) - survexblock = models.ForeignKey(CoreSurvexblock, models.DO_NOTHING, blank=True, null=True) - - class Meta: - managed = False - db_table = 'core_survextitle' - - -class CoreTunnelfile(models.Model): - tunnelpath = models.CharField(max_length=200) - tunnelname = models.CharField(max_length=200) - bfontcolours = models.IntegerField() - filesize = models.IntegerField() - npaths = models.IntegerField() - - class Meta: - managed = False - db_table = 'core_tunnelfile' - - -class CoreTunnelfileManyscansfolders(models.Model): - 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): - 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): - 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): - 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'),) - - -class DjangoAdminLog(models.Model): - action_time = models.DateTimeField() - object_id = models.TextField(blank=True, null=True) - object_repr = models.CharField(max_length=200) - action_flag = models.SmallIntegerField() - change_message = models.TextField() - content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING, blank=True, null=True) - user = models.ForeignKey(AuthUser, models.DO_NOTHING) - - class Meta: - managed = False - db_table = 'django_admin_log' - - -class DjangoContentType(models.Model): - 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): - 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): - 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): - 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): - activation_key = models.CharField(max_length=40) - user = models.ForeignKey(AuthUser, models.DO_NOTHING, unique=True) - - class Meta: - managed = False - db_table = 'registration_registrationprofile' |