Changes between Version 2 and Version 3 of SqLiteToMySql

Timestamp:

May 5, 2007, 12:14:34 AM (17 years ago)

Author:

anonymous

Comment:

—

SqLiteToMySql

@@ -35 +35 @@
 cat trac.mysql.sql trac.sqlite.sql.dataonly > trac.sql  
     }}}
+
+----
+
+An alternatice to the cleansql above (that works a bit better):
+{{{
+
+$ cat cleansql.py
+#!/usr/bin/env python
+
+import sys
+import re
+
+file = sys.stdin.read()
+file = re.sub(r'(CREATE (TABLE|INDEX)[^;]*|COMMIT|BEGIN TRANSACTION);', '', file)
+file = re.sub(r'INSERT INTO "([^"]+)"', lambda m: 'INSERT INTO `%s`' % m.groups(1), file)
+sys.stdout.write(file)
+
+$ cat trac.sqlite.sql | ./cleansql.py > trac.sqlite.sql.dataonly
+}}}