-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathBasicDataHandler.py
218 lines (188 loc) · 7.19 KB
/
BasicDataHandler.py
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
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
# -*- coding: utf-8 -*-
from google.appengine.ext import webapp
from google.appengine.ext.webapp.util import login_required
from google.appengine.api import users
from google.appengine.ext.webapp import template
import os
import logging
from google.appengine.ext import db
from models import *
import datetime
class BasicDataHandler(webapp.RequestHandler):
"""docstring for BasicDataHandler"""
@login_required
def get(self):
if not users.is_current_user_admin():
self.error(401)
else:
user = users.get_current_user()
loginurl = users.create_logout_url(self.request.uri)
loginurl_text = "Logout..."
op = self.request.get('op')
punters = ["Anders Haglund",
"Andreas Pousette",
u"Andreas Öhrn",
"Christian Axelsson",
u"Kristofer Åkerblom",
"Erik Lundkvist",
"Fredrik Jansson",
"Jerker Nordmark",
"Johnny Nilsson",
"Kim Wellton",
u"Magnus Lööf",
"Mattias Andersson",
"Oskar Larsson",
"Peter Johnsson",
u"Peter Löfgren",
"Tommy Lund",
]
gameslist = [("Polen", "Grekland", "Jun 08, 2012 18:00"),
("Ryssland","Tjeckien","Jun 08, 2012 20:45"),
("Holland","Danmark","Jun 09, 2012 18:00"),
("Tyskland","Portugal","Jun 09, 2012 20:45"),
("Spanien","Italien","Jun 10, 2012 18:00"),
("Irland","Kroatien","Jun 10, 2012 20:45"),
("Frankrike","England","Jun 11, 2012 18:00"),
("Ukraina","Sverige","Jun 11, 2012 20:45"),
("Grekland","Tjeckien","Jun 12, 2012 18:00"),
("Polen","Ryssland","Jun 12, 2012 20:45"),
("Danmark","Portugal","Jun 13, 2012 18:00"),
("Holland","Tyskland","Jun 13, 2012 20:45"),
("Italien","Kroatien","Jun 14, 2012 18:00"),
("Spanien","Irland","Jun 14, 2012 20:45"),
("Ukraina","Frankrike","Jun 15, 2012 18:00"),
("Sverige","England","Jun 15, 2012 20:45"),
("Grekland","Ryssland","Jun 16, 2012 20:45"),
("Tjeckien","Polen","Jun 16, 2012 20:45"),
("Portugal","Holland","Jun 17, 2012 20:45"),
("Danmark","Tyskland","Jun 17, 2012 20:45"),
("Spanien","Kroatien","Jun 18, 2012 20:45"),
("Italien","Irland","Jun 18, 2012 20:45"),
("Sverige","Frankrike","Jun 19, 2012 20:45"),
("England","Ukraina","Jun 19, 2012 20:45"),
]
if op == "games":
q = db.GqlQuery("SELECT __key__ FROM GameModel")
for game in q:
db.delete(game)
teams = TeamModel.all()
teamlist = {}
for team in teams:
teamlist[team.displayName] = team
gamecursor = 0
for game in gameslist:
home = game[0]
away = game[1]
date = game[2]
gameobj = GameModel()
gameobj.homeTeam = teamlist[home]
gameobj.awayTeam = teamlist[away]
gameobj.gameTime = datetime.datetime.strptime(date, "%b %d, %Y %H:%M")
gameobj.ordinal = gamecursor
gameobj.played = False
gameobj.scored = False
gameobj.put()
gamecursor += 1
self.redirect('/basicdataload')
if op == "teams":
q = db.GqlQuery("SELECT __key__ FROM TeamModel")
for team in q:
db.delete(team)
teams = ["Danmark",
"England",
"Frankrike",
"Grekland",
"Holland",
"Irland",
"Italien",
"Kroatien",
"Polen",
"Portugal",
"Ryssland",
"Spanien",
"Sverige",
"Tjeckien",
"Tyskland",
"Ukraina",
]
for team in teams:
tmp = TeamModel()
tmp.displayName = team
tmp.put()
self.redirect('/basicdataload')
if op == "punters":
q = db.GqlQuery("SELECT __key__ FROM PunterModel")
for punter in q:
db.delete(punter)
#TODO fixa bugg, bets kommer inte in i nummerordning, puntercursor borde persistenshanteras i datastore
puntercursor = 0
for punter in punters:
tmp = PunterModel()
tmp.displayName = punter
tmp.ordinal = puntercursor
tmp.score = 0
tmp.put()
puntercursor += 1
self.redirect('/basicdataload')
if op == "clearbets":
q = db.GqlQuery("SELECT __key__ FROM BetModel")
punters = PunterModel.all()
for bet in q:
db.delete(bet)
for punter in punters:
punter.score = 0
punter.put()
if op == "bets":
#[1,1,1,0,1,1,1,1,0,4,1,2,0,2,0,2,1,2,1,3,2,0,1,1,0,1,1,1,1,1,1,1,2,2,1,1,0,2,0,1,0,2,1,3,1,2,1,2,1,2,0,2,1,2,1,2,1,1,0,1,1,2,1,2,1,2,],
# en rad per match - bets per punter home-away
bets = [[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
[2,1,2,2,3,0,4,1,3,1,0,4,4,2,1,3,0,0,2,1,2,3,4,2,2,2,5,0,0,4,3,2,1,1,2,3,3,3,1,4,3,3,2,0,4,3,3,1],
]
q = db.GqlQuery("SELECT * FROM BetCursor")
if q.count() == 0:
c = BetCursor()
c.ordinal = 0
c.put()
gamecursor = q.get()
logging.debug("gamecursor: " + str(gamecursor.ordinal))
games = GameModel.gql("WHERE ordinal = :ordinal", ordinal=gamecursor.ordinal)
if not games:
self.redirect('/')
punters = PunterModel.gql("ORDER BY ordinal")
for game in games:
logging.debug("RUNNING GAME")
betcursor = 0
ordinalcursor = 0
for punter in punters:
bet = BetModel()
bet.game = game
bet.punter = punter
bet.homeGoals = bets[gamecursor.ordinal][betcursor]
betcursor += 1
bet.awayGoals = bets[gamecursor.ordinal][betcursor]
betcursor += 1
bet.ordinal = ordinalcursor
ordinalcursor += 1
bet.put()
gamecursor.ordinal += 1
gamecursor.put()
self.redirect('/basicdataload?' + str(gamecursor.ordinal))
path = os.path.join(os.path.dirname(__file__), 'templates/basicdata.html')
template_stuff = {'user': user,
'loginurl': loginurl,
'loginurl_text': loginurl_text,
}
self.response.out.write(template.render(path, template_stuff))