def select_artist_by_album_id(id):
album = None
sql = "SELECT * FROM albums WHERE id = %s"
values = [id]
result = run_sql(sql, values)
if result is not None:
artist = artist_repository.select(result['artist_id'])
return artist
def update_album(id):
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.update(album)
return redirect("/albums")
def select(id):
album = None
sql = "SELECT * FROM album where id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
artist = artist_repository.select(result['artist_id'])
album = Album(result['title'], artist, result['genre'], result['id'])
return album
def find_artist_by_album(album):
artist = None
sql = "SELECT * FROM album WHERE album_title = %s"
values = [album.title]
results = run_sql(sql, values)
if results != None:
artist = artist_repository.select(result['artist_id'])
album = Album(result['title'], result['genre'], result['id'], artist)
return artist
def select_all():
albums = []
sql = "SELECT * FROM albums"
results = run_sql(sql)
for row in results:
artist = artist_repository.select(row['artist_id'])
album = Album(row['title'], row['genre'], artist, row['id'])
albums.append(album)
return albums
def select_by_artist_id(artist_id):
albums = []
sql = "SELECT * FROM albums WHERE artist_id = %s"
values = [artist_id]
results = run_sql(sql, values)
for row in results:
artist = artist_repository.select(row['artist_id'])
album = Album(row['title'], row['genre'], artist, row['id'])
albums.append(album)
return albums
def select(id):
album = None
sql = "SELECT * FROM albums WHERE id = %s"
results = run_sql(sql, (id,))
row = results[0]
artist = artist_repository.select(row["artist_id"])
title = row["title"]
quantity = row["quantity"]
id = row["id"]
album = Album(title, artist, quantity, id)
return album
def select(id):
album = None
sql = "SELECT * FROM albums WHERE id = %s"
values = [id]
results = run_sql(sql, values)[0]
if results is not None:
artist = artist_repository.select(results["artist_id"])
album = Album(results["title"], results["genre"], artist,
results["id"])
return album
def select_for_artist(artist_id):
artist = artist_repository.select(artist_id)
albums = []
sql = "SELECT * FROM albums where artist_id = %s"
results = run_sql(sql, (artist_id,))
for row in results:
title = row["title"]
quantity = row["quantity"]
id = row["id"]
album = Album(title, artist, quantity, id)
albums.append(album)
return albums
def select_all():
albums = []
sql = "SELECT * FROM albums"
results = run_sql(sql)
for row in results:
artist_id = row["artist_id"]
artist = artist_repository.select(artist_id)
title = row["title"]
quantity = row["quantity"]
id = row["id"]
album = Album(title, artist, quantity, id)
albums.append(album)
return albums
def albums_by_label(label):
albums = []
sql = "SELECT * FROM albums WHERE label_id = %s"
values = [label.id]
results = run_sql(sql, values)
for row in results:
artist = artist_repository.select(row['artist_id'])
genre = genre_repository.select(row['genre_id'])
album = Album(row['title'], artist, genre, row['price'], row['cost_price'], row['release_year'], row['cover_art'], row['stock'], label, row['sales_count'], row['id'])
albums.append(album)
return albums
def select(id):
album = None
sql = "SELECT * FROM albums WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
artist = artist_repository.select(result['artist_id'])
label = label_repository.select(result['label_id'])
genre = genre_repository.select(result['genre_id'])
album = Album(result['title'], artist, genre, result['price'],
result['cost_price'], result['release_year'],
result['cover_art'], result['stock'], label,
result['sales_count'], result['id'])
return album
def select_all():
albums = []
sql = "SELECT * FROM albums ORDER BY artist_id ASC, release_year DESC"
results = run_sql(sql)
for row in results:
artist = artist_repository.select(row['artist_id'])
label = label_repository.select(row['label_id'])
genre = genre_repository.select(row['genre_id'])
album = Album(row['title'], artist, genre, row['price'],
row['cost_price'], row['release_year'], row['cover_art'],
row['stock'], label, row['sales_count'], row['id'])
albums.append(album)
return albums
def update_album(id):
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, id)
album_repository.update(album)
return render_template("/albums/updated.html", **locals())
def bestsellers():
albums = []
sql = "SELECT * FROM albums ORDER BY sales_count DESC LIMIT 12"
results = run_sql(sql)
for row in results:
artist = artist_repository.select(row['artist_id'])
label = label_repository.select(row['label_id'])
genre = genre_repository.select(row['genre_id'])
album = Album(row['title'], artist, genre, row['price'],
row['cost_price'], row['release_year'], row['cover_art'],
row['stock'], label, row['sales_count'], row['id'])
albums.append(album)
return albums
# Search function?
# "SELECT title, name FROM albums INNER JOIN artists on artists.id = albums.artist_id WHERE name LIKE '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
artist_repository.delete_all()
artist_1 = Artist('Dave')
artist_repository.save(artist_1)
artist_2 = Artist('Matt/Jen')
artist_repository.save(artist_2)
artists = artist_repository.select_all()
fetch_artist = artist_repository.select(1)
pdb.set_trace()
def show_artist(id):
artist = artist_repository.select(id)
albums = album_repository.select_for_artist(id)
return render_template("artists/show.html", artist=artist, albums=albums)
def edit_artist(id):
artist = artist_repository.select(id)
return render_template("artists/edit.html", artist=artist)
import repositories.album_repository as album_repository
artist_1 = Artist("Ed Sheeran")
artist_repository.save(artist_1)
artist_2 = Artist("Craig")
artist_repository.save(artist_2)
album_1 = Album("Divide", artist_1, "Soft Rock" )
album_2 = Album("Multiply", artist_1, "Soft Rock")
album_3 = Album("CodeClan", artist_2, "ABCD")
album_repository.save(album_1)
album_repository.save(album_2)
album_repository.save(album_3)
print(album_repository.select(1))
# print(artist_repository.select_artist(album_1).__dict__)
artist_2.change_name()
artist_repository.update(artist_2)
print(artist_2.__dict__)
album_3.change_name()
album_repository.update(album_3)
print(album_3.__dict__)
print(artist_repository.select(1).__dict__)
# album_repository.delete(album_3)
pdb.set_trace()
def artist_albums(id):
artist = artist_repository.select(id)
artists_albums = artist_repository.albums_by_artist(artist)
return render_template("artists/show.html",
artist=artist,
albums=artists_albums)
