def _querySessions(self, filters, key=None):
        """
        Gernal query used for searching Sessions.
        """
        if key:
            # get Conference object from request; bail if not found
            safeKey = ndb.Key(urlsafe=key)
            conf = safeKey.get()
            if not conf:
                raise endpoints.NotFoundException(
                    'No conference found with key: %s' % key)
            q = Session.query(ancestor=safeKey)
        else:
            q = Session.query()

        if filters:
            inequality_filter, filters, excluded_values = self._formatMutliInequality(
                filters)
            # If exists, sort on inequality filter first
            if inequality_filter:
                q = q.order(ndb.GenericProperty(inequality_filter))

            q = q.order(Session.startTime)
            q = q.order(Session.name)

            for filtr in filters:
                formatted_query = ndb.query.FilterNode(filtr["field"],
                                                       filtr["operator"],
                                                       filtr["value"])
                q = q.filter(formatted_query)

            if excluded_values:
                """
                This code is used to solve query extra credit problem.
                Create list of session types but exclude the not equal to type
                """
                # Create list by turning TypeOfSession EMUN into dict then
                # filtered out values that are in the excluded_values list.
                typeOfSession = [typeOfSession for typeOfSession in \
                                 TypeOfSession.to_dict() if typeOfSession\
                                 not in excluded_values]
                FilterList = []
                # Add additional filter to query
                for i in typeOfSession:
                    FilterList.append(
                        ndb.query.FilterNode('typeOfSession', '=', i))

                q = q.filter(ndb.OR(*FilterList))

        return q
    def _querySessions(self, filters, key=None):
        """
        Gernal query used for searching Sessions.
        """
        if key:
            # get Conference object from request; bail if not found
            safeKey = ndb.Key(urlsafe=key)
            conf = safeKey.get()
            if not conf:
                raise endpoints.NotFoundException(
                    'No conference found with key: %s' % key)
            q = Session.query(ancestor=safeKey)
        else:
            q = Session.query()

        if filters:
            inequality_filter, filters, excluded_values = self._formatMutliInequality(filters)
            # If exists, sort on inequality filter first
            if inequality_filter:
                q = q.order(ndb.GenericProperty(inequality_filter))

            q = q.order(Session.startTime)
            q = q.order(Session.name)

            for filtr in filters:
                formatted_query = ndb.query.FilterNode(filtr["field"], filtr["operator"], filtr["value"])
                q = q.filter(formatted_query)

            if excluded_values:
                """
                This code is used to solve query extra credit problem.
                Create list of session types but exclude the not equal to type
                """
                # Create list by turning TypeOfSession EMUN into dict then
                # filtered out values that are in the excluded_values list.
                typeOfSession = [typeOfSession for typeOfSession in \
                                 TypeOfSession.to_dict() if typeOfSession\
                                 not in excluded_values]
                FilterList = []
                # Add additional filter to query
                for i in typeOfSession:
                    FilterList.append(ndb.query.FilterNode('typeOfSession', '=', i))

                q = q.filter(ndb.OR(*FilterList))

        return q
 def getConferenceSessionsByType(self, request):
     """
     Given a conference, return all sessions of a specified type
     (eg lecture, keynote, workshop)
     """
     key = ndb.Key(urlsafe=request.websafeConferenceKey)
     conf = key.get()
     value = request.value.upper()
     if not conf:
         raise endpoints.NotFoundException(
             'No conference found with key: %s' % key)
     # Check if field and operation are valid
     if request.field != "TYPE" or request.operator not in OPERATORS:
         raise endpoints.NotFoundException('Can only filter by type or check operator')
     # Check if value is valid
     if value not in TypeOfSession.to_dict():
         raise endpoints.NotFoundException('Not a valid session type')
     sessions = Session.query(ancestor=key).\
         filter(ndb.query.FilterNode(FIELDS[request.field],\
         OPERATORS[request.operator], value)).\
         order(Session.startTime)
     return SessionForms(sessions=[self._copySessionToForm(sess)\
                         for sess in sessions])
 def getConferenceSessionsByType(self, request):
     """
     Given a conference, return all sessions of a specified type
     (eg lecture, keynote, workshop)
     """
     key = ndb.Key(urlsafe=request.websafeConferenceKey)
     conf = key.get()
     value = request.value.upper()
     if not conf:
         raise endpoints.NotFoundException(
             'No conference found with key: %s' % key)
     # Check if field and operation are valid
     if request.field != "TYPE" or request.operator not in OPERATORS:
         raise endpoints.NotFoundException(
             'Can only filter by type or check operator')
     # Check if value is valid
     if value not in TypeOfSession.to_dict():
         raise endpoints.NotFoundException('Not a valid session type')
     sessions = Session.query(ancestor=key).\
         filter(ndb.query.FilterNode(FIELDS[request.field],\
         OPERATORS[request.operator], value)).\
         order(Session.startTime)
     return SessionForms(sessions=[self._copySessionToForm(sess)\
                         for sess in sessions])
Пример #5
0
MEMCACHE_ANNOUNCEMENTS_KEY = "RECENT_ANNOUNCEMENTS"
ANNOUNCEMENT_TPL = ('Last chance to attend! The following conferences '
                    'are nearly sold out: %s')
# - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

DEFAULTS = {
    "city": "Default City",
    "maxAttendees": 0,
    "seatsAvailable": 0,
    "topics": ["Default", "Topic"],
}

DEFAULT_SESS = {
    "highlights": ["Default", "Highlight"],
    "duration": "00:00",
    "typeOfSession": TypeOfSession("NOT_SPECIFIED"),
    "date": "1999-12-12",
    "startTime": "12:00",
    "location": "Default Location",
}

OPERATORS = {
    'EQ': '=',
    'GT': '>',
    'GTEQ': '>=',
    'LT': '<',
    'LTEQ': '<=',
    'NE': '!='
}

FIELDS = {