import pdb 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)
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()
import repositories.artist_repository as artist_repository import repositories.label_repository as label_repository import repositories.album_repository as album_repository import repositories.genre_repository as genre_repository # Clears data from tables album_repository.delete_all() label_repository.delete_all() artist_repository.delete_all() genre_repository.delete_all() # ARTISTS - Populates Artists table various = Artist("Various Artists") artist_repository.save(various) beyonce = Artist("Beyoncé") artist_repository.save(beyonce) biffy = Artist("Biffy Clyro") artist_repository.save(biffy) dire_straits = Artist("Dire Straits") artist_repository.save(dire_straits) fleetwood_mac = Artist("Fleetwood Mac") artist_repository.save(fleetwood_mac) frightened_rabbit = Artist("Frightened Rabbit") artist_repository.save(frightened_rabbit) hozier = Artist("Hozier") artist_repository.save(hozier) janelle = Artist("Janelle Monáe") artist_repository.save(janelle) leonard_cohen = Artist("Leonard Cohen")
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)
def create_artist(): name = request.form['artist-name'] artist = Artist(name) artist_repository.save(artist) return redirect("/artists")
def new_artist(): name = request.form["name"] artist = Artist(name) artist_repository.save(artist) return redirect("/artists")