application.yml
3.9 KB
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
spring:
application:
name: iot-scheduler
main:
banner-mode: off
server:
port: 32211
logging:
level:
root: INFO
com.iot.scheduler: DEBUG
# Scheduler Configuration (Cron Expressions)
# Format: sec min hour day month day-of-week
scheduler:
huaining:
pull: "0 0/5 * * * ?" # Every 5 minutes
push: "0 0/10 * * * ?" # Every 10 minutes
chizhou:
pull: "0 0/5 * * * ?"
push: "0 0/10 * * * ?"
panji:
pull: "0 0/5 * * * ?"
push: "0 0/10 * * * ?"
ks:
pull: "0 0/2 * * * ?"
push: "0 0/2 * * * ?"
ks:
third:
jdbcUrl: "jdbc:postgresql://192.168.0.249:5432/iot"
jdbcUserName: "postgres"
jdbcPassword: "1qaz@WSX"
selectSql: "SELECT
de.sn AS sn,
tkl1.dbl_v AS Ep,
tkl2.dbl_v AS Ubc,
tkl3.dbl_v AS Uc,
tkl4.dbl_v AS P,
tkl5.dbl_v AS Uab,
tkl6.dbl_v AS Ib,
tkl7.dbl_v AS Eq,
tkl8.dbl_v AS F,
tkl9.dbl_v AS Q,
tkl10.dbl_v AS Ua,
tkl11.dbl_v AS S,
tkl12.dbl_v AS Ic,
tkl13.dbl_v AS Ub,
tkl14.dbl_v AS Uca,
tkl15.dbl_v AS PSum,
tkl16.dbl_v AS Ia
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.key = 64
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 65
LEFT JOIN ts_kv_latest tkl3 ON de.id = tkl3.entity_id
AND tkl3.key = 66
LEFT JOIN ts_kv_latest tkl4 ON de.id = tkl4.entity_id
AND tkl4.key = 67
LEFT JOIN ts_kv_latest tkl5 ON de.id = tkl5.entity_id
AND tkl5.key = 68
LEFT JOIN ts_kv_latest tkl6 ON de.id = tkl6.entity_id
AND tkl6.key = 69
LEFT JOIN ts_kv_latest tkl7 ON de.id = tkl7.entity_id
AND tkl7.key = 70
LEFT JOIN ts_kv_latest tkl8 ON de.id = tkl8.entity_id
AND tkl8.key = 71
LEFT JOIN ts_kv_latest tkl9 ON de.id = tkl9.entity_id
AND tkl9.key = 72
LEFT JOIN ts_kv_latest tkl10 ON de.id = tkl10.entity_id
AND tkl10.key = 73
LEFT JOIN ts_kv_latest tkl11 ON de.id = tkl11.entity_id
AND tkl11.key = 74
LEFT JOIN ts_kv_latest tkl12 ON de.id = tkl12.entity_id
AND tkl12.key = 75
LEFT JOIN ts_kv_latest tkl13 ON de.id = tkl13.entity_id
AND tkl13.key = 76
LEFT JOIN ts_kv_latest tkl14 ON de.id = tkl14.entity_id
AND tkl14.key = 77
LEFT JOIN ts_kv_latest tkl15 ON de.id = tkl15.entity_id
AND tkl15.key = 78
LEFT JOIN ts_kv_latest tkl16 ON de.id = tkl16.entity_id
AND tkl16.key = 79
WHERE
de.organization_id='1697500a-dc11-45cc-88f5-2ad47472a9bb'
AND de.device_profile_id = 'c2401630-ffec-11f0-926f-2f3182abc65f'"
selectSql1: "SELECT
de.sn AS sn,
tkl1.dbl_v AS devid,
tkl2.dbl_v AS zll,
tkl3.dbl_v AS ssll
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.key = 58
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 83
LEFT JOIN ts_kv_latest tkl3 ON de.id = tkl3.entity_id
AND tkl3.key = 84
WHERE
de.organization_id='1697500a-dc11-45cc-88f5-2ad47472a9bb'
AND de.device_profile_id = '4e404b10-ffe7-11f0-926f-2f3182abc65f'"