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 _connect(self, database, **kwargs):
return pycmdb.connect(database, **kwargs)
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()
