def show_all_tables(self): """Function passes the order to SqlManager to query all table names in database.""" sql_m = SqlManager() all_tables = sql_m.sql_get_all_tables() tables_list = [tables.table_name for tables in all_tables] self.gui_show_all_tables(tables_list) return tables_list
def test_create_exam_database(self): """Creates a database 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_exam_database(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 + "_db", queried_table_name) print("test_create_exam_database: successful") self.tearDownTable(table_name + "_db")
def test_create_database_copy(self): """Creates a database copy table with certain name, queries all tables and checks that the queried last table_name equals the initial name. """ test_obj = TestVariables() selected_database = test_obj.selected_database self.setUpDatabase() sql_m = SqlManager() sql_m.sql_create_database_copy(selected_database) 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(selected_database + "_copy", queried_table_name) print("test_create_database_copy: successful") self.tearDownTable(selected_database) self.tearDownTable(selected_database + "_copy")
def set_up_settings(self): """Function selects each one of the three table types: database, results, database_copy.""" sql_m = SqlManager() all_tables = sql_m.sql_get_all_tables() database_list = DatabaseTables().get_settings_variables(all_tables) results_list = ResultsTables().get_settings_variables(all_tables) database_copy_list = DatabaseCopyTables().get_settings_variables( all_tables) database_list = [database.database_name for database in database_list] results_list = [results.results_name for results in results_list] database_copy_list = [ database_copy.database_copy_name for database_copy in database_copy_list ] self.gui_setting_menu(database_list, results_list, database_copy_list) return database_list, results_list, database_copy_list