Skip to main content

A query generator for the SQL dialect of the Influx Query Language (InfluxQL)

Project description

https://github.com/daq-tools/pyinfluxql/workflows/Tests/badge.svg https://img.shields.io/pypi/pyversions/pyinfluxql.svg https://img.shields.io/pypi/v/pyinfluxql.svg https://img.shields.io/pypi/dm/pyinfluxql.svg https://img.shields.io/pypi/status/pyinfluxql.svg https://img.shields.io/pypi/l/pyinfluxql.svg

About

A query generator for the SQL dialect of the Influx Query Language (InfluxQL). Like SQLAlchemy but for InfluxDB. Consider this an experimental WIP.

Synopsis

from influxdb import InfluxDBClient
from pyinfluxql import Engine, Query, Mean

client = InfluxDBClient('localhost', 8086, 'root', 'root', 'example')
engine = Engine(client)
query = Query(Mean('value')).from_('cpu_load') \
    .where(time__gt=datetime.now() - timedelta(1))
    .group_by(time=timedelta(hours=1))
engine.execute(query)

Tests

How to invoke the test suite.

Using Tox

Run InfluxDB within Docker:

docker run -it --rm --publish 8086:8086 influxdb:1.8.3

Run tox:

tox

Using sandbox

Alternatively, setup package in development mode:

python3 -mvenv .venv
source .venv/bin/activate
pip install --editable=.[test]

Run pytest:

pytest tests -vvv

Credits

Thanks a stack to the original author Jeremiah Malina for his excellent work as well as Michael Pérez for adding integration tests, timezone support and for improving the documentation.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyinfluxql-0.1.1.tar.gz (7.8 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page