From 1a3cc2642346933710fabfdd01395b320a623c35 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sat, 5 Mar 2005 03:13:13 +0000 Subject: [PATCH] Add an SQL snippet for fixing some stuff related to chosen/random songs in the data from DDR Europe. --- sql/fixup-chosensongs.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/fixup-chosensongs.sql diff --git a/sql/fixup-chosensongs.sql b/sql/fixup-chosensongs.sql new file mode 100644 index 0000000..c884a31 --- /dev/null +++ b/sql/fixup-chosensongs.sql @@ -0,0 +1,19 @@ +-- +-- Fix some brokenness in the data we get from DDR Europe; specifically, +-- if all players in a round select the same chosen song, the data says +-- that is was a random song. We find the most obvious cases and fix them; +-- I don't believe there are any more of them than those. +-- + +BEGIN; + +UPDATE scores SET chosen='t' WHERE (tournament,round,songnumber) IN ( + SELECT tournament,round,randomsongs-1 FROM rounds WHERE chosensongs = 0 AND randomsongs > 1 +); + +UPDATE rounds SET chosensongs=1,randomsongs=randomsongs-1 WHERE (tournament,round) IN ( + SELECT tournament, round FROM rounds WHERE chosensongs = 0 AND randomsongs > 1 +); + +COMMIT; + -- 2.39.2