def get(self):
#test param exists and is right type
notapp=1
if 'sportablesapp' in self.request.cookies:
notapp=0
try:
result_set = int(self.request.get('result_set'))
except:
result_set = 0
try:
table_get = int(self.request.get('table_name'))
except:
table_get = 0
if(table_get == 0):
logging.warning("param or type wrong")
self.redirect('/existingtable')
else:
u = None
if users.get_current_user() == None:
if 'sportablesuser' in self.request.cookies:
u = User.gql("WHERE tempusername = :1", self.request.cookies['sportablesuser'])
else:
u = User.gql("WHERE username = :1", users.get_current_user())
if u != None:
if u.count() == 1:
#test if table exists
k = db.Key.from_path('Table', table_get)
tb = db.get(k)
if not type(tb) is NoneType:
for o in u:
#test if user is owner
if o.key().id() == tb.user.key().id():
tms = Team().all()
tms.filter('table = ', k)
tms.order('-points')
tms.order('-goal_difference')
tms.order('-goals_for')
tms.order('name')
if(tms.count()<2):
disable = 1
else:
disable = 0
#new test part
rs = Result().all()
rs.filter('table = ', k)
rs_away = Result().all()
rs_away.filter('table = ', k)
hrl = []
if int(result_set) != 0:
rs.filter('home_team_id = ', result_set)
rs_away.filter('away_team_id = ', result_set)
for r in rs:
hrl.append(int(r.key().id()))
for r in rs_away:
hrl.append(int(r.key().id()))
rs = Result.get_by_id(hrl)
rs.sort(key=lambda result: result.time_added)
#new test end
score_options = range(300)
template_values = {
'notapp': notapp,
'tabledata': tb,
'teamsdata': tms,
'result_set_data': result_set,
'resultsdata': rs,
'disable': disable,
'score_options': score_options
}
path = os.path.join(os.path.dirname(__file__), 'results.html')
self.response.out.write(template.render(path, template_values))
else:
logging.warning("attempt to get teams from another user's table")
self.redirect('/existingtable')
else:
logging.warning("attempt to get teams from a table that doesn't exist")
self.redirect('/existingtable')
else:
logging.warning("user has a google or temp account but has no User entity")
self.redirect('/existingtable')
else:
logging.warning("user has neither logged in with a google account or a set a cookie")
self.redirect('/existingtable')
def get(self):
#test param exists and is right type
notapp=1
if 'sportablesapp' in self.request.cookies:
notapp=0
try:
table_get = int(self.request.get('table_name'))
except:
table_get = 0
if(table_get == 0):
logging.warning("param or type wrong")
self.redirect('/existingtable')
else:
u = None
if users.get_current_user() == None:
if 'sportablesuser' in self.request.cookies:
u = User.gql("WHERE tempusername = :1", self.request.cookies['sportablesuser'])
else:
u = User.gql("WHERE username = :1", users.get_current_user())
if u != None:
if u.count() == 1:
#test if table exists
k = db.Key.from_path('Table', table_get)
tb = db.get(k)
if not type(tb) is NoneType:
for o in u:
#test if user is owner
if o.key().id() == tb.user.key().id():
tms = Team().all()
tms.filter('table = ', k)
tms.order('-points')
tms.order('-goal_difference')
tms.order('-goals_for')
tms.order('name')
if(tms.count()<2):
disable = 1
else:
disable = 0
if(tms.count()<1):
disable2 = 1
else:
disable2 = 0
template_values = {
'notapp': notapp,
'tabledata': tb,
'teamsdata': tms,
'disable': disable,
'disable2': disable2
}
path = os.path.join(os.path.dirname(__file__), 'teams.html')
self.response.out.write(template.render(path, template_values))
else:
logging.warning("attempt to get teams from another user's table")
self.redirect('/existingtable')
else:
logging.warning("attempt to get teams from a table that doesn't exist")
self.redirect('/existingtable')
else:
logging.warning("user has a google or temp account but has no User entity")
self.redirect('/existingtable')
else:
logging.warning("user has neither logged in with a google account or a set a cookie")
self.redirect('/existingtable')
