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
})