crssconfig/crss-meterprocess-stream-source-daily-raw/crss-meterprocess-stream-source-daily-raw.yml

#daily extract
spring:
  profiles: dailyExtract
  datasource:
    url: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=metering&ApplicationName=streamingSource
    username: crss_metering
    password: Fh7UcXpW
    driver-class-name: com.edb.Driver
    connectionTimeout: 150000
    maximumPoolSize: 3
    test-on-borrow: true
    validation-query: SELECT 1
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json

jdbc:
  query: "select * from metering.txn_meter_data_daily where consumed <> TRUE or consumed is null limit 10000;"
  update: "update metering.txn_meter_data_daily set consumed = TRUE where meter_data_id in (:meter_data_id);"

trigger:
  fixed-delay: 5
  time-unit: SECONDS

logging:
  level:
    com.pemc: DEBUG

---

#Monthly extract
spring:
  profiles: monthlyExtract
  datasource:
    url: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=metering
    username: crss_metering
    password: Fh7UcXpW
    driver-class-name: com.edb.Driver
    maximumPoolSize: 2
    test-on-borrow: true
    validation-query: SELECT 1
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json

jdbc:
  query: "select * from metering.txn_meter_data_monthly where consumed <> TRUE or consumed is null limit 10000;"
  update: "update metering.txn_meter_data_monthly set consumed = TRUE where meter_data_id in (:meter_data_id);"


trigger:
  fixed-delay: 5
  time-unit: SECONDS

logging:
  level:
    com.pemc: DEBUG

---

# default
spring:
  datasource:
    url: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=metering
    username: crss_metering
    password: Fh7UcXpW
    driver-class-name: com.edb.Driver
    maximumPoolSize: 2
    test-on-borrow: true
    validation-query: SELECT 1
  cloud:
    stream:
      bindings:
        output:
          content-type: application/json

jdbc:
  query: "select * from metering.txn_meter_data_monthly where consumed <> TRUE or consumed is null limit 10000;"
  update: "update metering.txn_meter_data_monthly set consumed = TRUE where meter_data_id in (:meter_data_id);"

trigger:
  fixed-delay: 5
  time-unit: SECONDS

logging:
  level:
    com.pemc: DEBUG