def testDBPropertyFileDoesNotExist(self): import os.path f = 'foo.db' self.sqlite = SQLiteConnection() self.sqlite.database = f self.assertEqual(os.path.isfile(self.sqlite.database), False)
def testDBPropertyFileExists(self): import os.path self.sqlite = SQLiteConnection() self.sqlite.database = FILENAME self.assertEqual(os.path.isfile(self.sqlite.database), True)
def testDBPropertyIsNone(self): self.sqlite = SQLiteConnection() self.sqlite.database = None self.assertEqual(self.sqlite.database, None)
def testDBPropertyIsMemory(self): self.sqlite = SQLiteConnection() self.sqlite.database = ':memory:' self.assertEqual(self.sqlite.database, ':memory:')
def testDatabaseIsMemory(self): self.sqlite = SQLiteConnection(database=':memory:') self.assertEqual(self.sqlite.database, ':memory:')
def testAutoCommitInTypes(self): self.sqlite = SQLiteConnection(autocommit=None) self.assertTrue(self.sqlite.autocommit in self.sqlite._autocommit_levels)
def testDatabaseIsNone(self): self.sqlite = SQLiteConnection(database=None) self.assertEqual(self.sqlite.database, None)
class TestSQLiteConnection(unittest.TestCase): # database from __init__ def testDatabaseIsNone(self): self.sqlite = SQLiteConnection(database=None) self.assertEqual(self.sqlite.database, None) def testDatabaseIsMemory(self): self.sqlite = SQLiteConnection(database=':memory:') self.assertEqual(self.sqlite.database, ':memory:') def testDatabaseFileExists(self): import os.path self.sqlite = SQLiteConnection(database=FILENAME) self.assertEqual(os.path.isfile(self.sqlite.database), True) def testDatabaseFileDoesNotExist(self): import os.path f = 'foo.db' self.sqlite = SQLiteConnection(database=f) self.assertEqual(os.path.isfile(self.sqlite.database), False) # autocommit in __init__ def testAutoCommitInTypes(self): self.sqlite = SQLiteConnection(autocommit=None) self.assertTrue(self.sqlite.autocommit in self.sqlite._autocommit_levels) # database as property def testDBPropertyIsNone(self): self.sqlite = SQLiteConnection() self.sqlite.database = None self.assertEqual(self.sqlite.database, None) def testDBPropertyIsMemory(self): self.sqlite = SQLiteConnection() self.sqlite.database = ':memory:' self.assertEqual(self.sqlite.database, ':memory:') def testDBPropertyFileExists(self): import os.path self.sqlite = SQLiteConnection() self.sqlite.database = FILENAME self.assertEqual(os.path.isfile(self.sqlite.database), True) def testDBPropertyFileDoesNotExist(self): import os.path f = 'foo.db' self.sqlite = SQLiteConnection() self.sqlite.database = f self.assertEqual(os.path.isfile(self.sqlite.database), False) # autocommit def testAutoCommitNotInTypes(self): with self.assertRaises(ValueError): self.sqlite = SQLiteConnection() self.sqlite.autocommit = 'FOO' # connect def testConnectDatabaseNotSet(self): self.sqlite = SQLiteConnection() with self.assertRaises(ValueError): self.sqlite.connect() def testConnect(self): self.sqlite = SQLiteConnection() self.sqlite.database = FILENAME db = self.sqlite.connect self.assertTrue('sqlite3.Connection' in repr(db)) db.close()
def testConnect(self): self.sqlite = SQLiteConnection() self.sqlite.database = FILENAME db = self.sqlite.connect self.assertTrue('sqlite3.Connection' in repr(db)) db.close()
def testConnectDatabaseNotSet(self): self.sqlite = SQLiteConnection() with self.assertRaises(ValueError): self.sqlite.connect()
def testAutoCommitNotInTypes(self): with self.assertRaises(ValueError): self.sqlite = SQLiteConnection() self.sqlite.autocommit = 'FOO'