def select_all():
books = []
sql = "SELECT * FROM books"
results = run_sql(sql)
for row in results:
author = author_repository.select(row['author_id'])
book = Book(row['title'], author, row['year'], row['id'])
books.append(book)
return books
def select(id):
book = None
sql = "SELECT * FROM books WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
author = author_repository.select(result['author_id'])
book = Book(result['title'], result['genre'], result['publisher'],
author, result['id'])
return book
def create_book():
# Gather all the data from the form
title = request.form['title']
genre = request.form['genre']
publisher = request.form['publisher']
author = request.form['author']
author = author_repository.select(author_id)
book = Book(title, genre, publisher, author)
book_repository.save(book)
return redirect('/books')
def create_new_book():
title = request.form['title']
genre = request.form['genre']
description = request.form['description']
rating = request.form['rating']
author_id = request.form['author_id']
author = author_repository.select(author_id)
book = Book(title, genre, description, author, rating)
book_repository.save(book)
return redirect('/books')
def create_book():
title = request.form["title"]
genre = request.form["genre"]
publisher = request.form["publisher"]
author = request.form["author"]
# select the user using the repository
author = author_repository.select(author)
# create a new book object
book = Book(title, genre, publisher, author)
# save that task object back to the db with the save method
book_repository.save(book)
return redirect('/books')
def select_all():
books = []
sql = "SELECT * FROM books"
results = run_sql(sql)
for row in books:
author = author_repository.select(row['author_id'])
book = Book(row['title'], row['genre'], row['id'])
books.append(book)
return books
# functions/methods that deal with crud data related to book table in library database
def update_book(id):
# grab the form data for book: title, genre, publisher
title = request.form['title']
genre = request.form['genre']
publisher = request.form['publisher']
# select the author from the repository
author = author_repository.select(request.form['author_id'])
# create a new Book object
book = Book(title, genre, publisher, author)
# save the Book object to database with the .update method
book_repository.update(book)
return redirect('/books')
def create_book():
# grab the form data for book: title, genre, publisher and author_id
title = request.form['title']
genre = request.form['genre']
publisher = request.form['publisher']
author_id = request.form['author_id']
# select the author using the repository
author = author_repository.select(author_id)
# create a new Book object
book = Book(title, genre, publisher, author)
# save the Book object to database with the .save method
book_repository.save(book)
return redirect('/books')
def select_all():
books = []
sql = "SELECT * FROM books"
results = run_sql(sql)
for row in results:
author = author_repository.select(row['author_id'])
book = Book(row['title'], row['genre'], row['publisher'], author,
row['id'])
books.append(book)
return books
# def select(id):
# book = None
# sql = "SELECT * FROM books WHERE id = %s"
# values = [id]
# result = run_sql(sql, values)[0]
# if result is not None:
# author = author_repository.select(result['author_id'])
# book = Book(result['title'], author, result['id'])
# return book
# def select_all():
# books = []
# sql = "SELECT * FROM albums"
# results = run_sql(sql)
# for row in results:
# artist = artist_repository.select(row['artist_id'])
# album = Album(row['title'], artist, row['genre'], row['id'])
# albums.append(album)
# return albums
def update_book():
author = author_repository.select(request.form['author_id'])
book = Book(request.form['title'], request.form['genre'], request.form['publisher'], author, request.form['book_id'])
book_repository.update(book)
print(f"book id is {request.form['book_id']}")
return redirect('/books')
def create_book():
author = author_repository.select(request.form['author_id'])
book = Book(request.form['title'], request.form['genre'], request.form['publisher'], author)
book_repository.save(book)
return redirect('/books')
