def insert_data():
print 'request',request
if request.method == 'POST':
c_ids = request.get_json().get('c_ids') #数组
name = request.get_json().get('name')
phone = request.get_json().get('telphone')
departure = request.get_json().get('departure')
a_id = request.get_json().get('a_id')
# time = request.get_json().get('time')
insert_time = curtime()
passenger = request.get_json().get('passenger')
print 'c_ids',c_ids
# r = True
r = check(phone,a_id)
print 'r', r
if r:
return jsonify({'code': '0', 'msg': '该号码 '+phone+' 已经参加此次活动！'})
#以下未完成，
#更新person_info表（有则按phone更新，无则插入）
text = "insert into person_info (name,phone,start_position) values ('%s','%s','%s') on conflict(phone) do update set name=EXCLUDED.name , start_position=EXCLUDED.start_position" % (name,phone,departure)
db_session.execute(text)
db_session.commit()
#插入join_content表
has_car = ''
if passenger != '无':
has_car = 'yes'
else:
has_car = 'no'
for c_id in c_ids:
text = "insert into join_act_cont (phone,c_id,drive_people,drive_car,insert_time) " \
"values ('%s','%s','%s','%s','%s')" % (phone,c_id,passenger,has_car,insert_time)
db_session.execute(text)
db_session.commit()
return jsonify({'code':'1', 'msg':'报名成功！'})
def patch(self):
args = highscorePostParser.parse_args()
score = args.score
jwt_encoded = args['Authorization'][7:]
jwt_payload = jwt.decode(jwt_encoded, JWT_SECRET, algorithms=['HS256'])
user_highscore = db_session.query(Highscore).filter_by(
user_id=jwt_payload['user_id']).first()
if (user_highscore is not None):
if (user_highscore.score < score):
user_highscore.score = score
db_session.commit()
return {
'status': 200,
'updated': True,
'message': 'Highscore updated.'
}, 200
else:
return {
'status': 200,
'updated': False,
'message': 'Highscore could not be updated.'
}, 200
else:
return {
'status': 404,
'message': 'The server could not find your user account.'
}, 404
pass
def create_a2c_relationship(a_id, c_ids):
"""创建活动与活动内容的关联"""
if a_id and c_ids:
for c_id in c_ids:
sql = """insert into act_has_cont (a_id, c_id) values (:a_id, :c_id)"""
try:
db_session.execute(sql, {'a_id': a_id, 'c_id': c_id})
except Exception as e:
print 'create_a2c_relationship=>ERROR,str(e): ', str(e)
db_session.commit()
def post(self):
username = request.form.get('username', None)
password = request.form.get('password', None)
if username and password:
enc_password = AESCipher().encrypt(password)
set_account = User(username, enc_password)
conn.add(set_account)
conn.commit()
return redirect(url_for('Accounts.accounts'))
def create_act_cont(a_id, cont_form):
'''创建活动内容'''
# 创建活动
print 'create_act_cont=>a_id', a_id
latest_cid = get_latest_content_id() # 已存在的最大c_id c4
c_ids = [] # 此a_id的所有活动内容的id
activates = cont_form.get('activates')
step = 1
for act_cont in activates:
c_id = 'c' + str(int(latest_cid[1:])+step)
c_ids.append(c_id)
charger = act_cont.get('charger')
company = act_cont.get('company')
start_time = act_cont.get('start_time')
end_time = act_cont.get('end_time')
bus_station = act_cont.get('bus_station')
gps = act_cont.get('gps')
address = act_cont.get('address')
print 'c_id', c_id
print 'type(charger)', type(charger), 'charger', charger
print 'type(company)', type(company), 'company', company
print 'type(start_time)', type(start_time), 'start_time', start_time
print 'type(bus_station)', type(bus_station), 'bus_station', bus_station
print 'type(end_time)', type(end_time), 'end_time', end_time
print 'type(gps)', type(gps), 'gps', gps
print 'type(address)', type(address), 'address', address
# 插入活动
sql = """insert into act_content (c_id,charger,company,time_start,time_end,addr,gps,bus_station)
values (:c_id,:charger,:company,:time_start,:time_end,:addr,:gps,:bus_station)"""
try:
db_session.execute(sql, {
'c_id': c_id, 'charger': charger, 'company': company, 'time_start': start_time,
'time_end': end_time, 'addr': address, 'gps': gps, 'bus_station': bus_station
})
except Exception as e:
print 'create_act_cont=>ERROR,str(e): ', str(e)
step += 1
# 全部插入后才提交
db_session.commit()
# 创建活动与活动内容的关联
create_a2c_relationship(a_id, c_ids)
def post(self):
args = userParser.parse_args()
print(args)
errors = UserRegistrationSchema().validate(args)
if any(errors):
error_string = ""
for i in errors:
error_string += ";".join(errors[i]) + ";"
return {'code': 'VALIDATION_ERROR', "error": True, 'errors': error_string[0:-1]}, 400
user = User(username=args.username, hash=args.password)
highscore = Highscore(user=user)
try:
db_session.add(user)
db_session.add(highscore)
db_session.commit()
except IntegrityError as err:
return {'code': 'BAD_REQUEST', "error": True,'errors': "Username already exists."}, 403
except Exception:
return {'code': 'INTERNAL_ERROR', "error": True, 'errors': 'An unknown error occurred, try again later.'}, 500
return {'code': 'SUCCESS', "error": False, 'message': 'User was created.'}, 201
pass
def create_act():
'''创建活动'''
if request.method == 'POST':
latest_id = get_latest_act_id()
a_id = 'a' + str(int(latest_id[1:]) + 1) #自动设置最新的活动id
print "request.get_json().get('actForm')", request.get_json().get('actForm')
print "request.get_json().get('contForm')", request.get_json().get('contForm')
# 活动内容列表
cont_form = request.get_json().get('contForm')
# 创建活动
act_form = request.get_json().get('actForm')
act_title = act_form.get('act_title')
act_desc = act_form.get('act_desc')
date_start = act_form.get('date_start').split('T')[0]
date_end = act_form.get('date_end').split('T')[0]
act_contact = act_form.get('act_contact') # 活动联系人
is_all = act_form.get('is_all')
print 'type(a_id)', type(a_id), 'a_id',a_id
print 'type(act_title)', type(act_title), 'act_title',act_title
print 'type(act_desc)', type(act_desc), 'act_desc',act_desc
print 'type(date_start)', type(date_start), 'date_start',date_start
print 'type(date_end)', type(date_end), 'date_end',date_end
print 'type(act_contact)', type(act_contact), 'act_contact',act_contact
print 'type(is_all)', type(is_all), 'is_all',is_all
try:
# 新建活动
sql = "insert into activities (a_id,act_title,act_desc,date_start,date_end,act_contact,is_all)" \
"values (:a_id,:act_title,:act_desc,:date_start,:date_end,:act_contact,:is_all)"
db_session.execute(sql, {'a_id':a_id,'act_title':act_title,'act_desc':act_desc,'date_start':date_start,
'date_end':date_end,'act_contact':act_contact,'is_all':is_all})
db_session.commit()
# 新建活动内容
create_act_cont(a_id, cont_form)
return jsonify({'code': '1', 'msg': '创建活动成功！'})
except Exception as e:
print 'create_act=>ERROR,str(e): ', str(e)
return jsonify({'code': '0', 'msg': '创建活动失败，请联系管理员！'})