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()
