diff options
| -rw-r--r-- | butler/config.json | 91 |
1 files changed, 22 insertions, 69 deletions
diff --git a/butler/config.json b/butler/config.json index 1fef174..e40e8a3 100644 --- a/butler/config.json +++ b/butler/config.json @@ -1,87 +1,40 @@ { "1+2": { "source": [ - "dmp202021_1n_b", - "dmp202021_1n_z3", - "dmp202021_1s", - "dmp202021_2se", - "dmp202021_2sw", - "dmp202021_2ne", - "dmp202021_2nw" + "dmp202122_2se", + "dmp202122_2sw", + "dmp202122_2ne", + "dmp202122_2nw", + "dmp202122_1s", + "dmp202122_1n" ], - "output": "dmp202021_b_0" + "output": "dmp202122_b0" }, "1": { "source": [ - "dmp202021_1n_b", - "dmp202021_1n_z3", - "dmp202021_1s" + "dmp202122_1s", + "dmp202122_1n" ], - "output": "dmp202021_b_1" + "output": "dmp202122_b1" }, "2": { "source": [ - "dmp202021_2sw", - "dmp202021_2ne", - "dmp202021_2nw", - "dmp202021_2se" + "dmp202122_2sw", + "dmp202122_2ne", + "dmp202122_2nw", + "dmp202122_2se" ], - "output": "dmp202021_b_2" + "output": "dmp202122_b2" }, "__groups": { - "dmp202021_e": "E", - "dmp202021_1s": "S", - "dmp202021_1n_b": "N", - "dmp202021_1n_z3": "N", - "dmp202021_2se": "SE", - "dmp202021_2sw": "SW", - "dmp202021_2ne": "NE", - "dmp202021_2nw": "NW" + "dmp202122_e": "E", + "dmp202122_1s": "S", + "dmp202122_1n": "N", + "dmp202122_2se": "SE", + "dmp202122_2sw": "SW", + "dmp202122_2ne": "NE", + "dmp202122_2nw": "NW" }, "__queries": { - "dmp202021_1n_b": [ - "UPDATE _matches SET mtitle = '--' WHERE rnd < 6;", - "DELETE FROM _segments WHERE rnd < 6;", - "UPDATE _matches SET mtitle = '--' WHERE rnd > 10;", - "DELETE FROM _segments WHERE rnd > 10;", - "TRUNCATE _players;" - ], - "dmp202021_1n_z3": [ - "UPDATE _rounds SET rnd = rnd + 10;", - "UPDATE _matches SET rnd = rnd + 10;", - "UPDATE _segments SET rnd = rnd + 10, openN = openN - 400, openS = openS - 400, openE = openE - 400, openW = openW - 400, closeN = closeN - 400, closeS = closeS - 400, closeE = closeE - 400, closeW = closeW - 400;", - "UPDATE _players SET id = id - 400;", - "UPDATE _scores SET rnd = rnd + 10;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 1, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 2, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 3, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 4, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 5, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 6, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 7, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 8, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 9, id, id, id+8, '--' FROM teams WHERE id < 9;", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 10, id, id, id+8, '--' FROM teams WHERE id < 9;" - ], - "dmp202021_2se": [ - "UPDATE admin SET roundcnt = 15;", - "UPDATE _rounds SET rnd = rnd + 1 WHERE rnd > 5;", - "UPDATE _matches SET rnd = rnd + 1 WHERE rnd > 5;", - "UPDATE _segments SET rnd = rnd + 1 WHERE rnd > 5;", - "UPDATE _scores SET rnd = rnd + 1 WHERE rnd > 5;", - "INSERT INTO _rounds(rnd) VALUES(6);", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 6, id, id, id+7, '--' FROM teams WHERE id < 8;", - "UPDATE _rounds SET rnd = rnd + 1 WHERE rnd > 10;", - "UPDATE _matches SET rnd = rnd + 1 WHERE rnd > 10;", - "UPDATE _segments SET rnd = rnd + 1 WHERE rnd > 10;", - "UPDATE _scores SET rnd = rnd + 1 WHERE rnd > 10;", - "INSERT INTO _rounds(rnd) VALUES(11);", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT 11, id, id, id+7, '--' FROM teams WHERE id < 8;", - "UPDATE admin SET teamcnt = 16;", - "INSERT INTO _teams(id, bye) VALUES(15, 2),(16, 2);", - "INSERT INTO _matches(rnd, tabl, homet, visit, mtitle) SELECT rnd, 8, 15, 16, '--' FROM _rounds;", - "INSERT INTO _segments(rnd, segment, tabl, homet, visit, towel) SELECT rnd, 1, 8, 15, 16, 1 FROM _rounds;", - "INSERT INTO _segments(rnd, segment, tabl, homet, visit, towel) SELECT rnd, 2, 8, 15, 16, 1 FROM _rounds;" - ] } } |