def students(request): sqlhepr = SqlHeper() result = sqlhepr.select_all_data( "select students.id, students.name,students.class_id, classes.title from students left JOIN classes on students.class_id = classes.id", []) class_list = sqlhepr.select_all_data("select id ,title from classes ", []) sqlhepr.close_data() context = {} context['students'] = result context['class_list'] = class_list return render(request, 'students.html', context)
def classes(request): sqlhepr = SqlHeper() result = sqlhepr.select_all_data("select * from classes", []) sqlhepr.close_data() context = {} context['classes'] = result return render(request, 'classes.html', context)
def modal_add_tearch(request): context = {} if request.method == 'GET': import time time.sleep(1) sqlheper = SqlHeper() class_list = sqlheper.select_all_data("select id,title from classes", []) sqlheper.close_data() context['class_list'] = class_list else: try: t_name = request.POST.get('t_name') class_id_list = request.POST.getlist('class_id_list') sqlheper = SqlHeper() t_id = sqlheper.lastrowid("insert into tearchs (tname)value(%s)", [ t_name, ]) t_c_id = list(map(lambda x: (t_id, x), class_id_list)) sqlheper.insert_many_data( "insert into tearch2class (tearch_id,class_id)value(%s,%s)", t_c_id) sqlheper.commit_data() sqlheper.close_data() context = {} context['status'] = 'success' except Exception as e: context['status'] = 'error' context['message'] = str(e) return JsonResponse(context)
def tearchs(request): sqlhepr = SqlHeper() tearchs_list = sqlhepr.select_all_data( """ select tearch2class.id, tearchs.id as tid ,tearchs.tname,classes.title from tearch2class left join tearchs on tearch2class.tearch_id=tearchs.id left join classes on tearch2class.class_id=classes.id """, []) sqlhepr.close_data() res = {} for data in tearchs_list: tid = data['tid'] if tid in res: res[tid]['titles'].append(data['title']) else: res[tid] = { "tid": data['tid'], 'name': data['tname'], 'titles': [ data['title'], ] } context = {} context['tearchs_list'] = res return render(request, 'tearchs.html', context)
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)
def addstudent(request): sqlhepr = SqlHeper() if request.method == 'POST': student_name = request.POST.get('addstudent') class_id = request.POST.get('class_name') sqlhepr.insert_data( "insert into students (name,class_id) value(%s,%s)", [student_name, class_id]) sqlhepr.commit_data() sqlhepr.close_data() return redirect('/students/') else: class_list = sqlhepr.select_all_data("select * from classes", []) context = {} context['class_list'] = class_list sqlhepr.close_data() return render(request, 'addstudent.html', context)
def editor(request): nid = request.GET.get('nid') sqlhepr = SqlHeper() if request.method == "POST": name = request.POST.get('editor') class_id = request.POST.get('class_name') sqlhepr.updata_data( "update students set name=%s,class_id=%s where id=%s", [name, class_id, nid]) sqlhepr.commit_data() sqlhepr.close_data() return redirect('/students/') else: result = sqlhepr.select_one_data( "select id,name ,class_id from students where id=%s", [ nid, ]) class_list = sqlhepr.select_all_data("select * from classes", []) sqlhepr.close_data() context = {} context['class_list'] = class_list context['result'] = result return render(request, "editorstudent.html", context)