def test_create_results_table(self):
"""Creates a results table with certain name, queries all tables
and checks that the queried last table_name equals the initial name.
"""
sql_m = SqlManager()
test_obj = TestVariables()
table_name = test_obj.entry_field_content
sql_m.sql_create_results_table(table_name)
queried_table_name = sql_m.sql_get_all_tables()
queried_table_name = [tables.table_name for tables in queried_table_name][-1][-1]
self.assertEqual(table_name, queried_table_name)
print("test_create_results_table: successful")
self.tearDownTable(table_name)
def create_results_tables(table_name, *args):
"""Creates a results table with the passed table name. *args is used only in the button widget to delete input
inside the entry widget.
*args: only needed to delete the gui entry_field after passing of data
"""
try:
# creates 2 tables: 1. for saving results and 2. a copy of the selected database
settings_obj = SettingVariables()
selected_database = settings_obj.selected_database
sql_m = SqlManager()
sql_m.sql_create_results_table(table_name)
sql_m.sql_create_database_copy(selected_database)
except sqlite3.OperationalError as oe:
print("Exception occurred in create_results_tables: " + str(oe))
def setUpResultsTable():
"""Creates new results table."""
test_obj = TestVariables()
results_table = test_obj.selected_results_table
sql_m = SqlManager()
sql_m.sql_create_results_table(results_table)
