application.yml 1.24 KB
spring:
  application:
    name: iot-scheduler
  main:
    banner-mode: off

server:
  port: 33221

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 * * * ?"

xkd:
  third:
    devicesRegisterUrl: "http://117.64.210.63:8087/api/v1/devices/register"
    dataUploadUrl: "http://117.64.210.63:8087/api/v1/data/upload"
    enterpriseId: "PLMOKNJIB8"
    apiKey: "UiOpAsDfGhJkLzXcVbNmQwEr6TyUiOpAsD"
    jdbcUrl: "jdbc:postgresql://192.168.0.61:5433/thingskit"
    jdbcUserName: "postgres"
    jdbcPassword: "postgres"
    selectSql: "SELECT
  dc.credentials_id AS deviceId,
  de.name AS deviceName 
FROM
  device de
  LEFT JOIN tk_organization tko ON de.organization_id = tko.id
  LEFT JOIN ts_kv_latest tkl ON de.id = tkl.entity_id AND tkl.KEY = 61
  LEFT JOIN device_credentials dc ON de.id = dc.device_id
WHERE
  de.tenant_id = '0414df80-f01d-11f0-9cb8-e3376d1e7978'
  AND de.device_profile_id = '0418b010-f01d-11f0-9cb8-e3376d1e7978'"