iframe-proxy | Sunbelt Computer Software

25 lines (18 loc) · 877 Bytes

#------------------------------------------------------------------------------

# subclass.py (Section 9.1 and 9.2)

#------------------------------------------------------------------------------

from __future__ import print_function

import cx_Oracle

import db_config

class MyConnection(cx_Oracle.Connection):

def __init__(self):

print("Connecting to database")

return super(MyConnection, self).__init__(db_config.user, db_config.pw, db_config.dsn)

con = MyConnection()

cur = con.cursor()

cur.execute("select count(*) from emp where deptno = :bv", (10,))

count, = cur.fetchone()

print("Number of rows:", count)

Sunbelt Computer Software