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'
