crssconfig/crss-metering/crss-metering.yml

spring:
  datasource:
    platform: oracle
    url: jdbc:oracle:thin:@192.168.235.6:1521:ORCL
    username: crss_metering
    password: crss_metering
    driverClassName: oracle.jdbc.OracleDriver
    hikari:
      connectionTimeout: 10000
      maximumPoolSize: 20
  rabbitmq:
    host: pemc-oracle.ss.exist.com
    ports:
      - "5672:5672"
      - "15672:15672"

server:
  port: 8080
  undertow:
    accesslog:
      dir: target
      enabled: true
      pattern: combined
  compression:
    enabled: true
    min-response-size: 1

eureka:
  client:
    serviceUrl:
      defaultZone: http://discovery:8080/eureka/
      #    healthcheck:
      #      enabled: true
#    lease:
#      duration: 5
#  instance:
#    leaseRenewalIntervalInSeconds: 1
#    leaseExpirationDurationInSeconds: 2

security:
  oauth2:
    client:
      accessTokenUri: http://app:8080/admin/oauth/access_token
      userAuthorizationUri: http://app:8080/admin/oauth/authorize
      clientId: crss
      clientSecret: crsssecret
      authorized-grant-types: authorization_code,refresh_token,password
      scope: openid
      access-token-validity-seconds: 3600
    resource:
      userInfoUri: http://app:8080/admin/user

logging:
  level:
    com.pemc: DEBUG
    com.netflix: WARN
    org.springframework.cloud: WARN
    org.hibernate.SQL: DEBUG

mq:
  manifest:
    header: >
      INSERT INTO TXN_MQ_MANIFEST_HEADER (header_id, transaction_id, file_count, category,
      upload_by, upload_datetime) VALUES (HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?)
    trailer: >
      UPDATE TXN_MQ_MANIFEST_HEADER SET tail_received = 'Y' WHERE transaction_id = ?
    file: >
      INSERT INTO TXN_MQ_MANIFEST_FILE (file_id, header_id, transaction_id, filename, filetype,
      filesize, checksum) VALUES (HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?, ?)
  meter:
    daily: >
      INSERT INTO TXN_METER_DATA_DAILY VALUES(
      HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
    monthly: >
      INSERT INTO TXN_METER_DATA_MONTHLY VALUES(
      HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bcq:
  manifest: >
    INSERT INTO TXN_BCQ_UPLOAD_FILE (FILE_ID, TRANSACTION_ID, FILE_NAME, FILE_SIZE, SUBMITTED_DATE)
    VALUES (HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?)
  header:
    insert: >
      INSERT INTO TXN_BCQ_HEADER (BCQ_HEADER_ID, FILE_ID, SELLING_MTN, BUYING_PARTICIPANT, SELLING_PARTICIPANT_NAME,
      SELLING_PARTICIPANT_SHORT_NAME, STATUS, TRADING_DATE) VALUES (HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?, ?, ?)
    update: >
      UPDATE TXN_BCQ_HEADER SET FILE_ID = ? WHERE SELLING_MTN = ? AND BUYING_PARTICIPANT = ? AND TRADING_DATE = ?
    exists: >
      SELECT CASE
      WHEN COUNT(*) > 0 THEN 'Y' ELSE 'N' END
      FROM TXN_BCQ_HEADER
      WHERE SELLING_MTN = ? AND BUYING_PARTICIPANT = ? AND TRADING_DATE = ?
  data:
    insert: >
      INSERT INTO TXN_BCQ_DATA (BCQ_DATA_ID, BCQ_HEADER_ID, REFERENCE_MTN, START_TIME, END_TIME, BCQ)
      VALUES (HIBERNATE_SEQUENCE.NEXTVAL, ?, ?, ?, ?, ?)
    update: >
      UPDATE TXN_BCQ_DATA SET REFERENCE_MTN = ?, BCQ = ? WHERE END_TIME = ? AND BCQ_HEADER_ID = ?
  display:
    data: >
      SELECT A.SELLING_PARTICIPANT_NAME, A.SELLING_PARTICIPANT_SHORT_NAME, A.SELLING_MTN,
      A.BUYING_PARTICIPANT, A.TRADING_DATE, B.TRANSACTION_ID, B.SUBMITTED_DATE, A.STATUS
      FROM TXN_BCQ_HEADER A INNER JOIN TXN_BCQ_UPLOAD_FILE ON A.FILE_ID = B.FILE_ID
      WHERE A.TRADING_DATE = ?
    count: >
      SELECT COUNT(*) FROM TXN_BCQ_HEADER A INNER JOIN TXN_BCQ_UPLOAD_FILE ON A.FILE_ID = B.FILE_ID
      WHERE A.TRADING_DATE = ?
    pagination: >
      OFFSET ? ROWS FETCH NEXT ? ROWS ONLY