def getCD(): data = [] if len(ClassDetail) == 0: sql = "select * from classdetail" cursor.execute(sql) result = cursor.fetchall() for i in result: cd = classDetail(i[0], i[1], i[2], i[3]) ClassDetail.append(cd) data.append(cd.getDict()) else: for i in ClassDetail: data.append(i.getDict()) return jsonify(data)
def getClass(): data = [] if len(Classes) == 0: sql = "select * from class" cursor.execute(sql) result = cursor.fetchall() for i in result: Classname = className(i[0], i[1], i[2], i[3], i[4], i[5]) Classes.append(Classname) data.append(Classname.getDict()) else: for i in Classes: data.append(i.getDict()) return jsonify(data)
def getTeachers(): data = [] if len(Teachers) == 0: sql = "select * from teachers" cursor.execute(sql) result = cursor.fetchall() for i in result: t = teacher(i[0], i[1], i[2]) Teachers.append(t) data.append(t.getDict()) else: for i in Teachers: data.append(i.getDict()) return jsonify(data)
def getUsers(): data = [] if 0 == len(Users): sql = "select * from users" cursor.execute(sql) result = cursor.fetchall() for i in result: user = User(i[0], i[1], i[2], i[3], i[4]) Users.append(user) data.append(user.getDict()) else: for i in Users: data.append(i.getDict()) return jsonify(data)
def getSH(): data = [] if len(StudyHistory) == 0: sql = "select * from studyhistory" cursor.execute(sql) result = cursor.fetchall() for i in result: sh = studyHistory(i[0], i[1], i[2], i[3], i[4], i[5]) StudyHistory.append(sh) data.append(sh.getDict()) else: for i in StudyHistory: data.append(i.getDict()) return jsonify(data)
def getSC(): data = [] if len(SelectClass) == 0: sql = "select * from selectclass" cursor.execute(sql) result = cursor.fetchall() for i in result: sc = selectClass(i[0], i[1], i[2], i[3]) SelectClass.append(sc) data.append(sc.getDict()) else: for i in SelectClass: data.append(i.getDict()) return jsonify(data)