Changes between Version 17 and Version 18 of SqLiteToMySql

Timestamp:

Feb 16, 2012, 7:38:05 AM (12 years ago)

Author:

kmenc15@…

Comment:

Write explicit tables for truncate in perl sqlite→mysql script

SqLiteToMySql

@@ -127 +127 @@
 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;
+print "BEGIN;\n";
+print "TRUNCATE `$_`;\n" for (qw(attachment auth_cookie cache component enum milestone node_change permission report
+                                 repository revision session session_attribute system ticket ticket_change ticket_custom version wiki));
+my ($inq,$del);
 sub qut { local $_=shift; ($inq ? (/'/ ? "\\" : ($inq=0,"'")) : "'".(/'/ ? '' : ($inq=1,''))).$_ }
-
 while (<>) {
         $del=!/;/, next if ($del);
@@ -148 +142 @@
         print;
 }
-print "COMMIT;"
+print "COMMIT;\n"
 }}}