aboutsummaryrefslogtreecommitdiff
path: root/create_tables.py
diff options
context:
space:
mode:
authorDeclan Hoare <[email protected]>2020-04-16 22:58:21 +1000
committerDeclan Hoare <[email protected]>2020-04-16 23:10:44 +1000
commit7000fce72fbec34c6f4957a59d4146cc7148ee59 (patch)
tree5affe93d68a7fbcc6cf85a4d9a3eedecc730d1f7 /create_tables.py
downloadshiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.tar.gz
shiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.tar.bz2
shiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.zip
Initial Release
Diffstat (limited to 'create_tables.py')
-rw-r--r--create_tables.py32
1 files changed, 32 insertions, 0 deletions
diff --git a/create_tables.py b/create_tables.py
new file mode 100644
index 0000000..ff4b2e4
--- /dev/null
+++ b/create_tables.py
@@ -0,0 +1,32 @@
+import database
+database.Base.metadata.create_all(database.engine)
+session = database.DbSession()
+
+systems = [("DevX", "mud", ["sys", "DevX"]),
+ ("hacker101", "undisclosed", ["hacker101"]),
+ ("victortran", "theos", ["victortran"])]
+
+# create the system account
+
+for i, (displayname, sysname, users) in enumerate(systems):
+
+ user = database.User()
+ user.dontvalidate = True
+ user.ID = "00000000-0000-0000-0000-%012d" % i
+ user.Email = f"{sysname}@system.invalid"
+ user.DisplayName = displayname
+ user.SysName = sysname
+ session.add(user)
+ save = database.Save()
+ save.User = user
+ save.IsMUDAdmin = True
+ session.add(save)
+ print(repr(user.Save))
+ for username in users:
+ clientsave = database.ClientSave()
+ clientsave.Username = username
+ clientsave.Save = save
+ session.add(clientsave)
+
+session.commit()
+session.close() \ No newline at end of file