def conditional_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_id = ""
book_name = ""
book_publisher = ""
book_room = ""
book_state = ""
C = Condition()
if "book_id" in data:
book_id = data["book_id"]
if "book_name" in data:
book_name = data["book_name"]
if "book_publisher" in data:
book_publisher = data["book_publisher"]
if "book_room" in data:
book_room = data["book_room"]
if "book_state" in data:
book_state = C.state(data["book_state"])
result = db_manage.sql_conditional_book_info(book_id, book_name,
book_publisher, book_room,
book_state)
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
for i in range(len(result[1])):
result[1][i]["book_state"] = C.state(result[1][i]["book_state"])
result[1][i]["book_language"] = C.language(
result[1][i]["book_language"])
return jsonify({"status": 0, "message": "success", "data": result[1]})
def book_info():
result = db_manage.sql_book_info()
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
C = Condition()
for i in range(len(result[1])):
result[1][i]["book_state"] = C.state(result[1][i]["book_state"])
result[1][i]["book_language"] = C.language(
result[1][i]["book_language"])
return jsonify({"status": 0, "message": "success", "data": result[1]})
def popular_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_name = data['book_name']
result = db_user_activity.sql_book_name_query(book_name)
result[1][0]["book_category"] = db_user_activity.sql_query_category(
result[1][0]["book_category"])
C = Condition()
result[1][0]["book_state"] = C.state(result[1][0]["book_state"])
result[1][0]["book_language"] = C.language(result[1][0]["book_language"])
if not result[0]:
return jsonify({"status": -1, "message": "fail"})
return jsonify({"status": 0, "message": "success", "data": result[1]})
def query_book_info():
data = json.loads(request.get_data("").decode("utf-8"))
book_id = data["book_id"]
result = db_user_activity.sql_query_book_info(book_id)
result[1][0]["book_category"] = db_user_activity.sql_query_category(
result[1][0]["book_category"])
C = Condition()
result[1][0]["book_state"] = C.state(result[1][0]["book_state"])
result[1][0]["book_language"] = C.language(result[1][0]["book_language"])
if not result[0]:
return jsonify({"status": -1, "massage": "fail", "data": result[1]})
for i in range(len(result[1])):
result[1][i][
"book_img_path"] = 'http://47.96.139.19:6868/library/images/' + str(
result[1][i]["book_img_path"])
return jsonify({"status": 0, "massage": "success", "data": result[1]})