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
