def get_items_1_0(page):
page -= 1
count = shdb.read("SELECT COUNT(*) FROM Items.ItemInfo")[0][0]
page_size = request.args.get("page_size")
if page_size == None:
page_size = 20
else:
try:
page_size = int(page_size)
except:
return make_error_response(PGNT_2)
if not (1 <= page_size <= 50):
return make_error_response(PGNT_1)
if not (0 <= page < -(-count // page_size)):
resp_json = {"pages": -(-count // page_size)}
resp_json.update(PGNT_3)
return make_error_response(resp_json)
items = shdb.read("SELECT * FROM Items.ItemInfo ORDER BY \"EAN\"" +
f" OFFSET {page * page_size} LIMIT {page_size}")
items_page = [marshall_item(x) for x in items]
return jsonify({"items": items_page, "pages": -(-count // page_size)}), 200
def edit_item_1_0():
if not request.json:
return make_error_response(JSON_1)
if not 'ean' in request.json:
return make_error_response(EAN_1)
EAN = request.json["ean"]
if len(
shdb.read("SELECT * FROM Items.ItemInfo WHERE \"EAN\" = {}".format(
EAN))) == 0:
return make_error_response(EAN_2)
x = marshall_item(
shdb.read(
"SELECT * FROM Items.ItemInfo WHERE \"EAN\" = {}".format(EAN))[0])
ItemName = request.json["itemname"] if "itemname" in request.json else x[
"itemname"]
Category = "'{}'".format(request.json["category"] if "category" in
request.json else x["category"])
shdb.execute("UPDATE Items.ItemInfo "
"SET \"ItemName\" = '{}'".format(ItemName) + ", "
"Category = {}".format(Category) + " "
"WHERE \"EAN\" = {}".format(EAN))
return jsonify(), 200
def get_item_1_0(EAN):
x = shdb.read(
"SELECT * FROM Items.ItemInfo WHERE \"EAN\" = {}".format(EAN))
if len(x) == 0:
return make_error_response(EAN_2)
return jsonify(marshall_item(x[0])), 200