Influxdb umbenennen von Measurements: Unterschied zwischen den Versionen
Erscheinungsbild
Die Seite wurde neu angelegt: „{{WorkInProgress}} Kategorie:Influxdb Kategorie:Linux Kategorie:Docker Kategorie:OpenHAB Kategorie:SmartHome Kategorie:Scripting “ |
KKeine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
{{WorkInProgress}} | {{WorkInProgress}} | ||
Download des Scriptes hier möglich: https://github.com/alaub81/openHAB/raw/master/rename-influxdb-measurement.sh | |||
<code>rename-influxdb-measurement.sh</code><syntaxhighlight lang="bash"> | |||
#!/bin/bash | |||
######################################################################### | |||
#Name: rename-influxdb-measurement.sh | |||
#Subscription: This Script renames influxdb measurements | |||
# | |||
#by A. Laub | |||
#andreas[-at-]laub-home.de | |||
# | |||
#License: | |||
#This program is free software: you can redistribute it and/or modify it | |||
#under the terms of the GNU General Public License as published by the | |||
#Free Software Foundation, either version 3 of the License, or (at your option) | |||
#any later version. | |||
#This program is distributed in the hope that it will be useful, | |||
#but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY | |||
#or FITNESS FOR A PARTICULAR PURPOSE. | |||
######################################################################### | |||
#Set the language | |||
export LANG="en_US.UTF-8" | |||
#Load the Pathes | |||
export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin | |||
#set the variables: | |||
# InfluxDB Command | |||
INFLUX="docker exec -ti openhab3_influxdb_1 influx" | |||
# InfluxDB Host | |||
INFLUXHOST=localhost | |||
# openHAB Database | |||
INFLUXDB=openhab_db | |||
OLDMEASUREMENT=$1 | |||
NEWMEASUREMENT=$2 | |||
# do the stuff | |||
if [ "$1" = "" -o "$2" = "" ]; then | |||
echo -e "Usage: ${0} { OldMeasurementName } { NewMeasurementName }\n" | |||
exit | |||
fi | |||
# Rename MEASUREMENT | |||
$INFLUX -host $INFLUXHOST -port '8086' -database $INFLUXDB -execute "SELECT * INTO $NEWMEASUREMENT FROM $OLDMEASUREMENT" | |||
$INFLUX -host $INFLUXHOST -port '8086' -database $INFLUXDB -execute "DROP MEASUREMENT $OLDMEASUREMENT" | |||
echo "deleted old measurement: $OLDMEASUREMENT" | |||
</syntaxhighlight> | |||
[[Kategorie:Influxdb]] | [[Kategorie:Influxdb]] | ||
[[Kategorie:Linux]] | [[Kategorie:Linux]] | ||
Version vom 17. Februar 2021, 15:41 Uhr
Work in Progress
Diese Seite wird erst noch aufgebaut. Bitte noch keine Änderungen vornehmen, ohne mit dem ursprünglichen Author zu sprechen!
Vielen Dank
Download des Scriptes hier möglich: https://github.com/alaub81/openHAB/raw/master/rename-influxdb-measurement.sh
rename-influxdb-measurement.sh
#!/bin/bash
#########################################################################
#Name: rename-influxdb-measurement.sh
#Subscription: This Script renames influxdb measurements
#
#by A. Laub
#andreas[-at-]laub-home.de
#
#License:
#This program is free software: you can redistribute it and/or modify it
#under the terms of the GNU General Public License as published by the
#Free Software Foundation, either version 3 of the License, or (at your option)
#any later version.
#This program is distributed in the hope that it will be useful,
#but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
#or FITNESS FOR A PARTICULAR PURPOSE.
#########################################################################
#Set the language
export LANG="en_US.UTF-8"
#Load the Pathes
export PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
#set the variables:
# InfluxDB Command
INFLUX="docker exec -ti openhab3_influxdb_1 influx"
# InfluxDB Host
INFLUXHOST=localhost
# openHAB Database
INFLUXDB=openhab_db
OLDMEASUREMENT=$1
NEWMEASUREMENT=$2
# do the stuff
if [ "$1" = "" -o "$2" = "" ]; then
echo -e "Usage: ${0} { OldMeasurementName } { NewMeasurementName }\n"
exit
fi
# Rename MEASUREMENT
$INFLUX -host $INFLUXHOST -port '8086' -database $INFLUXDB -execute "SELECT * INTO $NEWMEASUREMENT FROM $OLDMEASUREMENT"
$INFLUX -host $INFLUXHOST -port '8086' -database $INFLUXDB -execute "DROP MEASUREMENT $OLDMEASUREMENT"
echo "deleted old measurement: $OLDMEASUREMENT"