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)
