Changes between Version 15 and Version 16 of SqLiteToMySql

Timestamp:

Feb 13, 2012, 2:44:54 PM (12 years ago)

Author:

kmenc15@…

Comment:

Add perl scripts for migrate

SqLiteToMySql

@@ -122 +122 @@
 
 I've also modified the Python {{{cleansql}}} script, which will now take in both the mysql table structure SQL and the SQLite SQL. It will remove the {{{PRAGMA}}} statement and convert {{{CAST(p.value AS int)}}} to {{{CAST(p.value AS signed)}}}. It will also try to fix the backslash escaped quotes(!). Not the best script but it worked for me :)
+
+----
+
+None of the scripts here deal with quoting of ' characters caused by sqlite/mysql differences. Here is my perl script for sqlite to mysql migrate, which handles quoting very accurately:
+{{{
+print << 'EOF';
+BEGIN;
+TRUNCATE `attachment` ;
+TRUNCATE `auth_cookie` ;
+-- ############ more truncates here...
+EOF
+
+$inq=0;
+$del=0;
+sub qut { local $_=shift; ($inq ? (/'/ ? "\\'\\" : ($inq=0,"'")) : "'".(/'/ ? '' : ($inq=1,''))).$_ }
+
+while (<>) {
+        $del=!/;/, next if ($del);
+        s/^(COMMIT|BEGIN TRANSACTION);//mg;
+        $del=1, next if (/^CREATE (TABLE|INDEX)/);
+        s/INSERT INTO "([^"]+)"/INSERT INTO `$1`/g;
+        s/\\/\\\\/g;
+        s/'(.|$)/qut($1)/ge;
+        s/(INSERT INTO `milestone` .*),0,NULL/$1,NULL/g;
+        print;
+}
+print "COMMIT;"
+}}}