if(localStorage.getItem("noteText")===null){
localStorage.setItem("noteText",'');
}
var noteArray = [];
if(localStorage.getItem("noteText") != ""){
noteArray = JSON.parse(localStorage.getItem("noteText"));
}
@app_database.route('/')
def database():
"""obtains all Users from table and loads Admin Form"""
return render_template("database.html", table=books_all())
# CRUD create/add
@app_database.route('/create/', methods=["POST"])
def create():
"""gets data from form and add it to Users table"""
if request.form:
po = Books(
request.form.get("name"),
request.form.get("book"),
request.form.get("review"),
)
po.create()
return redirect(url_for('database.database'))
# CRUD read
@app_database.route('/read/', methods=["POST"])
def read():
"""gets userid from form and obtains corresponding data from Users table"""
table = []
if request.form:
bookid = request.form.get("bookid")
po = book_by_id(bookid)
if po is not None:
table = [po.read()] # placed in list for easier/consistent use within HTML
return render_template("database.html", table=table)
# CRUD update
@app_database.route('/update/', methods=["POST"])
def update():
"""gets userid and name from form and filters and then data in Users table"""
if request.form:
bookid = request.form.get("bookid")
review = request.form.get("review")
po = book_by_id(bookid)
print("here")
print(po)
if po is not None:
po.update(review)
return redirect(url_for('database.database'))
# CRUD delete
@app_database.route('/delete/', methods=["POST"])
def delete():
"""gets userid from form delete corresponding record from Users table"""
if request.form:
bookid = request.form.get("bookid")
po = book_by_id(bookid)
if po is not None:
po.delete()
return redirect(url_for('database.database'))
@app.route('/beginnerforum/')
def beginnerforum():
return render_template("beginnerforum.html")
@app.route('/post', methods=['GET', 'POST'])
def post():
if request.form:
thought = request.form.get("thought")
thisList.append(thought)
if len(thought) != 0:
return render_template("beginnerforum.html", nickname=thisList)
return render_template("beginnerforum.html")
@app.route('/delete', methods=['GET', 'POST'])
def delete():
if len(thisList) > 0:
thisList.pop(len(thisList) - 1)
return render_template("beginnerforum.html", nickname=thisList)
@app.route('/dictionary/', methods=['GET','POST'])
def dictionary():
try:
keyword = request.form['keyword']
except:
keyword = "study"
url = "https://twinword-word-graph-dictionary.p.rapidapi.com/definition/"
querystring = {"entry":keyword}
headers = {
'x-rapidapi-host': "twinword-word-graph-dictionary.p.rapidapi.com",
'x-rapidapi-key': "3d43659d98msh26d5e705bc7d8b6p1d6431jsnba44357aaf20"
}
response = requests.request("GET", url, headers=headers, params=querystring)
if response.status_code<400:
results = json.loads(response.content.decode("utf-8"))
return render_template("dictionary.html", results=results, word=keyword)
else:
return render_template("dictionary.html", word=keyword)
# print(response.text)