2010/9/2 Paweł Gronkiewicz <[email protected]>
> While we are at it, how do you query a key by it's name? I pretty much
> need to check if entity exists for a given key name.
>
Assuming the entity is a root entity:
SELECT * FROM entity WHERE __key__ = KEY('entity', 'key name')
>
> GQL documentation lacks examples and is really lacking, especially for
> people with less experience.
>
> On Sep 2, 8:48 pm, "Ikai L (Google)" <[email protected]> wrote:
> > Try this:
> >
> > SELECT * FROM entity where __key__ = KEY('string-key')
> >
> > See the section about Keys here:
> >
> > http://code.google.com/appengine/docs/python/datastore/gqlreference.html
> >
> > On Thu, Sep 2, 2010 at 10:28 AM, John Gardner <[email protected]> wrote:
> > > This is probably obvious, but:
> > > I cannot for the life of me figure out how to fetch a known entity by
> > > key in the viewer.
> >
> > > The GQL reference doesn't specify key syntax, since you can do a
> > > db.get(key) from code.
> >
> > > I've tried:
> > > SELECT * FROM entity where __key__ = "string-key"
> > > SELECT * FROM entity where entity.__key__ = "string-key"
> > > SELECT * FROM entity where entity.key = "string-key"
> > > SELECT * FROM entity where entity = "string-key"
> > > and the same without quotes.
> >
> > > This really should be easier, I think.
> >
> > > --
> > > You received this message because you are subscribed to the Google
> Groups
> > > "Google App Engine" group.
> > > To post to this group, send email to [email protected]
> .
> > > To unsubscribe from this group, send email to
> > > [email protected]<google-appengine%[email protected]>
> <google-appengine%[email protected]<google-appengine%[email protected]>
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/google-appengine?hl=en.
> >
> > --
> > Ikai Lan
> > Developer Programs Engineer, Google App Engine
> > Blog:http://googleappengine.blogspot.com
> > Twitter:http://twitter.com/app_engine
> > Reddit:http://www.reddit.com/r/appengine
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<google-appengine%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-appengine?hl=en.
>
>
--
Nick Johnson, Developer Programs Engineer, App Engine Google Ireland Ltd. ::
Registered in Dublin, Ireland, Registration Number: 368047
Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration Number:
368047
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
