FEATURE: add custom ad-hoc queries for schedulled run, etc
Change-Id: Idabbb59c74a6ca004629c8f33e92c96d2d35c113
diff --git a/README.rst b/README.rst
index 75ffe55..854da83 100644
--- a/README.rst
+++ b/README.rst
@@ -273,10 +273,40 @@
client:
database:
mydb1:
- continuos_query:
+ continuous_query:
cq_avg_bus_passengers: >-
SELECT mean("passengers") INTO "transportation"."three_weeks"."average_passengers" FROM "bus_data" GROUP BY time(1h)
+Prunning data and data management:
+
+Intended to use in scheduled jobs, executed to maintain data life cycle above retention policy. These states are executed by
+``query.sls`` and you are expected to trigger ``sls_id`` individually.
+
+.. code-block:: yaml
+
+ influxdb:
+ client:
+ database:
+ mydb1:
+ query:
+ drop_measurement_h2o: >-
+ DROP MEASUREMENT h2o_quality
+ drop_shard_h2o: >-
+ DROP SHARD h2o_quality
+ drop_series_h2o_feet: >-
+ DROP SERIES FROM "h2o_feet"
+ drop_series_h2o_feet_loc_smonica: >-
+ DROP SERIES FROM "h2o_feet" WHERE "location" = 'santa_monica'
+ delete_h2o_quality_rt3: >-
+ DELETE FROM "h2o_quality" WHERE "randtag" = '3'
+ delete_h2o_quality: >-
+ DELETE FROM "h2o_quality"
+
+
+.. code-block:: shell
+
+ salt \* state.sls_id influxdb_query_delete_h2o_quality influxdb.query
+
InfluxDB relay with HTTP outputs: