def get(self): teams = Team.query(Team.year == get_year()).fetch() individuals = Individual.query(Individual.year == get_year()).fetch() teamsDict = {} for team in teams: if team.assigned_id is not None and len(team.assigned_id) > 0: teamsDict[team.key.id()] = { 'id': team.assigned_id, 'name': team.name, 'team_scores': parse_or_none(team.team_scores), 'guts_scores': parse_or_none(team.guts_scores), 'members': [] } for individual in individuals: if individual.team > 0 and individual.team in teamsDict: teamsDict[individual.team]["members"].append({ 'name': individual.name, 'id': individual.assigned_id, 'speed_scores': json.loads(individual.speed_scores if ( individual.speed_scores is not None) else 'null'), 'accuracy_scores': json.loads(individual.accuracy_scores if ( individual.accuracy_scores is not None) else 'null') }) self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps(teamsDict))
def get(self): rnd = self.request.get('round') _id = self.request.get('id') name = '' ret = '[]' if rnd in ('speed', 'accuracy'): ind = Individual.query(Individual.assigned_id == _id, Individual.year == YEAR) if ind.count() > 0: ind = ind.fetch()[0] name = ind.name + '|' + Team.get_by_id(ind.team).name if rnd == 'speed': ret = ind.speed_scores else: ret = ind.accuracy_scores else: team = Team.query(Team.assigned_id == _id) if team.count() > 0: team = team.fetch()[0] name = team.name if rnd == 'team': ret = team.team_scores else: if team.guts_scores is None: ret = [] else: ret = team.guts_scores self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'scores': ret, 'name': name }))
def get(self): teams = {} individuals = [] # Create and insert a record # for this registration. user = self.auth.get_user_by_session()['user_id'] query = Individual.query(Individual.user == user) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append( member.serialize_full()) else: teams[member.team] = {'members': [member.serialize_full()]} else: individuals.append(member.serialize_full()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['paid'] = record.paid teams[team_id]['year'] = record.year teams[team_id]['guts_scores'] = parse_or_none(record.guts_scores) teams[team_id]['team_scores'] = parse_or_none(record.team_scores) # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write( json.dumps({ 'teams': teams, 'individuals': individuals }))
def get(self): teams = Team.query(Team.year == get_year()).fetch() individuals = Individual.query(Individual.year == get_year()).fetch() teamsDict = {} for team in teams: if team.assigned_id is not None and len(team.assigned_id) > 0: teamsDict[team.key.id()] = { 'id': team.assigned_id, 'name': team.name, 'team_scores': parse_or_none(team.team_scores), 'guts_scores': parse_or_none(team.guts_scores), 'members': [] } for individual in individuals: if individual.team > 0 and individual.team in teamsDict: teamsDict[individual.team]["members"].append({ 'name': individual.name, 'id': individual.assigned_id, 'speed_scores': json.loads(individual.speed_scores if (individual.speed_scores is not None) else 'null'), 'accuracy_scores': json.loads(individual.accuracy_scores if (individual.accuracy_scores is not None) else 'null') }) self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps(teamsDict))
def get(self): rnd = self.request.get('round') _id = self.request.get('id') name = '' ret = '[]' if rnd in ('speed', 'accuracy'): ind = Individual.query(Individual.assigned_id == _id, Individual.year == YEAR) if ind.count() > 0: ind = ind.fetch()[0] name = ind.name + '|' + Team.get_by_id(ind.team).name if rnd == 'speed': ret = ind.speed_scores else: ret = ind.accuracy_scores else: team = Team.query(Team.assigned_id == _id) if team.count() > 0: team = team.fetch()[0] name = team.name if rnd == 'team': ret = team.team_scores else: if team.guts_scores is None: ret = [] else: ret = team.guts_scores self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({'scores': ret, 'name': name}))
def get(self): teams = {} individuals = [] # Create and insert a record # for this registration. user = self.auth.get_user_by_session()['user_id'] query = Individual.query(Individual.user == user) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append(member.serialize_full()) else: teams[member.team] = { 'members': [member.serialize_full()] } else: individuals.append(member.serialize_full()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['paid'] = record.paid teams[team_id]['year'] = record.year teams[team_id]['guts_scores'] = parse_or_none(record.guts_scores) teams[team_id]['team_scores'] = parse_or_none(record.team_scores) # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'teams': teams, 'individuals': individuals }))
def post(self): email = self.request.get('email') password = self.request.get('password') success = True problem = "" query = LegacyUser.query(LegacyUser.email == email) if query.count() == 0: try: u = self.auth.get_user_by_password(email, password, remember=True, save_session=True) print u except (InvalidAuthIdError, InvalidPasswordError) as e: success = False problem = str(type(e)) else: user = query.get() salt = user.salt _hash = user.hash hashfun = hashlib.sha512() hashfun.update(salt) hashfun.update(password.encode()) hashval = hashfun.hexdigest() if hashval == _hash: success = True user_data = self.user_model.create_user(email, password_raw=password, institution=user.institution) if not user_data[0]: success = False else: # Re-attribute any teams belonging to the legacy user # to the new user. query = Team.query(Team.user == user.key.id()) for team in query: print 'Reattributing ' + team.name team.user = user_data[1].key.id() team.put() query = Individual.query(Individual.user == user.key.id()) for individual in query: print 'Reattributing ' + individual.name individual.user = user_data[1].key.id() individual.put() self.auth.set_session(self.auth.store.user_to_dict(user_data[1]), remember=True) user.key.delete() else: success = False problem = 'InvalidPasswordError' self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'success': success, 'problem': problem }))
def get(self): users = self.user_model.query(self.user_model.team_updated >= ( datetime.datetime.today() - datetime.timedelta(hours=1))).fetch() for user in users: teams = {} individuals = [] query = Individual.query(Individual.user == user.key.id(), Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append( member.serialize()) else: teams[member.team] = {'members': [member.serialize()]} else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name values = teams.values() body = "" for team in values: body += """ %s %s %s %s %s """ % (team['name'], team['members'][0], team['members'][1], team['members'][2], team['members'][3]) if len(individuals) > 0: body += """ Individuals """ for individual in individuals: body += individual + '\n' mail.send_mail( sender= 'Exeter Math Club Competition <*****@*****.**>', to=user.auth_ids[0], subject='EMCC Team Information Change', body="""Hi, This email is to confirm that you have made changes to your registered teams and the list of teams and individuals registered is now: %s Best, Exeter Math Club Competition""" % (body, ))
def get(self): users = self.user_model.query(self.user_model.team_updated >= (datetime.datetime.today() - datetime.timedelta(hours=1))).fetch() for user in users: teams = {} individuals = [] query = Individual.query(Individual.user == user.key.id(), Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append(member.serialize()) else: teams[member.team] = { 'members': [member.serialize()] } else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name values = teams.values() body = "" for team in values: body += """ %s %s %s %s %s """ % (team['name'], team['members'][0], team['members'][1], team['members'][2], team['members'][3]) if len(individuals) > 0: body += """ Individuals """ for individual in individuals: body += individual + '\n' mail.send_mail(sender='Exeter Math Club Competition <*****@*****.**>', to=user.auth_ids[0], subject='EMCC Team Information Change', body="""Hi, This email is to confirm that you have made changes to your registered teams and the list of teams and individuals registered is now: %s Best, Exeter Math Club Competition""" % (body,))
def post(self): password = self.request.get('password') problem = '' success = True if password != 'adidasTwilight': success = False problem = 'password' else: rnd = self.request.get('round') _id = self.request.get('id') score = self.request.get('score') if rnd in ('speed', 'accuracy'): ind = Individual.query(Individual.assigned_id == _id, Individual.year == YEAR) if ind.count() != 0: ind = ind.fetch()[0] if rnd == 'speed': ind.speed_scores = score else: ind.accuracy_scores = score ind.put() else: success = False problem = 'id' else: team = Team.query(Team.assigned_id == _id) if team.count() != 0: team = team.fetch()[0] if rnd == 'team': team.team_scores = score else: guts_round = int(self.request.get('guts_round')) if team.guts_scores is None: team.guts_scores = '[]' loaded = json.loads(team.guts_scores) loaded[guts_round * 3 - 3:guts_round * 3] = json.loads(score) team.guts_scores = json.dumps(loaded) team.put() else: success = False problem = 'id' self.response.headers['Content-Type'] = 'application/json' self.response.write( json.dumps({ 'success': success, 'problem': problem }))
def get(self): teams = Team.query(Team.year == get_year() - 1) teams_dict = {} for team in teams: team.year = get_year() individuals = Individual.query(Individual.team == team.key.id()) for individual in individuals: individual.year = team.year individual.put() teams_dict[team.key.id()] = team.year team.put() self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({'teams': teams_dict}))
def post(self): password = self.request.get('password') problem = '' success = True if password != 'adidasTwilight': success = False problem = 'password' else: rnd = self.request.get('round') _id = self.request.get('id') score = self.request.get('score') if rnd in ('speed', 'accuracy'): ind = Individual.query(Individual.assigned_id == _id, Individual.year == YEAR) if ind.count() != 0: ind = ind.fetch()[0] if rnd == 'speed': ind.speed_scores = score else: ind.accuracy_scores = score ind.put() else: success = False problem = 'id' else: team = Team.query(Team.assigned_id == _id) if team.count() != 0: team = team.fetch()[0] if rnd == 'team': team.team_scores = score else: guts_round = int(self.request.get('guts_round')) if team.guts_scores is None: team.guts_scores = '[]' loaded = json.loads(team.guts_scores) loaded[guts_round*3-3:guts_round*3] = json.loads(score) team.guts_scores = json.dumps(loaded) team.put() else: success = False problem = 'id' self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'success': success, 'problem': problem }))
def get(self): teams = Team.query(Team.year == get_year() - 1) teams_dict = {} for team in teams: team.year = get_year() individuals = Individual.query(Individual.team == team.key.id()) for individual in individuals: individual.year = team.year individual.put() teams_dict[team.key.id()] = team.year team.put() self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'teams': teams_dict }))
def get(self): teams = {} individuals = [] # Query all users registered this year. query = Individual.query(Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append(member.serialize()) else: teams[member.team] = { 'members': [member.serialize()] } else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['assigned_id'] = record.assigned_id teams[team_id]['paid'] = record.paid teams[team_id]['user'] = record.user users_query = User.query() users = {} for user in users_query: users[user.key.id()] = user.auth_ids[0] # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'teams': teams, 'individuals': individuals, 'users': users }))
def post(self): # Create and insert a record # for this registration. user_id = int(self.auth.get_user_by_session()['user_id']) query = Individual.query(Individual.user == user_id, Individual.year == YEAR) for member in query: member.key.delete() individuals = json.loads(self.request.get('individuals')) for individual in individuals: record = Individual( name = individual['name'], team = individual['team'], user = user_id, paid = (individual['paid'] if 'paid' in individual else False), year = YEAR ) record.put() teams = json.loads(self.request.get('teams')) for team in teams: print team record = Team.get_by_id(team['id']) record.name = team['name'] record.put() user = self.user_model.get_by_id(user_id) user.refresh() user.put() # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'success': True }))
def get(self): teams = {} individuals = [] # Query all users registered this year. query = Individual.query(Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append(member.serialize()) else: teams[member.team] = {'members': [member.serialize()]} else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['assigned_id'] = record.assigned_id teams[team_id]['paid'] = record.paid teams[team_id]['user'] = record.user users_query = User.query() users = {} for user in users_query: users[user.key.id()] = user.auth_ids[0] # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write( json.dumps({ 'teams': teams, 'individuals': individuals, 'users': users }))
def post(self): # Create and insert a record # for this registration. user_id = int(self.auth.get_user_by_session()['user_id']) query = Individual.query(Individual.user == user_id, Individual.year == YEAR) for member in query: member.key.delete() individuals = json.loads(self.request.get('individuals')) for individual in individuals: record = Individual( name=individual['name'], team=individual['team'], user=user_id, paid=(individual['paid'] if 'paid' in individual else False), year=YEAR) record.put() teams = json.loads(self.request.get('teams')) for team in teams: print team record = Team.get_by_id(team['id']) record.name = team['name'] record.put() user = self.user_model.get_by_id(user_id) user.refresh() user.put() # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({'success': True}))
def get(self): teams = {} individuals = [] # Create and insert a record # for this registration. user_dict = self.auth.get_user_by_session() if user_dict: user = user_dict['user_id'] query = Individual.query(Individual.user == user, Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append( member.serialize()) else: teams[member.team] = {'members': [member.serialize()]} else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['paid'] = record.paid # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write( json.dumps({ 'teams': teams, 'individuals': individuals })) else: self.abort(403)
def get(self): teams = {} individuals = [] # Create and insert a record # for this registration. user_dict = self.auth.get_user_by_session() if user_dict: user = user_dict['user_id'] query = Individual.query(Individual.user == user, Individual.year == YEAR) for member in query: if member.team != -1: if member.team in teams: teams[member.team]['members'].append(member.serialize()) else: teams[member.team] = { 'members': [member.serialize()] } else: individuals.append(member.serialize()) for team_id in teams: record = Team.get_by_id(team_id) teams[team_id]['name'] = record.name teams[team_id]['id'] = int(team_id) teams[team_id]['paid'] = record.paid # Inform the client of success. self.response.headers['Content-Type'] = 'application/json' self.response.write(json.dumps({ 'teams': teams, 'individuals': individuals })) else: self.abort(403)
def post(self): email = self.request.get('email') password = self.request.get('password') success = True problem = "" query = LegacyUser.query(LegacyUser.email == email) if query.count() == 0: try: u = self.auth.get_user_by_password(email, password, remember=True, save_session=True) print u except (InvalidAuthIdError, InvalidPasswordError) as e: success = False problem = str(type(e)) else: user = query.get() salt = user.salt _hash = user.hash hashfun = hashlib.sha512() hashfun.update(salt) hashfun.update(password.encode()) hashval = hashfun.hexdigest() if hashval == _hash: success = True user_data = self.user_model.create_user( email, password_raw=password, institution=user.institution) if not user_data[0]: success = False else: # Re-attribute any teams belonging to the legacy user # to the new user. query = Team.query(Team.user == user.key.id()) for team in query: print 'Reattributing ' + team.name team.user = user_data[1].key.id() team.put() query = Individual.query(Individual.user == user.key.id()) for individual in query: print 'Reattributing ' + individual.name individual.user = user_data[1].key.id() individual.put() self.auth.set_session(self.auth.store.user_to_dict( user_data[1]), remember=True) user.key.delete() else: success = False problem = 'InvalidPasswordError' self.response.headers['Content-Type'] = 'application/json' self.response.write( json.dumps({ 'success': success, 'problem': problem }))