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'))