def getListOfSongs(cls, db):
query = "SELECT * FROM songs JOIN artist ON artist.id = songs.artist_id WHERE artist.id = %(artistId)s;"
results = connectToMySQL('songinfo').query_db(query, db)
songList = cls(results[0])
for row_from_db in results:
data = {
"id": row_from_db['artist_id'],
"title": row_from_db['title'],
"video": row_from_db['video'],
"created_at": row_from_db['created_at'],
"updated_at": row_from_db['updated_at'],
}
songList.songs.append(Songs(data))
return songList
def songDashboard():
return render_template("songs/songDashboard.html", songs=Songs.get_all())
def deleteSong(songId):
data = {"songId": int(songId)}
Songs.delete(data)
return redirect("/artist/dashboard")
def processSongUpdate():
Songs.update(request.form)
updatedSong = Songs.getById(id)
return redirect(f"/show/song/{updatedSong['id']}")
def editsong(id):
return render_template('songs/editSong.html', song=Songs.getById(id))
def processSongForm():
newSong = Songs.save(request.form)
return redirect(f"/show/artist/{request.form['artistId']}")
def showSong(songId):
data = {"songId": int(songId)}
return render_template("songs/showSong.html", song=Songs.getById(data))