application.yml
3.08 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
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://106.15.73.210:5433/thingskit"
jdbcUserName: "postgres"
jdbcPassword: "thingskit"
selectSql: "SELECT
de.sn AS sn,
tkl1.dbl_v AS Ep,
tkl2.dbl_v AS Ubc,
tkl3.dbl_v AS Uc,
tkl5.dbl_v AS Uab,
tkl6.dbl_v AS Ib,
tkl8.dbl_v AS F,
tkl10.dbl_v AS Ua,
tkl12.dbl_v AS Ic,
tkl13.dbl_v AS Ub,
tkl14.dbl_v AS Uca,
tkl16.dbl_v AS Ia
FROM
device de
LEFT JOIN ts_kv_latest tkl1 ON de.id = tkl1.entity_id
AND tkl1.key = 536
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 499
LEFT JOIN ts_kv_latest tkl3 ON de.id = tkl3.entity_id
AND tkl3.key = 492
LEFT JOIN ts_kv_latest tkl5 ON de.id = tkl5.entity_id
AND tkl5.key = 496
LEFT JOIN ts_kv_latest tkl6 ON de.id = tkl6.entity_id
AND tkl6.key = 495
LEFT JOIN ts_kv_latest tkl8 ON de.id = tkl8.entity_id
AND tkl8.key = 537
LEFT JOIN ts_kv_latest tkl10 ON de.id = tkl10.entity_id
AND tkl10.key = 497
LEFT JOIN ts_kv_latest tkl12 ON de.id = tkl12.entity_id
AND tkl12.key = 498
LEFT JOIN ts_kv_latest tkl13 ON de.id = tkl13.entity_id
AND tkl13.key = 493
LEFT JOIN ts_kv_latest tkl14 ON de.id = tkl14.entity_id
AND tkl14.key = 494
LEFT JOIN ts_kv_latest tkl16 ON de.id = tkl16.entity_id
AND tkl16.key = 489
WHERE
de.organization_id='35bcdb94-31ec-4750-9ee9-cc855aa66e17'
AND de.device_profile_id = '6c1f9650-0298-11f1-9cb8-e3376d1e7978'"
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 = 541
LEFT JOIN ts_kv_latest tkl2 ON de.id = tkl2.entity_id
AND tkl2.key = 542
WHERE
de.organization_id='35bcdb94-31ec-4750-9ee9-cc855aa66e17'
AND de.device_profile_id = 'fdf70e30-0272-11f1-9cb8-e3376d1e7978'"