1 files changed, 36 insertions, 0 deletions
diff --git a/scripts/Old/test-sql.py b/scripts/Old/test-sql.py
new file mode 100644
index 00000000..6357ed42
--- /dev/null
+++ b/scripts/Old/test-sql.py
@@ -0,0 +1,36 @@
+# $Id$
+
+import MySQLdb, rpki.config
+
+def test(filename, section):
+
+  print "[Checking " + filename + "]\n"
+
+  cfg = rpki.config.parser(filename)
+
+  db = MySQLdb.connect(user   = cfg.get(section, "sql-username"),
+                       db     = cfg.get(section, "sql-database"),
+                       passwd = cfg.get(section, "sql-password"))
+
+  cur = db.cursor()
+
+  def duh(db, cmd, header):
+    cur.execute(cmd)
+    print header
+    print "-" * len(header)
+    print cur.description
+    for i in cur.fetchall():
+      print i[0]
+    print
+
+  duh(db, "SHOW DATABASES", "Databases")
+  duh(db, "SELECT DATABASE()", "Current database")
+  duh(db, "SHOW TABLES", "Current tables")
+
+  db.close()
+
+print MySQLdb.Timestamp(2007,6,9,9,45,51), MySQLdb.DateFromTicks(1000), \
+      MySQLdb.Binary("Hi, Mom!"), MySQLdb.STRING, MySQLdb.BINARY, MySQLdb.NUMBER, MySQLdb.NULL, "\n"
+
+test("re.conf",   "rpki")
+test("irbe.conf", "irdb")