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 getwhere(): res = db.session().query(User).filter(User.uid > 0) resList = list() for uobj in list(res): dobj = uobj.__dict__ dobj.pop('_sa_instance_state') resList.append(dobj) return jsonify(resList)
def getfilter(): ''' __le__() <= __ge__() >= __gt__() > __eq__() == ''' res = db.session().query(User.uid.__eq__(1)) return jsonify(list(res[0].__dict__))
def getdata(): #使用session res = db.session().query(User).all() #保存过滤后的数据 resList = list() for obj in res: dobj = obj.__dict__ dobj.pop('_sa_instance_state') resList.append(dobj) return jsonify(resList)
def setdata(): user = User() #dict可以获取user类当中的所有属性 print(user.__dict__) user.name = 'Jack' user.idcard = '123456789123456789' user.sex = '男' #事物 Flask默认使用事物 print(user.__dict__) #提交事物使用的是session(sqlalchemy当中的session,并不是服务器中的session) try: db.session().add(user) db.session().commit() res = '插入成功' except Exception as e: print(e) db.session.rollback() res = '插入失败' return res
def getone(): res = db.session().query(User).get(1) dobj = res.__dict__ dobj.pop('_sa_instance_state') return dobj