def deletestudent(request):
nid = request.GET.get('nid')
sqlhepr = SqlHeper()
sqlhepr.delete_data("delete from students where id=%s", [
nid,
])
sqlhepr.commit_data()
return redirect('/students/')
def deleteclass(request):
nid = request.GET.get('nid')
sqlhepr = SqlHeper()
sqlhepr.delete_data("delete from classes where id=%s", [
nid,
])
sqlhepr.commit_data()
sqlhepr.close_data()
return redirect('/classes/')
def modal_deleteclass(request):
sqlhepr = SqlHeper()
nid = request.POST.get('nid')
sqlhepr.delete_data("delete from classes where id=%s", [
nid,
])
sqlhepr.commit_data()
sqlhepr.close_data()
data = {}
data['status'] = 'success'
return JsonResponse(data)
def editor_tearch(request):
sqlhepr = SqlHeper()
context = {}
if request.method == 'POST':
t_id = request.GET.get('t_id')
#的到的是字符串
t2c_id = request.POST.get('t_c_ids')
# 转化为列表
import re
compile = re.compile('\d+')
t2c_id = compile.findall(t2c_id)
editor_class_ids = request.POST.getlist('editor_class_ids')
t_name = request.POST.get('t_name')
t_c = list(map(lambda x: (t_id, x), editor_class_ids))
sqlhepr.updata_data("update tearchs set tname=%s where id=%s",
[t_name, t_id])
for i in t2c_id:
sqlhepr.delete_data("delete from tearch2class where id=%s ", [i])
sqlhepr.commit_data()
sqlhepr.updata_many_data(
"insert into tearch2class (tearch_id,class_id)value(%s,%s)", t_c)
sqlhepr.commit_data()
sqlhepr.close_data()
return redirect('/tearchs/')
else:
tid = request.GET.get('tid')
tearch_name = sqlhepr.select_one_data(
"select tname from tearchs where id=%s ", [tid])
current_class_list = sqlhepr.select_all_data(
"select id ,class_id from tearch2class where tearch_id=%s", [tid])
tearch_class_ids = list(map(lambda x: x['id'], current_class_list))
current_class_ids = list(
map(lambda x: x.get('class_id'), current_class_list))
class_list = sqlhepr.select_all_data("select id,title from classes ",
[])
sqlhepr.close_data()
context['tearch_name'] = tearch_name
context['current_class_ids'] = current_class_ids
context['class_list'] = class_list
context['tearch_class_ids'] = tearch_class_ids
context['t_id'] = tid
return render(request, 'editor_tearch.html', context)
