diff options
| author | Declan Hoare <[email protected]> | 2020-04-16 22:58:21 +1000 |
|---|---|---|
| committer | Declan Hoare <[email protected]> | 2020-04-16 23:10:44 +1000 |
| commit | 7000fce72fbec34c6f4957a59d4146cc7148ee59 (patch) | |
| tree | 5affe93d68a7fbcc6cf85a4d9a3eedecc730d1f7 /create_tables.py | |
| download | shiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.tar.gz shiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.tar.bz2 shiftgears-7000fce72fbec34c6f4957a59d4146cc7148ee59.zip | |
Initial Release
Diffstat (limited to 'create_tables.py')
| -rw-r--r-- | create_tables.py | 32 |
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 |
