def go():
# GET请求
from forms import Search
search_form = Search()
# 判断参数
if search_form.validate_on_submit():
search = search_form.search.data
webServer.writeData(conn, search)
print(search)
if request.method == "POST":
# resqult = sr(search)
resqult = webServer.readData(conn)
values = [
search,
]
for url in resqult:
url = url.decode("gb2312")
values.append(url)
if len(values) > 1:
return render_template("result.html",
result=values,
form1=search_form)
# return render_template("result.html", title='Result', form1=search_form)
else:
pass
#print("data:", search)
values = []
values.append("%s" % search)
print(values)
return render_template('result.html', result=values, form1=search_form)
def judge():
from forms import Search
sform = Search()
if request.method == 'POST':
if sform.validate_on_submit():
search = sform.search.data
print(search)
return redirect(url_for('.go', search=search))
return render_template('search.html', title='Search', form=sform)
def search():
"""Search page."""
form = Search()
if form.validate_on_submit():
search = request.form["search"]
if not search:
search = "*"
select = request.form["select"]
return redirect(url_for("search", **{select: search}, page=1))
page = request.args.get('page', default=1, type=int)
user_id = session["user_id"]
if request.args.get("title"):
select = "title"
search = request.args.get("title")
elif request.args.get("category"):
select = "category"
search = request.args.get("category")
elif request.args.get("ingredient"):
select = "ingredient"
search = request.args.get("ingredient")
else:
return render_template('page_not_found.html'), 404
if search == "*":
recipes = db.execute("SELECT title, recipes.recipe_id FROM recipes JOIN owners ON "
"recipes.recipe_id=owners.recipe_id WHERE user_id = ?",
(user_id,))
elif select == "title":
recipes = db.execute("SELECT title, recipes.recipe_id FROM recipes JOIN owners ON "
"recipes.recipe_id=owners.recipe_id WHERE user_id = ? AND title "
"LIKE ?", (user_id, "%" + search + "%"))
elif select == "category":
recipes = db.execute("SELECT title, recipes.recipe_id FROM recipes INNER JOIN owners "
"ON recipes.recipe_id=owners.recipe_id INNER JOIN categories ON "
"recipes.recipe_id=categories.recipe_id WHERE user_id = ? AND "
"category = ? GROUP BY title", (user_id, search))
else:
recipes = db.execute("SELECT title, recipes.recipe_id FROM recipes INNER JOIN owners "
"ON recipes.recipe_id=owners.recipe_id INNER JOIN ingredients ON "
"recipes.recipe_id=ingredients.recipe_id WHERE user_id = ? AND "
"(' ' || ingredient || ' ') LIKE ? GROUP BY title", (user_id, "% " +
search + " %"))
# try pages
per_page = 10
try:
pages = Pagination(recipes, page, per_page)
except IndexError:
return render_template('page_not_found.html'), 404
if pages.total >= pages.per_page:
recipes = pages.items
return render_template("search.html", form=form, select=select, search=search, pages=pages,
recipes=recipes)
def search_results():
form = Search()
if form.validate_on_submit():
if form.search_by.data == 'first_name':
first_name_search = Patient.query.filter_by(first_name=form.search_term.data).all()
elif form.search_by.data == 'last_name':
last_name_search = Patient.query.filter_by(last_name=form.search_term.data).all()
else:
patient_number_search = Patient.query.filter_by(patient_number=form.search_term.data).all()
return render_template('search_results.html', form=form, first_name_search=first_name_search, \
last_name_search=last_name_search, patient_number_search=patient_number_search)
def search():
""" The search by name return page the lists pets with the searched name """
form = Search()
if form.validate_on_submit():
search = form.name.data
pets = Pet.query.filter(Pet.name.like('%' + search + '%'))
return render_template('search_results.html', pets=pets, form=form)
else:
pets = Pet.query.all()
return redirect('/')
def index():
"""Website homepage."""
form = Search()
if form.validate_on_submit():
search = request.form["search"]
if not search:
search = "*"
select = request.form["select"]
return redirect(url_for("search", **{select: search}, page=1))
return render_template("index.html", form=form)
def search():
form = Search()
name = form.name.data
if form.validate_on_submit():
rows = find(name)
try:
result = rows[0]
except:
return render_template('search.html',
error="No match found",
form=form)
return render_template('search.html', result=result)
return render_template('search.html', form=form)
def home():
form = Search()
if form.validate_on_submit():
if form.search_by.data == 'first_name':
first_name_search = Patient.query.filter_by(
first_name=form.search_term.data).all()
elif form.search_by.data == 'last_name':
last_name_search = Patient.query.filter_by(
last_name=form.search_term.data).all()
else:
patient_number_search = Patient.query.filter_by(
patient_number=form.search_term.data).all()
return render_template('home.html', form=form, first_name_search=first_name_search, last_name_search=last_name_search, \
patient_number_search=patient_number_search)
def go():
from forms import Search
sform = Search()
db = MySQL.connectDatabase()
if sform.validate_on_submit():
search = sform.search.data
webServer.writeData(connecter, search)
print(search)
if request.method == "POST":
sqt = webServer.readData(connecter)
val = []
title = []
for url in sqt:
sql = "select id from urllist where url = '" + url + "' ;"
urlid = MySQL.query(db, sql)
try:
root = ET.parse('news/' + '%s.xml' % urlid[0][0]).getroot()
url = root.find('url').text
title = root.find('title').text
doc = {'url': url, 'title': title, 'id': urlid[0][0]}
except:
article_content = fetch(url)
doc = ET.Element("doc")
ET.SubElement(doc, "id").text = "%d" % (urlid[0][0])
ET.SubElement(doc, "url").text = url
ET.SubElement(doc, "title").text = article_content["title"]
ET.SubElement(
doc, "datetime").text = article_content["publish_time"]
ET.SubElement(doc,
"body").text = article_content["content"]
tree = ET.ElementTree(doc)
tree.write("news/" + "%d.xml" % (urlid[0][0]),
encoding="utf-8",
xml_declaration=True)
doc = {
'url': url,
'title': article_content["title"],
'id': urlid[0][0]
}
val.append(doc)
if len(val) > 1:
return render_template("result.html", result=val, form1=sform)
else:
pass
val = []
val.append("%s" % search)
print(val)
return render_template('result.html', result=val, form1=sform)
def pet_details(pet_id):
"""get details on a particular pet"""
pet = Pet.query.get(pet_id)
editForm = EditPet()
form = Search()
if form.validate_on_submit():
if editForm.photo_url.data != None and editForm.photo_url.data != '':
pet.photo_url = editForm.photo_url.data
if editForm.notes.data != None and editForm.notes.data != '':
pet.notes = editForm.notes.data
if editForm.available.data != None and editForm.available.data != '':
pet.available = editForm.available.data
if pet.available == False:
flash(f'{pet.name} has been adopted!')
db.session.commit()
return redirect(f'/pets/{pet_id}')
else:
return render_template('pet_details.html',
pet=pet,
form=form,
editForm=editForm)
def search():
form = Search()
pens = models.Pen.query.all()
brands = models.Brand.query.all()
tags = models.Tag.query.all()
# populate the dropdown selections
form.brand.choices = [(brand.id, brand.name) for brand in brands]
form.tag.choices = [(tag.id, tag.name) for tag in tags]
selected_tag = form.tag.data
selected_brand = form.brand.data
# if no search done yet
results = pens
has_searched = False
if request.method == 'POST':
if form.validate_on_submit():
has_searched = True
brand = models.Brand.query.filter_by(id=selected_brand).first()
tag = models.Tag.query.filter_by(id=selected_tag).first()
# Get a list of the pens common between the brand and the tag chosen.
results = list(set(brand.pens).intersection(tag.pens))
# render the search results
return render_template('search.html',
title="Find a Pen",
form=form,
results=results,
brand=brand.name,
tag=tag.name,
has_searched=has_searched)
else:
abort(404)
return render_template('search.html',
title="Find a Pen",
form=form,
results=results,
has_searched=has_searched)
