def testConnect(self):
self.connection = OracleConnection()
self.connection.host = 'localhost'
self.connection.user = '******'
self.connection.passwd = 'y47test'
self.connection.sid = 'XE'
db = self.connection.connect
self.assertTrue('cx_Oracle.Connection' in repr(db))
db.close()
def testConnectSidNotSet(self):
self.connection = OracleConnection(host='localhost', user='******',
passwd='y47test')
with self.assertRaises(ValueError):
self.connection.connect()
def testAutoCommitIsDisabled(self):
self.connection = OracleConnection()
self.connection.autocommit = 0
self.assertEqual(self.connection.autocommit, 0)
def testConnectHostNotSet(self):
self.connection = OracleConnection(user='******', passwd='y47test',
sid='XE')
with self.assertRaises(ValueError):
self.connection.connect()
def testSidIsNone(self):
self.connection = OracleConnection()
self.connection.sid = None
self.assertEqual(self.connection.sid, None)
def testSidIsNotNone(self):
self.connection = OracleConnection()
self.connection.sid = 'XE'
self.assertEqual(self.connection.sid, 'XE')
def testPasswdIsNone(self):
self.connection = OracleConnection()
self.connection.passwd = None
self.assertEqual(self.connection.passwd, None)
def testPasswdIsNotNone(self):
self.connection = OracleConnection()
self.connection.passwd = 'y47test'
self.assertEqual(self.connection.passwd, 'y47test')
def testUserIsNone(self):
self.connection = OracleConnection()
self.connection.user = None
self.assertEqual(self.connection.user, None)
def testUserIsNotNone(self):
self.connection = OracleConnection()
self.connection.user = '******'
self.assertEqual(self.connection.user, 'y47test')
def testHostIsNotNone(self):
self.connection = OracleConnection()
self.connection.host = 'localhost'
self.assertEqual(self.connection.host, 'localhost')
def testHostIsNone(self):
self.connection = OracleConnection()
self.connection.host = None
self.assertEqual(self.connection.host, None)
def testInitAutoCommitIsEnabled(self):
self.connection = OracleConnection(autocommit=1)
self.assertEqual(self.connection.autocommit, 1)
def testInitAutoCommitIsOneByDefault(self):
self.connection = OracleConnection()
self.assertEqual(self.connection.autocommit, 1)
class TestOracleConnection(unittest.TestCase):
# host from __init__
def testInitHostIsNone(self):
self.connection = OracleConnection(host=None)
self.assertEqual(self.connection.host, None)
def testInitHostIsNotNone(self):
self.connection = OracleConnection(host='localhost')
self.assertEqual(self.connection.host, 'localhost')
# user from __init__
def testInitUserIsNone(self):
self.connection = OracleConnection(user=None)
self.assertEqual(self.connection.user, None)
def testInitUserIsNotNone(self):
self.connection = OracleConnection(user='******')
self.assertEqual(self.connection.user, 'y47test')
# passwd from __init__
def testInitPasswdIsNone(self):
self.connection = OracleConnection(passwd=None)
self.assertEqual(self.connection.passwd, None)
def testInitPasswdIsNotNone(self):
self.connection = OracleConnection(passwd='y47test')
self.assertEqual(self.connection.passwd, 'y47test')
# sid from __init__
def testInitSidIsNone(self):
self.connection = OracleConnection(sid=None)
self.assertEqual(self.connection.sid, None)
def testInitSidIsNotNone(self):
self.connection = OracleConnection(sid='XE')
self.assertEqual(self.connection.sid, 'XE')
# autocommit from __init__
def testInitAutoCommitIsOneByDefault(self):
self.connection = OracleConnection()
self.assertEqual(self.connection.autocommit, 1)
def testInitAutoCommitIsEnabled(self):
self.connection = OracleConnection(autocommit=1)
self.assertEqual(self.connection.autocommit, 1)
def testInitAutoCommitIsDisabled(self):
self.connection = OracleConnection(autocommit=0)
self.assertEqual(self.connection.autocommit, 0)
# host property
def testHostIsNone(self):
self.connection = OracleConnection()
self.connection.host = None
self.assertEqual(self.connection.host, None)
def testHostIsNotNone(self):
self.connection = OracleConnection()
self.connection.host = 'localhost'
self.assertEqual(self.connection.host, 'localhost')
# user property
def testUserIsNone(self):
self.connection = OracleConnection()
self.connection.user = None
self.assertEqual(self.connection.user, None)
def testUserIsNotNone(self):
self.connection = OracleConnection()
self.connection.user = '******'
self.assertEqual(self.connection.user, 'y47test')
# passwd property
def testPasswdIsNone(self):
self.connection = OracleConnection()
self.connection.passwd = None
self.assertEqual(self.connection.passwd, None)
def testPasswdIsNotNone(self):
self.connection = OracleConnection()
self.connection.passwd = 'y47test'
self.assertEqual(self.connection.passwd, 'y47test')
# sid property
def testSidIsNone(self):
self.connection = OracleConnection()
self.connection.sid = None
self.assertEqual(self.connection.sid, None)
def testSidIsNotNone(self):
self.connection = OracleConnection()
self.connection.sid = 'XE'
self.assertEqual(self.connection.sid, 'XE')
# autocommit property
def testAutoCommitIsEnabled(self):
self.connection = OracleConnection()
self.connection.autocommit = 1
self.assertEqual(self.connection.autocommit, 1)
def testAutoCommitIsDisabled(self):
self.connection = OracleConnection()
self.connection.autocommit = 0
self.assertEqual(self.connection.autocommit, 0)
# connect
def testConnectHostNotSet(self):
self.connection = OracleConnection(user='******', passwd='y47test',
sid='XE')
with self.assertRaises(ValueError):
self.connection.connect()
def testConnectUserNotSet(self):
self.connection = OracleConnection(host='localhost', passwd='y47test',
sid='XE')
with self.assertRaises(ValueError):
self.connection.connect()
def testConnectPasswdNotSet(self):
self.connection = OracleConnection(host='localhost', user='******',
sid='XE')
with self.assertRaises(ValueError):
self.connection.connect()
def testConnectSidNotSet(self):
self.connection = OracleConnection(host='localhost', user='******',
passwd='y47test')
with self.assertRaises(ValueError):
self.connection.connect()
def testConnect(self):
self.connection = OracleConnection()
self.connection.host = 'localhost'
self.connection.user = '******'
self.connection.passwd = 'y47test'
self.connection.sid = 'XE'
db = self.connection.connect
self.assertTrue('cx_Oracle.Connection' in repr(db))
db.close()