-
Notifications
You must be signed in to change notification settings - Fork 0
/
electro_counter200.sh
41 lines (29 loc) · 1.24 KB
/
electro_counter200.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
#!/bin/sh
#
# For yuoras, [email protected] ICQ: 377599750
# see more info https://redmine.hi.dp.ua/projects/electro_counter/wiki
# electro_counter200.sh
# 2017-05-15 version 1
# kokhan pavel e-mail: [email protected] Skype: kpp77strannik
#
#
# version 1
#
#main_path="/opt/root/200"
main_path="."
c_mysql=/opt/bin/mysql
DB_HOST=192.168.100.15
DB_USER=merk
DB_PASS=
DB_BASE=merkury
#query="insert into mer200(date, t1, t2, t3, t4, summa, volt, power, prim) values (now(), T1, T2, T3, T4, SUMMA, VOLT, POWER, PRIM)"
query="insert into mer200(date, t1, t2, t3, t4, summa, volt, power) values (now(), T1, T2, T3, T4, SUMMA, VOLT, POWER)"
elsum=`sh $main_path/electro_counter.sh kwatt_summ2 | grep -Ei ^[a-z,0-9]{1,8}=[0-9,\.]{1,}$`
eval $elsum
power=`sh $main_path/electro_counter.sh avp | grep -Ei ^[a-z,0-9]{1,8}=[0-9,\.]{1,}$`
eval $power
#Last_on=`$main_path/electro_counter.sh last_on`
#eval $Last_on
#f_sql_scr="`echo $query | sed 's/T1/'$T1'/; s/T2/'$T2'/; s/T3/'$T3'/; s/T4/'$T4'/; s/SUMMA/'$SUM'/; s/VOLT/'$VOLT'/; s/POWER/'$WATT'/; s
f_sql_scr="`echo $query | sed 's/T1/'$T1'/; s/T2/'$T2'/; s/T3/'$T3'/; s/T4/'$T4'/; s/SUMMA/'$SUM'/; s/VOLT/'$VOLT'/; s/POWER/'$WATT'/'`"
$c_mysql -h $DB_HOST -u $DB_USER -p$DB_PASS $DB_BASE -vv -e "${f_sql_scr};"