def test_connection_context(self):
"""Test for Connection context manager methods"""
with connect(self.dsn) as conn:
dbptr = getattr(conn, '_dbptr')
self.assertNotEqual( _ds._dbquery(dbptr,_ds.dbDATABASE_COUNT), 0 )
self.assertEqual( _ds._dbquery(dbptr,_ds.dbDATABASE_COUNT), 0 )
def dbprocess(self, args):
"""
connect to a db, run dbprocess, close connection
"""
cmds = [c.encode() for c in args[0]] # no Unicode support sux
with dbapi2.connect(self.dbname) as conn:
curs = conn.cursor(**self.cursor_params)
nrecs = curs.execute('dbprocess', [cmds])
desc = curs.description
rows = [c for c in curs]
return {'cursor': {'description': desc, 'rows': rows}}
def test_cursor(self):
"""Test for Cursor Constructor"""
with connect(self.dsn) as conn:
curs = conn.cursor()
self.assertTrue( hasattr( curs, '_dbptr') )
self.assertTrue( hasattr( curs, 'CONVERT_NULL') )
self.assertTrue( hasattr( curs, 'CONVERT_DATETIME') )
self.assertTrue( hasattr( curs, 'row_factory') )
self.assertTrue( hasattr( curs, 'connection') )
self.assertTrue( hasattr( curs, 'rownumber') )
self.assertTrue( hasattr( curs, 'rowcount') )
self.assertTrue( hasattr( curs, '_nullptr') )
self.assertTrue( hasattr( curs, 'description') )
self.assertTrue( hasattr( curs, 'execute') )
self.assertTrue( hasattr( curs, 'executemany') )
self.assertTrue( hasattr( curs, '_fetch') )
self.assertTrue( hasattr( curs, 'fetchone') )
self.assertTrue( hasattr( curs, 'fetchmany') )
self.assertTrue( hasattr( curs, 'fetchall') )
self.assertTrue( hasattr( curs, 'scroll') )
self.assertTrue( hasattr( curs, '__init__') )
self.assertTrue( hasattr( curs, '__iter__') )
def setUp(self):
self.dsn = '/opt/antelope/data/db/demo/demo'
self.NRECS_ORIGIN = 1351
self.conn = connect(self.dsn)
self.curs = self.conn.cursor()
def test_connection_cursor(self):
"""Test for Connection cursor function"""
with connect(self.dsn) as conn:
self.assertIsInstance( conn.cursor(), Cursor )
def test_connect(self):
"""Test for connect function"""
conn = connect(self.dsn)
self.assertIsInstance(conn, Connection)
conn.close()
