Differences

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

--- informatica:linux:influxdb [2022/06/09 08:27] – jose
+++ informatica:linux:influxdb [2022/06/09 09:04] (current) – jose
@@ Line 8: / Line 8: @@
-Por ejemplo ponemos de HOST:
+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://$HOST/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>