fix：修改配置问题

zhuml4

2026-02-26 21dc249bd967da8afac8e3973ceda1c7b07ba57b

fix：修改配置问题

 xp-robotaxi-account-boot/src/main/java/com/xiaopeng/account/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-account-boot/src/main/resources/application-local.properties

@@ -1,8 +1,5 @@
spring.config.activate.on-profile=local
#spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
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
@@ -32,29 +29,22 @@
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_app_user.actual-data-nodes=xp0.xp_app_user_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_app_user.table-strategy.standard.sharding-column=phone_number
spring.shardingsphere.rules.sharding.tables.xp_app_user.table-strategy.standard.sharding-algorithm-name=xp_app_user_inline
spring.shardingsphere.rules.sharding.tables.xp_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.actual-data-nodes=xp0.xp_app_user_coupon_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.actual-data-nodes=xp0.xp_app_user_coupon_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.table-strategy.standard.sharding-algorithm-name=xp_app_user_coupon_inline
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.table-strategy.standard.sharding-algorithm-name=xp-app-user-coupon-inline
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_app_user_coupon.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.actual-data-nodes=xp0.xp_operations_user_notification_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.actual-data-nodes=xp0.xp_operations_user_notification_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.table-strategy.standard.sharding-column=operations_user_id
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.table-strategy.standard.sharding-algorithm-name=xp_operations_user_notification_inline
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.table-strategy.standard.sharding-algorithm-name=xp-operations-user-notification-inline
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_operations_user_notification.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_app_user_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_app_user_inline.props.algorithm-expression=xp_app_user_$->{phone_number % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_app_user_coupon_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_app_user_coupon_inline.props.algorithm-expression=xp_app_user_coupon_$->{app_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_operations_user_notification_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_operations_user_notification_inline.props.algorithm-expression=xp_operations_user_notification_$->{operations_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-app-user-coupon-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-app-user-coupon-inline.props.algorithm-expression=xp_app_user_coupon_${app_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-operations-user-notification-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-operations-user-notification-inline.props.algorithm-expression=xp_operations_user_notification_${operations_user_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
seata.enabled=false

 xp-robotaxi-account-boot/src/main/resources/application-local.yml

@@ -5,11 +5,6 @@
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -48,46 +43,33 @@
    rules:
      sharding:
        tables:
          xp_app_user:
            actual-data-nodes: xp0.xp_app_user_$->{0..9}
            table-strategy:
              standard:
                sharding-column: phone_number
                sharding-algorithm-name: xp_app_user_inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_app_user_coupon:
            actual-data-nodes: xp0.xp_app_user_coupon_$->{0..19}
            actual-data-nodes: xp0.xp_app_user_coupon_${0..19}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_app_user_coupon_inline
                sharding-algorithm-name: xp-app-user-coupon-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_operations_user_notification:
            actual-data-nodes: xp0.xp_operations_user_notification_$->{0..19}
            actual-data-nodes: xp0.xp_operations_user_notification_${0..19}
            table-strategy:
              standard:
                sharding-column: operations_user_id
                sharding-algorithm-name: xp_operations_user_notification_inline
                sharding-algorithm-name: xp-operations-user-notification-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_app_user_inline:
          xp-app-user-coupon-inline:
            type: INLINE
            props:
              algorithm-expression: xp_app_user_$->{phone_number % 10}
          xp_app_user_coupon_inline:
              algorithm-expression: xp_app_user_coupon_${app_user_id % 20}
          xp-operations-user-notification-inline:
            type: INLINE
            props:
              algorithm-expression: xp_app_user_coupon_$->{app_user_id % 20}
          xp_operations_user_notification_inline:
            type: INLINE
            props:
              algorithm-expression: xp_operations_user_notification_$->{operations_user_id % 20}
              algorithm-expression: xp_operations_user_notification_${operations_user_id % 20}
        key-generators:
          snowflake:
            type: SNOWFLAKE

 xp-robotaxi-automatic-pilot-boot/src/main/java/com/xiaopeng/automaticPilot/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-automatic-pilot-boot/src/main/resources/application-local.properties

@@ -1,8 +1,5 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
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
@@ -32,77 +29,76 @@
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..19}
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.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.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.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.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.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.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.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.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.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.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.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

 xp-robotaxi-automatic-pilot-boot/src/main/resources/application-local.yml

@@ -5,11 +5,6 @@
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -49,11 +44,11 @@
      sharding:
        tables:
          xp_charging_record:
            actual-data-nodes: xp0.xp_charging_record_$->{0..19}
            actual-data-nodes: xp0.xp_charging_record_$->{0..9}
            table-strategy:
              standard:
                sharding-column: vehicle_id
                sharding-algorithm-name: xp_charging_record_inline
                sharding-algorithm-name: xp-charging-record-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -62,7 +57,7 @@
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_clock_in_inline
                sharding-algorithm-name: xp-clock-in-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -71,7 +66,7 @@
            table-strategy:
              standard:
                sharding-column: vehicle_id
                sharding-algorithm-name: xp_task_inline
                sharding-algorithm-name: xp-task-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -80,7 +75,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_task_handle_detail_inline
                sharding-algorithm-name: xp-task-handle-detail-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -89,7 +84,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_task_handle_detail_routine_inline
                sharding-algorithm-name: xp-task-handle-detail-routine-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -98,7 +93,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_detection_inline
                sharding-algorithm-name: xp-vehicle-detection-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -107,7 +102,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_preparation_inline
                sharding-algorithm-name: xp-vehicle-preparation-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -116,7 +111,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_repair_inline
                sharding-algorithm-name: xp-vehicle-repair-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -125,7 +120,7 @@
            table-strategy:
              standard:
                sharding-column: feedback_user_phone
                sharding-algorithm-name: xp_work_order_inline
                sharding-algorithm-name: xp-work-order-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -134,51 +129,51 @@
            table-strategy:
              standard:
                sharding-column: work_order_id
                sharding-algorithm-name: xp_work_order_log_inline
                sharding-algorithm-name: xp-work-order-log-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_charging_record_inline:
          xp-charging-record-inline:
            type: INLINE
            props:
              algorithm-expression: xp_charging_record_$->{vehicle_id % 20}
          xp_clock_in_inline:
              algorithm-expression: xp_charging_record_${vehicle_id % 20}
          xp-clock-in-inline:
            type: INLINE
            props:
              algorithm-expression: xp_clock_in_$->{app_user_id % 10}
          xp_task_inline:
              algorithm-expression: xp_clock_in_${app_user_id % 10}
          xp-task-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_$->{vehicle_id % 20}
          xp_task_handle_detail_inline:
              algorithm-expression: xp_task_${vehicle_id % 20}
          xp-task-handle-detail-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_handle_detail_$->{task_id % 20}
          xp_task_handle_detail_routine_inline:
              algorithm-expression: xp_task_handle_detail_${task_id % 20}
          xp-task-handle-detail-routine-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_handle_detail_routine_$->{task_id % 20}
          xp_vehicle_detection_inline:
              algorithm-expression: xp_task_handle_detail_routine_${task_id % 20}
          xp-vehicle-detection-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_detection_$->{task_id % 10}
          xp_vehicle_preparation_inline:
              algorithm-expression: xp_vehicle_detection_${task_id % 10}
          xp-vehicle-preparation-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_preparation_$->{task_id % 10}
          xp_vehicle_repair_inline:
              algorithm-expression: xp_vehicle_preparation_${task_id % 10}
          xp-vehicle-repair-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_repair_$->{task_id % 10}
          xp_work_order_inline:
              algorithm-expression: xp_vehicle_repair_${task_id % 10}
          xp-work-order-inline:
            type: INLINE
            props:
              algorithm-expression: xp_work_order_$->{feedback_user_phone % 10}
          xp_work_order_log_inline:
              algorithm-expression: xp_work_order_${feedback_user_phone % 10}
          xp-work-order-log-inline:
            type: INLINE
            props:
              algorithm-expression: xp_work_order_log_$->{work_order_id % 20}
              algorithm-expression: xp_work_order_log_${work_order_id % 20}
        key-generators:
          snowflake:
            type: SNOWFLAKE

 xp-robotaxi-itinerary-boot/src/main/java/com/xiaopeng/itinerary/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-itinerary-boot/src/main/resources/application-local.properties

@@ -1,8 +1,5 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
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
@@ -32,41 +29,27 @@
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_order.actual-data-nodes=xp0.xp_order_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_order.table-strategy.standard.sharding-algorithm-name=xp_order_inline
spring.shardingsphere.rules.sharding.tables.xp_order.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.actual-data-nodes=xp0.xp_order_cancel_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.table-strategy.standard.sharding-algorithm-name=xp_order_cancel_inline
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.actual-data-nodes=xp0.xp_order_evaluate_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.table-strategy.standard.sharding-algorithm-name=xp_order_evaluate_inline
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_payment.actual-data-nodes=xp0.xp_order_payment_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_payment.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_payment.table-strategy.standard.sharding-algorithm-name=xp_order_payment_inline
spring.shardingsphere.rules.sharding.tables.xp_order_payment.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_payment.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.actual-data-nodes=xp0.xp_order_reassign_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-algorithm-name=xp_order_reassign_inline
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_inline.props.algorithm-expression=xp_order_$->{app_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_cancel_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_cancel_inline.props.algorithm-expression=xp_order_cancel_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_evaluate_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_evaluate_inline.props.algorithm-expression=xp_order_evaluate_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_payment_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_payment_inline.props.algorithm-expression=xp_order_payment_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_reassign_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_reassign_inline.props.algorithm-expression=xp_order_reassign_$->{order_id % 10}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_${0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-column=userId
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys-oper-log-inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.column=oper_id
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp-agreement-app-user-inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=electronic_area_id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp-point-inline
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.props.algorithm-expression=sys_oper_log_${userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.props.algorithm-expression=xp_agreement_app_user_${app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.props.algorithm-expression=xp_point_${electronic_area_id % 10}
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

 xp-robotaxi-itinerary-boot/src/main/resources/application-local.yml

@@ -5,11 +5,6 @@
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -48,72 +43,46 @@
    rules:
      sharding:
        tables:
          xp_order:
            actual-data-nodes: xp0.xp_order_$->{0..19}
          sys_oper_log:
            actual-data-nodes: xp0.sys_oper_log_${0..9}
            table-strategy:
              standard:
                sharding-column: userId
                sharding-algorithm-name: sys-oper-log-inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            actual-data-nodes: xp0.xp_agreement_app_user_${0..9}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_order_inline
                sharding-algorithm-name: xp-agreement-app-user-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_cancel:
            actual-data-nodes: xp0.xp_order_cancel_$->{0..19}
          xp_point:
            actual-data-nodes: xp0.xp_point_${0..9}
            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
                sharding-column: electronic_area_id
                sharding-algorithm-name: xp-point-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_order_inline:
          sys-oper-log-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_$->{app_user_id % 20}
          xp_order_cancel_inline:
              algorithm-expression: sys_oper_log_${userId % 10}
          xp-agreement-app-user-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_cancel_$->{order_id % 20}
          xp_order_evaluate_inline:
              algorithm-expression: xp_agreement_app_user_${app_user_id % 10}
          xp-point-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}
              algorithm-expression: xp_point_${electronic_area_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE

 xp-robotaxi-maintenance-boot/src/main/java/com/xiaopeng/maintenance/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-maintenance-boot/src/main/resources/application-local.yml

@@ -17,11 +17,6 @@
      username: xp_robotaxi
      password: hDXSBe_hs0d5KxUf
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -81,11 +76,11 @@
      sharding:
        tables:
          xp_charging_record:
            actual-data-nodes: xp0.xp_charging_record_$->{0..19}
            actual-data-nodes: xp0.xp_charging_record_$->{0..9}
            table-strategy:
              standard:
                sharding-column: vehicle_id
                sharding-algorithm-name: xp_charging_record_inline
                sharding-algorithm-name: xp-charging-record-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -94,7 +89,7 @@
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_clock_in_inline
                sharding-algorithm-name: xp-clock-in-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -103,7 +98,7 @@
            table-strategy:
              standard:
                sharding-column: vehicle_id
                sharding-algorithm-name: xp_task_inline
                sharding-algorithm-name: xp-task-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -112,7 +107,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_task_handle_detail_inline
                sharding-algorithm-name: xp-task-handle-detail-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -121,7 +116,7 @@
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_task_handle_detail_routine_inline
                sharding-algorithm-name: xp-task-handle-detail-routine-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -129,8 +124,8 @@
            actual-data-nodes: xp0.xp_vehicle_detection_$->{0..9}
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_detection_inline
                sharding-column: vehicle_id
                sharding-algorithm-name: xp-vehicle-detection-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -138,8 +133,8 @@
            actual-data-nodes: xp0.xp_vehicle_preparation_$->{0..9}
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_preparation_inline
                sharding-column: vehicle_id
                sharding-algorithm-name: xp-vehicle-preparation-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -147,8 +142,8 @@
            actual-data-nodes: xp0.xp_vehicle_repair_$->{0..9}
            table-strategy:
              standard:
                sharding-column: task_id
                sharding-algorithm-name: xp_vehicle_repair_inline
                sharding-column: vehicle_id
                sharding-algorithm-name: xp-vehicle-repair-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -157,7 +152,7 @@
            table-strategy:
              standard:
                sharding-column: feedback_user_phone
                sharding-algorithm-name: xp_work_order_inline
                sharding-algorithm-name: xp-work-order-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
@@ -166,51 +161,51 @@
            table-strategy:
              standard:
                sharding-column: work_order_id
                sharding-algorithm-name: xp_work_order_log_inline
                sharding-algorithm-name: xp-work-order-log-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_charging_record_inline:
          xp-charging-record-inline:
            type: INLINE
            props:
              algorithm-expression: xp_charging_record_$->{vehicle_id % 20}
          xp_clock_in_inline:
              algorithm-expression: xp_charging_record_${vehicle_id % 20}
          xp-clock-in-inline:
            type: INLINE
            props:
              algorithm-expression: xp_clock_in_$->{app_user_id % 10}
          xp_task_inline:
              algorithm-expression: xp_clock_in_${app_user_id % 10}
          xp-task-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_$->{vehicle_id % 20}
          xp_task_handle_detail_inline:
              algorithm-expression: xp_task_${vehicle_id % 20}
          xp-task-handle-detail-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_handle_detail_$->{task_id % 20}
          xp_task_handle_detail_routine_inline:
              algorithm-expression: xp_task_handle_detail_${task_id % 20}
          xp-task-handle-detail-routine-inline:
            type: INLINE
            props:
              algorithm-expression: xp_task_handle_detail_routine_$->{task_id % 20}
          xp_vehicle_detection_inline:
              algorithm-expression: xp_task_handle_detail_routine_${task_id % 20}
          xp-vehicle-detection-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_detection_$->{task_id % 10}
          xp_vehicle_preparation_inline:
              algorithm-expression: xp_vehicle_detection_${vehicle_id % 10}
          xp-vehicle-preparation-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_preparation_$->{task_id % 10}
          xp_vehicle_repair_inline:
              algorithm-expression: xp_vehicle_preparation_${vehicle_id % 10}
          xp-vehicle-repair-inline:
            type: INLINE
            props:
              algorithm-expression: xp_vehicle_repair_$->{task_id % 10}
          xp_work_order_inline:
              algorithm-expression: xp_vehicle_repair_${vehicle_id % 10}
          xp-work-order-inline:
            type: INLINE
            props:
              algorithm-expression: xp_work_order_$->{feedback_user_phone % 10}
          xp_work_order_log_inline:
              algorithm-expression: xp_work_order_${feedback_user_phone % 10}
          xp-work-order-log-inline:
            type: INLINE
            props:
              algorithm-expression: xp_work_order_log_$->{work_order_id % 20}
              algorithm-expression: xp_work_order_log_${work_order_id % 20}
        key-generators:
          snowflake:
            type: SNOWFLAKE

 xp-robotaxi-map-boot/src/main/java/com/xiaopeng/map/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-map-boot/src/main/resources/application-local.properties

@@ -1,14 +1,13 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
spring.shardingsphere.props.sql-show=true
spring.shardingsphere.props.sql-simple=true
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_operation?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.url=jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_rt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
spring.shardingsphere.datasource.xp0.username=xp_rt_operation
spring.shardingsphere.datasource.xp0.password=g0Tw2f_KoNlmW21M
spring.shardingsphere.datasource.xp0.druid.initial-size=10
spring.shardingsphere.datasource.xp0.druid.min-idle=10
spring.shardingsphere.datasource.xp0.druid.max-active=100
@@ -32,29 +31,30 @@
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.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_$->{0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_${0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-column=userId
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys_oper_log_inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys-oper-log-inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.column=oper_id
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp_agreement_app_user_inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp-agreement-app-user-inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp_point_inline
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=electronic_area_id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp-point-inline
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.props.algorithm-expression=sys_oper_log_$->{userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.props.algorithm-expression=xp_agreement_app_user_$->{app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.props.algorithm-expression=xp_point_$->{id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.props.algorithm-expression=sys_oper_log_${userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.props.algorithm-expression=xp_agreement_app_user_${app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.props.algorithm-expression=xp_point_${electronic_area_id % 10}
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
swagger.title=????????
swagger.enabled=true
swagger.license=Powered By xiaopeng
swagger.licenseUrl=http://127.0.0.1:5800/doc.html
seata.enabled=false

 xp-robotaxi-map-boot/src/main/resources/application-local.yml

@@ -4,20 +4,19 @@
      on-profile: local
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure

  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    props:
      sql-show: true
      sql-simple: 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_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        url: jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_rt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: xp_rt_operation
        password: g0Tw2f_KoNlmW21M
        druid:
          initial-size: 10
          min-idle: 10
@@ -49,53 +48,56 @@
      sharding:
        tables:
          sys_oper_log:
            actual-data-nodes: xp0.sys_oper_log_$->{0..9}
            actual-data-nodes: xp0.sys_oper_log_${0..9}
            table-strategy:
              standard:
                sharding-column: userId
                sharding-algorithm-name: sys_oper_log_inline
                sharding-algorithm-name: sys-oper-log-inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            actual-data-nodes: xp0.xp_agreement_app_user_$->{0..9}
            actual-data-nodes: xp0.xp_agreement_app_user_${0..9}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_agreement_app_user_inline
                sharding-algorithm-name: xp-agreement-app-user-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            actual-data-nodes: xp0.xp_point_$->{0..9}
            actual-data-nodes: xp0.xp_point_${0..9}
            table-strategy:
              standard:
                sharding-column: id
                sharding-algorithm-name: xp_point_inline
                sharding-column: electronic_area_id
                sharding-algorithm-name: xp-point-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          sys_oper_log_inline:
          sys-oper-log-inline:
            type: INLINE
            props:
              algorithm-expression: sys_oper_log_$->{userId % 10}
          xp_agreement_app_user_inline:
              algorithm-expression: sys_oper_log_${userId % 10}
          xp-agreement-app-user-inline:
            type: INLINE
            props:
              algorithm-expression: xp_agreement_app_user_$->{app_user_id % 10}
          xp_point_inline:
              algorithm-expression: xp_agreement_app_user_${app_user_id % 10}
          xp-point-inline:
            type: INLINE
            props:
              algorithm-expression: xp_point_$->{id % 10}
              algorithm-expression: xp_point_${electronic_area_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE
      single-table:
        default-data-source-name: xp0
    props:
      sql-show: true
      sql-simple: true


# swagger配置
swagger:
  title: 地图模块接口文档
  enabled: true
  license: Powered By xiaopeng
  licenseUrl: http://127.0.0.1:5800/doc.html

seata:
  enabled: false

 xp-robotaxi-operation-boot/src/main/java/com/xiaopeng/operation/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-operation-boot/src/main/resources/application-local.properties

@@ -1,8 +1,5 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
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
@@ -32,30 +29,28 @@
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.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_$->{0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_${0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-column=userId
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys_oper_log_inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys-oper-log-inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.column=oper_id
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp_agreement_app_user_inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp-agreement-app-user-inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp_point_inline
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=electronic_area_id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp-point-inline
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.props.algorithm-expression=sys_oper_log_$->{userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.props.algorithm-expression=xp_agreement_app_user_$->{app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.props.algorithm-expression=xp_point_$->{id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.props.algorithm-expression=sys_oper_log_${userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.props.algorithm-expression=xp_agreement_app_user_${app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.props.algorithm-expression=xp_point_${electronic_area_id % 10}
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
seata.enabled=false

 xp-robotaxi-operation-boot/src/main/resources/application-local.yml

@@ -5,11 +5,6 @@
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -49,50 +44,48 @@
      sharding:
        tables:
          sys_oper_log:
            actual-data-nodes: xp0.sys_oper_log_$->{0..9}
            actual-data-nodes: xp0.sys_oper_log_${0..9}
            table-strategy:
              standard:
                sharding-column: userId
                sharding-algorithm-name: sys_oper_log_inline
                sharding-algorithm-name: sys-oper-log-inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            actual-data-nodes: xp0.xp_agreement_app_user_$->{0..9}
            actual-data-nodes: xp0.xp_agreement_app_user_${0..9}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_agreement_app_user_inline
                sharding-algorithm-name: xp-agreement-app-user-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            actual-data-nodes: xp0.xp_point_$->{0..9}
            actual-data-nodes: xp0.xp_point_${0..9}
            table-strategy:
              standard:
                sharding-column: id
                sharding-algorithm-name: xp_point_inline
                sharding-column: electronic_area_id
                sharding-algorithm-name: xp-point-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          sys_oper_log_inline:
          sys-oper-log-inline:
            type: INLINE
            props:
              algorithm-expression: sys_oper_log_$->{userId % 10}
          xp_agreement_app_user_inline:
              algorithm-expression: sys_oper_log_${userId % 10}
          xp-agreement-app-user-inline:
            type: INLINE
            props:
              algorithm-expression: xp_agreement_app_user_$->{app_user_id % 10}
          xp_point_inline:
              algorithm-expression: xp_agreement_app_user_${app_user_id % 10}
          xp-point-inline:
            type: INLINE
            props:
              algorithm-expression: xp_point_$->{id % 10}
              algorithm-expression: xp_point_${electronic_area_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE
      single-table:
        default-data-source-name: xp0
    props:
      sql-show: true
      sql-simple: true

 xp-robotaxi-order-boot/src/main/java/com/xiaopeng/order/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-order-boot/src/main/resources/application-local.properties

@@ -1,8 +1,5 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
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
@@ -32,42 +29,48 @@
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_order.actual-data-nodes=xp0.xp_order_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order.actual-data-nodes=xp0.xp_order_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_order.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_order.table-strategy.standard.sharding-algorithm-name=xp_order_inline
spring.shardingsphere.rules.sharding.tables.xp_order.table-strategy.standard.sharding-algorithm-name=xp-order-inline
spring.shardingsphere.rules.sharding.tables.xp_order.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.actual-data-nodes=xp0.xp_order_cancel_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.actual-data-nodes=xp0.xp_order_cancel_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.table-strategy.standard.sharding-algorithm-name=xp_order_cancel_inline
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.table-strategy.standard.sharding-algorithm-name=xp-order-cancel-inline
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_cancel.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.actual-data-nodes=xp0.xp_order_evaluate_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_detail.actual-data-nodes=xp0.xp_order_detail_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_detail.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_detail.table-strategy.standard.sharding-algorithm-name=xp-order-detail-inline
spring.shardingsphere.rules.sharding.tables.xp_order_detail.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_detail.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.actual-data-nodes=xp0.xp_order_evaluate_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.table-strategy.standard.sharding-algorithm-name=xp_order_evaluate_inline
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.table-strategy.standard.sharding-algorithm-name=xp-order-evaluate-inline
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_evaluate.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_payment.actual-data-nodes=xp0.xp_order_payment_$->{0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_payment.actual-data-nodes=xp0.xp_order_payment_${0..19}
spring.shardingsphere.rules.sharding.tables.xp_order_payment.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_payment.table-strategy.standard.sharding-algorithm-name=xp_order_payment_inline
spring.shardingsphere.rules.sharding.tables.xp_order_payment.table-strategy.standard.sharding-algorithm-name=xp-order-payment-inline
spring.shardingsphere.rules.sharding.tables.xp_order_payment.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_payment.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.actual-data-nodes=xp0.xp_order_reassign_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-column=order_id
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-algorithm-name=xp_order_reassign_inline
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.actual-data-nodes=xp0.xp_order_reassign_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-column=task_id
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.table-strategy.standard.sharding-algorithm-name=xp-order-reassign-inline
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_order_reassign.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_inline.props.algorithm-expression=xp_order_$->{app_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_cancel_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_cancel_inline.props.algorithm-expression=xp_order_cancel_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_evaluate_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_evaluate_inline.props.algorithm-expression=xp_order_evaluate_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_payment_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_payment_inline.props.algorithm-expression=xp_order_payment_$->{order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_reassign_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_order_reassign_inline.props.algorithm-expression=xp_order_reassign_$->{order_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-inline.props.algorithm-expression=xp_order_${app_user_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-cancel-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-cancel-inline.props.algorithm-expression=xp_order_cancel_${order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-detail-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-detail-inline.props.algorithm-expression=xp_order_detail_${order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-evaluate-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-evaluate-inline.props.algorithm-expression=xp_order_evaluate_${order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-payment-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-payment-inline.props.algorithm-expression=xp_order_payment_${order_id % 20}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-reassign-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-order-reassign-inline.props.algorithm-expression=xp_order_reassign_${task_id % 10}
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

 xp-robotaxi-order-boot/src/main/resources/application-local.yml

@@ -5,11 +5,6 @@
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    datasource:
      names: xp0
      xp0:
@@ -49,71 +44,84 @@
      sharding:
        tables:
          xp_order:
            actual-data-nodes: xp0.xp_order_$->{0..19}
            actual-data-nodes: xp0.xp_order_${0..19}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_order_inline
                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}
            actual-data-nodes: xp0.xp_order_cancel_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_cancel_inline
                sharding-algorithm-name: xp-order-cancel-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_detail:
            actual-data-nodes: xp0.xp_order_detail_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp-order-detail-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_order_evaluate:
            actual-data-nodes: xp0.xp_order_evaluate_$->{0..19}
            actual-data-nodes: xp0.xp_order_evaluate_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_evaluate_inline
                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}
            actual-data-nodes: xp0.xp_order_payment_${0..19}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_payment_inline
                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}
            actual-data-nodes: xp0.xp_order_reassign_${0..9}
            table-strategy:
              standard:
                sharding-column: order_id
                sharding-algorithm-name: xp_order_reassign_inline
                sharding-column: task_id
                sharding-algorithm-name: xp-order-reassign-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          xp_order_inline:
          xp-order-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_$->{app_user_id % 20}
          xp_order_cancel_inline:
              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:
              algorithm-expression: xp_order_cancel_${order_id % 20}
          xp-order-detail-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_evaluate_$->{order_id % 20}
          xp_order_payment_inline:
              algorithm-expression: xp_order_detail_${order_id % 20}
          xp-order-evaluate-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_payment_$->{order_id % 20}
          xp_order_reassign_inline:
              algorithm-expression: xp_order_evaluate_${order_id % 20}
          xp-order-payment-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_reassign_$->{order_id % 10}
              algorithm-expression: xp_order_payment_${order_id % 20}
          xp-order-reassign-inline:
            type: INLINE
            props:
              algorithm-expression: xp_order_reassign_${task_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE

 xp-robotaxi-payment-boot/src/main/java/com/xiaopeng/payment/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-push-message-boot/src/main/java/com/xiaopeng/pushMessage/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-push-message-boot/src/main/resources/application-local.properties

@@ -1,14 +1,13 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
spring.shardingsphere.props.sql.show=true
spring.shardingsphere.props.show-sql=true
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_operation?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.url=jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_rt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
spring.shardingsphere.datasource.xp0.username=xp_rt_operation
spring.shardingsphere.datasource.xp0.password=g0Tw2f_KoNlmW21M
spring.shardingsphere.datasource.xp0.druid.initial-size=10
spring.shardingsphere.datasource.xp0.druid.min-idle=10
spring.shardingsphere.datasource.xp0.druid.max-active=100
@@ -32,30 +31,30 @@
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.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_$->{0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_${0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-column=userId
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys_oper_log_inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys-oper-log-inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.column=oper_id
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp_agreement_app_user_inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp-agreement-app-user-inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp_point_inline
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_${0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=electronic_area_id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp-point-inline
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.props.algorithm-expression=sys_oper_log_$->{userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.props.algorithm-expression=xp_agreement_app_user_$->{app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.props.algorithm-expression=xp_point_$->{id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys-oper-log-inline.props.algorithm-expression=sys_oper_log_${userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-agreement-app-user-inline.props.algorithm-expression=xp_agreement_app_user_${app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp-point-inline.props.algorithm-expression=xp_point_${electronic_area_id % 10}
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
swagger.title=????????
swagger.enabled=true
swagger.license=Powered By xiaopeng
swagger.licenseUrl=http://127.0.0.1:5800/doc.html
seata.enabled=false

 xp-robotaxi-push-message-boot/src/main/resources/application-local.yml

@@ -4,20 +4,19 @@
      on-profile: local
  autoconfigure:
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure

  shardingsphere:
    mode:
      type: Standalone
      repository:
        type: File
      overwrite: true
    props:
      sql.show: true
      show-sql: 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_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: root
        password: 123456
        url: jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_rt_operation?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
        username: xp_rt_operation
        password: g0Tw2f_KoNlmW21M
        druid:
          initial-size: 10
          min-idle: 10
@@ -49,53 +48,56 @@
      sharding:
        tables:
          sys_oper_log:
            actual-data-nodes: xp0.sys_oper_log_$->{0..9}
            actual-data-nodes: xp0.sys_oper_log_${0..9}
            table-strategy:
              standard:
                sharding-column: userId
                sharding-algorithm-name: sys_oper_log_inline
                sharding-algorithm-name: sys-oper-log-inline
            key-generate-strategy:
              column: oper_id
              key-generator-name: snowflake
          xp_agreement_app_user:
            actual-data-nodes: xp0.xp_agreement_app_user_$->{0..9}
            actual-data-nodes: xp0.xp_agreement_app_user_${0..9}
            table-strategy:
              standard:
                sharding-column: app_user_id
                sharding-algorithm-name: xp_agreement_app_user_inline
                sharding-algorithm-name: xp-agreement-app-user-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
          xp_point:
            actual-data-nodes: xp0.xp_point_$->{0..9}
            actual-data-nodes: xp0.xp_point_${0..9}
            table-strategy:
              standard:
                sharding-column: id
                sharding-algorithm-name: xp_point_inline
                sharding-column: electronic_area_id
                sharding-algorithm-name: xp-point-inline
            key-generate-strategy:
              column: id
              key-generator-name: snowflake
        sharding-algorithms:
          sys_oper_log_inline:
          sys-oper-log-inline:
            type: INLINE
            props:
              algorithm-expression: sys_oper_log_$->{userId % 10}
          xp_agreement_app_user_inline:
              algorithm-expression: sys_oper_log_${userId % 10}
          xp-agreement-app-user-inline:
            type: INLINE
            props:
              algorithm-expression: xp_agreement_app_user_$->{app_user_id % 10}
          xp_point_inline:
              algorithm-expression: xp_agreement_app_user_${app_user_id % 10}
          xp-point-inline:
            type: INLINE
            props:
              algorithm-expression: xp_point_$->{id % 10}
              algorithm-expression: xp_point_${electronic_area_id % 10}
        key-generators:
          snowflake:
            type: SNOWFLAKE
      single-table:
        default-data-source-name: xp0
    props:
      sql-show: true
      sql-simple: true


# swagger配置
swagger:
  title: 消息推送接口文档
  enabled: true
  license: Powered By xiaopeng
  licenseUrl: http://127.0.0.1:5800/doc.html

seata:
  enabled: false

 xp-robotaxi-remote-driving-boot/src/main/java/com/xiaopeng/remoteDriving/config/ShardingAlgorithmPropsFixer.java

File was deleted

 xp-robotaxi-vehicle-convoy-boot/src/main/resources/application-local.properties

@@ -1,14 +1,12 @@
spring.config.activate.on-profile=local
spring.autoconfigure.exclude=com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
spring.shardingsphere.mode.type=Standalone
spring.shardingsphere.mode.repository.type=File
spring.shardingsphere.mode.overwrite=true
spring.shardingsphere.props.sql.show=true
spring.shardingsphere.props.show-sql=true
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_operation?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.url=jdbc:mysql://pc-bp1o444934f546768po.rwlb.rds.aliyuncs.com:3306/xp_rt_maintenance?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
spring.shardingsphere.datasource.xp0.username=xp_rt_maintenance
spring.shardingsphere.datasource.xp0.password=gWgoAv_bi02um8sN
spring.shardingsphere.datasource.xp0.druid.initial-size=10
spring.shardingsphere.datasource.xp0.druid.min-idle=10
spring.shardingsphere.datasource.xp0.druid.max-active=100
@@ -32,29 +30,77 @@
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.sys_oper_log.actual-data-nodes=xp0.sys_oper_log_$->{0..9}
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-column=userId
spring.shardingsphere.rules.sharding.tables.sys_oper_log.table-strategy.standard.sharding-algorithm-name=sys_oper_log_inline
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.column=oper_id
spring.shardingsphere.rules.sharding.tables.sys_oper_log.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.actual-data-nodes=xp0.xp_agreement_app_user_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-column=app_user_id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.table-strategy.standard.sharding-algorithm-name=xp_agreement_app_user_inline
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_agreement_app_user.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.tables.xp_point.actual-data-nodes=xp0.xp_point_$->{0..9}
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-column=id
spring.shardingsphere.rules.sharding.tables.xp_point.table-strategy.standard.sharding-algorithm-name=xp_point_inline
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.column=id
spring.shardingsphere.rules.sharding.tables.xp_point.key-generate-strategy.key-generator-name=snowflake
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.sys_oper_log_inline.props.algorithm-expression=sys_oper_log_$->{userId % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_agreement_app_user_inline.props.algorithm-expression=xp_agreement_app_user_$->{app_user_id % 10}
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.type=INLINE
spring.shardingsphere.rules.sharding.sharding-algorithms.xp_point_inline.props.algorithm-expression=xp_point_$->{id % 10}
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
vehicle.control.appId=xp_robotaxi_api
vehicle.control.appSecret=zaOuwp7Nb4rRemhP