From 6ce048d6b3c5518ada39022b164c4aec41c7f5c9 Mon Sep 17 00:00:00 2001 From: momothereal Date: Sat, 23 Jun 2018 17:48:43 -0400 Subject: [Jams/Teams] Simplify getting the code jam for a team (team -> jam) --- pysite/migrations/tables/code_jam_teams/__init__.py | 0 pysite/migrations/tables/code_jam_teams/v1.py | 12 ++++++++++++ 2 files changed, 12 insertions(+) create mode 100644 pysite/migrations/tables/code_jam_teams/__init__.py create mode 100644 pysite/migrations/tables/code_jam_teams/v1.py (limited to 'pysite/migrations/tables/code_jam_teams') diff --git a/pysite/migrations/tables/code_jam_teams/__init__.py b/pysite/migrations/tables/code_jam_teams/__init__.py new file mode 100644 index 00000000..e69de29b diff --git a/pysite/migrations/tables/code_jam_teams/v1.py b/pysite/migrations/tables/code_jam_teams/v1.py new file mode 100644 index 00000000..563a146b --- /dev/null +++ b/pysite/migrations/tables/code_jam_teams/v1.py @@ -0,0 +1,12 @@ +def run(db, table, table_obj): + """ + Associate the ID of each team's code jam (team -> jam) + """ + + for document in db.get_all(table): + if "jam" not in document: + # find the code jam containing this team + for jam in db.get_all("code_jams"): + if document["id"] in jam["teams"]: + document["jam"] = jam["number"] + db.insert(table, document, conflict="update", durability="soft") -- cgit v1.2.3