def get(self):
args = Product.get_parser.parse_args()
rows = db.query(db.P).select()
col, _ord = args.pop('col'), args.pop('ord')
cols, vals = utils.marshal(args)
rows.eql(*vals).where(*cols)
rows.order_by(col, _ord)
return utils.jsonify(rows.eval())
def post(self):
print(request.json)
print(request.form)
args = Product.post_parser.parse_args()
print(args)
rows = db.query(db.P)
cols, vals = utils.marshal(args)
rows.write(*vals).into(*cols)
return utils.jsonify(rows.eval())
def get(self):
args = Supplier.get_parser.parse_args()
rows = db.query(db.S).select()
cols, vals = utils.marshal(args)
rows.eql(*vals).where(*cols)
suppliers = utils.jsonify(rows.eval())
for ind, sup in enumerate(suppliers):
if sup['s_id'] == -1:
del suppliers[ind]
break
return suppliers
def get(self):
args = ProductSupplierMap.get_parser.parse_args()
rows = db.query(db.PSM).select().join(db.S).on("s_id").join(
db.P).on("p_id")
cols, vals = utils.marshal(args)
rows.eql(*vals).where(*cols)
suppliers = utils.jsonify(rows.eval())
#remove empty, preferrably id
# for ind,sup in enumerate(suppliers):
# for key, val in sup.items():
# if val == -1:
# del suppliers[ind]
return suppliers
def post(self):
args = ProductSupplierMap.post_parser.parse_args()
rows = db.query(db.PSM)
cols, vals = utils.marshal(args)
rows.write(*vals).into(*cols)
return utils.jsonify(rows.eval())
