def edit(album_id):
form = AlbumForm(request.form)
if request.method == 'POST' and form.validate():
title = form.title.data
body = form.body.data
# create cursor
cur = mysql.connection.cursor()
update = """UPDATE albums
SET title = '{0}', body = '{1}'
WHERE id = '{2}'
""".format(title, body, album_id)
cur.execute(update)
# commit to db
mysql.connection.commit()
# close cursor connection
cur.close()
flash('album successfully updated', 'success')
return redirect(url_for('album', album_id=album_id))
return render_template('edit.html', form=form, album=find_by_id(album_id))
def delete(id):
qry = db_session.query(Album).filter(Album.id==id)
album = qry.first()
if album:
form = AlbumForm(formdata=request.form, obj=album)
if request.method == 'DELETE' and form.validate():
db_session.delete(album)
db_session.commit()
def new_album():
form = AlbumForm(request.form)
if request.method == 'POST' and form.validate():
# save the album
al = Album()
album_save_changes(al, form, new=True)
flash('Album created successfully!')
return redirect('/albuminfo')
return render_template('new_album.html', form=form)
def new_album():
"""
Add a new album
"""
form = AlbumForm(request.form)
if request.method == 'POST' and form.validate():
# save the album
album = Album()
save_changes(album, form, new=True)
flash('Data inserted successfully!')
return redirect('/')
return render_template('new_album.html', form=form)
def edit(id):
qry = Album.query.filter(Album.id == id)
al = qry.first()
if Album:
form = AlbumForm(formdata=request.form, obj=al)
if request.method == 'POST' and form.validate():
# save edits
album_save_changes(al, form)
flash('Album updated successfully!')
return redirect('/Albuminfo')
return render_template('edit_Album.html', form=form)
else:
return 'Error loading #{id}'.format(id=id)
def edit(id):
qry = db_session.query(Album).filter(Album.id==id)
album = qry.first()
if album:
form = AlbumForm(formdata=request.form, obj=album)
if request.method == 'POST' and form.validate():
# save edits
save_changes(album, form)
return redirect('/')
return render_template('edit_album.html', form=form)
else:
return 'Error loading #{id}'.format(id=id)
def delet(id):
qry = Album.query.filter(Album.id == id)
al = qry.first()
if al:
form = AlbumForm(formdata=request.form, obj=al)
if request.method == 'POST' and form.validate():
# delete the item from the database
db.session.delete(al)
db.session.commit()
flash('Album deleted successfully!')
return redirect('/albuminfo')
return render_template('delete_album.html', form=form)
else:
return 'Error deleting #{id}'.format(id=id)
def new_album():
"""
Add a new album
"""
form = AlbumForm(request.form)
if request.method == 'POST' and form.validate():
# save the album
album = Album()
save_changes(album, form, new=True)
flash(
f'You have successfully created the album {album.title} by {album.artist}!'
)
return redirect('/')
return render_template('new_album.html', form=form)
def post_album(username):
user = User.query.filter_by(username=username).first()
form = AlbumForm()
if request.method == 'POST' and form.validate():
new_album = Album(title=form.title.data,
image=form.image.data,
user_id=current_user.id)
db.session.add(new_album)
db.session.commit()
flash('Album successfully created')
album = Album.query.filter_by(title=new_album.title).first()
return redirect(
url_for('photos',
username=current_user.username,
album_id=album.id))
return render_template('new_album.html', user=user, form=form)
def edit(id):
"""
Add / edit an item in the database
"""
qry = db_session.query(Album).filter(Album.id == id)
album = qry.first()
if album:
form = AlbumForm(formdata=request.form, obj=album)
if request.method == 'POST' and form.validate():
# save edits
save_changes(album, form)
flash('Album updated successfully!')
return redirect('/')
return render_template('edit_album.html', form=form)
else:
return 'Error loading #{id}'.format(id=id)
def delete(id):
"""
Delete the item in the database that matches the specified
id in the URL
"""
qry = db_session.query(Album).filter(Album.id == id)
album = qry.first()
if album:
form = AlbumForm(formdata=request.form, obj=album)
if request.method == 'POST' and form.validate():
# delete the item from the database
db_session.delete(album)
db_session.commit()
flash('Album deleted successfully!')
return redirect('/')
return render_template('delete_album.html', form=form)
else:
return 'Error deleting #{id}'.format(id=id)
def new():
form = AlbumForm(request.form)
if request.method == 'POST' and form.validate():
title = form.title.data
body = form.body.data
# create cursor
cur = mysql.connection.cursor()
insert = """INSERT INTO albums(title, author, body)
VALUES('{0}', '{1}', '{2}')
""".format(title, session['username'], body)
cur.execute(insert)
# commit to db
mysql.connection.commit()
# close cursor connection
cur.close()
flash('album successfully updated', 'success')
return redirect(url_for('albums'))
return render_template('new.html', form=form)
