def search_book(content):
rows = Book.query.filter(
or_(
Book.id.like("%" + content + "%") if content is not None else "",
Book.title.like("%" + content +
"%") if content is not None else "",
Book.author.like("%" + content +
"%") if content is not None else "",
Book.publisher.like("%" + content +
"%") if content is not None else "",
Book.year.like("%" + content +
"%") if content is not None else "")).limit(100)
response = {}
book_list = []
for row in rows:
book_list.append(Book.as_dict(row))
if len(book_list) is not 0:
response['ok'] = True
response['data'] = book_list
else:
response['ok'] = False
response['data'] = {}
return json.dumps(response)
def get_item_info():
rows = Book.query.all()
book_list = []
for row in rows:
book_list.append(Book.as_dict(row))
item_info_dict = reader.get_item_full_info(book_list)
return item_info_dict
def show_item_info():
rows = Book.query.all()
book_list = []
for row in rows[:1000]:
book_list.append(Book.as_dict(row))
item_info_dict = reader.get_item_full_info(book_list)
return json.dumps(item_info_dict)
def book_query_all():
rows = Book.query.all()
response = {}
book_list = []
for row in rows[:100]:
book_list.append(Book.as_dict(row))
response['ok'] = True
response['data'] = book_list
return json.dumps(response)
