GAE NeedIndexError:

Question

Error returned is 500 Internal server error when the running app processes a get request for ViewDogs. At GAE Stack Driver console I get:

NeedIndexError: no matching index found - recommended index is: 
- kind:Dog 
  ancestor: yes 
  properties: - 
     name: id 
     direction: desc".

I confirm there is an index loaded named Dog and it currently shows "Serving"

Also confirm there are 4 dogs created successfully, and they can be queried from the DataStore Entities tab individually and with SELECT * FROM Dog. Also note the commented out line self.response.write('You dog!') which returns as expected when uncommented, so presumably not a route issue. I can return a single dog via GET (this code omitted) Code within class ViewAllDogs is likely faulty, did my best with the GAE docs.

index.yaml file, which I confirm is uploaded and has status: "serving"

indexes:
- kind: Dog
  ancestor: yes
  properties:- name: id
    direction: desc
  - name: name
    direction: desc
  - name: type
    direction: desc
  - name: weight
    direction: desc
  - name: boarded
    direction: desc

app.yaml file:

runtime: python27
api_version: 1
threadsafe: true

handlers:
- url: /.*
  script: main.app

main.py

import webapp2
from datetime import datetime
from google.appengine.ext import ndb
import webbrowser
import json

def gql_json_parser(query_obj):
    result = []
    for entry in query_obj:
        result.append(dict([(p, unicode(getattr(entry, p))) for p in entry.properties()]))
    return result

class Dog(ndb.Model):
    """ Models an individual Dog """
    id = ndb.StringProperty(required = True, indexed = True)
    name = ndb.StringProperty(required = True, indexed = True)
    type = ndb.StringProperty(required = True, indexed = True)
    weight = ndb.IntegerProperty(required = True, indexed = True)
    boarded = ndb.BooleanProperty(required = True, indexed = True)

    @classmethod
    def query_dog(cls, ancestor_key):
        return cls.query(ancestor=ancestor_key).order(-cls.id)

class ViewAllDogs(webapp2.RequestHandler):
    def get(self):
#       self.response.write('You dog!')
        parent_dog = self.request.get('parent_dog')
        ancestor_key = ndb.Key("Dog", parent_dog or '*noDogs*')
        query_data = Dog.query_dog(ancestor_key).fetch(10)
        json_query_data = gql_json_parser(query_data)
        self.response.headers['Content-Type'] = 'application/json'
        self.response.write(json.dumps(json_query_data))

app = webapp2.WSGIApplication([
    ('/ViewDogs', ViewAllDogs)
], debug=True)

Similar questions abound, inlcuding this Query google app engine datastore for all entities but none are solving my issue. Thanks.

Answer 1

As usual, I was making it much more complicated than need be...

import webapp2, json
from datetime import datetime
from google.appengine.ext import ndb

MAXDOGS = 100

class Dog(ndb.Model):
    """ Models an individual Dog """
    id = ndb.StringProperty(required = True, indexed = True)
    name = ndb.StringProperty(required = True, indexed = True)
    type = ndb.StringProperty(required = True, indexed = True)
    weight = ndb.IntegerProperty(required = True, indexed = True)
    boarded = ndb.BooleanProperty(required = True, indexed = True)

class ViewAllDogs(webapp2.RequestHandler):
    def get(self):
        query_data = Dog.query()
        results = query.fetch(limit = MAX_SLIPS)
        aList = []
        for match in results:
            aList.append({'id': match.id, 'name': match.name, 'type': match.type, 
                          'weight': match.weight, 'boarded': match.boarded})
        self.response.headers['Content-Type'] = 'application/json'
        self.response.write(json.dumps(aList))

app = webapp2.WSGIApplication([
    ('/ViewDogs', ViewAllDogs)