import pandas
import mysql.connector
from multiprocessing import Pool, TimeoutError, Value, Array


db = mysql.connector.connect(
  host='localhost',
  user='babetgoug',
  password='pokpok',
  database='crossfit_open',
  auth_plugin='mysql_native_password'
)

# data = pandas.read_sql('SELECT * FROM Leaderboard WHERE year=2024 AND CompetitionType="open" and Event=1', db)
# data.to_csv("24.1.csv")
# d = data[(data['Scaled'] == False) & (data['HeightCm'] != 0) & (data['HeightCm'].notna())][['HeightCm','AthleteGender','EventRank','Score']].groupby(['HeightCm', 'AthleteGender']).mean()
# d.to_csv("24.1-height-score.csv")
# print(d)
# data = pandas.read_sql('SELECT * FROM Leaderboard WHERE year=2019 AND CompetitionType="open" and Event=1', db)
# data.to_csv("19.1.csv")
data = pandas.read_sql('SELECT * FROM Leaderboard WHERE year=2023 AND CompetitionType="open" and Event=3', db)
data.to_csv("23.2.csv")