def songs_create():
form = SongForm(request.form)
if not form.validate():
return render_template("songs/new.html", form=form)
s = Song(form.name.data)
s.artist = form.artist.data
s.length = form.length.data
s.songkey = form.songkey.data
s.account_id = current_user.id
db.session().add(s)
db.session().commit()
flash("Song successfully created!")
return redirect(url_for("songs_index"))
def songs_create():
form = SongForm(request.form)
if not form.validate():
return render_template("songs/new.html", form=form, song_error="")
song = Song.query.filter_by(songname=form.songname.data).first()
artist = Artist.query.filter_by(artistname=form.artistname.data).first()
if song and artist:
artistsong = Song.check_artistsong(song, artist)
if artistsong:
return render_template(
"songs/new.html",
form=form,
song_error="This song has been added already")
else:
song = Song(form.songname.data)
Song.new_song_dbs(song, artist)
return redirect(url_for("songs_index"))
elif song:
song = Song(form.songname.data)
song.description = form.description.data
artist = Artist(form.artistname.data)
Song.new_song_dbs(song, artist)
return redirect(url_for("songs_index"))
elif not song:
song = Song(form.songname.data)
song.description = form.description.data
if artist:
Song.new_song_dbs(song, artist)
return redirect(url_for("songs_index"))
if not artist:
artist = Artist(form.artistname.data)
Song.new_song_dbs(song, artist)
return redirect(url_for("songs_index"))
return redirect(url_for("songs_index"))
def songs_create():
form = SongForm(request.form)
form.song_artist.choices = [(artist.id, artist.name)
for artist in Artist.query.order_by('name')]
form.album.choices = [(album.id, album.name)
for album in Album.query.order_by('name')]
if not form.validate():
return render_template('songs/new.html', form=form)
song = Song(form.name.data, form.album.data)
song.account_id = current_user.id
artist = Artist.query.get(form.song_artist.data)
artist.song_artist.append(song)
db.session().add(song)
db.session().add(artist)
db.session().commit()
return redirect(url_for('songs_index'))
def songs_create():
"""Method gets user input from form and adds new song to db"""
form = SongForm(request.form)
if not form.validate():
return render_template("songs/new.html", form=form)
song_already_added = Song.query.filter_by(name=form.name.data,
artist=form.artist.data).first()
if song_already_added:
form.name.errors.append("Song is already in database")
return render_template("songs/new.html", form=form)
new_song = Song(form.name.data, form.artist.data)
new_song.account_id = current_user.id
db.session().add(new_song)
db.session().commit()
flash('Song successfully added')
return redirect(url_for("songs_index"))