application.yml
4.71 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
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/5 * * * ?"
push: "0 0/5 * * * ?"
ks:
third:
jdbcUrl: "jdbc:postgresql://192.168.0.249:5432/iot"
jdbcUserName: "postgres"
jdbcPassword: "1qaz@WSX"
selectSql: "SELECT
de.sn AS sn,
COALESCE(tkl1.dbl_v, CAST(tkl1.long_v AS DOUBLE PRECISION)) AS Ep,
COALESCE(tkl2.dbl_v, CAST(tkl2.long_v AS DOUBLE PRECISION)) AS Ubc,
COALESCE(tkl3.dbl_v, CAST(tkl3.long_v AS DOUBLE PRECISION)) AS Uc,
COALESCE(tkl4.dbl_v, CAST(tkl4.long_v AS DOUBLE PRECISION)) AS P,
COALESCE(tkl5.dbl_v, CAST(tkl5.long_v AS DOUBLE PRECISION)) AS Uab,
COALESCE(tkl6.dbl_v, CAST(tkl6.long_v AS DOUBLE PRECISION)) AS Ib,
COALESCE(tkl7.dbl_v, CAST(tkl7.long_v AS DOUBLE PRECISION)) AS Eq,
COALESCE(tkl8.dbl_v, CAST(tkl8.long_v AS DOUBLE PRECISION)) AS F,
COALESCE(tkl9.dbl_v, CAST(tkl9.long_v AS DOUBLE PRECISION)) AS Q,
COALESCE(tkl10.dbl_v, CAST(tkl10.long_v AS DOUBLE PRECISION)) AS Ua,
COALESCE(tkl11.dbl_v, CAST(tkl11.long_v AS DOUBLE PRECISION)) AS S,
COALESCE(tkl12.dbl_v, CAST(tkl12.long_v AS DOUBLE PRECISION)) AS Ic,
COALESCE(tkl13.dbl_v, CAST(tkl13.long_v AS DOUBLE PRECISION)) AS Ub,
COALESCE(tkl14.dbl_v, CAST(tkl14.long_v AS DOUBLE PRECISION)) AS Uca,
COALESCE(tkl15.dbl_v, CAST(tkl15.long_v AS DOUBLE PRECISION)) AS PSum,
COALESCE(tkl16.dbl_v, CAST(tkl16.long_v AS DOUBLE PRECISION)) 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 = 'de36b0f0-9acf-11f1-91f1-1bded40a486e'"
selectSql1: "SELECT
de.sn AS sn,
tkl1.dbl_v AS zll,
tkl2.dbl_v AS ssll
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.key = 83
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 84
WHERE
de.organization_id='1697500a-dc11-45cc-88f5-2ad47472a9bb'
AND de.device_profile_id = '4e404b10-ffe7-11f0-926f-2f3182abc65f'"
iot:
organizeId: "ad80a0f8-3483-43bf-af47-18bde28e59e7"
profileId: "be113b00-5269-11f1-bb2f-9df639274ae7"
deviceProfileId: "be113b00-5269-11f1-bb2f-9df639274ae7"
userName: "kskj"
password: "Kskj@123.com"
tokenUrl: "http://192.168.0.249:8080/api/auth/login"
infoUrl: "http://192.168.0.249:8080/api/yt/device"
detailUrl: "http://192.168.0.249:8080/api/v1/"