def search():
form = SearchForm()
if form.is_submitted():
cuisine_r = request.form['cuisine']
loc_r = request.form['location']
price_r = request.form['price']
params = {
'term': cuisine_r,
'location': loc_r,
'price': price_r,
'sort_by': "distance",
'limit': 5
}
api_key = '4OT8ngau2AxIlDyHvrRAugyNpXP8BnXdSGvCDz9pzt6-c8Ff2XIKZNlNpYRFCFSuzJSSkUPYpvKJEqViA0LbclqZKjRe950k37zR73wTLl58060tR5yqcjY_QG15XnYx'
headers = {'Authorization': 'Bearer %s' % api_key}
url = 'https://api.yelp.com/v3/businesses/search'
# make call to Yelp API
result = requests.get(url, params=params, headers=headers)
# Convert the JSON string into a dictionary
business_data = result.json()
return render_template('foodlist.html', business_data=business_data)
else:
return render_template('searchbar.html', form=form)
def query5():
form = SearchForm()
if form.is_submitted():
#teamName = str(request.form['teamName'])
order = str(request.form['order'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT Player.FirstName, Player.LastName, ((Player.AvgPoints/Player.AvgMin)*Player.GP) AS MVPFactor\
FROM Player\
WHERE Player.AvgPoints <> 0 "
#if teamName:
# query += "AND TEAM = '" + teamName + "' "
query += " GROUP BY FirstName, LastName, MVPFactor"
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = ["First Name", "Last Name", "MVP Factor (Potential)"]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchQuery5.html', form=form)
def query3():
form = SearchForm()
if form.is_submitted():
winOrLose = str(request.form['winOrLose'])
order = str(request.form['order'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT Manager.FirstName, Manager.LastName, team.TEAMNAME, COUNT(WINorLOSE) AS WonTimes\
FROM Manager INNER JOIN (team INNER JOIN (game INNER JOIN teamhasgame ON game.GameID = teamhasgame.GameID)\
ON team.TEAMNAME = teamhasgame.teamteam) ON manager.ManagerID = team.ManagerID\
WHERE"
query += " WINorLOSE = '" + winOrLose + "' "
query += " GROUP BY Manager.FirstName, Manager.LastName, team.TEAMNAME"
query += " ORDER BY COUNT(WINorLOSE) " + order
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = ["First Name", "Last Name", "Team Name", "Times"]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchQuery3.html', form=form)
def query1():
form = SearchForm()
if form.is_submitted():
teamName = str(request.form['teamName'])
select = str(request.form['select'])
order = str(request.form['order'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM player WHERE TRUE "
if teamName:
query += "AND TEAM = '" + teamName + "' "
query += "ORDER BY " + select
query += " " + order
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"ID", "First Name", "Last Name", "Suffix", "Position", "Age",
"averageMinutes", "gamePlay", "averagePoints", "TEAM"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchQuery1.html', form=form)
def search():
form_search = SearchForm(request.form)
if form_search.is_submitted():
string = form_search.search.data
if string:
if len(string) > 1:
return redirect(url_for('stock', search=string))
if session['search_string']:
return redirect(url_for('stock', search=session['search_string']))
return redirect('stock')
def searchPlayer():
form = SearchForm()
if form.is_submitted():
teamName = str(request.form['teamName'])
playerID = str(request.form['playerID'])
playerFirstName = str(request.form['playerFirstName'])
playerLastName = str(request.form['playerLastName'])
playerSuffix = str(request.form['playerSuffix'])
playerAge = str(request.form['playerAge'])
position = str(request.form['position'])
averageMinutes = str(request.form['averageMinutes'])
gamePlay = str(request.form['gamePlay'])
averagePoints = str(request.form['averagePoints'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM Player WHERE TRUE "
if teamName:
query += "AND TEAM = '" + teamName + "' "
if playerID:
query += "AND ID = '" + playerID + "' "
if playerFirstName:
query += "AND FirstName = '" + playerFirstName + "' "
if playerLastName:
query += "AND LastName = '" + playerLastName + "' "
if playerSuffix:
query += "AND SUFFIX = '" + playerSuffix + "' "
if playerAge:
query += "AND AGE = '" + playerAge + "' "
if position:
query += "AND POS = '" + position + "' "
if averageMinutes:
query += "AND AvgMin = '" + averageMinutes + "' "
if gamePlay:
query += "AND GP = '" + gamePlay + "' "
if averagePoints:
query += "AND AvgPoints = '" + averagePoints + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"ID", "First Name", "Last Name", "Suffix", "Position", "Age",
"averageMinutes", "gamePlay", "averagePoints", "TEAM"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchPlayer.html', form=form)
def home():
form = SearchForm()
print(request.method)
if request.method == 'POST' and form.is_submitted():
form_data = {
'genre': form.genre.data,
'type': form.type.data,
'episode': form.episode.data,
'members': form.members.data
}
data = json.dumps(form_data)
print("data ", data)
return redirect(url_for('predict', message=data))
return render_template('form.html', form=form)
def searchTeam():
form = SearchForm()
if form.is_submitted():
teamName = request.form['teamName']
teamCity = request.form['teamCity']
initial = request.form['initial']
conference = request.form['conference']
division = request.form['division']
champion = request.form['champion']
totallySalary = request.form['totallySalary']
managerID = request.form['managerID']
coachID = request.form['coachID']
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM team WHERE TRUE "
if teamCity:
query += "AND TEAMCITY = '" + teamCity + "' "
if teamName:
query += "AND TEAMNAME = '" + teamName + "' "
if coachID:
query += "AND CoachID = '" + coachID + "' "
if managerID:
query += "AND ManagerID = '" + managerID + "' "
if initial:
query += "AND INITIALS = '" + initial + "' "
if totallySalary:
query += "AND totallySalary = '" + totallySalary + "' "
if conference:
query += "AND CONFERENCE = '" + conference + "' "
if division:
query += "AND DIVISION = '" + division + "' "
if champion:
query += "AND Champion = '" + champion + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"Team City", "Team Name", "Initials", "Conference", "Division",
"Champion", "Totally Salary($million)", "ManagerID", "CoachID"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchTeam.html', form=form)
def product():
form = SearchForm(meta={'csrf': False})
print(form.errors)
if form.is_submitted():
print("submitted")
if form.validate():
print("valid")
print(form.username)
print('-----------------------------------------')
print(form.errors)
if form.validate_on_submit():
print('Successful')
return redirect(url_for('igsearch', username=form.username.data))
return render_template('product.html', form=form)
def searchGame():
form = SearchForm()
if form.is_submitted():
teamName = request.form['teamName']
gameID = request.form['gameID']
date = request.form['date']
teamCity = request.form['teamCity']
venue = request.form['venue']
winOrLose = request.form['winOrLose']
finalScore = request.form['finalScore']
refID = request.form['refID']
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM Game WHERE TRUE "
if teamName:
query += "AND TEAMNAME = '" + teamName + "' "
if gameID:
query += "AND GameID = '" + gameID + "' "
if date:
query += "AND DATE = '" + date + "' "
if teamCity:
query += "AND TEAMCITY = '" + teamCity + "' "
if venue:
query += "AND VENUE = '" + venue + "' "
if winOrLose:
query += "AND WINorLOSE = '" + winOrLose + "' "
if finalScore:
query += "AND FinalScore = '" + finalScore + "' "
if refID:
query += "AND RefID = '" + refID + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"Game ID", "DATE", "Team City", "Team Name", "Venue",
"WIN or LOSE", "Final Score", "Referee ID"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchGame.html', form=form)
def searchCoach():
form = SearchForm()
if form.is_submitted():
teamName = str(request.form['teamName'])
coachID = str(request.form['coachID'])
coachFirstName = str(request.form['coachFirstName'])
coachLastName = str(request.form['coachLastName'])
coachAge = str(request.form['coachAge'])
coachSalary = str(request.form['coachSalary'])
coachWorkingYears = str(request.form['coachWorkingYears'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM coach WHERE TRUE "
if teamName:
query += "AND TEAMNAME = '" + teamName + "' "
if coachID:
query += "AND CoachID = '" + coachID + "' "
if coachFirstName:
query += "AND FirstName = '" + coachFirstName + "' "
if coachLastName:
query += "AND LastName = '" + coachLastName + "' "
if coachAge:
query += "AND Age = '" + coachAge + "' "
if coachSalary:
query += "AND Salary = '" + coachSalary + "' "
if coachWorkingYears:
query += "AND WorkingYears = '" + coachWorkingYears + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"CoachID", "Team Name", "First Name", "Last Name", "Age",
"Salary($million)", "Working Years"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchCoach.html', form=form)
def searchManager():
form = SearchForm()
if form.is_submitted():
managerID = request.form['managerID']
teamName = request.form['teamName']
managerFirstName = request.form['managerFirstName']
managerLastName = request.form['managerLastName']
age = request.form['age']
salary = request.form['salary']
workingYears = request.form['workingYears']
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM Manager WHERE TRUE "
if managerID:
query += "AND ManagerID = '" + managerID + "' "
if teamName:
query += "AND TEAMNAME = '" + teamName + "' "
if managerFirstName:
query += "AND FirstName = '" + managerFirstName + "' "
if managerLastName:
query += "AND LastName = '" + managerLastName + "' "
if age:
query += "AND age = '" + age + "' "
if salary:
query += "AND Salary = '" + salary + "' "
if workingYears:
query += "AND WorkingYears = '" + workingYears + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"ManagerID", "Team Name", "First Name", "Last Name", "Age",
"Salary($million)", "Working Years"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchManager.html', form=form)
def searchReferee():
form = SearchForm()
if form.is_submitted():
refID = request.form['refID']
refFirstName = request.form['refFirstName']
refLastName = request.form['refLastName']
age = request.form['age']
salary = request.form['salary']
workingYears = request.form['workingYears']
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT * FROM Referee WHERE TRUE "
if refID:
query += "AND RefID = '" + refID + "' "
if refFirstName:
query += "AND FirstName = '" + refFirstName + "' "
if refLastName:
query += "AND LastName = '" + refLastName + "' "
if age:
query += "AND Age = '" + age + "' "
if salary:
query += "AND Salary = '" + salary + "' "
if workingYears:
query += "AND WorkingYears = '" + workingYears + "' "
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = [
"RefereeID", "Referee First Name", "Referee Last Name", "Age",
"Salary", "Working Years"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchReferee.html', form=form)
def query2():
form = SearchForm()
if form.is_submitted():
winOrLose = str(request.form['winOrLose'])
order = str(request.form['order'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
query = "SELECT team.TEAMCITY, team.TEAMNAME, game.WINorLOSE, game.FinalScore FROM team INNER JOIN (game INNER JOIN teamhasgame ON game.GameID = teamhasgame.GameID) ON team.TEAMNAME = teamhasgame.teamteam WHERE"
query += " WINorLOSE = '" + winOrLose + "' "
query += " ORDER BY FinalScore " + order
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
titles = ["Tean City", "Team Name", "WIN or LOSE", "Final Score"]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchQuery2.html', form=form)
def query4():
form = SearchForm()
if form.is_submitted():
winOrLose = str(request.form['winOrLose'])
order = str(request.form['order'])
mydb = mysql.connector.connect(host="localhost",
user="******",
passwd="123456",
database="NBA")
mycursor = mydb.cursor()
if mycursor:
# query = "SELECT COUNT(referee.RefID) AS RefTimes, game.WINorLOSE, referee.FirstName, referee.LastName, referee.WorkingYears\
# FROM game INNER JOIN referee ON referee.RefID = game.RefID\
# WHERE "
query = "SELECT TEAMCITY, TEAMNAME, WINorLOSE, referee.RefID, FirstName, LastName, WorkingYears, COUNT(referee.RefID) AS RefTimes\
FROM game INNER JOIN referee ON referee.RefID = game.RefID\
WHERE "
query += " WINorLOSE = '" + winOrLose + "' "
query += " GROUP BY TEAMNAME"
query += " ORDER BY COUNT(referee.RefID) " + order
print(query)
mycursor.execute(query)
myresult = mycursor.fetchall()
# titles = ["RefTimes", "WIN or LOSE", "First Name", "Last Name", "WorkingYears"]
titles = [
"Team City", "Team Name", "WinOrLose", "RefID",
"Ref First Name", "Ref Last Name", "Working Years",
"Team Won Games With This Ref"
]
return render_template('home.html',
form=form,
myresult=myresult,
titles=titles)
return render_template('searchQuery4.html', form=form)
def search():
form = SearchForm(request.form)
if form.is_submitted():
term = form.term.data
return redirect(url_for('results', term=term))
return render_template('home.html', form=form)
