1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
|
from __future__ import print_function
import datetime
import sys
from os import path
import __main__
import dateutil.relativedelta
from f1elo.db import Session
from f1elo.elo import Elo
from f1elo.model import *
class Interface(object):
def __init__(self, date=None):
self.session = Session()
self.date = date
def init_db(self, force=False):
from f1elo.model import Base
if force:
Base.metadata.drop_all(self.session.get_bind())
Base.metadata.create_all(self.session.get_bind())
with open(path.join(path.dirname(__main__.__file__),
'sql', 'results.sql')) as result_dump:
for line in result_dump.readlines():
line = line.strip()
if line and line[0:2] != '--':
self.session.bind.execute(line)
def reset(self, date=None, _debug=False):
if date is None:
date = self.date
query = self.session.query(Race)
if date is not None:
query = query.filter(Race.date > date)
for race in query.all():
race.ranked = False
if _debug:
print(race, file=sys.stderr)
query = self.session.query(Ranking)
if date is not None:
query = query.filter(Ranking.rank_date > date)
query.delete()
self.session.commit()
if date is not None:
date += datetime.timedelta(1)
self.date = date
return
def rate(self, date=None, _debug=False):
if date is None:
date = self.date
if date is None:
date = datetime.date.today()
elo = Elo(self.session)
race_query = self.session.query(Race).filter(Race.ranked.is_(False))
if date is not None:
race_query = race_query.filter(Race.date <= date)
races = race_query.order_by(Race.date, Race.id).all()
for race in races:
if _debug:
print(race, file=sys.stderr)
print('', file=sys.stderr)
ranks = elo.rank_race(race)
driver_ranks = {}
for entry, rank in ranks.iteritems():
if entry.result_group:
correction = rank / len(entry.drivers)
for driver in entry.drivers:
if driver not in driver_ranks:
driver_ranks[driver] = 0
driver_ranks[driver] += correction
for driver, rank in driver_ranks.iteritems():
ranking = Ranking()
ranking.rank_date = race.date
ranking.ranking = round(
elo.get_ranking(driver, race.date) + rank,
2)
self.session.add(ranking)
driver.rankings.append(ranking)
if _debug:
podium_rating = 0
podium_rating_after = 0
rating_sum = 0
rating_change_sum = 0
changed_ratings = 0
for entry in sorted(race.entries):
old_rating = elo.get_entry_ranking(
entry,
race.date
- dateutil.relativedelta.relativedelta(days=1))
new_rating = elo.get_entry_ranking(entry)
rating_sum += old_rating
if entry.result_group != 0:
rating_change_sum += abs(new_rating - old_rating)
changed_ratings += 1
print(
entry,
old_rating,
new_rating,
file=sys.stderr)
if entry.result in ['1', '2', '3']:
podium_rating += old_rating
podium_rating_after += new_rating
print('', file=sys.stderr)
print('Podium rating: ', podium_rating, podium_rating_after,
file=sys.stderr)
print('Average rating: ', rating_sum / len(race.entries),
file=sys.stderr)
print('Average rating change: ',
rating_change_sum / changed_ratings,
file=sys.stderr)
print('', file=sys.stderr)
race.ranked = True
date = race.date
self.session.commit()
self.date = date
if self.date is not None:
self.date += datetime.timedelta(1)
return
def fetch(self, date=None):
if date is None:
date = self.date
if date is None:
date = datetime.date.today()
date += datetime.timedelta(1)
one_year = dateutil.relativedelta.relativedelta(years=1)
rankings = self.session.query(
Ranking
).filter(
Ranking.rank_date > (date - one_year)
).filter(
Ranking.rank_date <= date
).all()
drivers = {}
for ranking in rankings:
if ranking.driver not in drivers:
drivers[ranking.driver] = ranking.driver.get_ranking(date)
self.date = date
return sorted(drivers.values(),
key=lambda rank: rank.ranking,
reverse=True)
|
