[web2py] Re: BELONGS is not supported on GAE?

2012-02-25 Thread howesc
yup that happens. sometimes i will read data into a dict so i can grab more than 30 rows and perform the "join" myself. i just spent a bunch of time redoing one of my databases to make it more NOSQL happy. On Friday, February 24, 2012 10:48:25 PM UTC-8, Peter G. wrote: > > BrendanC: Thanks for

[web2py] Re: BELONGS is not supported on GAE?

2012-02-24 Thread Peter G.
BrendanC: Thanks for those resources! I ended up gutting that functionality for now, but those are some great read :)! The non- relational database backend requires some "unlearning" of SQL database practices... New challenge for a new environment. I also have not gotten a local shell working with

[web2py] Re: BELONGS is not supported on GAE?

2012-02-21 Thread howesc
what version of web2py are you using? belongs was not supported on ID at one point, but we fixed that i believe anyhow, i would write the queries for GAE like: # Construct a query to fetch all the mootid's from the group mootGroup = db(db.moot_groups.gid==groupid).select() ###NOTE: you may

[web2py] Re: BELONGS is not supported on GAE?

2012-02-21 Thread BrendanC
I've just started looking Web2py and the Google App Engine - here is some research you might find useful. While this does not relate directly to Web2py it's worth reading/reviewing as it illustrates some gae fundamentals. http://www.arbingersys.com/20080430/google-app-engine-a-better-many-to-ma

[web2py] Re: BELONGS is not supported on GAE?

2012-02-21 Thread Peter G.
Hmm, if that's the case, can someone recommend a viable alternative to perform what I'm trying to do with an operation that works under GAE? On Feb 20, 11:09 pm, guruyaya wrote: > I think inner select belongs are not supported by GAE, but using an > array, is. Can anyone confirm what I just said

[web2py] Re: BELONGS is not supported on GAE?

2012-02-20 Thread guruyaya
I think inner select belongs are not supported by GAE, but using an array, is. Can anyone confirm what I just said (read the code, didn't test it). On 21 פברואר, 08:06, "Peter G." wrote: > I'm trying to obtain a set of rows whose ID values belongs in rows' > fields of another table. > > Here's t