Adding postini and prerm scripts for sipb-xen-database-server

[invirt/packages/invirt-database.git] / sipb-xen-database-tables

diff --git a/sipb-xen-database-tables b/sipb-xen-database-tables
new file mode 100755 (executable)
index 0000000..f054616
--- /dev/null
+++ b/sipb-xen-database-tables
@@ -0,0 +1,18 @@
+#!/usr/bin/env python
+
+from sipb_xen_database import *
+import sys
+
+def usage():
+    print >>sys.stderr, "Usage: %s [create|drop]" %(sys.argv[0],)
+    sys.exit(-1)
+
+if len(sys.argv) == 1:
+    usage()
+
+connect('postgres://sipb-xen@localhost/sipb_xen')
+
+if sys.argv[1] == "create":
+    meta.create_all()
+else:
+    meta.drop_all()