btw, Hans' suggestion is better than mine. If you're running on GAE,
then you should follow the best practices for that platform. In this
case, the concept is to make your datastore read operations as
lightweight/simple as possible - at the expense of more complicated
write operations and increased storage requirements.
On Jun 22, 11:26 am, Dan <danbr...@gmail.com> wrote:
> Here's a suggestion - there might be better ways to get where you want
> to go, of course. This tries to minimize the changes to your existing
> code.
>
> Since you can't work with more than one table at a time with GAE, you
> could change your GAE 'cats' query to work with only one table, then
> perform a lookup for each resulting row.
>
> so this:
>
> > cats=db((db.posts.id == post_id) & (db.posts.post_category ==
> > db.categories.id)).select(db.categories.ALL)
>
> would become this:
> posts=db((db.posts.id == post_id).select
> (db.posts.post_category).as_list()
> cats=[]
> for p in posts
> cats.append({
> db((db.categories.id == p).select
> (db.categories.category_name,db.categories.category_tip)
> })
>
> On Jun 22, 9:20 am, ProfessionalIT <lsever...@gmail.com> wrote:
>
> > Hans,
>
> > I Have this code:
>
> > def get_post_cats(post_id):
> > cats=db((db.posts.id == post_id) & (db.posts.post_category ==
> > db.categories.id)).select(db.categories.ALL)
> > items=[]
> > for cat in cats:
> > item="<a href='/category/%(cat)s' title='%(tip)s'>%(name)s</
> > a>" % {'app':request.application, 'cat':cat.category_name,
> > 'name':cat.category_name, 'tip':cat.category_tip}
> > items.append(item)
> > pass
> > cat_list=", ".join(items)
> > return XML(cat_list)
>
> > How to transform this code to run in GAE ?
>
> > ps: I'm sorry but I'm a Python dummie programmer.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
