def get_score_instance_by_user_id(self, user_id): key = self.get_score_id_key(user_id) data = self.get_instance_from_cache(key) if not data: data = Score.get_object(user_id=user_id) if isinstance(data, Exception): init_dict = {'user_id': user_id, 'score': 0, 'created': now(), 'updated': now()} data = Score(**init_dict) self.set_instance_to_cache(key, data) return data
def upload_score(self, file_path): wb = openpyxl.load_workbook(file_path) # 打开excel ws = wb.active # 选中第一个sheet rows = ws.max_row # 获取行数 columns = ws.max_column # 获取列数 score_list = [] repetition = 0 # 从第二行开始遍历每行 for row in ws.iter_rows(min_row=2, min_col=1, max_row=rows, max_col=columns): data = [i.value for i in row] # 获取每一行数据 # 查找student表,获取student_id try: student = Student.objects.get(student_num=data[1]) except: continue # 去除重复数据 if Score.objects.filter(title=data[0], student_id=student.id).exists(): repetition += 1 continue # 写入student表 score = Score( title=data[0], # 标题 student_id=student.id, # 学生id score=data[-1] # 学生分数 ) score_list.append(score) Score.objects.bulk_create(score_list) # 批量加入Score表 return repetition
def post(request): p = request.REQUEST.copy() try: secret = p["secret"] ip = p["ip"] score = p["score"] except: return HttpResponse("invalid args") if secret == settings.SCORE_POST_SECRET: q = Score(ip=ip, score=score) q.save() return HttpResponse("posted %s %s" % (ip, score)) else: return HttpResponse("invalid secret")
def post(self, request): form = PacienteForms(request.POST) if form.is_valid(): # model_instance = form.save(commit=False) dados = form.data paciente = Paciente(nome=dados['nome'], telefone=dados['telefone'], leito=dados['leito'], nome_mae=dados['nome_mae'], data_nascimento=dados['data_nascimento']) score = Score() score.save() paciente.score = score paciente.save() return redirect('paciente', paciente.id) return render(request, 'cadastrar_paciente.html', {'form': form})
def create_or_retrieve(self, request=None, uname="test", scoreval="0", format=None): page = urllib.request.urlopen('http://localhost:8000/user/' + uname) json_string = page.read() parsed_json = json.loads(json_string) if request.method == "GET": try: found_id = parsed_json['id'] user_id = Score.objects.get(id=found_id) except ObjectDoesNotExist as e: return HttpResponse(json.dumps({"status": "NoSuchUser"}), status=404) data = {"ID": user_id.id, "Score": user_id.score} return HttpResponse(json.dumps(data)) elif request.method == "POST": try: found_id = parsed_json['id'] user_id = Score.objects.get(id=found_id) return HttpResponse(json.dumps({"status": "AlreadyExists"}), status=403) except ObjectDoesNotExist as e: pass u = Score(id=found_id) u.save() return HttpResponse(json.dumps({"status": "Success"})) elif request.method == "PUT": try: found_id = parsed_json['id'] user = Score.objects.get(id=found_id) user.score = scoreval user.save() return HttpResponse(json.dumps({"status": "Success"})) except ObjectDoesNotExist as e: return HttpResponse(json.dumps({"status": "NoSuchUser"}))
def create_or_retrieve(self, request=None, idval="001", format=None): if request.method == "GET": try: found_id = Score.objects.get(id=idval) except ObjectDoesNotExist as e: return HttpResponse(json.dumps({"status": "NoSuchUser"}), status=404) data = {"ID": idval, "Score": found_id.score} return HttpResponse(json.dumps(data)) elif request.method == "POST": try: found_id = Score.objects.get(id=idval) return HttpResponse(json.dumps({"status": "AlreadyExists"}), status=403) except ObjectDoesNotExist as e: pass u = Score(id=idval) u.save() return HttpResponse(json.dumps({"status": "Success"}))
def create_or_retrieve(self, request=None, userid=0, format=None): if request.method == 'GET': try: found_score = Score.objects.get(id=userid) data = {"score": found_score.score, "id": userid} return HttpResponse(json.dumps(data), status=200) except ObjectDoesNotExist as e: return HttpResponse(json.dumps({"status": "NoSuchID"}), status=404) if request.method == "POST": try: found_user = Score.objects.get(id=userid) return HttpResponse(json.dumps({"status": "AlreadyExists"}), status=403) except ObjectDoesNotExist as e: pass s = Score(score=0) s.save() return HttpResponse(json.dumps({"status": "SuccessScoreSetToZero"}))
def get_score_of_user(self, request): score = Score.get_object(user_id=request.user.id) if isinstance(score, Exception): return 0 return score.score
def update_score(cls, request, action='comment'): # 更新缓存 ScoreCache().delete_score_instance_by_user_id(request.user.id) return Score.update_score(request, action=action)
newteachingtask.semester = semester newteachingtask.is_input = True newteachingtask.save() teachingtask = newteachingtask #print("----save one task ") from score.models import Score try: score = Score.objects.get( \ task = teachingtask, student = student, score = score ) except: newscore = Score() newscore.task = teachingtask newscore.student = student newscore.score = score newscore.save() score = newscore #print("savesocre",str(i)) ''' #补考成绩录入 if len(str(bukaoscore)) > 0 and score.score < 60: score = Score.objects.filter( \ task = teachingtask, student = student )[0] try: bukaoscore = Score.objects.get( \
def post(self, request, paciente_id): form = ScoreForms(request.POST) paciente = Paciente.objects.get(pk=paciente_id) if form.is_valid(): dados = form.data score = Score() usuario = get_usuario_logado(request) score.nivel_conciencia = dados['nivel_conciencia'] score.temperatura = float(dados['temperatura']) score.frequencia_cardiaca = int(dados['frequencia_cardiaca']) score.pa_sistolica = int(dados['pa_sistolica']) score.frequencia_respiratoria = int( dados['frequencia_respiratoria']) score.saturacao_oxigenio = int(dados['saturacao_oxigenio']) score.qualquer_o2 = dados['qualquer_o2'] score.paciente = paciente score.profissional = usuario score.save() paciente.valor_score = score.score() paciente.save() return redirect('paciente', paciente_id) return render(request, 'paciente.html', { 'form': form, 'paciente': paciente })