EGD-mine Changeset - ce5c50aae93a

Changeset - ce5c50aae93a

Parent rev.

Child rev.

[Not reviewed]

default

0 1 0

Laman - 6 years ago 2019-05-29 12:32:09

lifespans: přidán min_rating

1 file changed with 3 insertions and 3 deletions:

queries.py

0 comments (0 inline, 0 general)

queries.py

➞

Show inline comments

@@ @@ -278,12 +278,12 @@ def playersProgress(): @@
 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,max(rating_after) as max_rating
 		from players_performance_tournaments group by pin having min(rating_before)<=100"""
 	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,max(rating_after) as max_rating,min(rating_before) as min_rating
 		from players_performance_tournaments group by pin"""
 	res=cursor.execute(query)
 	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů\tmax rating")
+	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů\tmax rating\tmin rating")
 	for rec in res:
 		print("\t".join([str(x) for x in rec]))

0 comments (0 inline, 0 general)