| 1234567891011121314151617181920212223242526272829303132333435363738 |
- #daily extract
- spring:
- profiles: dailyExtract
- datasource:
- password: crss_metering
- username: crss_metering
- url: jdbc:postgresql://10.64.0.4:5432/crss?currentSchema=metering
- 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);"
- ---
- #Monthly extract
- spring:
- profiles: monthlyExtract
- datasource:
- password: crss_metering
- username: crss_metering
- url: jdbc:postgresql://10.64.0.4:5432/crss?currentSchema=metering
- 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);"
- ---
- # default
- spring:
- datasource:
- password: crss_metering
- username: crss_metering
- url: jdbc:postgresql://10.64.0.4:5432/crss?currentSchema=metering
- 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);"
|
