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': '添加成功'})