[openstack-dev] [all][API WG] How does one best express a time interval as an API filtering query?

Jay Pipes jaypipes at gmail.com
Thu Oct 6 14:59:05 UTC 2016


Great question! My opinion inline...

On 10/06/2016 08:56 AM, milanisko k wrote:
> Dear API WG,
> We've got ourselves into a bike shedding situation[1] w/r the WG
> filtering suggestion[2]. What we find difficult is to express the
> ISO8601 time intervals[3][4] in accordance to the filtering suggestion.
> We'd like to have support for specifying multiple time intervals a node
> introspection can belong to as a filter criterion.
>
> Currently, we propose:
>
> ?finished_at=<ISOdate_a>/<ISOdate_b>&finished_at=<ISOdate_c>/<ISOdate_d>&...

The issue I have with the is that it uses a / character to delimit the a 
and b dates.

In keeping with the style of the API-WG filter operators, I would 
propose something like this:

?finished_at=between:ISO_DATE_A:ISO_DATE_B&finished_at=between:ISO_DATE_C:ISO_DATE_D

Best,
-jay

> denoting following Python condition:
>       (ISOdate_a <= finished_at < ISOdate_b) or (ISOdate_c <=
> finished_at < ISOdate_d) or...
>
> How does one best express this query in accordance to the WG filtering
> suggestion?
>
> Thanks,
> milan
>
> [1]
> https://review.openstack.org/#/c/375045/7/specs/list-introspection-statuses.rst
> [2]
> https://github.com/openstack/api-wg/blob/master/guidelines/pagination_filter_sort.rst#filtering
>
> [3] https://en.wikipedia.org/wiki/ISO_8601#Time_intervals
> [4] http://www.ukoln.ac.uk/metadata/dcmi/date-dccd-odrf
>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>



More information about the OpenStack-dev mailing list