How to bind parameters to InfluxDB Python client query

Question

How can I bind query parameters to an InfluxDB query using the Python client?

For example, I want the results of a query filtered by the InfluxDb tag "my_tag": some_id=5 SELECT * FROM "foobar" WHERE ("my_tag"=some_id);

client = InfluxDBClient(host=my_host,port=my_port)
client.switch_database(database=my_database)

def get_results_by_id(my_id):
    results = client.query(
        query='SELECT * FROM "foobar" WHERE ("my_tag" = id)',
        params={"id": my_id}
    )
    ...
)

Getting zero results with this. Obviously, I can just use a string formatter, but there must be a way to do it with the Influx API.

hoang pham · Accepted Answer · 2019-12-19 07:09:49Z

3

client = InfluxDBClient(host=my_host,port=my_port)
client.switch_database(database=my_database)

def get_results_by_id(my_id):
    results = client.query(
        query='SELECT * FROM foobar WHERE my_tag=$my_tag;',
        params={"my_tag": my_id}
    )
    ...
)

answered Dec 19, 2019 at 7:09

hoang pham

811 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Boendal Over a year ago

It's a good style to also use a few words to explain what you did to make it work.

Collectives™ on Stack Overflow

How to bind parameters to InfluxDB Python client query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related