Saturday, April 26, 2008
by Nik Kalyani
Saturday, April 26, 2008 10:48:18 PM (Pacific Standard Time, UTC-08:00)

As I go through the process of getting familiar with Google AppEngine, I'll post interesting things I learn (mostly so I can find them later). Here's a quick note on GQL query syntax:

Assuming a model called Customer, you can use:

1) customers = db.GqlQuery("SELECT * FROM Customer ORDER BY name LIMIT 10")

2) And since GQL queries always return data objects, you can skip the SELECT * and abbreviate to:

customers = Customer.gql("ORDER BY name LIMIT 10")

3) You can also use parameters like this:

customers = Customer.gql("WHERE name = :1 ORDER BY name LIMIT 10", "Smith")

4) And finally, #3 with named parameters like this:

customers = Customer.gql("WHERE name= :person ORDER BY name LIMIT 10", person="Smith")

RSS feed
Search and Links
Bling

View Nik Kalyani's profile on LinkedIn

TechBubble
www.flickr.com
This is a Flickr badge showing public photos from techbubble. Make your own badge here.
Statistics
Total Posts: 216
This Year: 19
This Month: 0
This Week: 0
Comments: 226
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2008
Nik Kalyani
Sign In
All Content © 2008, Nik Kalyani