def post(self):
department_name = self.request.get('department_name')
department_id = int(self.request.get('department_id') or 0)
if department_id:
department = Department.get_by_id(department_id)
department.department_name = department_name
department.put()
else:
department = Department(
id = department_id,
department_name = department_name
)
department.put()
self.redirectto('/department')
def get(self):
faculties = db.GqlQuery("SELECT * FROM Faculty")
departments = db.GqlQuery("SELECT * FROM Department")
# for faculty in faculties:
# # found = False
# for department in departments:
# if faculty.department == department.key().id():
# # found = True
# # faculty.department = department.department_name
# # faculty['department'] = department.department_name
# break
f = []
for faculty in faculties:
f.append({
'id': faculty.key().name(),
'faculty_name': faculty.faculty_name,
'department_id': faculty.department,
'department_name': Department.get_by_id(faculty.department).department_name
})
self.render("faculty.html",{'faculties':f, 'departments':departments})
def get(self):
teachers = db.GqlQuery("Select * from Teacher")
departments = db.GqlQuery("Select * from Department")
# class_courses = db.GqlQuery("Select * from ClassCourse")
r = []
for teacher in teachers:
r.append(
{
"id": teacher.key().id(),
"teacher_name": teacher.teacher_name,
"department_id": teacher.department,
"department_name": Department.get_by_id(teacher.department).department_name,
"teaching_time": teacher.teaching_time,
}
)
self.render(
"teacher.html",
{
"teachers": r,
"departments": departments,
# 'class_courses': class_courses
},
)
