def read_by_name(player_name): connect, cursor = database.open_database() cursor.execute("SELECT * FROM player WHERE playerName = ?", (player_name,)) data_list = cursor.fetchall() database.close_databse(connect, cursor) return data_list
def get_female_rank(): connect, cursor = database.open_database() cursor.execute("SELECT * FROM Womenrank ORDER BY score DESC") data_list = cursor.fetchall() database.close_databse(connect, cursor) return data_list
def analysis_html(html_data): soup = BeautifulSoup(html_data, 'html.parser') player_profile = analysis.get_personal_data(soup) player_result = analysis.get_player_result(soup) connect, cursor = database.open_database() cursor.execute( "INSERT INTO playerProfile (playerId, playerName, playerAssco, playerGender, playerAge) VALUES (?, ?, ?, ?, ?)", (player_profile[0], player_profile[1], player_profile[2], player_profile[4], player_profile[3]) ) player_id = player_profile[0] for element in player_result[0]: cursor.execute( "INSERT INTO playerResult (playerId, playerResult) VALUES (?, ?)", (player_id, element) ) for element in player_result[1]: cursor.execute( "INSERT INTO playerOtherResult (playerId, playerResult) VALUES (?, ?)", (player_id, element) ) for element in player_result[2]: cursor.execute( "INSERT INTO playerDoubleResult (playerId, playerResult) VALUES (?, ?)", (player_id, element) ) database.close_databse(connect, cursor) return
def get_list(): connect, cursor = database.open_database() cursor.execute("SELECT playerId FROM player") id_list = cursor.fetchall() database.close_databse(connect, cursor) return id_list
def get_team_rank(model): connect, cursor = database.open_database() if model == 1: cursor.execute("SELECT * FROM CountryRankMan ORDER BY score DESC") elif model == 2: cursor.execute("SELECT * FROM CountryRankWomen ORDER BY score DESC") data_list = cursor.fetchall() database.close_databse(connect, cursor) return data_list
def analysis_html(html_data): soup = BeautifulSoup(html_data, 'html.parser') player_match, next_link = analysis.get_player_match(soup) if len(player_match) == 0: print("table empty, data not found") return None try: connect, cursor = database.open_database() for element in player_match: cursor.execute( "INSERT INTO matchList2018 (matchName, playerA, playerB, playerX, playerY, event, resultA, resultX, winner, winnerDbl) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", (element[0], element[1], element[2], element[3], element[4], element[5], element[6], element[7], element[8], element[9])) database.close_databse(connect, cursor) except OSError as e: print(e) return next_link
def analysis_html(html_data): soup = BeautifulSoup(html_data, 'html.parser') player_ranking, next_link = analysis.get_player_ranking(soup) if len(player_ranking) <= 1: print("table empty, data not found") return None try: connect, cursor = database.open_database() for element in player_ranking: cursor.execute( "INSERT INTO playerRanking (playerName, playerPosition, playerPoints) VALUES (?, ?, ?)", (element[0], element[1], element[2])) database.close_databse(connect, cursor) except OSError as e: print(e) return next_link
def analysis_html(html_data): soup = BeautifulSoup(html_data, 'html.parser') tournament, next_link = analysis.get_tournament_list(soup) if len(tournament) <= 1: print("table empty, data not found") return None try: connect, cursor = database.open_database() for element in tournament: if check_exist(element[0], cursor) == 0: cursor.execute( "INSERT INTO tournaments (tournamentID, year, tournamentName, type, kind, organizer, matches, fromTime, toTime) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", (element[0], element[1], element[2], element[3], element[4], element[5], element[6], element[7], element[8]) ) database.close_databse(connect, cursor) except OSError as e: print(e) return next_link
def get_list3(): connect, cursor = database.open_database() cursor.execute("SELECT * FROM matchList2018") rank1 = cursor.fetchall() database.close_databse(connect, cursor) return rank1