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