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)