def test_can_create_table(self): fields = [ {'name': 'id', 'type': 'INTEGER', 'indexed': True}, {'name': 'name', 'type': 'TEXT'} ] schema.create_table('testing', fields) sql.db_insert(settings.PGA_DB, 'testing', {'name': "testok"}) results = sql.db_select(settings.PGA_DB, 'testing', fields=['id', 'name']) self.assertEqual(results[0]['name'], "testok")
def create_table(self): schema.create_table(self.tablename, self.schema)
def test_cant_create_empty_table(self): with self.assertRaises(OperationalError): schema.create_table('emptytable', [])