# HG changeset patch
# User Laman
# Date 2018-06-08 00:39:01
# Node ID 02615be35737b6be3de988b91caefaf08fa2cdb7
# Parent  0aeebf95bfe7c7ec73c8dbb502ba7951c21fe811

dotaz lifeSpans

diff --git a/queries.py b/queries.py
--- a/queries.py
+++ b/queries.py
@@ -276,6 +276,18 @@ def playersProgress():
 		print(pin,p.country,p.tournamentCount,*(p.rating.get(y,0) for y in range(y1,y2)),sep="\t")
 
 
+def lifeSpans():
+	"""Životnosti hráčů. Datum prvního a posledního turnaje, jejich rozdíl v letech, počet odehraných turnajů."""
+	query="""select pin,min(datum) as min_datum,max(datum) as max_datum,(julianday(max(datum))-julianday(min(datum)))/365.25 as lifespan,count(datum) as t_count
+		from players_performance_tournaments group by pin"""
+
+	res=cursor.execute(query)
+
+	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů")
+	for rec in res:
+		print("\t".join([str(x) for x in rec]))
+
+
 # playerHistory("Kotowski Jaroslav")
 # timeRank(2017,"CZ")
 # yearsByCountry(2001,2018)
@@ -285,3 +297,4 @@ def playersProgress():
 # fetchByRating(2600,"CZ")
 # timeToPeak()
 # playersProgress()
+# lifeSpans()