def test_simple_db(self): db = SQLiteDBMS(get_temp_filename()) db.create_table('TEST', [('id', 'INT'), ('data', 'TEXT')]).result() db.execute('INSERT INTO TEST VALUES (1,"a")').result() self.assertIn((1, 'a'), db.select('SELECT * from TEST')) self.assertEqual((1, 'a'), db.select_one('SELECT * from TEST'))
def test_simple_db(self): db = SQLiteDBMS(get_temp_filename()) db.create_table('TEST', set([('id', 'INT'), ('data', 'TEXT')])).result() db.execute('INSERT INTO TEST VALUES (1,"a")').result() self.assertIn(('1', 'a'), db.select('SELECT * from TEST')) self.assertEqual(('1', 'a'), db.select_one('SELECT * from TEST'))
def test_simple_db_with_pk(self): db = SQLiteDBMS(get_temp_filename()) fr = db.create_table('TEST', [('id', 'INT'), ('data', 'TEXT')],['id']) fr.result() self.assertEqual([], db.select('SELECT * from TEST'))
def test_simple_db_with_pk(self): db = SQLiteDBMS(get_temp_filename()) fr = db.create_table('TEST', [('id', 'INT'), ('data', 'TEXT')], ['id']) fr.result() self.assertEqual([], db.select('SELECT * from TEST'))