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)