Control functionality question

[corndog2000]

Hi, I am considering using your plugin for a user interface in my grafana dashboard. I'm confused as to how database queries can be used for dashboard controls.

[speakyourcode]

Hi, here an example with postgres:
#1 (comment)
Which datasource are you using?

[corndog2000]

I am using InfluxDB. I don't understand how the other person in that closed issue was able to get grafana to run scripts with this plugin.

[speakyourcode]

Here is an example to create a database with InfluxDB:

{
  "query": "create database \"foo\"",
  "rawQuery": true,
  "resultFormat": "time_series"
}

And to delete it:

{
  "query": "drop database \"foo\"",
  "rawQuery": true,
  "resultFormat": "time_series"
}

[CocoJumbA]

Good afternoon,
Could you be so kind and make an example of a query with inserting some value to an InfluxDB measurement?
Regards

[speakyourcode]

Hi,
InfluxDB has three endpoints: /api/v2/query, /api/v2/write and /health, and Grafana always uses query. AFAIK the only way to use the write endpoint is with a custom datasource.

[angellee99]

Hi,
InfluxDB has three endpoints: /api/v2/query, /api/v2/write and /health, and Grafana always uses query. AFAIK the only way to use the write endpoint is with a custom datasource.

Hi, how should we add queries to insert values into the influxdb database?

[speakyourcode]

Hi, you can only insert values with the endpoint /api/v2/write. Grafana's InfluxDB Datasource only supports /api/v2/query, so you can't unless you use a custom datasource implementing the write endpoint (see https://grafana.com/tutorials/build-a-data-source-plugin/).

[AmmarAhmed]

Hello, I am on grafana version 6.7.3, I am trying to add speakyourcode-button-panel but I have an error "Error loading panel plugin: speakyourcode-button-panel TypeError: v.setPanelOptions is not a function"
Do you have an idea ?

[speakyourcode]

The plugin requires Grafana 7 or higher, can you upgrade and try again?

[PapaRoach25]

Hello, @speakyourcode
Is it possible to delete series of data from InfluxDB using your plugin?
My query is:

{
  "query": "drop series from \"jmeter\" where \"application\" = \"$test_name\"",
  "rawQuery": true,
  "resultFormat": "time_series"
}

$test_name - grafana variable

After clicking on the button I received:
Button: 500 (Internal Server Error) An error occurred within the plugin

Using your example I was able to create a database.

Updates: my bad I've missed space after where clause: where"application". (already edited in this comment)
After that 500 error disappeared, but the query itself couldn't drop the series from DB. (in the dev tools I'm observing 200 OK)
Do you have any suggestions on how it can be done using your plugin?
Thanks.