spring:
  config:
    activate:
      on-profile: local
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  token:
    secret: iymGhx1XkAAHrex2Zf4ASbiD9P2ksTam

  # 以下为本地数据库/中间件配置，后续迁移至 Nacos
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
        type: com.alibaba.druid.pool.DruidDataSource
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.110.34:3306/xprt_order?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        druid:
          initial-size: 10
          min-idle: 10
          max-active: 100
          max-wait: 60000
          time-between-eviction-runs-millis: 60000
          min-evictable-idle-time-millis: 300000
          validation-query: SELECT 1
          test-while-idle: true
          test-on-borrow: false
          test-on-return: false
          pool-prepared-statements: true
          max-pool-prepared-statement-per-connection-size: 20
          filters: stat,wall,log4j
          connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
          remove-abandoned: true
          remove-abandoned-timeout: 1800
          log-abandoned: true
          stat-view-servlet:
            enabled: true
            url-pattern: /druid/*
            login-username: admin
            login-password: admin
            reset-enable: false
          wall:
            config:
              multi-statement-allow: false
    rules:
      sharding:
        tables:
          xp_order:
            actual-data-nodes: xp0.xp_order_$->{0..19}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_order_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_cancel:
            actual-data-nodes: xp0.xp_order_cancel_$->{0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_cancel_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_evaluate:
            actual-data-nodes: xp0.xp_order_evaluate_$->{0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_evaluate_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_payment:
            actual-data-nodes: xp0.xp_order_payment_$->{0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_payment_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_reassign:
            actual-data-nodes: xp0.xp_order_reassign_$->{0..9}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_reassign_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_order_inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_$->{app_user_id % 20}
          xp_order_cancel_inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_cancel_$->{order_id % 20}
          xp_order_evaluate_inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_evaluate_$->{order_id % 20}
          xp_order_payment_inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_payment_$->{order_id % 20}
          xp_order_reassign_inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_reassign_$->{order_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE
      single-table:
        default-data-source-name: xp0
    props:
      sql-show: true
      sql-simple: true

seata:
  enabled: false