def query_book(isbn): book_record = db.execute( """ SELECT * FROM books WHERE isbn=:isbn """, { "isbn": isbn }).fetchone() if book_record is None: return None return Book.create_from_db_record(book_record)
def query_search_books(search_keyword: str): record_list = db.execute( """ SELECT * FROM books WHERE upper(title) like :search_keyword or isbn like :search_keyword or upper(author) like :search_keyword; """, { "search_keyword": '%' + search_keyword.upper() + '%' }).fetchall() if len(record_list) == 0: return None return [Book.create_from_db_record(record) for record in record_list]