Google app engine: Queries

Question

I have a table Foo where my foos are stored and if I log in via browser and list all my foos there is one Foo with ID=12. Then I have this code:

logging.info(fid)
q = db.GqlQuery("SELECT * FROM Foo WHERE ID = :1", fid)
logging.info(list(q))

which prints

12
[]

If I do q.fetch(4) it still gives me index out of range. What am I doing wrong? Thanks for your help!

Answer 1

get_by_id

is what I was looking for!

Answer 2

Read the doc. You can't query with a raw ID, you need to create a Key object.