summaryrefslogtreecommitdiffstats
path: root/troggle-inspectdb.py
diff options
context:
space:
mode:
Diffstat (limited to 'troggle-inspectdb.py')
-rw-r--r--troggle-inspectdb.py227
1 files changed, 131 insertions, 96 deletions
diff --git a/troggle-inspectdb.py b/troggle-inspectdb.py
index 266077a..38f3dbb 100644
--- a/troggle-inspectdb.py
+++ b/troggle-inspectdb.py
@@ -1,6 +1,5 @@
* 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
@@ -20,21 +19,27 @@ 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 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):
- id = models.IntegerField(primary_key=True) # AutoField?
+ name = models.CharField(max_length=255)
content_type = models.ForeignKey('DjangoContentType', models.DO_NOTHING)
codename = models.CharField(max_length=100)
- name = models.CharField(max_length=255)
class Meta:
managed = False
@@ -43,31 +48,45 @@ class AuthPermission(models.Model):
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()
+ 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.BooleanField()
- is_active = models.BooleanField()
+ is_staff = models.IntegerField()
+ is_active = models.IntegerField()
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 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):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -79,9 +98,8 @@ class CoreArea(models.Model):
class CoreCave(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -108,7 +126,6 @@ class CoreCave(models.Model):
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)
@@ -119,7 +136,6 @@ class CoreCaveArea(models.Model):
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)
@@ -130,9 +146,8 @@ class CoreCaveandentrance(models.Model):
class CoreCavedescription(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -143,7 +158,6 @@ class CoreCavedescription(models.Model):
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)
@@ -154,7 +168,6 @@ class CoreCavedescriptionLinkedEntrances(models.Model):
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)
@@ -165,7 +178,6 @@ class CoreCavedescriptionLinkedQms(models.Model):
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)
@@ -176,9 +188,8 @@ class CoreCavedescriptionLinkedSubcaves(models.Model):
class CoreCaveslug(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
slug = models.CharField(unique=True, max_length=50)
- primary = models.BooleanField()
+ primary = models.IntegerField()
cave = models.ForeignKey(CoreCave, models.DO_NOTHING)
class Meta:
@@ -187,9 +198,8 @@ class CoreCaveslug(models.Model):
class CoreDataissue(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -200,9 +210,8 @@ class CoreDataissue(models.Model):
class CoreEntrance(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -233,9 +242,8 @@ class CoreEntrance(models.Model):
class CoreEntranceslug(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
slug = models.CharField(unique=True, max_length=50)
- primary = models.BooleanField()
+ primary = models.IntegerField()
entrance = models.ForeignKey(CoreEntrance, models.DO_NOTHING)
class Meta:
@@ -244,9 +252,8 @@ class CoreEntranceslug(models.Model):
class CoreExpedition(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
year = models.CharField(unique=True, max_length=20)
name = models.CharField(max_length=100)
@@ -256,9 +263,8 @@ class CoreExpedition(models.Model):
class CoreExpeditionday(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
date = models.DateField()
expedition = models.ForeignKey(CoreExpedition, models.DO_NOTHING)
@@ -268,9 +274,8 @@ class CoreExpeditionday(models.Model):
class CoreLogbookentry(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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)
@@ -288,9 +293,8 @@ class CoreLogbookentry(models.Model):
class CoreNewsubcave(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
name = models.CharField(unique=True, max_length=200)
class Meta:
@@ -299,9 +303,8 @@ class CoreNewsubcave(models.Model):
class CoreOthercavename(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
name = models.CharField(max_length=160)
cave = models.ForeignKey(CoreCave, models.DO_NOTHING)
@@ -311,13 +314,12 @@ class CoreOthercavename(models.Model):
class CorePerson(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ 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.BooleanField()
+ 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)
@@ -329,11 +331,10 @@ class CorePerson(models.Model):
class CorePersonexpedition(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
slugfield = models.CharField(max_length=50, blank=True, null=True)
- is_guest = models.BooleanField()
+ 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)
@@ -345,11 +346,10 @@ class CorePersonexpedition(models.Model):
class CorePersontrip(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
time_underground = models.FloatField()
- is_logbook_entry_author = models.BooleanField()
+ 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)
@@ -359,9 +359,8 @@ class CorePersontrip(models.Model):
class CoreQm(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
- new_since_parsing = models.BooleanField()
- non_public = models.BooleanField()
+ new_since_parsing = models.IntegerField()
+ non_public = models.IntegerField()
number = models.IntegerField()
grade = models.CharField(max_length=1)
location_description = models.TextField()
@@ -380,7 +379,6 @@ class CoreQm(models.Model):
class CoreScansfolder(models.Model):
- id = models.IntegerField(primary_key=True) # AutoField?
fpath = models.CharField(max_length=200)
walletname = models.CharField(max_length=200)
@@ -390,7 +388,6 @@ class CoreScansfolder(models.Model):
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)
@@ -401,7 +398,6 @@ class CoreSinglescan(models.Model):
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)
@@ -411,9 +407,9 @@ class CoreSurvexblock(models.Model):
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)
- parent = models.ForeignKey('self', models.DO_NOTHING, blank=True, null=True)
class Meta:
managed = False
@@ -421,7 +417,6 @@ class CoreSurvexblock(models.Model):
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)
@@ -429,21 +424,58 @@ class CoreSurvexdirectory(models.Model):
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 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):
- id = models.IntegerField(primary_key=True) # AutoField?
tunnelpath = models.CharField(max_length=200)
tunnelname = models.CharField(max_length=200)
- bfontcolours = models.BooleanField()
+ bfontcolours = models.IntegerField()
filesize = models.IntegerField()
npaths = models.IntegerField()
@@ -453,7 +485,6 @@ class CoreTunnelfile(models.Model):
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)
@@ -464,7 +495,6 @@ class CoreTunnelfileManyscansfolders(models.Model):
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)
@@ -475,9 +505,8 @@ class CoreTunnelfileScans(models.Model):
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)
+ survexfile = models.ForeignKey(CoreSurvexfile, models.DO_NOTHING)
class Meta:
managed = False
@@ -486,7 +515,6 @@ class CoreTunnelfileSurvexfiles(models.Model):
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)
@@ -494,12 +522,23 @@ class CoreTunnelfileTunnelcontains(models.Model):
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 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):
- id = models.IntegerField(primary_key=True) # AutoField?
app_label = models.CharField(max_length=100)
model = models.CharField(max_length=100)
@@ -510,7 +549,6 @@ class DjangoContentType(models.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()
@@ -531,7 +569,6 @@ class DjangoSession(models.Model):
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)
@@ -541,7 +578,6 @@ class FlatpagesEntranceredirect(models.Model):
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.
@@ -551,7 +587,6 @@ class FlatpagesRedirect(models.Model):
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)
generated by cgit v1.2.3 (git 2.39.1) at 2025-07-17 04:39:02 +0000