diff --git a/egd.py b/egd.py --- a/egd.py +++ b/egd.py @@ -88,7 +88,7 @@ def fillDB(tournaments,players): tournaments.values() ) - cursor.executemany("""insert or ignore into players (pin,name) values (:pin,:name)""", players) + cursor.executemany("""insert or replace into players (pin,name) values (:pin,:name)""", players) cursor.executemany( """insert into players_performance (pin,tournament_code,country_code,club,win_count,game_count,rating_before,rating_after) values (:pin,:tournamentCode,:countryCode,:club,:winCount,:gameCount,:rating1,:rating2)""",