diff options
Diffstat (limited to 'pysite/tables.py')
| -rw-r--r-- | pysite/tables.py | 86 |
1 files changed, 85 insertions, 1 deletions
diff --git a/pysite/tables.py b/pysite/tables.py index 4d9142fa..8ec550fb 100644 --- a/pysite/tables.py +++ b/pysite/tables.py @@ -8,6 +8,14 @@ class Table(NamedTuple): TABLES = { + "bot_events": Table( # Events to be sent to the bot via websocket + primary_key="id", + keys=sorted([ + "id", + "data" + ]) + ), + "hiphopify": Table( # Users in hiphop prison primary_key="user_id", keys=sorted([ @@ -26,6 +34,81 @@ TABLES = { locked=False ), + "code_jams": Table( # Information about each code jam + primary_key="number", + keys=sorted([ + "date_end", # datetime + "date_start", # datetime + "end_html", # str + "end_rst", # str + "number", # int + "participants", # list[int] + "repo", # str + "state", # str + "task_html", # str + "task_rst", # str + "teams", # list[int] + "theme", # str + "title", # str + "winners" # list[int] + ]) + ), + + "code_jam_forms": Table( # Application forms for each jam + primary_key="number", + keys=sorted([ + "number", # int + "questions" # list[dict[str, str]] {title, type, input_type, options?} + ]) + ), + + "code_jam_questions": Table( # Application form questions + primary_key="id", + keys=sorted([ + "id", # uuid + "" # TODO + ]) + ), + + "code_jam_responses": Table( # Application form responses + primary_key="id", + keys=sorted([ + "id", # uuid + "jam", # int + "answers", # dict {question, answer, metadata} + ]) + ), + + "code_jam_teams": Table( # Teams for each jam + primary_key="id", + keys=sorted([ + "id", # uuid + "name", # str + "members" # list[int] + ]) + ), + + "code_jam_infractions": Table( # Individual infractions for each user + primary_key="id", + keys=sorted([ + "snowflake", # int + "participant", # int + "reason", # str + "number" # int (optionally -1 for permanent) + ]) + ), + + "code_jam_participants": Table( # Info for each participant + primary_key="id", + keys=sorted([ + "snowflake", # int + "skill_level", # str + "age", # str + "github_username", # str + "timezone" # str + ]) + ), + "oauth_data": Table( # OAuth login information primary_key="id", keys=sorted([ @@ -70,7 +153,8 @@ TABLES = { ), "wiki_revisions": Table( # Revisions of wiki articles - primary_key="id", keys=sorted([ + primary_key="id", + keys=sorted([ "id", "date", "post", |