def create_book(self, book: Book) -> Book:
sql = """INSERT INTO book (title,author,available,return_date,book_condition) VALUES (%s,%s,%s,%s,%s) RETURNING book_id"""
cursor = connection.cursor()
cursor.execute(sql, (book.title, book.author, book.available, 0, book.quality))
connection.commit()
book_id = cursor.fetchone()[0]
book.book_id = book_id
return book
def create_book(self, book: Book) -> Book:
BookDaoLocal.id_maker += 1
book.book_id = BookDaoLocal.id_maker
BookDaoLocal.book_table[book.book_id] = book
return book
