def edit_teacher(request):
if request.method == 'GET':
nid = request.GET.get('tid')
name = request.POST.get('name')
obj = SqlHeper()
teacher_info = obj.get_one('select id,name from teacher where id=%s', [
nid,
])
class_list = obj.get_list('select id,title from classes')
class_id_list = obj.get_list(
'select class_id from teacher2class where teacher_id=%s', [
nid,
])
lst = []
for item in class_id_list:
lst.append(item['class_id'])
class_id_list = lst
return render(
request, 'edit_teacher.html', {
'teacher_info': teacher_info,
'class_list': class_list,
'class_id_list': class_id_list,
'tid': nid
})
else:
nid = request.GET.get('nid')
name = request.POST.get('name')
class_id_list = request.POST.getlist('clsid')
obj = SqlHeper()
obj.modify('update teacher set name=%s where id=%s', [name, nid])
print(nid)
obj.modify('delete from teacher2class where teacher_id=%s', [
nid,
])
lst = []
for cls in class_id_list:
lst.append((nid, cls))
obj.multiple_modify(
'insert into teacher2class(teacher_id,class_id) value(%s,%s)', lst)
obj.close()
return redirect('/teacher/')
def edit_class(request, *args):
obj = SqlHeper()
if request.method == 'GET':
#nid = request.GET.get('nid')
nid = args[0]
result = obj.get_one("select id,title from classes where id=%s", [nid])
title = result['title']
return render(request, "edit_class.html", {'nid': nid, 'title': title})
else:
#nid = request.POST.get('nid')
nid = args[0]
title = request.POST.get('title')
obj.modify("update classes set title=%s where id=%s", [
title,
nid,
])
return redirect('/classes/')