Hey Googlers,
First time poster here. I've been messing with this for hours, and I'm
thinking it must be the simplest thing to do if you're slow like myself.
I'm trying to get into Google App Engine, so I've picked up a small task
from a friend as a way to get my feet wet. He's put together an Access
Database of electronic cigarette information, single table, simple stuff.
Now I've created the following code to get it into google:
e.g.
flavours(flavourID='7', flavourname='Spliced Lime',
vendor='JuiceWhore', rating=7, notes='Good', Type='Desserts/Sweets').put()
flavours(flavourID='8', flavourname='Cherry', vendor='Perfumers
Apprentice', rating=5, notes='None', Type='Fruit').put()
flavours(flavourID='9', flavourname='Vanilla', vendor='Perfumers
Apprentice', rating=5, notes='None', Type='Other').put()
flavours(flavourID='10', flavourname='Peach', vendor='Perfumers
Apprentice', rating=7, notes='Good, goes well with menthol',
Type='Fruit').put()
This seems to work however i've got 2 issues I can't seem to resolve.
1. Data isn't added to the database in order. In other words, the flavourID
is incremental in nature, yet I'm not seeing "Spliced Lime" as the 7th
entry in the datastore
2. Because of issue one I can't be sure if this is working. But I'd like to
ORDER by flavourID ACS, in fact being about to query flavourID would be
good to validate its working. I've been
using secondquerytestobject.order('__key__') and query =
db.GqlQuery("SELECT * FROM flavours Order by __key__") which seem to be
legal commands but I can't get the ID with something like this:
for i in query.run():
self.response.out.write(i.__key__)
Now I've been looking in a few places:
https://developers.google.com/appengine/docs/python/tools/uploadingdata
https://developers.google.com/appengine/docs/python/datastore/queries#Sort_Orders
https://developers.google.com/appengine/docs/python/datastore/gqlreference
https://developers.google.com/appengine/docs/python/datastore/queries
I think in one of these I saw, you simply cant use __key__ to query its
value. How is everyone else doing it, is anyone else doing it? Does it have
something to do with i.key().id()?
First time poster so let me know if I've not provided enough info!
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
