def new_album(): artist_id = request.form["artist_id"] artist = artist_repository.select(artist_id) title = request.form["title"] quantity = request.form["quantity"] album = Album(title, artist, quantity, id) album_repository.save(album) return redirect("/albums")
def create_album(): title = request.form['title'] artist = artist_repository.select(request.form['artist_id']) genre = genre_repository.select(request.form['genre_id']) price = float(request.form['price']) cost_price = float(request.form['cost-price']) release_year = (request.form['release-year']) cover_art = request.form['cover-art'] stock = int(request.form['stock']) label = label_repository.select(request.form['label_id']) sales_count = int(request.form['sales_count']) album = Album(title, artist, genre, price, cost_price, release_year, cover_art, stock, label, sales_count) album_repository.save(album) return render_template("/albums/updated.html", **locals())
from models.album import Album from models.artist import Artist import repositories.artist_repository as artist_repository import repositories.album_repository as album_repository album_repository.delete_all() artist_repository.delete_all() artist1 = Artist("ABBA") artist_repository.save(artist1) artist2 = Artist("Fleetwood Mac") artist_repository.save(artist2) album1 = Album("Greatest Hits", "Pop", artist1) album_repository.save(album1) album2 = Album("Rumours", "Classic Rock", artist2) album_repository.save(album2) album3 = Album("Voulez-Vous", "Pop", artist1) album_repository.save(album3) artists = artist_repository.select_all() album1.title = "Greatest Hits Vol. 2" album_repository.update(album1) found_album = album_repository.select(album2.id) print(found_album.artist.__dict__) found_albums = artist_repository.albums(artist1) for album in found_albums:
import pdb from models.album import Album from models.artist import Artist import repositories.album_repository as album_repository import repositories.artist_repository as artist_repository album_1 = Album("Black", "Pop", "Beyonce") album_repository.save(album_1) album_1.title = "White" album_1.genre = "Rock_Pop" album_1.artist = "Beatles" album_repository.update(album_1) artist_1 = Artist("Michael", "Jackson") artist_repository.save(artist_1) pdb.set_trace()
genre_repository.save(rb) funk = Genre("Funk") genre_repository.save(funk) rap_metal = Genre("Rap Metal") genre_repository.save(rap_metal) # ALBUMS - Populates Albums table # Biffy Clyro Albums endings = Album("A Celebration of Endings", biffy, alt_rock, 21.99, 14.99, "2020", "https://is5-ssl.mzstatic.com/image/thumb/Music114/v4/3a/e3/77/3ae37790-7982-c517-02b4-b4ea4b55a7b5/source/600x600bb.jpg", 4, fourteenth, 8) album_repository.save(endings) ellipsis = Album("Ellipsis", biffy, alt_rock, 17.99, 11.99, "2016", "https://is2-ssl.mzstatic.com/image/thumb/Music49/v4/7b/29/cd/7b29cd44-0d47-963e-5ffe-89d67c6e7dc4/source/600x600bb.jpg", 5, fourteenth , 9) album_repository.save(ellipsis) opposites = Album("Opposites", biffy, alt_rock, 20.99, 13.79, "2013", "https://is3-ssl.mzstatic.com/image/thumb/Music/v4/bc/b0/d7/bcb0d7a1-48f0-63d0-ea4b-a780e8f43dd6/source/600x600bb.jpg", 3, fourteenth , 7) album_repository.save(opposites) revolutions = Album("Only Revolutions", biffy, alt_rock, 15.99, 9.99, "2009", "https://is2-ssl.mzstatic.com/image/thumb/Music/v4/d4/ba/68/d4ba6840-7a23-3e3e-eda4-ab39a00fbf30/source/600x600bb.jpg", 2, fourteenth , 9) album_repository.save(revolutions) puzzle = Album("Puzzle", biffy, alt_rock, 25.99, 16.79, "2007", "https://is5-ssl.mzstatic.com/image/thumb/Music/v4/fb/27/17/fb2717b4-403d-9aa2-72ca-757849357e5a/source/600x600bb.jpg", 3, fourteenth, 15) album_repository.save(puzzle) # # Dire Straits Albums brothers = Album("Brothers in Arms", dire_straits, rock, 23.99, 15.59, "1985", "https://is4-ssl.mzstatic.com/image/thumb/Music118/v4/c5/1a/30/c51a303c-2f0a-197a-be89-903b302527b5/source/600x600bb.jpg", 1, vertigo, 7)
import pdb from model.album import Album from model.artist import Artist import repositories.artist_repository as artist_repository import repositories.album_repository as album_repository artist_1 = Artist("Adele") artist_repository.save(artist_1) artist_2 = Artist("The Beatles") artist_repository.save(artist_2) album_1 = Album("21", "Pop", artist_1) album_repository.save(album_1) album_2 = Album("Sgt Pepper", "Pop", artist_2) album_repository.save(album_2) album_3 = Album("19", "Pop", artist_1) album_repository.save(album_3) album_4 = Album("25", "Pop", artist_1) album_repository.save(album_4) results = album_repository.albums_by_artist(artist_1) for result in results: print(result.__dict__) artist = album_repository.artist_by_album(album_1) print(artist) pdb.set_trace()
import pdb from models.artist import Artist from models.album import Album import repositories.artist_repository as artist_repository import repositories.album_repository as album_repository album_repository.delete_all() artist_repository.delete_all() ## swap these 2, delete albums before artist artist = Artist("Simply Red", 55) artist2 = Artist("Barbera", 17) artist3 = Artist("Bob", 12) album = Album("Complexly Black", artist, "pop") album2 = Album("Convex", artist, "classical") album3 = Album("Little by little", artist2, "jazz") album4 = Album("High Life", artist3, "pop") artist_repository.save(artist) artist_repository.save(artist2) artist_repository.save(artist3) album_repository.save(album) album_repository.save(album2) album_repository.save(album3) album_repository.save(album4)