can you url escape the : and have it work?
if not, maybe use a different separator and change the string to timestamp
parsing to expect your format.
cfh
On Monday, May 6, 2013 1:42:40 PM UTC-7, Bernard wrote:
>
>
> Hi Web2py users,
> I am using the parse_as_rest feature for filtering by date range:
> The pattern is as follows:
> "/unit/{unit.unit_id}/timeseries[timeseries.unit]/{
> timeseries.utc_time.ge}/{timeseries.utc_time.le}",
> I couldn't find documentation that 'ge' and 'le' are valid for datetime
> fields, it seems to work well:
>
> http://localhost/manager/default/api/unit/123/timeseries/2013-05-01/2013-05-02
>
> However, I need to filter based on date and time.
>
> Ideally, I would like to send a request with the time as part of the date
> specification:
>
> http://localhost/manager/default/api/unit/123/timeseries/2013-05-0102:00/2013-05-02
> 00:00
> However, this is an invalid request due to the ':' in the URI.
> I looked into using seconds since epoch for the datetime spec, but that's
> too slow on sqlite.
>
> I'm wondering if anybody knows an easy way to work around this?
>
> The not so pretty solution I'm considering right now is to add a time as
> part of the URI after the date:
>
> http://localhost/manager/default/api/unit/123/timeseries/2013-05-01/02/00/2013-05-02/00/00
> Then, in the controller, I would modify the args before passing to the
> parse_as_rest() function by concating args 4 and 5 with the date in arg 3,
> to form the correct format ('YYYY-MM-YY hh:ss') that parse_as_rest() can
> use.
>
> Any help much appreciated.
>
> Regards,
> Bernard
>
>
--
---
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.
For more options, visit https://groups.google.com/groups/opt_out.
