def test_insert_check_default_values(self, connection): mro.load_database(connection) table_count = mro.table1.select_count() table = mro.table1(column1 = 3, column2 = 'Hi!') table = mro.table1(column1 = 3, column2 = 'Hi!', column3 = 11, created_date = datetime.now().date()) tables = mro.table1.select() for table in tables: assert isinstance(table.id, int) assert table.id != None assert isinstance(table.created_date, date) assert table.created_date != None assert isinstance(table.column1, int) assert table.column1 != None assert isinstance(table.column2, str) assert table.column2 != None assert table.column3 == None or isinstance(table.column3, int) table = mro.table3(column3 = 'Hi56!', column4 = '{"data": 1}') table = mro.table3.select_one("column3 = 'Hi56!'") assert isinstance(table.column1, str) assert table.column1 == 'ABC DEF' assert isinstance(table.column3, str) assert table.column3 != None assert isinstance(table.column4, str) assert table.column4 != None
def test_create_object(self, connection): mro.load_database(connection) table_count = mro.table1.select_count() table = mro.table1(column1 = 3, column2 = 'Hi!', column3 = 11) assert table.column1 == 3 assert table.column2 == 'Hi!' assert table.column3 == 11 table = mro.table1(column2 = 'Hi2!') assert table.column1 == 1 assert table.column2 == 'Hi2!' assert table.column3 == None kwargs = {'column1': 5, 'column2': 'Hi3!', 'column3': 78} table = mro.table1(**kwargs) assert table.column1 == 5 assert table.column2 == 'Hi3!' assert table.column3 == 78 tables = mro.table1.select() assert table_count + 3 ==len(tables) assert tables[4].column1 == 5 assert tables[4].column2 == 'Hi3!' assert tables[4].column3 == 78
def test_multiple_column_primary_key_update(self, connection): table = mro.table1(name='Test34', value='first') selectedTable = mro.table1.select_one("name='Test34'") assert selectedTable.value == 'first' table.value = 'second' selectedTable = mro.table1.select_one("name='Test34'") assert selectedTable.value == 'second'
def test_update_multiple_values(self, connection): table = mro.table1(name='Test35', value='first') assert len(mro.table1.select("name='Test35'")) == 1 assert len(mro.table1.select("name='Test36'")) == 0 table.update(name='Test36', value='second') assert len(mro.table1.select("name='Test35'")) == 0 assert len(mro.table1.select("name='Test36'")) == 1 selectedTable = mro.table1.select_one("name='Test36'") assert selectedTable.value == 'second'
def test_insert_class_that_has_foreign_references(self, connection): mro.table1(name = 'Bob') table = mro.table3(name = 'Bob2') # test that it's a varchar not a foreign key reference table.table4s = 'test string'
def test_insert_with_only_primary_key_no_kwargs(self, connection): mro.load_database(connection) table_count = mro.table1()