EGD-mine Changeset - 606acf3a4446

Changeset - 606acf3a4446

Parent rev.

Child rev.

[Not reviewed]

default

0 1 0

Laman - 7 years ago 2018-05-05 12:51:28

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

1 file changed with 1 insertions and 1 deletions:

queries.py

0 comments (0 inline, 0 general)

queries.py

➞

Show inline comments

@@ @@ -200,13 +200,13 @@ def timeToPeak(): @@
 	"""Jakého hráči dosáhli maximálního ratingu a jak dlouho jim to trvalo.
 	Uvažuje hráče začínající s ratingem<=600 a s vrcholem před 1.1.2017."""
 	# 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
 			having peak_datum<date('2017-01-01')
 	"""

0 comments (0 inline, 0 general)