def welcome():
req = request.form
user = req.get('reg_username')
password = req.get('reg_password')
gender = req.get('reg_gender')
# nationality = request.form['nationality']
# email = request.form['email']
dob = req.get('dob')
# if the user is adult or not
adult = False
if calculateAge(datetime.strptime(dob, '%Y-%m-%d')) > 18:
adult = True
# connection
#database = database.Database()
con = database.createConnection()
# database.createTables(con)
database.inputUser(con, user, password, adult)
username = database.readUser(con, user)
session["USERNAME"] = user
session["USER_ID"] = username
return render_template('Genre-selection.html',
name_id=zip(genre, genre_ID))
def genre_section():
# user = request.form['username']
con_genre = database.createConnection()
# database.createTables(con_genre)s
checkboxes = request.form.getlist('check')
test_arr = []
genre_name = []
total_genres = len(checkboxes)
percent = []
i = 0
for check in checkboxes:
test_arr.append(str(check))
percent.append(round((100 / total_genres), 2))
print(test_arr)
# id=database.readGenreID(con_genre,test_arr[i])
print(session)
database.input_preferences(conn=con_genre,
username=session.get("USER_ID")[-1],
genre=test_arr[i],
percent=percent[i])
i = i + 1
# print(user_set)
movie_id, movie_title, movie_poster, genre_id, genre_name, combine_id = fetch_movies(
)
might_like_title, might_like_poster, might_like_id = fetch_user_might_like_movies(
)
continue_watch_title, continue_watch_poster, continue_watch_id = fetch_continue_watch_movies(
)
return render_template(
'movie-page.html',
poster_id_title=zip(combine_id, movie_title, movie_poster),
might_id_title_poster=zip(might_like_id, might_like_title,
might_like_poster),
continue_id_title_poster=zip(continue_watch_id, continue_watch_title,
continue_watch_poster))
import requests
import json
import database
import FinalVariables
import urllib.parse
import operator
database = database.Database()
conn = database.createConnection()
class MovieDetails:
"""----------------------------------------------------------------------
Wrapper class structure for parsing json to html frontend
----------------------------------------------------------------------"""
def __init__(self, title, movie_id, movie_rating, overview, release_date, adult, poster_path, genre_ids):
self.original_title = title
self.id = movie_id
self.rating = movie_rating
self.overview = overview
self.release_date = release_date
self.adult = adult
self.poster_path = poster_path
self.genre_ids = genre_ids
def deserialize_movie_date(movie_date):
"""----------------------------------------------------------------------
Function to deserialize json data into MovieDetails class object
----------------------------------------------------------------------"""
return datetime.utcfromtimestamp(remoteTimestamp)
def pushTable(table, l):
url = 'https://intra.atelier-medias.org/xwiki/bin/get/Door/Code/ReplicationService'
params = {'outputSyntax': 'plain', 'table': table, 'raction': 'push', 'code' : '85aV5wzDDZFJLDQ6'}
r = requests.post(url, params=params, json=l)
print(r.status_code, r.reason, r.text)
############################
## log_card
############################
remoteDate = getRemoteTimestamp('log_card')
connection = database.createConnection()
cursor = connection.cursor()
query = ('SELECT * FROM log_card where timestamp > %s')
data = (remoteDate,)
cursor.execute(query, data, False)
results = cursor.fetchall()
l = []
for code, success, timestamp in results:
l.append({'code' : code, 'success' : success, 'timestamp' : int(timestamp.timestamp() * 1000)})
print(l)
cursor.close()
connection.close()