From cf4d957ce7c3474204cc6775d31d29edb7cdbdc0 Mon Sep 17 00:00:00 2001 From: Yuval Adam Date: Sat, 9 Oct 2010 17:25:53 +0200 Subject: renamed db utils --- dbutils.py | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 dbutils.py (limited to 'dbutils.py') diff --git a/dbutils.py b/dbutils.py new file mode 100644 index 0000000..f073548 --- /dev/null +++ b/dbutils.py @@ -0,0 +1,10 @@ +import cx_Oracle +import dbconfig + +connStr = '%s/%s@%s' % (dbconfig.USER, dbconfig.PASS, dbconfig.SID) + +with cx_Oracle.connect(connStr) as conn: + cur = conn.cursor() + cur.execute('SELECT COUNT(*) FROM D_CARRIL_PM_2008_01') + for s in cur.fetchall(): + print s -- cgit v1.3.1