From 515c9e839fabb4ebfffdbfaf17b76744c24e2449 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Tue, 25 Feb 2014 18:36:17 +0100 Subject: [PATCH] sql to create synthetic games points enhanced --- sql/sql.d/066-insert-unnorm-games.sql.test | 23 +++++++++++++++++++--- 1 file changed, 20 insertions(+), 3 deletions(-) diff --git a/sql/sql.d/066-insert-unnorm-games.sql.test b/sql/sql.d/066-insert-unnorm-games.sql.test index a5089cb..3430369 100644 --- a/sql/sql.d/066-insert-unnorm-games.sql.test +++ b/sql/sql.d/066-insert-unnorm-games.sql.test @@ -1,20 +1,37 @@ -DELETE FROM bsk_bin5_matches WHERE code = 100; +DELETE FROM bsk_bin5_matches WHERE code = 100 OR code = 101; INSERT INTO bsk_bin5_matches (code, ttok, tidx, mazzo_next, mult_next) VALUES (100, 'normalize_points', 2, 1, 1) RETURNING *; INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (100, 10101, 0); INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (100, 10102, 1); INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (100, 10103, 2); INSERT INTO bsk_bin5_games (code, mcode, tstamp, act, asta_pnt, pnt, asta_win, friend, mazzo, mult) - VALUES (200, 100, to_timestamp(112211221122), 2, 60, 0, -1, -1, 0, 0) RETURNING *; + VALUES (200, 100, to_timestamp(139000000), 2, 60, 0, -1, -1, 0, 0) RETURNING *; INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (200, 10101, 0); INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (200, 10102, 0); INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (200, 10103, 0); UPDATE bsk_bin5_matches SET (mazzo_next, mult_next) = (2, 0) WHERE code = 100; INSERT INTO bsk_bin5_games (code, mcode, tstamp, act, asta_pnt, pnt, asta_win, friend, mazzo, mult) - VALUES (201, 100, to_timestamp(112211221142), 0, 61, 37, 2, 1, 1, 1) RETURNING *; + VALUES (201, 100, to_timestamp(139000100), 0, 61, 37, 2, 1, 1, 1) RETURNING *; INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (201, 10101, 2); INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (201, 10102, -2); INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (201, 10103, -4); +INSERT INTO bsk_bin5_matches (code, ttok, tidx, mazzo_next, mult_next) VALUES (101, 'normalize_points2', 2, 1, 0) RETURNING *; +INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (101, 10101, 0); +INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (101, 10102, 1); +INSERT INTO bsk_bin5_table_orders (mcode, ucode, pos) VALUES (101, 10103, 2); +INSERT INTO bsk_bin5_games (code, mcode, tstamp, act, asta_pnt, pnt, asta_win, friend, mazzo, mult) + VALUES (202, 101, to_timestamp(139000200), 2, 60, 0, -1, -1, 0, 0) RETURNING *; +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (202, 10101, 0); +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (202, 10102, 0); +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (202, 10103, 0); +UPDATE bsk_bin5_matches SET (mazzo_next, mult_next) = (2, 0) WHERE code = 100; +INSERT INTO bsk_bin5_games (code, mcode, tstamp, act, asta_pnt, pnt, asta_win, friend, mazzo, mult) + VALUES (203, 101, to_timestamp(139000300), 0, 81, 37, 2, 1, 1, 1) RETURNING *; +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (203, 10101, 6); +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (203, 10102, -6); +INSERT INTO bsk_bin5_points (gcode, ucode, pts) VALUES (203, 10103, -12); + + -- 2.17.1