@@ -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)""",
@@ -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.
* (text) p_country_code - země hráče
* (real) rating_before
Status change: