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
