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)