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