def search():
form = SearchForm()
if form.validate_on_submit():
results = wiki.search(form.term.data)
return render_template('search.html', form=form,
results=results, search=form.term.data)
return render_template('search.html', form=form, search=None)
def login(id=0):
searchform = SearchForm()
form = LoginForm()
if form.validate_on_submit():
if verify_login(form.number.data, form.password.data):
flash('You have logged in!', 'primary')
if sql_query("SELECT * FROM PartIn WHERE playerid=? AND eventid=?",
(user.number, id)):
flash('You are already attending that event', 'warning')
elif id != 0:
sql_query("INSERT INTO PartIn values(?,?)", (user.number, id),
commit=True)
sql_query("UPDATE Events SET num=num+1 WHERE id=?", (id, ),
commit=True)
return redirect(url_for('account'))
else:
flash('Wrong password or number!', 'danger')
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template("loginpage.html",
title='Login page',
user=user,
form=form,
searchform=searchform)
def home_page():
searchform = SearchForm()
data = []
events = sql_query("SELECT * FROM Events;")
for event in events:
ev = []
players = []
list = sql_query("SELECT playerid FROM PartIn WHERE eventid=?;",
(event[0], ))
ev.append(event)
for i in list:
player = sql_query("SELECT * FROM Players WHERE number=?;",
(i[0], ))
if player:
players.append(player[0])
ev.append(players)
data.append(ev)
if searchform.is_submitted():
data = search_for_events(searchform)
return render_template("mainpage.html",
title="Front page",
data=data,
user=user,
searchform=searchform)
def account():
searchform = SearchForm()
if (user.number == None):
flash('You have to be logged in to enter that page', 'danger')
return redirect('login')
image_source = "static/profile_pics/" + user.photo
events = sql_query(
"SELECT * FROM Events INNER JOIN PartIn ON Events.id==PartIn.eventid AND PartIn.playerid=?;",
(user.number, ))
data = []
for event in events:
ev = []
players = []
list = sql_query("SELECT playerid FROM PartIn WHERE eventid=?;",
(event[0], ))
ev.append(event)
for i in list:
player = sql_query("SELECT * FROM Players WHERE number=?;",
(i[0], ))
if player:
players.append(player[0])
ev.append(players)
data.append(ev)
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template("account.html",
title='Account',
user=user,
image_source=image_source,
data=data,
searchform=searchform)
def show_stock():
form = SearchForm()
page = request.args.get(get_page_parameter(), type=int, default=1)
if request.method == 'POST':
modelQuery = form.data.get('model')
queried_stock = UsedStock.query.filter_by(model=modelQuery).all()
pagination = UsedStock.paginate_stock_queries(request, queried_stock,
page, per_page)
flash("Invalid Search Parameter")
return render_template("stock/all_used_stock.html",
queried_stock=queried_stock,
form=form,
pagination=pagination)
queried_stock = UsedStock.get_all_used_stock()
offset = UsedStock.pagination_offset(page, per_page)
pagination_results = UsedStock.query.limit(per_page).offset(offset).all()
pagination = UsedStock.paginate_stock_queries(request, queried_stock, page,
per_page)
return render_template("stock/all_used_stock.html",
queried_stock=pagination_results,
form=form,
pagination=pagination)
def guestlogin(id=0):
searchform = SearchForm()
form = GuestForm()
if form.validate_on_submit():
user.new(form.number.data, form.name.data, form.age.data,
form.sex.data)
sql_query("INSERT INTO Players VALUES(?,?,?,?,?,?,?)",
(user.age, user.sex, user.name, 'None', None, user.number,
user.photo),
commit=True)
sql_query("INSERT INTO PartIn values(?,?)", (user.number, id),
commit=True)
sql_query("UPDATE Events SET num=num+1 WHERE id=?", (id, ),
commit=True)
flash('You can now modify your info and make a password', 'warning')
return redirect(url_for('account'))
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template('guestlogin.html',
title='Guest login',
user=user,
form=form,
id=id,
searchform=searchform)
def change_password():
searchform = SearchForm()
if (user.number == None):
flash('You have to be logged in to enter that page', 'danger')
return redirect('login')
form = ChangePasswordForm()
if form.validate_on_submit():
if user.password == None or bcrypt.check_password_hash(
user.password, form.old.data):
new_hashed = bcrypt.generate_password_hash(
form.new.data).decode('utf-8')
ree = sql_query("UPDATE Players SET password=? WHERE number=?;",
(new_hashed, user.number),
commit=True)
if ree == None:
flash('Something went wrong', 'danger')
else:
flash('Password changed', 'success')
return redirect(url_for('account'))
else:
flash('Old password wrong', 'danger')
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template('change_password.html',
title='Change password',
user=user,
form=form,
searchform=searchform)
def hello():
form = SearchForm()
username = ''
subreddit = ''
num_of_records = ''
choice = ''
query = ''
data = ''
if request.method == 'POST':
username = request.form['username']
subreddit = request.form['subreddit']
num_of_records = request.form['num_of_records']
choice = request.form['choice']
query = request.form['query']
print(username)
print(subreddit)
print(num_of_records)
print(choice)
print(query)
print(type(num_of_records))
if choice == 'post':
url = f'https://api.pushshift.io/reddit/search/submission/?q={query}&author={username}&subreddit={subreddit}&size={num_of_records}'
else:
url = f'https://api.pushshift.io/reddit/search/comment/?q={query}&author={username}&subreddit={subreddit}&size={num_of_records}'
print(url)
response = requests.get(url)
response = response.text
data = json.loads(response)
data = data['data']
# if choice == 'post':
# url = f'https://api.pushshift.io/reddit/search/submission/?q={query}&author={username}&subreddit={subreddit}&size={num_of_records}'
# response = requests.get(url)
# response = response.text
# data = json.loads(response)
# data = data['data']
# else:
# url = f'https://api.pushshift.io/reddit/search/comment/?q={query}&author={username}&subreddit={subreddit}&size={num_of_records}'
# response = requests.get(url)
# response = response.text
# data = json.loads(response)
# data = data['data']
return render_template('index.html',
form=form,
username=username,
subreddit=subreddit,
num_of_records=num_of_records,
choice=choice,
query=query,
data=data)
def covid():
form = SearchForm()
if form.validate_on_submit():
if (not checkImage(form.state.data)):
createImage(form.state.data)
session['image'] = form.state.data + "_" + str(datetime.date.today())
return redirect(url_for('result'))
return render_template('search.html', form=form)
def homepage():
day_weather = Weather()
form = SearchForm()
if form.is_submitted():
city = form.search_term.data
else:
city = 'London'
day_weather.single_day_weather(city)
return render_template('index.html',
content=day_weather.get_data(),
form=form)
def index():
city_name = ""
search_form = SearchForm()
city_name = search_form.city_name.data
print(city_name)
r = requests.get(url.format(city_name)).json()
weather = {
'icon': r['weather'][0]['icon'],
'city_name': r['name'],
'tempareture': round((r['main']['temp'])-273.15),
'description': r['weather'][0]['description']
}
print(weather)
return render_template('index.html', search_form=search_form, weather=weather)
def home():
form = SearchForm()
results = []
if request.method == 'POST':
if form.validate() == False:
return render_template("index.html", form=form)
else:
search_query = form.search_query.data
book_search = BookSearch(search_query)
book_search.make_a_search()
results = book_search.get_search_results()
return render_template("index.html", form=form, results=results)
elif request.method == 'GET':
return render_template("index.html", form=form, results=results)
def result(request):
if request.method == 'POST':
form = SearchForm(request.POST)
if form.is_valid():
title = request.POST.get('title')
form1 = ArticleForm
title1 = title
if Article.objects.all().filter(title=title):
content1 = Article.objects.get(title=title).content
user1 = Article.objects.get(title=title).user
return render_to_response('result.html', {
'title1': title1,
'user1': user1,
'content1': content1
})
else:
return HttpResponseRedirect('/article/default/')
def auteur(request):
#on initialise une dictionnaire vide
c = {}
c.update(csrf(request))
# charge le formulaire dans le fichier form.py
form = SearchForm()
c = ({'form': form})
if request.method == 'POST':
name = request.POST['nom']
last_name = request.POST['prenom']
try:
autor = Photo.objects.filter(photographe__nom=name,
photographe__prenom=last_name)
info = autor[0]
c.update({'autor': autor, 'info': info})
except:
error = "ce photographe n est pas dans la base de donnee"
c.update({'error': error, 'form': form})
c.update(csrf(request))
return render_to_response('auteur.html', c)
def create_event():
searchform = SearchForm()
form = EventForm()
if user.number:
form = EventForm2()
if form.validate_on_submit():
number = user.number
if not user.number:
number = form.number.data
last_id = sql_query(
"INSERT INTO Events VALUES(?,?,?,?,?,?,?,?,?,?)",
(None, form.header.data, form.sport.data, form.place.data,
form.city.data, form.time.data, form.description.data,
form.limit.data, 1, number),
commit=True,
get_id=True)
sql_query("INSERT INTO PartIn VALUES(?,?)", (number, last_id),
commit=True)
if user.number == None:
ans = sql_query("SELECT * FROM PLayers WHERE number=?",
(form.number.data, ))
if ans:
return redirect(url_for('login'))
else:
user.number = form.number.data
return redirect(url_for('create_account'))
return redirect(url_for('home_page'))
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template("create_event.html",
title='Create an event',
form=form,
user=user,
searchform=searchform)
def change_accountinfo():
searchform = SearchForm()
if (user.number == None):
flash('You have to be logged in to enter that page', 'danger')
return redirect('login')
form = AccountInfoForm()
if form.validate_on_submit():
if bcrypt.check_password_hash(user.password, form.password.data):
picture_file = user.photo
if form.photo.data:
picture_file = save_picture(form.photo.data)
user.photo = picture_file
ree = sql_query(
"UPDATE Players SET name=?, age=?, sex=?, photo=?, bio=? WHERE number=?;",
(form.name.data, form.age.data, form.sex.data, picture_file,
form.bio.data, user.number),
commit=True)
user.login(user.number)
return redirect(url_for('account'))
else:
flash('Wrong password', 'danger')
elif request.method == 'GET':
form.name.data = user.name
form.age.data = user.age
form.sex.data = user.sex
form.bio.data = user.bio
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template("account_info.html",
title='Account info',
user=user,
form=form,
searchform=searchform)
def main():
form = SearchForm()
if form.validate_on_submit():
isbn = form.isbn.data
title = form.title.data.lower()
author = form.author.data.lower()
pub_year = form.pub_year.data
form.isbn.data = ""
form.title.data = ""
form.author.data = ""
form.pub_year.data = ""
books = Book.query.filter(
or_(Book.isbn.like("%" + isbn + "%"),
func.lower(Book.author).like("%" + author + "%"),
func.lower(Book.title).like("%" + title + "%"),
Book.pub_year == pub_year)).all()
if books:
return render_template('index.html', form=form, books=books)
flash('There is no such a book in our records')
return redirect(url_for('main'))
books = Book.query[:20]
return render_template('index.html', form=form, books=books)
def deleteaccount():
if (user.number == None):
flash('You have to be logged in to enter that page', 'danger')
return redirect('login')
form = DeleteAccountForm()
searchform = SearchForm()
if form.validate_on_submit():
if bcrypt.check_password_hash(user.password, form.password.data):
sql_query("DELETE FROM Players WHERE number=?", (user.number, ),
commit=True)
flash('Account deleted', 'warning')
logout()
return redirect(url_for('home_page'))
else:
flash('Password is wrong!', 'danger')
return render_template('deleteaccount.html',
title='Delete account',
user=user,
form=form,
searchform=searchform)
def create_account():
searchform = SearchForm()
form = AccountForm()
if form.validate_on_submit():
kuva = 'default.png'
if form.sex.data == 'Female':
kuva = 'default2.png'
if form.photo.data:
picture_file = save_picture(form.photo.data)
kuva = picture_file
hashed = None
if form.password.data:
hashed = bcrypt.generate_password_hash(
form.password.data).decode('utf-8')
sql_query("INSERT INTO Players VALUES(?,?,?,?,?,?,?)",
(form.age.data, form.sex.data, form.name.data,
form.bio.data, hashed, form.number.data, kuva),
commit=True)
user.login(form.number.data)
flash('Account created, logged in!', 'primary')
return redirect(url_for('home_page'))
elif request.method == 'GET' and user.number:
form.number.data = user.number
if searchform.is_submitted():
data = search_for_events(searchform)
return home_page()
return render_template("create_account.html",
title='Create an account',
form=form,
user=user,
searchform=searchform)
def before_request():
g.user = current_user
g.search_form = SearchForm()
def dispatch_request(self):
""" This form is plugeable. That means that all what you need to do is
to install the package and run the url :: /ponywhoosh/
(You may change it in the config) and get the results.
Returns:
Results: The results are sent to the template using bootstrap.
They are renderized using whether a grid or a table, depending on what
models did you register.
By default the first field registered is considered the one that will
be contained in the tittle of each searh result.
"""
ctx = {'form' : SearchForm()}
except_field = None
query, fields = None, None
wildcards = True
form = SearchForm()
if self.debug:
print 'form:'
pprint(form.data)
if form.validate_on_submit():
add_wildcards = form.add_wildcards.data
except_fields = re.split('\W+', form.except_field.data, flags=re.UNICODE)
fields = re.split('\W+', form.fields.data, flags=re.UNICODE)
models = re.split('\W+', form.models.data, flags=re.UNICODE)
query = form.query.data
something = form.something.data
results = self._pw.search(
query
, add_wildcards=add_wildcards
, something=something
, include_entity=True
, fields=fields
, models=models
, except_fields=except_fields
, use_dict=False
)
if self.debug:
print 'form = ',
pprint({
'query': query
, 'add_wildcards': add_wildcards
, 'something': something
, 'include_entity': True
, 'fields': fields
, 'models': models
, 'except_fields': except_fields
})
print "results = "
pprint(results)
return render_template(
'ponywhoosh/results.html'
, entidades=list(self._pw._entities.keys())
, action_url_form=self.action_url_form
, form=form
, results=results
, n=results['cant_results']
, labels=results['results'].keys()
)
return render_template(
'ponywhoosh/index.html'
, form=form
, action_url_form=self.action_url_form
, query=query
)
import tkinter as tk
from form import SearchForm
from controls import UsersControl
root = tk.Tk()
# root.title = ("SEARCH FORM")
root.geometry("300x400")
control = UsersControl("test_db.db")
search_form = SearchForm(root, control)
root.mainloop()
#нужно создать форму, куда сами добавляем пользователя
# добавить пользователя в БД
def search_view(request):
if request.method == 'POST':
form_in = request.POST
# 字典型態{'a':[1,2],'b':[5,6],'c':[]}
# ======定義使用者本身性別======
try:
my_biological_sex = Member.objects.get(user=str(request.user)).biological_sex
except:
my_biological_sex = None
# ======定義使用者本身性別======
# =========分析找男女==========
# 輸出 test_biological_sex 1:男女都選或都不選 2:女 3:男
test_girl = 0
test_boy = 0
try:
if len(form_in['find_girl']) > 0:
test_girl = 1
except:
pass
try:
if len(form_in['find_boy']) > 0:
test_boy = 1
except:
pass
if test_girl == 1:
if test_boy == 1:
test_biological_sex = 1
else:
test_biological_sex = 2
else:
if test_boy == 1:
test_biological_sex = 3
else:
test_biological_sex = 1
del test_girl, test_boy
# =========分析找男女==========
# ======生成搜索用queryset======
# 已轉換為清單內含字典格式(純PY) ex : [{'id': 1, 'level_id': 2, 'job_id': 2, 'n.....
q_set = None
if my_biological_sex == '男':
if test_biological_sex == 1:
# 男女都撈(只撈性向
q_set = filters_view.find_q_set(Member, 2, 3, 4, 6)
if test_biological_sex == 2:
# 撈女生
q_set = filters_view.find_q_set(Member, 4, 6)
if test_biological_sex == 3:
# 撈男生
q_set = filters_view.find_q_set(Member, 2, 3)
elif my_biological_sex == '女':
if test_biological_sex == 1:
# 男女都撈(只撈性向
q_set = filters_view.find_q_set(Member, 1, 3, 5, 6)
if test_biological_sex == 2:
# 撈女生
q_set = filters_view.find_q_set(Member, 5, 6)
if test_biological_sex == 3:
# 撈男生
q_set = filters_view.find_q_set(Member, 1, 3)
else:
if test_biological_sex == 1:
# 男女都撈(只撈性向
q_set = filters_view.find_q_set(Member, 1, 4, 2, 5, 3, 6)
if test_biological_sex == 2:
# 撈女生
q_set = filters_view.find_q_set(Member, 4, 6)
if test_biological_sex == 3:
# 撈男生
q_set = filters_view.find_q_set(Member, 1, 3)
# ======生成搜索用queryset======
# ====生成年齡範圍丟入filter=====
# 生成 age_range = [10,11,12,13,14,15] 若無設定則生成 0 到 100
if len(form_in['age_min']) != 0 or len(form_in['age_max']) != 0: # 如果有輸入條件才開始進入過濾器
if len(form_in['age_min']) == 0:
age_min = 0 # 如果年齡最小值未輸入 則設為0
else:
age_min = int(form_in['age_min']) # 如果年齡最小值有輸入 讀進來
if len(form_in['age_max']) == 0:
age_max = 300 # 如果年齡最大值未輸入 則設為300
else:
age_max = int(form_in['age_max']) # 如果年齡最小值有輸入 讀進來
q_set = filters_view.filter_age(Member, q_set, age_min, age_max) # 過濾器參數 ( 資料庫 , 字典 , 最小值 , 最大值 )
# ====生成年齡範圍丟入filter=====
# ====生成身高範圍丟入filter=====
if len(form_in['height_min']) != 0 or len(form_in['height_max']) != 0:
if len(form_in['height_min']) == 0:
height_min = 0
else:
height_min = int(form_in['height_min'])
if len(form_in['height_max']) == 0:
height_max = 300
else:
height_max = int(form_in['height_max'])
q_set = filters_view.filter_height(Member, q_set, height_min, height_max)
# ====生成身高範圍丟入filter=====
# ====生成體重範圍丟入filter=====
if len(form_in['weight_min']) != 0 or len(form_in['weight_max']) != 0:
if len(form_in['weight_min']) == 0:
weight_min = 0
else:
weight_min = int(form_in['weight_min'])
if len(form_in['weight_max']) == 0:
weight_max = 300
else:
weight_max = int(form_in['weight_max'])
q_set = filters_view.filter_weight(Member,q_set,weight_min,weight_max)
# ====生成體重範圍丟入filter=====
# ==========過濾血型==========
blood_type_list = request.POST.getlist('blood_type') # 搜尋者要求的血型 為一清單型態 紀錄方式為 blood_type_id
if len(blood_type_list) != 0: # 如果清單內有東西(有搜尋條件) 才開始過濾
q_set = filters_view.filter_blood_type(Member, q_set, blood_type_list)
# ==========過濾血型==========
# ==========過濾地點==========
location_list = request.POST.getlist('location')
if len(location_list) != 0:
q_set = filters_view.filter_location(Member, q_set, location_list)
# ==========過濾地點==========
# ==========過濾信仰==========
religion_list = request.POST.getlist('religion')
if len(religion_list) != 0:
q_set = filters_view.filter_religion(Member, q_set, religion_list)
# ==========過濾信仰==========
# ==========過濾關係==========
relationship_list = request.POST.getlist('relationship')
if len(relationship_list) != 0:
q_set = filters_view.filter_relationship(Member, q_set, relationship_list)
# ==========過濾關係==========
# ========過濾感情狀態========
relationship_status_list = request.POST.getlist('relationship_status')
if len(relationship_status_list) != 0:
q_set = filters_view.filter_relationship_status(Member, q_set, relationship_status_list)
# ========過濾感情狀態========
# ========過濾照片有無========
# 待決議
# ========過濾照片有無========
# ========輸出優先名單========
q_set_list = []
for c1 in q_set:
q_set_list.append([c1,int(q_set[c1])])
q_set_list = sorted(q_set_list, key=lambda x: x[1], reverse=True)
# ========輸出優先名單========
end = q_set_list
end1 = Member.objects.get(id=9).blood_type_id
return render(request,'match/end.html',{'end': end,'end1':end1})
else:
form = SearchForm()
ver1 = 'ver_view = %s' % (9131207,)
return render(request,'match/test.html',{'test': form,'ver1':ver1})
