i personally have not used parse_as_rest so i might be out in left field here.....but are you able to access the output of the query and update it before it is returned?
or perhaps even better, add a format parameter to the table definitions so that you can format the display of references (to show group_name rather than id). good luck! cfh On Thursday, August 16, 2012 10:15:42 AM UTC-7, Matthew Wood wrote: > > I'm posting this question here as well as on > stackoverflow<http://stackoverflow.com/questions/11991678/can-web2py-serve-rest-data-of-many-to-may-tables-via-parse-as-rest>. > > So hopefully the extra exposure will help me out! > > I need to serve REST data about a many-to-many relationship. I've been > playing with web2py's lovely parse_as_rest functionality, but can't quite > get the many-to-many thing working. > > As an example, let's take standard users and groups. > > Tables: > > - user > - id > - user_name > - group > - id > - group_name > - membership > - id > - user_id > - group_id > > > > What pattern do I need to use to serve a url that will give me all > group_name's that a user belongs to? > > patterns = [ > "/user[user]", > "/user[user]/id/{user.id}", > "/user[user]/id/{user.id}/membership[membership.user_id]", > > # This is the line that I can't make yet: > #"/user[user]/id/{user.id}/membership[membership.user_id]/group<WHAT > GOES HERE>", > > "/group[group]", > "/group[group]/id/{group.id}", > ] > parser = db.parse_as_rest(patterns, args, vars) > > > With the non-commented lines above, I can get to these urls: > > > 1. .../user > 2. .../user/id/1 > 3. .../user/id/1/membership > 4. .../group > 5. .../group/id/3 > > > URL #3 shows me all my memberships, and I can then make several separate > calls to URL #5 to get the group_name values, but there's got to be a way > to do this with one call. > > > Help me web2py google forum! You're my only hope. (Besides > stackoverflow<http://stackoverflow.com/questions/11991678/can-web2py-serve-rest-data-of-many-to-may-tables-via-parse-as-rest> > of > course!) > --
