#daily extract
spring:
  profiles: dailyExtract
  datasource:
    url: jdbc:postgresql://192.168.233.9:5432/crss?currentSchema=metering
    username: crss_metering
    password: crss_metering
    driver-class-name: org.postgresql.Driver

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

---

#Monthly extract
spring:
  profiles: monthlyExtract
  datasource:
    url: jdbc:postgresql://192.168.233.9:5432/crss?currentSchema=metering
    username: crss_metering
    password: crss_metering
    driver-class-name: org.postgresql.Driver

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


---

# default
spring:
  datasource:
    url: jdbc:postgresql://192.168.233.9:5432/crss?currentSchema=metering
    username: crss_metering
    password: crss_metering
    driver-class-name: org.postgresql.Driver

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