Fun with SQL.

svn path=/scripts/test-sql.py; revision=903

1 files changed, 33 insertions, 0 deletions

diff --git a/scripts/test-sql.py b/scripts/test-sql.py
new file mode 100644
index 00000000..fa179a00
--- /dev/null
+++ b/scripts/test-sql.py
@@ -0,0 +1,33 @@
+# $Id$
+
+import MySQLdb, ConfigParser
+
+cfg = ConfigParser.ConfigParser()
+cfg.read("re.conf")
+
+db = MySQLdb.connect(user = "rpki", db = "rpki", passwd = cfg.get("rpki", "password"))
+cur = db.cursor()
+
+def duh(cmd, header):
+  cur.execute(cmd)
+  print header
+  print "-" * len(header)
+  print cur.description
+  for i in cur.fetchall():
+    print i[0]
+  print
+
+duh("SHOW DATABASES", "Databases")
+
+duh("SELECT DATABASE()", "Current database")
+
+duh("USE rpki", "Select database")
+
+duh("SELECT DATABASE()", "Current database")
+
+duh("SHOW TABLES", "Current tables")
+
+print MySQLdb.Timestamp(2007,6,9,9,45,51), MySQLdb.DateFromTicks(1000), MySQLdb.Binary("Hi, Mom!"), MySQLdb.STRING, MySQLdb.BINARY, MySQLdb.NUMBER, MySQLdb.NULL
+
+cur.close()
+db.close()