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)