GQL query help - How can I write a query with where clause in GQL ? I am using google appengine data

Posted by srivigneshwar on Stack Overflow See other posts from Stack Overflow or by srivigneshwar
Published on 2010-04-17T21:00:12Z Indexed on 2010/04/17 21:03 UTC
Read the original article Hit count: 630

Filed under:

google-app-engine

|

gql

|

gqlquery

I have three records in a table example:

*Usernames*        *email*                *city*
Nick            [email protected]        London
Vikky           [email protected]       Paris
Lisa            [email protected]        Sydney

Now I want to get specific record keeping email ID as a key ,

SQL query may be like this

select * from table1 where email = "[email protected]"

What is the equivalent GQL query for the above ??

© Stack Overflow or respective owner

Related posts about google-app-engine

unittest import error with virtualenv + google-app-engine-django

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working with google-app-engine-django + zipped django. Just running "python manage.py test" succeeded without error. But with virtualenv, test was failed with "import unittest error". same error with Django 1.1. - OSX 10.5.6 - google-app-engine-django (r101 via svn) : r100 was failed with launcher… >>> More
Could not import Django settings into Google App Engine

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all you Google App Engine experts, I have used Django a little before but am new to Google App Engine and am trying to use it's development web server with Django for the first time. I don't know if this is relevent but I previously had Django 1.1 and Python 2.6 on my Windows XP and even… >>> More
How does Google App Engine precompile Java ?

as seen on Stack Overflow - Search for 'Stack Overflow'
App Engine uses a "precompilation" process with the Java bytecode of an app to enhance the performance of the app in the Java runtime environment. Precompiled code functions identically to the original bytecode. Is there any detailed information what this does? >>> More
Creating a session scoped bean in Google App Engine using Spring 2.5

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to create a session bean in spring mvc. I am having the following error message when I run my google app engine server in my local box: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'siteController' defined in ServletContext resource [/WEB-INF/springapp-servlet… >>> More
Google App Engine UI Widgets

as seen on Stack Overflow - Search for 'Stack Overflow'
Are there any UI widgets available to the python side of Google App Engine? I'd like something like the collapsed/expanded views of Google Groups threads. Are these type things limited to the GWT side? >>> More

Related posts about gql

How to do this GQL query in JDO

as seen on Stack Overflow - Search for 'Stack Overflow'
I have about 50k entities stored in appengine. I am able to look up an individual record via the GQL admin interface with a query like: SELECT * FROM Pet where __key__ = KEY( 'Pet','Fido') But I'm having trouble figuring out how to do a batch version of this via JDO. Right now I have this: … >>> More
GQL query language inside of jpa program

as seen on Stack Overflow - Search for 'Stack Overflow'
How we use GQL query language inside of jpa program. >>> More
What's your experience developing on Google App Engine?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is GQL easy to learn for someone who knows SQL? How is Django/Python? Does App Engine really make scaling easy? Is there any built-in protection against "GQL Injections"? And so on... I'd love to hear the not-so-obvious ups and downs of using app engine. Cheers! >>> More
GQL how to select by UserProperty

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey I have this code but it doesn't work because it is expecting a string. How can I make it work? class Atable(BaseModel): owner = db.UserProperty() (...) --------- // -------------- query = "SELECT * FROM Atable WHERE owner=", users.get_current_user() results = db.GqlQuery(query) How… >>> More
GQL select by UserProperty

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey I have this code but it doesn't work because it is expecting a string. How can I make it work? class Atable(BaseModel): owner = db.UserProperty() (...) --------- // -------------- query = "SELECT * FROM Atable WHERE owner=", users.get_current_user() results = db.GqlQuery(query) How… >>> More