LaPetiteReine | Python Fiddle

import datetime
import MySQLdb

# Account for each people who join the game 
class Player:     
    def __init__(self, name, email, password, age, profession, date):
        self.name = name
        self.email = email
        self.password = password
        self.age = age
        self.profession = profession
        self.date = datetime.datetime.now().day
        
        
             
class League:
 
    list_players = []
    list_bet = []
    list_potential_cyclist = []
    
    def __init__(self, name, creator, creation_date):
        self.name = name
        self.creator = creator
        self.creation_date = datetime.datetime.now().day

def add_player(self, league_player):
        self.list_players.append(league_player)
        
        
    def make_bet(cyclist,price,list_of_cyclist):
        bet = Bet(player,cyclist,price)

# Iteration of a player inside a list         
class League_player: 
    
    list_of_cyclist =[]
    
    def __init__(self,player)
    	self.player = player
    
    def add_cyclist(self, cyclist):
        self.list_of_cyclist.append(cyclist)
        
    def calculate_point(self,list_of_cyclist):
        for i in self.list_of_cyclist:
            current_points = current_points + i.point
        return(current_points)

class Bet:
    def __init__(self,player,cyclist,price)
    	self.player = player
        self.cyclist = cyclist
        self.price = price 
        
    
                
class Cyclist:
    def __init__(self, name, point):
        self.name = name
        self.point = 0
        
        
        
""" New file """         
# Connect to database 
import MySQLdb

# Function to select a statement and return a list 
def select_statement(sql):
    statement = []
    db = MySQLdb.connect(host="localhost",    # your host, usually localhost
                         user="john",         # your username
                         passwd="megajonhy",  # your password
                         db="jonhydb")        # name of the data base
    cur = db.cursor()
    cur.execute(sql)
    for row in cur.fetchall():
        statement.append(row)
    db.close()

# Function to insert using a sql query
def insert_statement(sql):
    db = MySQLdb.connect(host="localhost",    # your host, usually localhost
                         user="john",         # your username
                         passwd="megajonhy",  # your password
                         db="jonhydb")        # name of the data base
    
    cur = db.cursor()
    
    try:
        cur.execute(sql)
        db.commit()
    except:
        db.rollback()
    db.close()
        
def create_db(sql):
    db = MySQLdb.connect(host="localhost",    # your host, usually localhost
                         user="john",         # your username
                         passwd="megajonhy",  # your password
                         db="jonhydb")        # name of the data base
    cursor = db.cursor()
    sql = 'CREATE DATABASE IF NOT EXISTS LaPetiteReine'
    cursor.execute(sql)
    
    #Structural tables
    cursor.execute("create table IF NOT EXISTS player (id_player int NOT NULL AUTO_INCREMENT, name varchar(10), email varchar(70),password varchar(20),age int, profession varchar(20), date datetime DEFAULT(getdate()), PRIMARY KEY (id_player));")
    cursor.execute("create table IF NOT EXISTS league (id_league int NOT NULL AUTO_INCREMENT, name varchar(10), date datetime DEFAULT(getdate()), id_creator int, total_player int DEFAULT(1), tour varchar(20), PRIMARY KEY (id_league));")
    cursor.execute("create table IF NOT EXISTS links_player_league (id_player_league int NOT NULL AUTO_INCREMENT, id_player int, id_league int, PRIMARY KEY (id_player_league);")
    cursor.execute("create table IF NOT EXISTS cyclist (id_cyclist int NOT NULL AUTO_INCREMENT, name varchar(20), surname varchar(20), PRIMARY KEY (id_cyclist));")
    cursor.execute("create table IF NOT EXISTS link_player_league_cyclist (id_player_league_cyclist int NOT NULL AUTO_INCREMENT, id_player int , id_league int, id_cyclist int,PRIMARY KEY (id_player_league_cyclist));")
    
    #Race and results
    cursor.execute("create table IF NOT EXISTS tour (id_tour int NOT NULL AUTO_INCREMENT, name varchar(20) , beginning datetime, end datetime,PRIMARY KEY (id_tour));")
    cursor.execute("create table IF NOT EXISTS stage (id_stage int NOT NULL AUTO_INCREMENT, id_tour int, , end datetime,PRIMARY KEY (id_tour));")
    
    #Betting rounds
    cursor.execute("create table IF NOT EXISTS round1 (id_bet1 int NOT NULL AUTO_INCREMENT, id_player int, id_league int, id_cyclist int, price int, date datetime DEFAULT(getdate()), PRIMARY KEY (id_bet1));")
    cursor.execute("create table IF NOT EXISTS round2 (id_bet2 int NOT NULL AUTO_INCREMENT, id_player int, id_league int, id_cyclist int, price int, date datetime DEFAULT(getdate()), PRIMARY KEY (id_bet2));")

#Get the id ? 
#Check if the name is already in the database ?
def insert_player(player):
    table = [player.name, player.email, player.password, player.age, player.profession]
    insert_statement("INSERT INTO player (name, email, password, age, profession) VALUES (%s, %s, %s, %s, %s)",)

def insert_league(league):
    table = [league.name, league.id_creator, league.tour]
    insert_statement("INSERT INTO league (name, id_creator, tour) VALUES (%s, %s, %s)", table)

def insert_player_league(player,league):
    table = [player.id_player, league.id_league]
    insert_statement("INSERT INTO links_player_league (id_player, id_league) VALUES (%s, %s)", table)

def insert_player_league_cyclist(player,league,cyclist):
    table = [player.id_player, league.id_league,cyclist.id_cyclist]
    insert_statement("INSERT INTO links_player_league_cyclist (id_player, id_league, id_cyclist) VALUES (%s, %s, %s)", table)
    
def insert_round1(player,league,cyclist,price):
    table = [player.id_player, league.id_league,cyclist.id_cyclist,price]
    insert_statement("INSERT INTO round1 (id_player, id_league, id_cyclist, price) VALUES (%s, %s, %s, %s)", table)
    
def insert_round2(player,league,cyclist,price):
    table = [player.id_player, league.id_league,cyclist.id_cyclist,price]
    insert_statement("INSERT INTO round2 (id_player, id_league, id_cyclist, price) VALUES (%s, %s, %s, %s)", table)

#Check if it works...    
def select_player_cyclist(player,league):
    table = [player.id_player,league.id_league]
    select_statement("SELECT * FROM links_player_league_cyclist WHERE (id_player,id_league) VALUES (%s,%s)", table)
	
#Create function Delete after round1 ...

Python Fiddle

Python Cloud IDE