def reload(root, conni, entries): configure_lables(root,conni) response = messagebox.askquestion("Reload Database","Do you wish to continue?\n\nAll progress will be lost") if response=='yes': cur = conni.cursor() cur.execute("DROP TABLE Classroom_Data") cur.execute("DROP TABLE Professor_Data") cur.execute("DROP TABLE Course_Data") cur.execute("DROP TABLE Instructor_Slots") cur.execute("DROP TABLE Allocated_subjs") conni.commit() index = 0 limit = 8 for i in ascii_uppercase: slot_no = int(ord(i) - ord("A")) num = slots[slot_no] for n in range(20): e[n+ slot_no*20].config(text="-",bg=colours[slot_no]) index += 1 if index==limit: break for i in range(8): slots[i] = 0 exec(open("./test.py").read()) exec(open("./allocate.py").read()) global db db = r"test.db" global conn conn = allocate.create_connection(db)
def modify(root, conn, entries): configure_lables(root, conn) response = messagebox.askquestion("Modify Database","Do you wish to continue?\n\nAll progress will be lost") if response=='yes': index = 0 limit = 8 for i in ascii_uppercase: slot_no = int(ord(i) - ord("A")) num = slots[slot_no] for n in range(20): e[n+ slot_no*20].config(text="-",bg=colours[slot_no]) index += 1 if index==limit: break cur = conn.cursor() cur.execute("DROP TABLE Instructor_Slots") cur.execute("DROP TABLE Allocated_subjs") conn.commit() for i in range(8): slots[i] = 0 exec(open("./allocate.py").read()) conn = allocate.create_connection(db) db_modify.main()
def main(): db = r"timetable_database.db" conn = allocate.create_connection(db) UserInterface(conn) if conn: conn.close()
def main(): db = r"test.db" conn = allocate.create_connection(db) UserInterface(conn) if conn: conn.close()
import csv import sys import os import allocate import numpy import string from string import ascii_uppercase from test import col_nums from test import basket_nums import db_modify import time exec(open("./test.py").read()) exec(open("./allocate.py").read()) db = r"timetable_database.db" conn = allocate.create_connection(db) fields = ('Course','Classroom','Slot','Row') fields2 = ['Slot','Row','Classroom'] e = [] slots = [0,0,0,0,0,0,0,0] colours= ["#c3c388","#ffcce6","#d9b3ff","#e6b3b3","#ffd9b3","#b3e6ff","#ffdf80","#99ff99","#ffb3b3","#d9d9d9"] entry_colours= ["#ecffb3","#ecffb3","#d9b3ff","#e6b3b3","#ffd9b3","#ffd1b3","#ffdf80","#99ff99","#ffb3b3","#d9d9d9"] clash_colour = "#ff704d" error_labels = [] def create_errorLables(root,conn): for i in range(0,5): error_labels.append(Label(root,text="-",fg="red")) error_labels[i].grid(row=i+10)