def get_all(): all_competitor = [] count = 1 for i in model.competitor.query.filter_by(status=1).all(): i = competitor2dict(i) i['id'] = count count += 1 all_competitor.append(i) all_competitor = random.sample(all_competitor, len(all_competitor)) return all_competitor
def get_range(): range = [] count = 1 for i in model.competitor.query.filter_by( status=1).order_by("count").all(): i = competitor2dict(i) i['id'] = count count += 1 range.append(i) return range
def get_offline_competitors(): offline_competitors = [] count = 1 for i in model.competitor.query.filter_by( method=2, status=1).order_by("count").limit(6).all(): i = competitor2dict(i) i['id'] = count count += 1 offline_competitors.append(i) return offline_competitors
def get_detail(name,position): cur_competitor = competitor.query.filter_by(name=name,position=position).all()[0] cur_messages = cur_competitor.message messages = [] for message in cur_messages: message = message2dict(message) messages.append(message) cur_competitor = competitor2dict(cur_competitor) #return dumps(dict(messages=messages,competitor=cur_competitor)) return render_template('userInfo.html',competitor=cur_competitor,messages=messages)
def login(): if request.method == 'GET': return render_template('login.html') phone = request.form['phone'] password = request.form['password'] cur_reference = reference.query.filter_by(phone=phone, password=password).all()[0] if cur_reference is not None: competitor = competitor2dict(cur_reference.competitor[0]) #return dumps(competitor) return render_template('edit.html', competitor=competitor,reference=cur_reference) return dumps({'statu': 1})
def get_detail_1(phone): cur_reference = reference.query.filter_by(phone=phone).all()[0] cur_competitor = cur_reference.competitor[0] cur_messages = cur_competitor.message messages = [] for message in cur_messages: message = message2dict(message) messages.append(message) cur_competitor = competitor2dict(cur_competitor) #return dumps(dict(messages=messages, competitor=cur_competitor)) return render_template('userInfo.html',competitor=cur_competitor,messages=messages)