How to form queries with time filters? about odata-influxdb HOT 4 CLOSED

Thanks for the quick response! I can report that the latest version does allow us to successfully run time-based queries on our data, and we get entirely sensible results. Also tried a compound filter with timestamp AND 'Location', and it worked perfectly as well.

Towards answering our own Bonus Question… Hacking odata-influxdb to support now() feels yucky. And I don't expect pyslet will have stable support for OData v4 anytime soon. I think in our specific application we can use Nginx or something similar to wire up URL handling such that we can effectively insert/expand now() in a query URL. That should get us where we want to go fairly painlessly.

from odata-influxdb.

Thanks for this, @soundstripe has been working on a pull request for this type of thing, so I'll leave it to him to comment on how he's going about that

and yeah, good point for the bonus question, I'd have to do a bit more reading about how to best handle that in odata - in general, the broader question of 'what best-practices there are for working with time-series data through odata' is something that I should look into more thoroughly, as i have found that quering a lot of data can be slow (since it constructs and downloads all the metadata for each row)

from odata-influxdb.

There's a few example queries in the README now.

The queries were designed according to InfluxDB 1.2 specs, but I believe they will work for 1.1 with no issues.

I have added to the supported filter operators, and the code to add more is pretty simple if you find some you need to be missing.

As for the Bonus Question, there are query functions in the OData spec (such as "now()") but it doesn't look like pyslet implements these. I think it would be possible to put this in this project, but would be better as a contribution to pyslet (toward its existing issue to support OData v4 etc).

from odata-influxdb.

Closing after fixes from #18

from odata-influxdb.