| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- #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);"
|
