from flask import Flask, request, Blueprint, render_template
from UseSqlite import InsertQuery, RecordQuery

TKTK = 'token' # set token

show_bp = Blueprint(
    'site',
    __name__,
)

# The following function is replaced by the template show.html. 
# And can be safely deleted.
# def make_html_paragraph(s): # build the word's table
#     if s.strip() == '':
#         return ''
#     lst = s.split(',')
#     word = lst[1].strip()
#     result = '<tr><td>' + word + '</td></tr>'
#     return result

@show_bp.route('/show/<name>/')  # set route for show page <name> means the var name to search
def show(name):
    token = request.args.get("token")
    # when token is wrong
    if token != TKTK:
        return "token is wrong, please try again"
    
    rq = RecordQuery('./static/wordfreqapp.db')
    # search the user's words in db
    rq.instructions_with_parameters("SELECT * FROM words WHERE user = ?", (name,))
    rq.do_with_parameters()
    results = [row.split(",")[1].strip() for row in rq.format_results().split("\n\n")]
    return render_template("show.html", name=name, results=results)