def test_open_existing(self):
db = sqlite.Database(test_db_name)
filter_db = sqlite.Table('test_table', db)
filter_db.create(('unique_id', 'INTEGER'), ('name', 'TEXT'), ('active', 'INTEGER'))
filter_db.insert("123", "N", True)
filter_db.commit()
db = sqlite.Database(test_db_name)
filter_db = sqlite.Table('test_table', db)
# May not create a new db file when it already exists on disk
self.assertRaises(IOError, filter_db.create,
('unique_id', 'INTEGER'), ('name', 'TEXT'), ('active', 'INTEGER'))
db = sqlite.Database(test_db_name)
filter_db = sqlite.Table('test_table', db)
# Will open existing database and skip creating a new table with the specified columns
filter_db.create(('unique_id', 'INTEGER'), ('name', 'TEXT'), ('active', 'INTEGER'),
mode="open")
records = filter_db(unique_id="123")
self.assertEqual(records[0], {'active': 1, '__id__': 1, 'unique_id': 123, 'name': u'N'})
# Overwrites existing db
filter_db.create(('unique_id', 'INTEGER'), ('name', 'TEXT'), ('active', 'INTEGER'),
mode="override")
records = filter_db(unique_id="123")
self.assertEqual(records, [])
db.close()
def setUp(self): # NOQA
self.first_record_id = 1
db = sqlite.Database(":memory:")
filter_db = sqlite.Table('test_database', db)
filter_db.create(('unique_id', 'INTEGER'), ('name', 'TEXT'),
('active', 'INTEGER'))
self.filter_db = filter_db
def test_00_create(self):
db = sqlite.Database(":memory:")
t1 = db.create('table1', ('name', 'TEXT'),
('birth', 'DATE DEFAULT CURRENT_DATE'), ('age', 'INT'),
mode="override")
t1.is_date('birth')
def setUp(self): # NOQA
self.db = sqlite.Database(":memory:")
self.db.create('table1',
('name', 'TEXT'),
('birth', 'DATE DEFAULT CURRENT_DATE'),
('age', 'INT'),
mode="override")
def test_with_statment(self):
with sqlite.Database(":memory:") as db:
pass
