dataSources:
  vbdsm_2023: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:13306/vbdsm_2023?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_2024: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:13306/vbdsm_2024?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_sysbase: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:13306/vbdsm_sysbase?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm_powergov: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:13306/vbdsm_powergov?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
    maxOpenPreparedStatements: 100
  vbdsm: !!com.alibaba.druid.pool.DruidDataSource
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://47.112.30.247:13306/vbdsm?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false
    username: root
    password: 123456
    filters: stat
    maxActive: 30
    initialSize: 5
    minIdle: 10
    maxWait: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    poolPreparedStatements: true
shardingRule:
  tables:
    t_online_warn:
      actualDataNodes: vbdsm_${2023..2024}.t_online_warn
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    t_sys_settings:
      actualDataNodes: vbdsm_sysbase.t_sys_settings
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_direct_transaction:
      actualDataNodes: vbdsm_powergov.t_direct_transaction
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_sys_industry:
      actualDataNodes: vbdsm_sysbase.t_sys_industry
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_city:
      actualDataNodes: vbdsm_sysbase.t_city
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_product_output:
      actualDataNodes: vbdsm_powergov.t_product_output
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_site:
      actualDataNodes: vbdsm_sysbase.t_site
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_org:
      actualDataNodes: vbdsm_sysbase.t_org
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_poweruser:
      actualDataNodes: vbdsm_sysbase.t_poweruser
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_company_online:
      actualDataNodes: vbdsm_powergov.t_company_online
      databaseStrategy:
        none:
      tableStrategy:
        none:
    sys_dictionary:
      actualDataNodes: vbdsm_sysbase.sys_dictionary
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_online_warn_handle_result:
      actualDataNodes: vbdsm_sysbase.t_online_warn_handle_result
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_sys_basecode:
      actualDataNodes: vbdsm_sysbase.t_sys_basecode
    real_time_alarm_params:
      actualDataNodes: vbdsm_sysbase.real_time_alarm_params
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_online_data_power:
      actualDataNodes: vbdsm_${2023..2024}.t_online_data_power_0${1..9},vbdsm_${2023..2024}.t_online_data_power_${10..12}
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseTableShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeTableShardingAlgorithm
    online_data_water:
      actualDataNodes: vbdsm_${2023..2024}.online_data_water_0${1..9},vbdsm_${2023..2024}.online_data_water_${10..12}
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseTableShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeTableShardingAlgorithm
    t_industry_product:
      actualDataNodes: vbdsm_powergov.t_industry_product
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_price:
      actualDataNodes: vbdsm_powergov.t_industry_price
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_date:
      actualDataNodes: vbdsm_powergov.t_industry_date
      databaseStrategy:
        none:
      tableStrategy:
        none:
    t_industry_month:
      actualDataNodes: vbdsm_powergov.t_industry_month
      databaseStrategy:
        none:
      tableStrategy:
        none:
    analysis_output_date:
      actualDataNodes: vbdsm_${2023..2024}.analysis_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_output_month:
      actualDataNodes: vbdsm_${2023..2024}.analysis_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.analysis_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    analysis_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.analysis_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_output_date:
      actualDataNodes: vbdsm_${2023..2024}.company_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_output_month:
      actualDataNodes: vbdsm_${2023..2024}.company_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.company_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    company_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.company_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_output_date:
      actualDataNodes: vbdsm_${2023..2024}.parks_output_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_output_month:
      actualDataNodes: vbdsm_${2023..2024}.parks_output_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_yield_date:
      actualDataNodes: vbdsm_${2023..2024}.parks_yield_date
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    parks_yield_month:
      actualDataNodes: vbdsm_${2023..2024}.parks_yield_month
      databaseStrategy:
        standard:
          shardingColumn: upload_date
          preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
          rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
      tableStrategy:
        none:
    t_monitor:
      actualDataNodes: vbdsm.t_monitor
      databaseStrategy:
        none:
      tableStrategy:
        none:
    area_increasing_speed:
      actualDataNodes: vbdsm_sysbase.area_increasing_speed
      databaseStrategy:
        standard:
        none:
      tableStrategy:
        none:
    t_sys_product:
      actualDataNodes: vbdsm_sysbase.t_sys_product
      databaseStrategy:
        standard:
        none:
      tableStrategy:
        none:
    industry_increasing_speed:
      actualDataNodes: vbdsm_sysbase.industry_increasing_speed
      databaseStrategy:
        standard:
        none:
      tableStrategy:
        none:
    t_province_date_info:
      actualDataNodes: vbdsm_powergov.t_province_date_info
      databaseStrategy:
        standard:
        none:
      tableStrategy:
        none:
    t_province_generating_capacity:
      actualDataNodes: vbdsm_powergov.t_province_generating_capacity
  defaultDatabaseStrategy:
    standard:
      shardingColumn: upload_date
      preciseAlgorithmClassName: cn.vbdsm.db.sharding.PreciseDatabaseShardingAlgorithm
      rangeAlgorithmClassName: cn.vbdsm.db.sharding.RangeDatabaseShardingAlgorithm
  defaultTableStrategy:
    none:
  props:
    sql.show: true