forked from mrlan/EnglishPal
34 lines
1.1 KiB
Python
34 lines
1.1 KiB
Python
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)
|