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()