| 123456789101112131415161718192021222324252627282930313233343536373839404142 |
- #daily extract
- spring:
- profiles: dailyExtract
- datasource:
- url: jdbc:postgresql://localhost:5432/crss?currentSchema=metering
- username: postgres
- password: postgres
- 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://localhost:5432/crss?currentSchema=metering
- username: postgres
- password: postgres
- 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://localhost:5432/crss?currentSchema=metering
- username: postgres
- password: postgres
- 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);"
|
