def new_movie():
if request.method == 'POST':
title = request.form.get('movie_title')
genre = request.form.get('genre')
release_year = request.form.get('release_year')
rating = request.form.get('rating')
description = request.form.get('description')
trailer_url = request.form.get('trailer_url')
# check if the post request has the file part
if 'file' not in request.files:
flash('No file part')
return redirect(request.url)
file = request.files['file']
# if user does not select file, browser also
# submit a empty part without filename
if file.filename == '':
flash('No selected file')
return redirect(request.url)
if file and allowed_file(file.filename):
filename = get_file_name(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
# return redirect(url_for('uploaded_file',
# filename=filename))
sql = "INSERT INTO movies(title, genre, release_year, rating, description, trailer_url, thumbnail) VALUES(%s, %s, %s, %s, %s, %s, %s)"
data = (title, genre, release_year, rating, description, trailer_url,
filename)
# Save into db
db.save(sql, data)
return render_template('new_movie.html')
return render_template('new_movie.html')
def movie_detail(title):
# Update the MSO in the database
sql = "UPDATE USERS SET last_watched=%s WHERE email=%s"
data = (title, session['email'])
db.save(sql, data)
r = kr.get_movie_rec(str(title))
r_movs = []
for i in r:
r_movs.append({'title': i, 'rating': db.get_rating(i)})
return render_template('movie_detail.html',
title=title,
movie_recommendation=r,
r_movs=r_movs,
user=str(session['email']))
def mso_request():
if request.method == 'POST':
requested_by = request.form.get('requested_by')
department_head = request.form.get('department_head')
location = request.form.get('location')
description_of_service = request.form.get('description_of_service')
# Get current user
user = current_user()['first_name'] + ' ' + current_user()['last_name']
sql = "INSERT INTO tsd_mso_form(posted_by, requested_by, department_head, location, description_of_service, requested_by_other_department) VALUES(%s, %s, %s, %s, %s, %s)"
data = (user, requested_by, department_head, location,
description_of_service, 1)
# Save into db
db.save(sql, data)
return redirect(url_for('my_msos'))
return render_template('mso_request.html', current_user=current_user())
def new():
if (current_user()['job_title']
in new_auth) and (current_user()['department']
== 'COMNAV') and (request.method == 'POST'):
requested_by = request.form.get('requested_by')
section = request.form.get('section')
department_head = request.form.get('department_head')
location = request.form.get('location')
description_of_service = request.form.get('description_of_service')
actual_work_description = request.form.get('actual_work_description')
date_started = request.form.get('date_started')
date_completed = request.form.get('date_completed')
work_completed_by = request.form.getlist('work_completed_by')
work_completed_by = [x.encode('utf-8') for x in work_completed_by]
work_completed_by = ', '.join(str(e) for e in work_completed_by)
user_id = current_user()['id']
posted_by = current_user()['first_name'] + ' ' + current_user(
)['last_name']
# Execute
sql = "INSERT INTO tsd_mso_form(id_number, posted_by, requested_by, section, department_head, location, description_of_service, actual_work_descripition, date_started, date_compleated, work_compleated_by) VALUES(%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
data = (user_id, posted_by, requested_by, section, department_head,
location, description_of_service, actual_work_description,
date_started, date_completed, work_completed_by)
# Save into db
db.save(sql, data)
return redirect(url_for('all_mso'))
elif request.method == 'GET' and (
current_user()['job_title']
in new_auth) and (current_user()['department'] == 'COMNAV'):
technicians = db.get_technicians()
return render_template('new_mso.html',
technicians=technicians,
current_user=current_user())
else:
return render_template('not_authorized.html',
current_user=current_user())
def register():
form = RegisterForm(request.form)
if request.method == 'POST' and form.validate():
first_name = form.first_name.data
last_name = form.last_name.data
sex = form.sex.data
airport_id = form.airport_id.data
email = form.email.data
job_title = form.job_title.data
department = form.department.data
password = sha256_crypt.encrypt(str(form.password.data))
sql = "insert into users(first_name, last_name, sex, airport_id, email, job_title, password, department) VALUES(%s, %s, %s, %s, %s, %s, %s, %s)"
data = (first_name, last_name, sex, airport_id, email, job_title,
password, department)
db.save(sql, data)
return redirect(url_for('login'))
return render_template('register.html',
form=form,
current_user=current_user())
def edit(id):
if request.method == 'POST':
title = request.form.get('movie_title')
genre = request.form.get('genre')
release_year = request.form.get('release_year')
rating = request.form.get('rating')
description = request.form.get('description')
trailer_url = request.form.get('trailer_url')
# check if the post request has the file part
if 'file' not in request.files:
flash('No file part')
return redirect(request.url)
file = request.files['file']
# if user does not select file, browser also
# submit a empty part without filename
if file.filename == '':
flash('No selected file')
return redirect(request.url)
if file and allowed_file(file.filename):
filename = get_file_name(file.filename)
file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename))
# return redirect(url_for('uploaded_file',
# filename=filename))
# Update the MSO in the database
sql = "UPDATE movies SET title=%s, genre=%s, release_year=%s, rating=%s, description=%s, trailer_url=%s, thumbnail=%s WHERE id=%s"
data = (title, genre, release_year, rating, description, trailer_url,
filename, int(id))
db.save(sql, data)
return redirect(url_for('all'))
movie = db.get_movie_details(id)
return render_template('edit.html',
movie=movie,
user=str(session['email']))
import pickle
import dbconnector as db
def openMv():
with open('mvs.pickle', 'rb') as handle:
mvs = pickle.load(handle)
print('opened')
return mvs
def saveMv(mvs):
with open('mvs.pickle', 'wb') as handle:
pickle.dump(mvs, handle, protocol=pickle.HIGHEST_PROTOCOL)
print('saved....')
mvs = openMv()
cntr = 1
for i in mvs:
sql = "INSERT INTO movies(title, genre, release_year, rating, description, trailer_url, thumbnail) VALUES(%s, %s, %s, %s, %s, %s, %s)"
data = (mvs[i]['title'], mvs[i]['genre'], '', mvs[i]['rating'], '', '', '')
# Save into db
db.save(sql, data)
print(cntr)
cntr += 1