def test_Table_renaming(self):
db.create_table('t', default_cols(a='text'))
table = Table('t')
table.rename('s')
table.save()
self.assertFalse(db.table_exists('t'))
self.assertTrue(db.table_exists('s'))
def test_Table_drop_if_exist_drops_correctly(self):
db.create_table('t', default_cols(a='text'))
table = Table('t')
table.drop_if_exists()
self.assertFalse(db.table_exists('t'))
def test_Table_droping(self):
db.create_table('t', default_cols(a='text'))
table = Table('t')
table.drop()
self.assertFalse(db.table_exists('t'))
def test_new_Table_adding_cols_with_expression(self):
with Table('t') as t:
t.create_columns(name=Text(), number=Integer())
self.assertTrue(db.table_exists('t'))
self.assertEqual(db.table_fields_types('t'), {
'name': 'text',
'number': 'integer'
})
def test_new_Table_adding_cols(self):
t = Table('t')
t.create_columns(name=Text(), number=Integer())
t.save()
self.assertTrue(db.table_exists('t'))
self.assertEqual(db.table_fields_types('t'), {
'name': 'text',
'number': 'integer'
})
def test_Table_adding_cols_with_object_syntax(self):
t = Table('t')
t.text = Text()
t.number = Integer()
t.save()
self.assertTrue(db.table_exists('t'))
self.assertEqual(db.table_fields_types('t'), {
'text': 'text',
'number': 'integer'
})
def test_Table_adding_foreing_constaints(self):
with Table('s') as s:
s.t = Integer()
t = Table('t')
t.text = Text()
t.text.references = 's (t)'
t.save()
db.create('t', text='ay')
self.assertTrue(db.table_exists('t'))