From 606aed7e01531ba0273139b69bc445b9f9bdf053 Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sesse@samfundet.no>
Date: Sun, 13 Feb 2005 16:46:23 +0000
Subject: [PATCH 1/1] Wrap INSERTs in a transaction.

---
 parse/parse-wiki-songlist.pl | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

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";
-- 
2.39.2