Python Book.create_from_db_record示例

示例#1

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)

示例#2

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]