diff options
| author | Yuval Adam <yuv.adm@gmail.com> | 2010-10-09 17:25:53 +0200 |
|---|---|---|
| committer | Yuval Adam <yuv.adm@gmail.com> | 2010-10-09 17:25:53 +0200 |
| commit | cf4d957ce7c3474204cc6775d31d29edb7cdbdc0 (patch) | |
| tree | c4caf921405ff3bf0cc12cddb37cdebbc96cd029 /dbutils.py | |
| parent | 64ca78c63f9c021cacd212b0c3341eb5f33b3676 (diff) | |
renamed db utils
Diffstat (limited to 'dbutils.py')
| -rw-r--r-- | dbutils.py | 10 |
1 files changed, 10 insertions, 0 deletions
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 |