Menu
I am trying to get my ancestor query to work but I keep getting this error:
BadQueryError: Parse Error: Identifier is a reserved keyword at symbol ANCESTOR
at this line:
TweepleKey(twitter_handle))
I was following Using the Datastore tutorial (which works) but when I tried to apply the concepts of ancestor query to my code (see below) it keeps producing the above mentioned error. Where did I go wrong?
import cgi
import urllib
import webapp2
import cgi
from google.appengine.ext import db
# defines a data model for a geotweet
# GeoTweet model has 1 property: twitter_handle
class GeoTweet(db.Model):
twitter_handle = db.StringProperty()
date = db.DateTimeProperty(auto_now_add=True)
def TweepleKey(twitter_handle=None):
# Constructs a Datastore key for a TweepleStore entity with twitter_handle
return db.Key.from_path('TweepleStore', twitter_handle or 'default_handle')
class MainPage(webapp2.RequestHandler):
def get(self):
self.response.out.write("""<html><body>""")
twitter_handle = self.request.get('twitter_handle')
tweeple = db.GqlQuery("SELECT * "
"FROM GeoTweet "
"WHERE ANCESTOR = :1 "
"ORDER BY date DESC LIMIT 10",
TweepleKey(twitter_handle))
for t in tweeple:
if t.twitter_handle:
self.out.write('<b>Found %s. Saved on %s.</b>' % (t.twitter_handle, t.date))
else:
self.out.write('<b>%s was not found!' % twitter_handle)
self.response.out.write("""<form action="/search" method="post">
<div><textarea name="twitter_handle" rows="1" cols="20">@example</textarea>
<div><input type="submit" value="Find"></div>
</form>
</body>
</html>""")
class TweepleStore(webapp2.RequestHandler):
def post(self):
twitter_name = self.request.get('twitter_handle')
geotweet = GeoTweet(parent=TweepleKey(twitter_name))
geotweet.twitter_handle = twitter_name
geotweet.put()
self.redirect('/?' + urllib.urlencode({'twitter_name': twitter_name}))
app = webapp2.WSGIApplication([('/', MainPage),
('/search', TweepleStore)], debug=True)
296
The GQL reference says to use WHERE ANCESTOR IS.
84
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
