Differences

This shows you the differences between two versions of the page.

--- informatica:linux:influxdb [2022/06/08 22:22] – created jose
+++ informatica:linux:influxdb [2022/06/09 09:04] (current) – jose
@@ Line 1: / Line 1: @@
-  docker run -p 8186:8086 -v $PWD:/var/lib/influxdb2 influxdb:2.0
+  docker run --name mi-influx -p 8086:8086 -v $PWD:/var/lib/influxdb2 influxdb:2.0
 Desde la GUI creamos usuario admin, organizacion, bucket y miramos el token
@@ Line 7: / Line 7: @@
 https://docs.influxdata.com/influxdb/v2.0/write-data/developer-tools/api/
+Definimos un par de variables. OJO con las comillas simples y las dobles. Las simples no interpretan las variables que tenga dentro:
+  HOST=localhost:8086
+  TOKEN=byqU_stHPeYKuuwFFRgI62zUQGY4i5_SBGxQjmq_pWqwqZOXx8cCg4av5EaAEqFqykF3N
 <code>
-curl -i -XPOST 'http://192.168.1.200:8186/api/v2/write?org=gh&bucket=borra&precision=ns' \
+curl -i -XPOST "http://$HOST/api/v2/write?org=gh&bucket=borra&precision=ns" \
-  --header 'Authorization: Token byqU_stHPeYKuuwFFRgI62zUQGY4i5_SBGxQjmq_pWqwqZOXx8cCg4av5EaAEqFqykF3N-RPVn9y6e4AckytUQ==' \
+  --header "Authorization: Token $TOKEN" \
-  --data-raw 'cpu_load_short,host=server01,region=us-west value=0.64 1434055562000000000'
+  --data-raw "cpu_load_short,host=server01,region=us-west value=0.64 `date +%s`000000000"
 </code>
 Para consultar:
+<code>
+curl --request POST \
+  http://$HOST/api/v2/query?org=gh  \
+  --header "Authorization: Token $TOKEN" \
+  --header 'Accept: application/csv' \
+  --header 'Content-type: application/vnd.flux' \
+  --data 'from(bucket:"inventario")
+        |> range(start: -12h)
+        |> filter(fn: (r) => r._measurement == "habitacion1")
+        |> aggregateWindow(every: 1h, fn: mean)'
+</code>