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)
