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)""", diff --git a/readme.md b/readme.md --- a/readme.md +++ b/readme.md @@ -25,6 +25,7 @@ Uložené dotazy. ### players_performance Co se vztahuje zároveň k hráči a k turnaji. Většina položek all.hst. + * (integer) pin * (text) tournament_code * (text) country_code @@ -36,6 +37,7 @@ Co se vztahuje zároveň k hráči a k turnaji. Většina položek all.hst. ### players_performance_tournaments Pohled na tournaments a players_performance. + * (integer) pin * (text) p_country_code - země hráče * (real) rating_before