From 9305c8129786dd81a64aac9729fbfa70b932bcbc Mon Sep 17 00:00:00 2001 From: Rob Austein Date: Fri, 24 Aug 2007 16:50:06 +0000 Subject: Fun with SQL. svn path=/scripts/test-sql.py; revision=903 --- scripts/test-sql.py | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 scripts/test-sql.py (limited to 'scripts/test-sql.py') 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() -- cgit v1.2.3