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)