71 lines
1.6 KiB
Bash
Executable File
71 lines
1.6 KiB
Bash
Executable File
#!/usr/bin/env bash
|
|
#
|
|
# Mailt den CSV Dump der Datenbank an Mailziel
|
|
#
|
|
|
|
function toWin() {
|
|
mv $1 $1.utf
|
|
/usr/bin/iconv -t windows-1252 -f utf-8 $1.utf > $1
|
|
rm $1.utf
|
|
}
|
|
|
|
MAILZIEL="br@runden.de"
|
|
CWD=$(dirname $0)
|
|
TODAY=$(date +"%Y-%m-%d")
|
|
SQLITE3=/usr/bin/sqlite3
|
|
DATABQL=$CWD/energiemon.db
|
|
|
|
CSVSUBDIR=$CWD/csv
|
|
mkdir -p $CSVSUBDIR
|
|
|
|
#rohdaten
|
|
DATEN=rohdaten
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
#gasdaten
|
|
DATEN=gasdaten
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
#stromdaten
|
|
DATEN=stromdaten
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
#wasserdaten
|
|
DATEN=wasserdaten
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
#monatssummen
|
|
DATEN=monatssummen
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
#wochensummen
|
|
DATEN=wochensummen
|
|
SQLTXTFILE=$CWD/export${DATEN}.sql
|
|
CSVDUMP=$CSVSUBDIR/${DATEN}_${TODAY}.csv
|
|
$SQLITE3 $DATABQL < $SQLTXTFILE > $CSVDUMP
|
|
toWin $CSVDUMP
|
|
|
|
echo -en "Hallo zusammen, \nAnbei die Zählerdaten \n" \
|
|
"von https://enermon.chmln.de \n\n"\
|
|
"Viele Grüße von der ChamäleonCloud \n\n" | \
|
|
/usr/bin/mutt -a $CSVSUBDIR/*$TODAY.csv -s "Energiemon Zählerstände vom $TODAY" -- $MAILZIEL
|
|
|
|
# Aufräumen
|
|
/usr/bin/find $CSVSUBDIR \( -iname "*.csv" -o -iname "*csv.utf" \) -mtime +29 -delete
|
|
|