def comment():
if request.method == "POST":
score = request.form["number"]
text = request.form["review"] # number of cluster
if not text:
text = ' '
database = DBQuery()
database.insert_comment(score, text) # comment input -> insert
database.close_db()
if "url" not in session:
flash('wrong access')
return redirect(url_for(index))
url = session['url']
lang = session['lang']
num = session['num']
video_name = session['video']
err, result, subtitle = main(url, lang, num, video_name)
# err - 1 : not available url
# 2 : not supported youtube url
# 3 : no language subtitle
result = result.replace('\n', '<br>')
subtitle = subtitle.replace('\n', '<br>')
link = "https://www.youtube.com/embed/" + video_name
link = "\"{}\"".format(link)
print(link)
database = DBQuery()
#score = 5.0
#text = "Final test"
#database.insert_comment(score, text) # comment input -> insert
score_rows = database.select_score()
comment_rows = database.select_comment()
database.close_db()
print(f"\nscore_rows:\n{score_rows}\n")
print(f"comment_rows:\n{comment_rows}\n")
average_score = int(round(np.average(np.array(score_rows))))
print("average", average_score)
session['url'] = url
session['lang'] = lang
session['num'] = num
#score_rows = ((63, 5, 'I love this so much!'), (64, 3, 'Not bad'), (65, 4, 'Pretty good'))
#average_score = 4
return render_template("TimeStamp.html",
video=link,
result=result,
subtitle=subtitle,
average=average_score,
score=comment_rows)
else:
flash('wrong access')
return render_template("index.html")
def db_query_test():
database = DBQuery()
score = 5.0
text = "Final test"
database.insert_comment(score, text)
score_rows = database.select_score()
comment_rows = database.select_comment()
database.close_db()
print(f"\nscore_rows:\n{score_rows}\n")
print(f"comment_rows:\n{comment_rows}\n")
average_score = int(round(np.average(np.array(score_rows))))
print(average_score)
return render_template("DBQueryTest.html",
score=score_rows,
text=comment_rows)
def timestamp():
if request.method == "POST":
url = request.form["url"]
num = request.form["cluster_num"] # number of cluster
lang = request.form["language"] # en or ko
if not num or not url: # empty url or empty num
flash("URL is empty or Number of cluster is empty ")
#return redirect(request.url)
return render_template("index.html")
num = int(num) # number of cluster
err = 0
try:
video_name_list = url.split('youtu.be/')
if len(video_name_list) == 1:
video_name = url.replace('v=', ' ').replace('&',
' ').split(' ')[1]
else:
video_name = video_name_list[1]
except:
err = 1
if err == 1: # not available url, no id
#return err, "Not available youtube URL", "None"
flash('Not available youtube URL')
# return redirect(request.url)
return render_template("index.html")
err, result, subtitle = main(url, lang, num, video_name)
# err - 1 : not available url
# 2 : not supported youtube url
# 3 : no language subtitle
if err == 2: # not available url, no id
#return err, "Not available youtube URL", "None"
flash('Not available youtube URL')
# return redirect(request.url)
return render_template("index.html")
if err == 3:
flash('There is no subtitle for this languague in this video')
return render_template("index.html")
if err == 4:
flash('Number of cluster might be too large to make a timestamp')
return render_template("index.html")
result = result.replace('\n', '<br>')
subtitle = subtitle.replace('\n', '<br>')
link = "https://www.youtube.com/embed/" + video_name
link = "\"{}\"".format(link)
print(link)
database = DBQuery()
#score = 5.0
#text = "Final test"
#database.insert_comment(score, text) # comment input -> insert
score_rows = database.select_score()
comment_rows = database.select_comment()
database.close_db()
print(f"\nscore_rows:\n{score_rows}\n")
print(f"comment_rows:\n{comment_rows}\n")
average_score = int(round(np.average(np.array(score_rows))))
print("average", average_score)
session['url'] = url
session['lang'] = lang
session['num'] = num
session['video'] = video_name
#score_rows = ((63, 5, 'I love this so much!'), (64, 3, 'Not bad'), (65, 4, 'Pretty good'))
#average_score = 4
#return render_template("TimeStamp.html")
return render_template("TimeStamp.html",
video=link,
result=result,
subtitle=subtitle,
average=average_score,
score=comment_rows)
#return render_template("Result.html", result = result)
else:
return render_template("index.html")
