initial query working

1 files changed, 6 insertions, 4 deletions

diff --git a/dbtest.py b/dbtest.py
index 45d7e50..f073548 100644
--- a/dbtest.py
+++ b/dbtest.py
@@ -1,8 +1,10 @@
 import cx_Oracle
 import dbconfig
 
-connStr = u'%s/%s@%s' % (dbconfig.USER, dbconfig.PASS, dbconfig.SID)
+connStr = '%s/%s@%s' % (dbconfig.USER, dbconfig.PASS, dbconfig.SID)
 
-conn = cx_Oracle.connect(connStr)
-
-conn.close()
+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