How to abstrct common rule config for sharding-jdbc:5.5.0

[774886347]

I have 50 project module and each of them using sharding-jdbc now, and I have to config all tables for dev,sit,uat,prod env:

spring:
    datasource:
        url: jdbc:shardingsphere:classpath:config/sharding-uat.yaml
        driver-class-name: org.apache.shardingsphere.driver.ShardingSphereDriver
        type: com.alibaba.druid.pool.DruidDataSource
        druid:
            filters: stat
            max-active: 50
            initial-size: 5
            max-wait: 60000
            min-idle: 5
            time-between-eviction-runs-millis: 60000
            min-evictable-idle-time-millis: 300000
            max-evictable-idle-time-millis: 1800000
            filter:
                config:
                    enabled: false
            web-stat-filter:
                enabled: false
            stat-view-servlet:
                enabled: false
            keep-alive: true
            validation-query: select 1
            remove-abandoned: true
            test-while-idle: true
            test-on-borrow: false
            test-on-return: false
            pool-prepared-statements: true
            max-open-prepared-statements: 50
            remove-abandoned-timeout: 300
            log-abandoned: true

Here is the sharding-uat.yaml:

dataSources:
 m1:
   dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
   driverClassName: com.mysql.cj.jdbc.Driver
   url: 
   username: 
   password: 
 m2:
   dataSourceClassName: com.alibaba.druid.pool.DruidDataSource
   driverClassName: com.mysql.cj.jdbc.Driver
   url: 
   username: 
   password: 
rules:
- !SINGLE
 tables:
   - m2.my_table_without_sharding
        ...**<422 items>**
- !SHARDING
 tables: 
   here is the sharding config
 shardingAlgorithms:
   here is the sharding config
 keyGenerators:
   snowflake:
     type: custom_snowflake_id
props:
 sql-show: true

When I adding a new "- !SINGLE" table for sharding, I hava to add this config for 4 environment(dev，sit，uat，prod) and all project modules (50 odules) have to adding these table config, and they are all the same! So how to config common rule config for sharding-jdbc:5.5.0?

[terrymanu]

DistSQL should be used instead of YAML configuration. DistSQL is more flexible and can be generated by the program for batch processing.