From 9c7a25181bb3f050eb3d03f57a09f4af3c57c7b8 Mon Sep 17 00:00:00 2001 From: Gareth Coles Date: Sun, 24 Jun 2018 22:47:23 +0100 Subject: [Jams] Fix broken team-jam assoc on edit --- pysite/migrations/tables/code_jam_teams/v2.py | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 pysite/migrations/tables/code_jam_teams/v2.py (limited to 'pysite/migrations/tables/code_jam_teams') diff --git a/pysite/migrations/tables/code_jam_teams/v2.py b/pysite/migrations/tables/code_jam_teams/v2.py new file mode 100644 index 00000000..c6d7c972 --- /dev/null +++ b/pysite/migrations/tables/code_jam_teams/v2.py @@ -0,0 +1,13 @@ +def run(db, table, table_obj): + """ + Associate the ID of each team's code jam (team -> jam) - again + """ + + 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") + db.sync(table) -- cgit v1.2.3