| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- #daily extract
- spring:
- profiles: dailyExtract
- datasource:
- password: crss_metering
- username: crss_metering
- url: jdbc:postgresql://10.176.23.24:5432/crss_sit?currentSchema=metering
- redis:
- database: 4
- 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.176.23.24:5432/crss_sit?currentSchema=metering
- redis:
- database: 4
- 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.176.23.24:5432/crss_sit?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);"
|
