Hi,
I'm looking at parse_as_rest() to provide an API and can't get it to work
as expected. I have two table: datasets and fields, with a 1 to N
relationship and I want to create an API that returns datasets that have a
field name matching a pattern so (using the tuple version of patterns to
provide a pattern, base query and exposed fields).
patterns = [
("/field_name/{fields.field_name.contains}/data[datasets.id]",
None, None),
]
I thought this was fine, but now I want to restrict results to the latest
version of datasets either through:
patterns = [
("/field_name/{fields.field_name.contains}/data[datasets.id]", (db.
datasets.latest == True), None),
]
or:
parser = db.parse_as_rest(patterns, args, vars, queries=(db.datasets.latest
== True))
That was returning datasets that are not the latest version. I stuck a
print(dbset._select()) into pydal/helpers/rest.py to try and figure it out.
I think that the example in the manual goes from 1 to N (people to pets),
whereas here I am going from N to 1 (fields to datasets) and the underlying
SQL from that select is performing a cross join:
SELECT *
FROM "datasets"
WHERE ("datasets"."id" IN (
SELECT "fields"."dataset_id"
FROM "fields", "datasets"
WHERE (("fields"."field_name" ILIKE '%search_text%')
AND ("datasets"."latest" = 'T') ESCAPE '\')));
That cross join is breaking the link between the two tables. If I edit that
by hand to check:
SELECT *
FROM "datasets"
WHERE ("datasets"."id" IN (
SELECT "datasets"."latest", "datasets"."id", "fields"."dataset_id"
FROM "fields", "datasets"
WHERE (("fields"."field_name" ILIKE '%search_text%')
AND ("datasets"."latest" = 'T') ESCAPE '\')));
then I get rows like this:
latest | id | dataset_id
-------------+-----+------------
T | 134 | 177
T | 134 | 177
T | 134 | 177
T | 134 | 180
T | 134 | 180
T | 134 | 180
T | 158 | 177
T | 158 | 177
T | 158 | 177
What am I doing wrong?
Cheers,
David
From looking at the code, it seems like the current options are:
1. If parse_at_rest() gets a queries object that isn't a dict, the is
applied
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/982e6d3f-a03e-4347-b23c-0860d3846a68%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
