summaryrefslogtreecommitdiff
path: root/dbtest.py
blob: f0735485c80773daa386fd340cbba8f01d0040eb (plain)
1
2
3
4
5
6
7
8
9
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