# HG changeset patch
# User Laman
# Date 2018-05-05 12:51:28
# Node ID 606acf3a4446305254764a122dcb04c8d93ea36b
# Parent  e8e04440f19605493ead2ea787530c3f892c8fa9

fix: timeToPeak ukazuje skutečné roky, ne kalendářní

diff --git a/queries.py b/queries.py
--- a/queries.py
+++ b/queries.py
@@ -203,7 +203,7 @@ def timeToPeak():
 	# join on pin, max_rating může duplikovat řádky, když měl hráč stejný max_rating vícekrát.
 	# proto ten ošklivý vnější group by :-ú
 	query="""
-		select subq.pin,min(min_rating),min(max_rating),min(_min_datum) as min_datum,min(datum) as peak_datum,min(datum)-min(_min_datum) as time_to_peak
+		select subq.pin,min(min_rating),min(max_rating),min(_min_datum) as min_datum,min(datum) as peak_datum,(julianday(min(datum))-julianday(min(_min_datum)))/365.25 as time_to_peak
 			from players_performance_tournaments as ppt
 				join (select pin,min(rating_before) as min_rating,max(rating_after) as max_rating,min(datum) as _min_datum from players_performance_tournaments group by pin having min_rating<=600) as subq on ppt.pin=subq.pin and ppt.rating_after=max_rating
 			group by ppt.pin