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)