From 5de4a49148636dce6568d37e4c62039934b0a188 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期三, 22 十月 2025 16:36:34 +0800
Subject: [PATCH] bug修改
---
ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/config/ShardingConfig.java | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 deletions(-)
diff --git a/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/config/ShardingConfig.java b/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/config/ShardingConfig.java
index d763ffe..6e53c56 100644
--- a/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/config/ShardingConfig.java
+++ b/ruoyi-service/ruoyi-study/src/main/java/com/ruoyi/study/config/ShardingConfig.java
@@ -98,12 +98,20 @@
props6.setProperty("algorithm-expression", "t_subject_record$->{userId % 5 + 1}");
result1.getShardingAlgorithms().put("t_subject_record-inline", new AlgorithmConfiguration("INLINE", props6));
result1.getKeyGenerators().put("t_subject_record-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties()));
+
//分片规则配置
result1.getTables().add(getCoursePackageOrderTableRuleConfiguration1());
Properties props7 = new Properties();
props7.setProperty("algorithm-expression", "t_user_present_record$->{user_id % 5 + 1}");
result1.getShardingAlgorithms().put("t_user_present_record-inline", new AlgorithmConfiguration("INLINE", props7));
result1.getKeyGenerators().put("t_user_present_record-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties()));
+
+ //分片规则配置
+ result1.getTables().add(getCoursePackageOrderTableRuleConfiguration2());
+ Properties props8 = new Properties();
+ props8.setProperty("algorithm-expression", "t_subject_record_detail$->{userId % 5 + 1}");
+ result1.getShardingAlgorithms().put("t_subject_record_detail-inline", new AlgorithmConfiguration("INLINE", props8));
+ result1.getKeyGenerators().put("t_subject_record_detail-snowflake", new AlgorithmConfiguration("SNOWFLAKE", new Properties()));
linkedList.add(result1);
return linkedList;
@@ -162,11 +170,18 @@
result.setTableShardingStrategy(new StandardShardingStrategyConfiguration("userId", "t_subject_record-inline"));
result.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "t_subject_record-snowflake"));
return result;
- }private ShardingTableRuleConfiguration getCoursePackageOrderTableRuleConfiguration1() {
+ }
+ private ShardingTableRuleConfiguration getCoursePackageOrderTableRuleConfiguration1() {
ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_user_present_record", "m_$->{0}.t_user_present_record$->{1..5}");//30
result.setTableShardingStrategy(new StandardShardingStrategyConfiguration("user_id", "t_user_present_record-inline"));
result.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "t_user_present_record-snowflake"));
return result;
}
+ private ShardingTableRuleConfiguration getCoursePackageOrderTableRuleConfiguration2() {
+ ShardingTableRuleConfiguration result = new ShardingTableRuleConfiguration("t_subject_record_detail", "m_$->{0}.t_subject_record_detail$->{1..5}");//30
+ result.setTableShardingStrategy(new StandardShardingStrategyConfiguration("userId", "t_subject_record_detail-inline"));
+ result.setKeyGenerateStrategy(new KeyGenerateStrategyConfiguration("id", "t_subject_record_detail-snowflake"));
+ return result;
+ }
}
--
Gitblit v1.7.1