rename for convenience

1 files changed, 27 insertions, 0 deletions

diff --git a/tools/mksqlite.py b/tools/mksqlite.py
new file mode 100755
index 0000000..7ca5665
--- /dev/null
+++ b/tools/mksqlite.py
@@ -0,0 +1,27 @@
+#!/usr/bin/python
+import os
+dbpath = "packages.db"
+
+if os.path.exists(dbpath):
+    print "Remove",dbpath,"first"
+    raise SystemExit
+
+print "Creating database", dbpath
+sqlite = os.popen('sqlite3 '+dbpath, "w")
+passthrough = True
+for line in open('pkgbase_schema.sql'):
+    if 'nosqlite-end' in line:
+        # end of disabled block
+        passthrough = True
+        print >>sqlite
+        continue
+    if 'nosqlite' in line:
+        passthrough = False
+        print >>sqlite
+        continue
+    if not passthrough:
+        print >> sqlite
+        continue
+    # make sqlite happy: SERIAL is not a valid type
+    sqlite.write(line.replace('SERIAL PRIMARY KEY', 'INTEGER PRIMARY KEY'))
+sqlite.close()