def edit(id): page_title = 'Edit Movie' movie = get_movie(id) if request.method == 'POST': title = request.form['title'] youtube_id = request.form['youtube_id'] error = None if not title: error = 'Title is required.' if not youtube_id: error = 'Youtube ID is required.' if error is not None: flash(error) else: db = get_db() db.execute( 'UPDATE movie SET title = ?, youtube_id = ?' ' WHERE id = ?', (title, youtube_id, id)) db.commit() return redirect(url_for('admin.index')) return render_template('admin/edit.html', movie=movie)
def add(): page_title = 'Add Movie' if request.method == 'POST': title = request.form['title'] youtube_id = request.form['youtube_id'] error = None if not title: error = 'Title is required.' if not youtube_id: error = 'Youtube ID is required.' if error is not None: flash(error) else: db = get_db() db.execute( 'INSERT INTO movie (title, youtube_id)' ' VALUES (?, ?)', (title, youtube_id)) db.commit() return redirect(url_for('admin.index')) return render_template('admin/add.html', page_title=page_title)
def get_movie(id): movie = get_db().execute( 'SELECT m.id, created, title, youtube_id' ' FROM movie m' ' WHERE m.id = ?', (id, )).fetchone() if movie is None: abort(404, "Movie id {0} doesn't exist.".format(id)) return movie
def index(): page_title = 'Movies' db = get_db() movies = db.execute('SELECT m.id, created, title, youtube_id' ' FROM movie m' ' ORDER BY created DESC').fetchall() return render_template('admin/index.html', movies=movies, page_title=page_title)
def index(): page_title = 'Player' db = get_db() movie = db.execute( 'SELECT m.title, youtube_id' ' FROM movie m' ' ORDER BY RANDOM()' ' LIMIT 1' ).fetchone() return render_template( 'player/player.html', movie=movie, page_title=page_title)
def home(): db = get_db() movie_count = db.execute('SELECT COUNT(*)' ' FROM movie').fetchone() return render_template('home/home.html', movie_count=movie_count[0])
def delete(id): get_movie(id) db = get_db() db.execute('DELETE FROM movie WHERE id = ?', (id, )) db.commit() return redirect(url_for('admin.index'))