def test_connect_ok(self): conn = pycmdb.connect(tests.DATABASE) self.assertEqual(conn.database, tests.DATABASE) conn.close() conn = pycmdb.connect(tests.DATABASE) self.assertEqual(conn.database, tests.DATABASE) conn.close()
def setUp(self): self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute( 'create table {0} (id int, txt char(64), no ulong, val float)'. format(tests.TABLE)) self.recs = ((1, 'aaa', 7, 7.1), (2, u'あああ', 1073741823L, 2.1), (3, u'あああ', 1073741824L, 2.1), (4, u'あああ', 4294967296L, -1.2))
def test_insert_rollback(self): self.cursor.execute('select * from {0}'.format(tests.TABLE)) self.assertEquals(0, self.cursor.rowcount) self.cursor.executemany( "insert into {0} values(?,?,?,?)".format(tests.TABLE), self.recs) self.conn.close() self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute('select * from {0}'.format(tests.TABLE)) self.assertEquals(0, self.cursor.rowcount)
def test_error(self): conn = pycmdb.connect(tests.DATABASE) self.assertEqual(pycmdb.Warning, conn.Warning) self.assertEqual(pycmdb.Error, conn.Error) self.assertEqual(pycmdb.InterfaceError, conn.InterfaceError) self.assertEqual(pycmdb.DatabaseError, conn.DatabaseError) self.assertEqual(pycmdb.DataError, conn.DataError) self.assertEqual(pycmdb.OperationalError, conn.OperationalError) self.assertEqual(pycmdb.IntegrityError, conn.IntegrityError) self.assertEqual(pycmdb.InternalError, conn.InternalError) self.assertEqual(pycmdb.ProgrammingError, conn.ProgrammingError) self.assertEqual(pycmdb.NotSupportedError, conn.NotSupportedError) conn.close()
def _connect(self, database, **kwargs): return pycmdb.connect(database, **kwargs)
def setUp(self): self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute( 'create table {0} (id int, txt char(64), no ulong, val float)'. format(tests.TABLE))
def test_cursor(self): conn = pycmdb.connect(tests.DATABASE) cur = conn.cursor() conn.close() self.assertIsNotNone(cur)
def test_rollback(self): conn = pycmdb.connect(tests.DATABASE) conn.rollback() conn.close()
def test_commit(self): conn = pycmdb.connect(tests.DATABASE) conn.commit() conn.close()
def test_connect_error(self): with self.assertRaisesRegexp(pycmdb.InterfaceError, 'connection failed'): pycmdb.connect(tests.BAD_DATABASE)
def test_connect_ok_with_kwargs(self): conn = pycmdb.connect(database=tests.DATABASE) self.assertEqual(conn.database, tests.DATABASE) conn.close()
def tearDown(self): self.conn.close() self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute('drop table {0}'.format(tests.TABLE)) self.conn.close()
def test_connection(self): conn = pycmdb.connect(tests.DATABASE) with self.assertRaises(AttributeError): a = conn.errorhandler conn.close()
def test_messages(self): conn = pycmdb.connect(tests.DATABASE) with self.assertRaises(AttributeError): a = conn.messages conn.close()
def setUp(self): self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute( 'create table {0} (id int, txt char(64), no ulong, val float)' .format(tests.TABLE))
def setUp(self): self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.cursor.execute('create table qq0 (val int)') self.cursor.execute('create table qq1 (val int)') self.cursor.execute('create table qq2 (val int)')
def setUp(self): self.conn = pycmdb.connect(tests.DATABASE) self.cursor = self.conn.cursor() self.conn.close()