diff options
| author | emkael <emkael@tlen.pl> | 2021-05-29 01:55:50 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2021-05-29 01:55:50 +0200 |
| commit | 49700f99cd9e44c5729ed31571eadfc4f42cae54 (patch) | |
| tree | 56b9d2beb6fbfdb8e7dcec9c84be51fd0968876e | |
| parent | 282de0f28e8191a467aa2b34bece378d96648d32 (diff) | |
Adding 1N clone with zeroed butler from first 5 rounds to copy into cummulative butlers
| -rw-r--r-- | butler/config.json | 8 | ||||
| -rw-r--r-- | dumps/.mapping | 15 |
2 files changed, 15 insertions, 8 deletions
diff --git a/butler/config.json b/butler/config.json index eea10ba..9a456a3 100644 --- a/butler/config.json +++ b/butler/config.json @@ -1,6 +1,7 @@ { "1+2": { "source": [ + "dmp202021_1n_b", "dmp202021_1s", "dmp202021_2se", "dmp202021_2sw", @@ -11,6 +12,7 @@ }, "1": { "source": [ + "dmp202021_1n_b", "dmp202021_1s" ], "output": "dmp202021_b_1" @@ -27,13 +29,17 @@ "__groups": { "dmp202021_e": "E", "dmp202021_1s": "S", - "dmp202021_1n": "N", + "dmp202021_1n_b": "N", "dmp202021_2se": "SE", "dmp202021_2sw": "SW", "dmp202021_2ne": "NE", "dmp202021_2nw": "NW" }, "__queries": { + "dmp202021_1n_b": [ + "UPDATE _matches SET mtitle = '--' WHERE rnd < 6;", + "UPDATE _segments SET openN = 0, openS = 0, openW = 0, openE = 0, closeN = 0, closeS = 0, closeW = 0, closeE = 0, towel = 1 WHERE rnd < 6;" + ], "dmp202021_2se": [ "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 WHERE rnd < 14;", diff --git a/dumps/.mapping b/dumps/.mapping index 6bb9d44..ca8abda 100644 --- a/dumps/.mapping +++ b/dumps/.mapping @@ -1,7 +1,8 @@ -# dmp202021_e sync/eliga2021.sql -dmp202021_1n sync/_21_1ligan.sql -# dmp202021_1s sync/tel.sql -# dmp202021_2ne sync/nerr.sql -# dmp202021_2nw sync/20nwrr.sql -# dmp202021_2se sync/serrr.sql -# dmp202021_2sw sync/2swrr.sql +dmp202021_e sync/eliga2021.sql +dmp202021_1n sync/_21_1ligan.sql +dmp202021_1n_b sync/_21_1ligan.sql +dmp202021_1s sync/tel.sql +dmp202021_2ne sync/2nerr.sql +dmp202021_2nw sync/20nwrr.sql +dmp202021_2se sync/serrr.sql +dmp202021_2sw sync/2swrr.sql |