From 2c048e7604ab11dd557cd0d8451a8cf532190130 Mon Sep 17 00:00:00 2001
From: Yuval Adam <yuv.adm@gmail.com>
Date: Sat, 9 Oct 2010 15:37:20 +0200
Subject: initial query working

---
 dbtest.py | 10 ++++++----
 1 file 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
-- 
cgit v1.3.1