def selectteammatch(): name = request.form['name'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT T1.team_long_name as teamname,League.name,Match.date,T2.team_long_name as hometeam,Match.home_team_goal,T3.team_long_name as awayteam,Match.away_team_goal \ from Team T1,Team T2,Team T3,League,Match \ WHERE Match.league_id=League.id and T2.team_api_id=Match.home_team_api_id AND T3.team_api_id=Match.away_team_api_id \ AND (T1.team_api_id=Match.home_team_api_id or T1.team_api_id=Match.away_team_api_id) AND T1.team_long_name=? \ order by Match.date desc limit 10', (name, )) if len(conn) == 0: response = {'code': 10001} return response, status else: attrhead = [ 'team_name', 'league', 'date', 'home_team', 'h_goal', 'away_team', 'a_goal' ] attr = conn[0] attr = list(attr) for i in range(1, len(conn)): attr[0] = attr[0] + '\n' + conn[i][0] attr[1] = attr[1] + '\n' + conn[i][1] attr[2] = attr[2] + '\n' + conn[i][2] attr[3] = attr[3] + '\n' + conn[i][3] attr[4] = str(attr[4]) + '\n ' + str(conn[i][4]) attr[5] = attr[5] + '\n' + conn[i][5] attr[6] = str(attr[6]) + '\n ' + str(conn[i][6]) totable = arrayTotable() path = totable.totable(attrhead, attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectleaguename(): response = {} status = 200 name = request.form['CountryName'] conn = sqlitedatabase.execute_select( "select League.name,Country.name from Country,League where Country.id=League.country_id and Country.name like ?", (name + "%", )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: attrhead = ['league name', 'country'] attr = conn[0] attr = list(attr) for i in range(1, len(conn)): attr[0] = attr[0] + '\n' + conn[i][0] attr[1] = attr[1] + '\n' + conn[i][1] totable = arrayTotable() name = 'League' path = totable.totable(attrhead, attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectteamgraph(): name = request.form['name'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT Team.team_long_name as teamname, Team_Attributes.date,Team_Attributes.buildUpPlaySpeed,\ Team_Attributes.buildUpPlayDribbling,Team_Attributes.buildUpPlayPassing,\ Team_Attributes.chanceCreationCrossing,\ Team_Attributes.chanceCreationPassing, \ Team_Attributes.chanceCreationShooting,Team_Attributes.defenceAggression,\ Team_Attributes.defencePressure,\ Team_Attributes.defenceTeamWidth\ from Team_Attributes, Team\ WHERE\ Team.team_api_id = Team_Attributes.team_api_id\ and team_long_name=? order by Team_Attributes.date desc limit 1', (name, )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: attr = [ conn[0][2], conn[0][3], conn[0][4], conn[0][5], conn[0][6], conn[0][7], conn[0][8], conn[0][9], conn[0][10] ] tograph = arrayTograpg() path = tograph.tographt(attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def register(): username = request.form['username'] password = request.form['password'] response = {} conn = sqlitedatabase.execute_select( 'select username from login where username=?', (username)) if len(conn) == 0: try: conn = sqlite3.connect('database.sqlite') cursor = conn.cursor() cursor.execute( 'insert into login (username,password) values (?,?)', (username, password)) conn.commit() response = {'code': 10002} except sqlite3.Error as err: raise err finally: # Close database connection. cursor.close() conn.close() resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: response = {'code': 10003} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectteamtactic(): name = request.form['name'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT Team.team_long_name as teamname, Team_Attributes.date,\ Team_Attributes.buildUpPlayDribblingClass,Team_Attributes.buildUpPlayPassingClass,\ Team_Attributes.buildUpPlayPositioningClass, Team_Attributes.buildUpPlaySpeedClass,\ Team_Attributes.chanceCreationCrossingClass,\ Team_Attributes.chanceCreationPassingClass, Team_Attributes.chanceCreationPositioningClass, \ Team_Attributes.chanceCreationShootingClass,Team_Attributes.defenceAggressionClass,\ Team_Attributes.defenceDefenderLineClass, Team_Attributes.defencePressureClass,\ Team_Attributes.defenceTeamWidthClass\ from Team_Attributes, Team\ WHERE\ Team.team_api_id = Team_Attributes.team_api_id\ and team_long_name=?', (name, )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: attrhead = [ 'team name', 'date', 'buildUpPlayDribbling', 'buildUpPlayPassing', 'buildUpPlayPositioning', 'buildUpPlaySpeed', 'chanceCreationCrossing', 'chanceCreationPassing', 'chanceCreationPositioning', 'chanceCreationShooting', 'defenceAggression', 'defenceDefenderLine', 'defencePressure', 'defenceTeamWidth' ] attr = conn[0] attr = list(attr) for i in range(1, len(conn)): attr[0] = attr[0] + '\n' + conn[i][0] attr[1] = attr[1] + '\n' + conn[i][1] attr[2] = attr[2] + '\n' + conn[i][2] attr[3] = attr[3] + '\n' + conn[i][3] attr[4] = attr[4] + '\n' + conn[i][4] attr[5] = attr[5] + '\n' + conn[i][5] attr[6] = attr[6] + '\n' + conn[i][6] attr[7] = attr[7] + '\n' + conn[i][7] attr[8] = attr[8] + '\n' + conn[i][8] attr[9] = attr[9] + '\n' + conn[i][9] attr[10] = attr[10] + '\n' + conn[i][10] attr[11] = attr[11] + '\n' + conn[i][11] attr[12] = attr[12] + '\n' + conn[i][12] attr[13] = attr[13] + '\n' + conn[i][13] totable = arrayTotable() path = totable.totable(attrhead, attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectplayerattr(): name = request.form['name'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT Player.player_name as name,Player.birthday,Player.height,Player.weight,Player_Attributes.overall_rating,\ Player_Attributes.preferred_foot,Player_Attributes.acceleration,Player_Attributes.sprint_speed,\ Player_Attributes.agility,Player_Attributes.balance,Player_Attributes.dribbling,Player_Attributes.reactions,\ Player_Attributes.crossing,Player_Attributes.finishing,Player_Attributes.heading_accuracy,Player_Attributes.long_shots,\ Player_Attributes.short_passing,Player_Attributes.volleys,Player_Attributes.curve,\ Player_Attributes.free_kick_accuracy,Player_Attributes.long_passing,Player_Attributes.ball_control,\ Player_Attributes.shot_power,Player_Attributes.jumping,Player_Attributes.stamina,Player_Attributes.strength,\ Player_Attributes.aggression,Player_Attributes.interceptions,Player_Attributes.positioning,\ Player_Attributes.vision,Player_Attributes.penalties,Player_Attributes.marking,\ Player_Attributes.standing_tackle,Player_Attributes.sliding_tackle,\ Player_Attributes.gk_diving,Player_Attributes.gk_handling,Player_Attributes.gk_kicking,\ Player_Attributes.gk_positioning,Player_Attributes.gk_reflexes\ FROM Player,Player_Attributes\ where Player.player_api_id=Player_Attributes.player_api_id and Player.player_name=?\ GROUP by Player.player_name', (name, )) if len(conn) == 0: response = {'code': 10001} return response, status else: attrhead = [ 'name', 'birthday', 'height', 'weight', 'overall rating', 'preferred_foot', 'acceleration', 'sprint_speed', 'agility', 'balance', 'dribbling', 'reactions', 'crossing', 'finishing', 'heading_accuracy', 'long_shots', 'short_passing', 'volleys', 'curve', 'free_kick_accuracy', 'long_passing', 'ball_control', 'shot_power', 'jumping', 'stamina', 'strength', 'aggression', 'interceptions', 'positioning', 'vision', 'penalties', 'marking', 'standing_tackle', 'sliding_tackle', 'gk_diving', 'gk_handling', 'gk_kicking', 'gk_positioning', 'gk_reflexes' ] attr = conn[0] attr = list(attr) totable = arrayTotable() path = totable.totable(attrhead, attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectteamrough(): name = request.form['TeamName'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'select distinct Team.team_long_name from Team,League,Match where Match.league_id=League.id and (Team.team_api_id=Match.home_team_api_id or Team.team_api_id=Match.away_team_api_id) and Team.team_long_name like ?', ("%" + name + "%", )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: response = {'status': 200, 'code': 1, 'attr': conn} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def login(): username = request.form['username'] password = request.form['password'] response = {} conn = sqlitedatabase.execute_select( 'select username,password from login where username=? and password=?', (username, password)) if len(conn) == 0: response = {'code': 0} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: response = {'code': 10} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectplayergraph(): name = request.form['name'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT Player.player_name as name,\ Player_Attributes.acceleration,Player_Attributes.sprint_speed,\ Player_Attributes.agility,Player_Attributes.balance,Player_Attributes.dribbling,\ Player_Attributes.finishing,Player_Attributes.long_shots,\ Player_Attributes.short_passing,\ Player_Attributes.long_passing,\ Player_Attributes.jumping,Player_Attributes.stamina,Player_Attributes.strength,\ Player_Attributes.interceptions,\ Player_Attributes.standing_tackle,Player_Attributes.sliding_tackle,\ Player_Attributes.gk_diving,Player_Attributes.gk_handling,Player_Attributes.gk_kicking,\ Player_Attributes.gk_positioning,Player_Attributes.gk_reflexes\ FROM Player,Player_Attributes\ where Player.player_api_id=Player_Attributes.player_api_id and Player.player_name=?\ GROUP by Player.player_name', (name, )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: attr = [(conn[0][1] + conn[0][2]) / 2, (conn[0][3] + conn[0][4] + conn[0][5]) / 3, (conn[0][6] + conn[0][7]) / 2, (conn[0][8] + conn[0][9]) / 2, (conn[0][13] + conn[0][14] + conn[0][15]) / 3, (conn[0][10] + conn[0][11] + conn[0][12]) / 3, conn[0][16], conn[0][17], conn[0][18], conn[0][19], conn[0][20]] tograph = arrayTograpg() path = tograph.tograph(attr, name) response = {'status': 200, 'code': 1, 'path': path} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res
def selectplayerrough(): name = request.form['PlayerName'] response = {} status = 200 conn = sqlitedatabase.execute_select( 'SELECT Player.player_name as name\ FROM Player,Player_Attributes\ where Player.player_api_id=Player_Attributes.player_api_id and Player.player_name like ?\ GROUP by player_name\ order by Player_Attributes.overall_rating desc', ("%" + name + "%", )) if len(conn) == 0: response = {'code': 10001} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res else: response = {'status': 200, 'code': 1, 'attr': conn} resj = jsonify(response) res = make_response(resj) res.headers['Access-Control-Allow-Origin'] = '*' return res