spring.config.activate.on-profile=local
|
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
|
spring.shardingsphere.datasource.names=xp0
|
spring.shardingsphere.datasource.xp0.type=com.alibaba.druid.pool.DruidDataSource
|
spring.shardingsphere.datasource.xp0.driver-class-name=com.mysql.cj.jdbc.Driver
|
spring.shardingsphere.datasource.xp0.url=jdbc:mysql://192.168.110.34:3306/xprt_maintenance?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
|
spring.shardingsphere.datasource.xp0.username=root
|
spring.shardingsphere.datasource.xp0.password=123456
|
spring.shardingsphere.datasource.xp0.druid.initial-size=10
|
spring.shardingsphere.datasource.xp0.druid.min-idle=10
|
spring.shardingsphere.datasource.xp0.druid.max-active=100
|
spring.shardingsphere.datasource.xp0.druid.max-wait=60000
|
spring.shardingsphere.datasource.xp0.druid.time-between-eviction-runs-millis=60000
|
spring.shardingsphere.datasource.xp0.druid.min-evictable-idle-time-millis=300000
|
spring.shardingsphere.datasource.xp0.druid.validation-query=SELECT 1
|
spring.shardingsphere.datasource.xp0.druid.test-while-idle=true
|
spring.shardingsphere.datasource.xp0.druid.test-on-borrow=false
|
spring.shardingsphere.datasource.xp0.druid.test-on-return=false
|
spring.shardingsphere.datasource.xp0.druid.pool-prepared-statements=true
|
spring.shardingsphere.datasource.xp0.druid.max-pool-prepared-statement-per-connection-size=20
|
spring.shardingsphere.datasource.xp0.druid.filters=stat,wall,log4j
|
spring.shardingsphere.datasource.xp0.druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
|
spring.shardingsphere.datasource.xp0.druid.remove-abandoned=true
|
spring.shardingsphere.datasource.xp0.druid.remove-abandoned-timeout=1800
|
spring.shardingsphere.datasource.xp0.druid.log-abandoned=true
|
spring.shardingsphere.datasource.xp0.druid.stat-view-servlet.enabled=true
|
spring.shardingsphere.datasource.xp0.druid.stat-view-servlet.url-pattern=/druid/*
|
spring.shardingsphere.datasource.xp0.druid.stat-view-servlet.login-username=admin
|
spring.shardingsphere.datasource.xp0.druid.stat-view-servlet.login-password=admin
|
spring.shardingsphere.datasource.xp0.druid.stat-view-servlet.reset-enable=false
|
spring.shardingsphere.datasource.xp0.druid.wall.config.multi-statement-allow=false
|
spring.shardingsphere.rules.sharding.tables.xp_charging_record.actual-data-nodes=xp0.xp_charging_record_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_charging_record.table-strategy.standard.sharding-column=vehicle_id
|
spring.shardingsphere.rules.sharding.tables.xp_charging_record.table-strategy.standard.sharding-algorithm-name=xp-charging-record-inline
|
spring.shardingsphere.rules.sharding.tables.xp_charging_record.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_charging_record.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_clock_in.actual-data-nodes=xp0.xp_clock_in_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_clock_in.table-strategy.standard.sharding-column=app_user_id
|
spring.shardingsphere.rules.sharding.tables.xp_clock_in.table-strategy.standard.sharding-algorithm-name=xp-clock-in-inline
|
spring.shardingsphere.rules.sharding.tables.xp_clock_in.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_clock_in.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_task.actual-data-nodes=xp0.xp_task_$->{0..19}
|
spring.shardingsphere.rules.sharding.tables.xp_task.table-strategy.standard.sharding-column=vehicle_id
|
spring.shardingsphere.rules.sharding.tables.xp_task.table-strategy.standard.sharding-algorithm-name=xp-task-inline
|
spring.shardingsphere.rules.sharding.tables.xp_task.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_task.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail.actual-data-nodes=xp0.xp_task_handle_detail_$->{0..19}
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail.table-strategy.standard.sharding-column=task_id
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail.table-strategy.standard.sharding-algorithm-name=xp-task-handle-detail-inline
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail_routine.actual-data-nodes=xp0.xp_task_handle_detail_routine_$->{0..19}
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail_routine.table-strategy.standard.sharding-column=task_id
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail_routine.table-strategy.standard.sharding-algorithm-name=xp-task-handle-detail-routine-inline
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail_routine.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_task_handle_detail_routine.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_detection.actual-data-nodes=xp0.xp_vehicle_detection_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_detection.table-strategy.standard.sharding-column=task_id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_detection.table-strategy.standard.sharding-algorithm-name=xp-vehicle-detection-inline
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_detection.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_detection.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_preparation.actual-data-nodes=xp0.xp_vehicle_preparation_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_preparation.table-strategy.standard.sharding-column=task_id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_preparation.table-strategy.standard.sharding-algorithm-name=xp-vehicle-preparation-inline
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_preparation.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_preparation.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_repair.actual-data-nodes=xp0.xp_vehicle_repair_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_repair.table-strategy.standard.sharding-column=task_id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_repair.table-strategy.standard.sharding-algorithm-name=xp-vehicle-repair-inline
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_repair.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_vehicle_repair.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_work_order.actual-data-nodes=xp0.xp_work_order_$->{0..9}
|
spring.shardingsphere.rules.sharding.tables.xp_work_order.table-strategy.standard.sharding-column=feedback_user_phone
|
spring.shardingsphere.rules.sharding.tables.xp_work_order.table-strategy.standard.sharding-algorithm-name=xp-work-order-inline
|
spring.shardingsphere.rules.sharding.tables.xp_work_order.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_work_order.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.tables.xp_work_order_log.actual-data-nodes=xp0.xp_work_order_log_$->{0..19}
|
spring.shardingsphere.rules.sharding.tables.xp_work_order_log.table-strategy.standard.sharding-column=work_order_id
|
spring.shardingsphere.rules.sharding.tables.xp_work_order_log.table-strategy.standard.sharding-algorithm-name=xp-work-order-log-inline
|
spring.shardingsphere.rules.sharding.tables.xp_work_order_log.key-generate-strategy.column=id
|
spring.shardingsphere.rules.sharding.tables.xp_work_order_log.key-generate-strategy.key-generator-name=snowflake
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-charging-record-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-charging-record-inline.props.algorithm-expression=xp_charging_record_${vehicle_id % 20}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-clock-in-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-clock-in-inline.props.algorithm-expression=xp_clock_in_${app_user_id % 10}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-inline.props.algorithm-expression=xp_task_${vehicle_id % 20}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-handle-detail-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-handle-detail-inline.props.algorithm-expression=xp_task_handle_detail_${task_id % 20}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-handle-detail-routine-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-task-handle-detail-routine-inline.props.algorithm-expression=xp_task_handle_detail_routine_${task_id % 20}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-detection-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-detection-inline.props.algorithm-expression=xp_vehicle_detection_${task_id % 10}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-preparation-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-preparation-inline.props.algorithm-expression=xp_vehicle_preparation_${task_id % 10}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-repair-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-vehicle-repair-inline.props.algorithm-expression=xp_vehicle_repair_${task_id % 10}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-work-order-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-work-order-inline.props.algorithm-expression=xp_work_order_${feedback_user_phone % 10}
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-work-order-log-inline.type=INLINE
|
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-work-order-log-inline.props.algorithm-expression=xp_work_order_log_${work_order_id % 20}
|
spring.shardingsphere.rules.sharding.key-generators.snowflake.type=SNOWFLAKE
|
spring.shardingsphere.rules.single-table.default-data-source-name=xp0
|
spring.shardingsphere.props.sql-show=true
|
spring.shardingsphere.props.sql-simple=true
|
seata.enabled=false
|
