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'))