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', [])