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)