def insert():
user = User()
order = Order()
#dict可以获取user类当中的所有属性 print(user.__dict__)
user.name = request.args.get('name')
user.idcard = request.args.get('idcard')
user.sex = request.args.get('sex')
#Flask进行插入时默认使用事物,事先读取文件id记录
db.session().add(user)
db.session.flush()
order.uid = user.uid
order.brand = request.args.get('brand')
order.ctype = request.args.get('ctype')
order.price = request.args.get('price')
order.by_at = datetime.now()
#提交事物使用的是session（sqlalchemy当中的session，并不是服务器中的session）
try:
db.session().add(user)
db.session().add(order)
db.session().commit()
res = {"code": 200, "content": "插入成功"}
except Exception as e:
print(e)
db.session.rollback()
res = {"code": 500, "content": "插入失败"}
return jsonify(res)
def post(self):
list_ = []
parse = parser.parse_args()
staff_id = parse.get('staff_id')
number = parse.get('number')
price = parse.get('price')
address = parse.get('address')
phone = parse.get('phone')
consignee = parse.get('consignee')
datetime_now = datetime.datetime.now()
date_stamp = str(int(time.mktime(datetime_now.timetuple())))
data_microsecond = str("%06d" % datetime_now.microsecond)
date_stamp = date_stamp + data_microsecond
order = Order()
order.order_no = date_stamp
order.price = price
order.user_id = staff_id
order.number = number
order.address = address
order.phone = phone
order.consignee = consignee
db.session.add(order)
db.session.commit()
point = Point.query.filter(Point.staff_id == staff_id).first()
orders = Order.query.filter(Order.user_id == staff_id).all()
if orders:
for order in orders:
list_.append(order.price)
prices = sum(list_)
print(prices)
point.sumprice = prices
print(point.sumprice)
db.session.commit()
else:
pass
return jsonify({'msg': '添加成功'})
