def update_province_area_state(res): """ 更新各省级数据 :return: """ now = datetime.now().strftime("%Y-%m-%d %H:%M:%S") data = session.query(Count).filter(Count.area_type == 'province').all() map_data = {} for count in data: map_data[count.area_name] = count for o in res: comment = o['comment'] key = o['provinceShortName'] count = map_data.get(key) if not count: count = Count() count.from_source = 'dxy' count.area_name = key count.area_type = 'province' count.province = key session.add(count) json_to_model(count, o) if comment != '': num_data = format_data(comment) filter_data(num_data, count) count.update_time = now session.commit()
def post(self, request): context = {"form": ""} user = User.objects.get(id=request.user.id) form = NewMRFForm(request.POST) if form.is_valid(): requisition_number = form.cleaned_data['requisition_number'] department = form.cleaned_data['department'] designation = form.cleaned_data['designation'] specialization = form.cleaned_data['specialization'] manager = form.cleaned_data['manager'] count = form.cleaned_data['count'] position = Position.objects.filter(department=department, designation=designation, specialization=specialization) requisitionnocheck = MRF.objects.filter( requisition_number=requisition_number) if position and not requisitionnocheck: MRF(requisition_number=requisition_number, position=position[0], manager=manager).save() mrf = MRF.objects.filter(requisition_number=requisition_number) Count(requisition_number=mrf[0], recruiter=user, count=count).save() context['success'] = "Requsition number saved" else: context['error'] = "Requsition number is already present." context["form"] = form return render(request, "newmrfform.html", context)
def redirect_to_old(alias): new = Url.query.filter_by(alias=alias).first() if new is None: abort(404) else: new.counts += 1 date = int(datetime.datetime.today().strftime('%Y%m%d')) count = Count.query.filter_by(url_id=new.id, date=date).first() if count is None: count = Count(url_id=new.id, date=date) else: count.counts += 1 db.session.add_all([new, count]) db.session.commit() return redirect(new.origin)
def save_country_data(res): """ 保存全国的数据 :return: """ count = session.query(Count).filter(Count.area_name == '全国').first() if not count: count = Count() count.area_type = 'country' count.area_name = '全国' count.from_source = 'dxy' session.add(count) filter_data(res, count) now = datetime.now().strftime("%Y-%m-%d %H:%M:%S") count.update_time = now session.commit()
def update_city_area_state(res): data = session.query(Count).filter(Count.area_type == 'city').all() map_data = {} now = datetime.now().strftime("%Y-%m-%d %H:%M:%S") for count in data: map_data["city_" + count.province + "_" + count.area_name] = count for province in res: cities = province['cities'] province = province['provinceShortName'] for city in cities: city_key = city['cityName'] city_count = map_data.get("city_" + province + "_" + city_key) if not city_count: city_count = Count() city_count.from_source = 'dxy' city_count.area_name = city_key city_count.area_type = 'city' city_count.province = province session.add(city_count) json_to_model(city_count, city) city_count.update_time = now session.commit()
def post(self, request): context = {"form": ""} form = MRFForm(request.POST) user = User.objects.get(id=request.user.id) if form.is_valid(): requisition_number = form.cleaned_data['requisition_number'] count = form.cleaned_data['count'] mrfentry = Count.objects.filter( requisition_number=requisition_number, recruiter=request.user.id) if mrfentry: mrfentry = mrfentry[0] mrfentry.count = count mrfentry.save() context['success'] = "Requsition number updated" else: Count(requisition_number=requisition_number, recruiter=user, count=count).save() context['success'] = "Requsition number updated" context["form"] = form return render(request, "mrfform.html", context)
def index(): if 'username' in session: wordindex = request.args.get('wordindex') username = session['username'] user = User.objects(user=username).first() if user.times < 0: return (render_template("recharge.html", username=user.user, times=user.times)) else: user.update(times=user.times - 1) questlists = pd.read_json(Result.objects().to_json()) wordroot = pd.read_json(Roots.objects().to_json())['root'] rlength = len(wordroot) length = len(questlists['word']) if wordindex == None: num1 = random.randint(0, length - 1) else: num1 = questlists[( questlists.word == wordindex)].index.tolist()[0] question = questlists.take([num1]) word = question['word'][num1] hints = question['hint'][num1] #roots roots = question['root'][num1].strip('[').strip(']') roots = roots.split(',') root2 = [] for root in roots: root = root.strip(" ") root2.append(root.strip().strip("'").strip('"')) answers = "".join(root2) while len(root2) <= 5: num2 = random.randint(0, rlength - 1) temword = wordroot[num2] if temword not in root2: root2.append(temword) root2.sort() Count(word=word, user=user.user).save() #wordcounts wordcounts = len(Count.objects(word=word).all()) #hints th = hints.split(']') com = (th[0]).split(';') t1 = com[0].split('[') t2 = com[-1].split('→') wordg = '' for i in range(len(word)): wordg += '_ ' component = [wordg, t1[1]] for c in com[1:-1]: component.append(c) for t in t2: component.append(t) hint = th[1].split('。') today = date.today() wordlearned = len( Count.objects(user=user.user, create_at=today).all()) return (render_template("index.html", word=word, roots=root2, component=component, hints=hint, itemid=num1, answer=question['origin'][num1], wordcounts=wordcounts, answers=answers, username=user.user, times=user.times, wordlearned=wordlearned)) else: return render_template('login.html')