Esempio n. 1
0
    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