Compiled Butler config

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;"
-        ]
     }
 }