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 create_exam_database(table_name, *args): """Creates a database table with the passed table name. *args: only needed to delete the gui entry_field after passing of data """ sql_m = SqlManager() sql_m.sql_create_exam_database(table_name)
def setUpDatabase(): """Creates new database table.""" test_obj = TestVariables() sql_m = SqlManager() sql_m.sql_create_exam_database(test_obj.entry_field_content)
from tkinter import * import sqlite3 from app_interface import AppInterface from sql_manager import SqlManager # todo errors should be saved to logfile # Create an example database table sql_m = SqlManager() try: sql_m.sql_create_exam_database("example_exam_database") print("Example Table Was Created") except sqlite3.OperationalError as oe: print("sqlite3.OperationalError occurred: " + str(oe)) # ===== Main ===== root = Tk() root.title("SQL Exam Simulator") gui_w = AppInterface(root) gui_w.gui_main_menu(root) AppInterface().set_up_settings() root.mainloop()