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')