break
ins_schoolyears = "INSERT INTO timetable(ID, Date, Time, Subject, Class, Room, Substitution) " \
"VALUES(%d,'%s','%s','%s','%s','%s','%s');" % (counter, splitted[0], splitted[1],splitted[2],splitted[3],splitted[4], "No")
execute(ins_schoolyears)
#
# Program Sequence
#
create_database()
# create table for Mr. Hager
create_t_timetable="CREATE TABLE IF NOT EXISTS timetable(" \
"ID INTEGER PRIMARY KEY AUTOINCREMENT," \
"Date VARCHAR(20) NOT NULL," \
"Time VARCHAR(10) NOT NULL," \
"Subject VARCHAR(10) NOT NULL," \
"Class VARCHAR(10) NOT NULL," \
"Room VARCHAR(10) NOT NULL," \
"Substitution VARCHAR(10) NOT NULL);" \
# create table inside our database
execute(create_t_timetable)
# Fill DB.
fill_database()
# Close all sessions.
CONNECTION.commit()
CONNECTION.close()
WebUntis_Session.close_session(WEBUNTIS_SESSION)
# This is just a testing-file and is not a relevant script of our diploma project.
#
import WebUntis_Session
import WebUntisData
import datetime
import json
import re
session = WebUntis_Session.open_session()
id = 365
#WebUntisData.printClasses()
#printDepartments()
#printRooms()
#printSubjects()
print(WebUntisData.getTeacherID("BRE"))
#printSchoolyears()
#printSubstitutions()
#printTimetable(id)
#print(getSubstitutions())
#print(WebUntisData.getClasses())
#WebUntisData.printAllSubstitutions()
#x = WebUntisData.getSubstitutionForSpecificTeacher("KOR")
#print(WebUntisData.printSubstitutionForSpecificTeacher("KOR"))
#WebUntisData.printAllSubstitutions()
#WebUntisData.checkForSubstitutions()
WebUntis_Session.close_session(session)
ins_schoolyears = "INSERT INTO timetable(ID, Date, Time, Subject, Class, Room, Substitution) " \
"VALUES(%d,'%s','%s','%s','%s','%s','%s');" % (counter, splitted[0], splitted[1],splitted[2],splitted[3],splitted[4], "No")
execute(ins_schoolyears)
#
# Program Sequence
#
create_database()
# create table for Mr. Hager
create_t_timetable="CREATE TABLE IF NOT EXISTS timetable(" \
"ID INTEGER PRIMARY KEY AUTOINCREMENT," \
"Date VARCHAR(20) NOT NULL," \
"Time VARCHAR(10) NOT NULL," \
"Subject VARCHAR(10) NOT NULL," \
"Class VARCHAR(10) NOT NULL," \
"Room VARCHAR(10) NOT NULL," \
"Substitution VARCHAR(10) NOT NULL);" \
# create table inside our database
execute(create_t_timetable)
# Fill DB.
fill_database()
# Close all sessions.
CONNECTION.commit()
CONNECTION.close()
WebUntis_Session.close_session(WEBUNTIS_SESSION)
# This is just a testing-file and is not a relevant script of our diploma project.
#
import WebUntis_Session
import WebUntisData
import datetime
import json
import re
session = WebUntis_Session.open_session()
id = 365
#WebUntisData.printClasses()
#printDepartments()
#printRooms()
#printSubjects()
print(WebUntisData.getTeacherID("BRE"))
#printSchoolyears()
#printSubstitutions()
#printTimetable(id)
#print(getSubstitutions())
#print(WebUntisData.getClasses())
#WebUntisData.printAllSubstitutions()
#x = WebUntisData.getSubstitutionForSpecificTeacher("KOR")
#print(WebUntisData.printSubstitutionForSpecificTeacher("KOR"))
#WebUntisData.printAllSubstitutions()
#WebUntisData.checkForSubstitutions()
WebUntis_Session.close_session(session)
