X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=parse%2Fparse-wiki-songlist.pl;h=3f1311839bb9cc2ea88b28584002956e174fa602;hp=169dbd26552cbde95c68eaf7dae5e7958a063256;hb=606aed7e01531ba0273139b69bc445b9f9bdf053;hpb=4df0f31f45e22db83701a52dd2e5dc9ecc3ea67b diff --git a/parse/parse-wiki-songlist.pl b/parse/parse-wiki-songlist.pl index 169dbd2..3f13118 100644 --- a/parse/parse-wiki-songlist.pl +++ b/parse/parse-wiki-songlist.pl @@ -4,6 +4,8 @@ use warnings; # Parses songlist from the DDRNO wiki +print "begin;\n"; + while (<>) { m/ \| \s* \[\[ (.*?) \]\] \s* # song name @@ -46,5 +48,6 @@ while (<>) { printf "INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='%s'),'%s','%s',%u);\n", $songname, $t->[0], $t->[1], $t->[2]; } - } + +printf "commit;\n";