def post(self, name): _entry = EntryModel.find_by_name(name) competition = CompetitionModel.find_by_name(name) if competition: if competition.isFinished: return {'message': "The competition '{}' is Finished! Can not accept more entries!".format(name)} competition_num_tries = competition.numTrys else: return {'message': "The competition '{}' doesen't exists.".format(name)} data = Entry.parser.parse_args() competition_id = CompetitionModel.find_competition_id(name) athlete_num_tries = EntryModel.find_athlete_tries(competition_id, data['atleta']) if _entry and athlete_num_tries and athlete_num_tries >= competition_num_tries: return {'message': "{} has reached the maximum number of attempts in {} competition.".format(data['atleta'], name)}, 500 competition = CompetitionModel.find_by_name(name) entry = EntryModel(data['atleta'], data['value'], data['unidade'], competition.id) try: entry.save_to_db() except: return {"message": "An error occurred inserting the entry."}, 500 return entry.json(), 201
def get(self, name): competition = CompetitionModel.find_by_name(name) if competition: competition_id = CompetitionModel.find_competition_id(name) if competition.competicao.find("ardo") != -1: #same as #query = "SELECT atleta FROM entrys WHERE competition_id=? ORDER BY value desc" return [ entry.json() for entry in EntryModel.query.filter_by( competition_id=competition_id).order_by( EntryModel.value.desc()) ] else: #query = "SELECT atleta FROM entrys WHERE competition_id=? ORDER BY value asc" return [ entry.json() for entry in EntryModel.query.filter_by( competition_id=competition_id).order_by('value') ] return {'message': 'Competition not found'}, 404