There was a problem upgrading the version 4.1.1 ~5.x

[asdxiaoqex]

In the old version 4.x, I got the split table rule through datasource, and then modified it with reflection to achieve dynamic capacity expansion.

In the new version5.x, I can't find a place to get the sharingrule. I hope you can prompt where you can reference.

Or there are other APIs that can provide better dynamic capacity expansion table rules. Please give me some guidance.

[TeslaCN]

Hi @asdxiaoqex
You may try getRuleMetaData().findRule(ShardingRule.class).

shardingsphere/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/metadata/rule/ShardingSphereRuleMetaData.java

Lines 94 to 97 in dab914a

	public <T extends ShardingSphereRule> Optional<T> findSingleRule(final Class<T> clazz) {
	Collection<T> foundRules = findRules(clazz);
	return foundRules.isEmpty() ? Optional.empty() : Optional.of(foundRules.iterator().next());
	}

[asdxiaoqex]

Hi @asdxiaoqex You may try getRuleMetaData().findRule(ShardingRule.class).

shardingsphere/shardingsphere-infra/shardingsphere-infra-common/src/main/java/org/apache/shardingsphere/infra/metadata/rule/ShardingSphereRuleMetaData.java

Lines 94 to 97 in dab914a

	public <T extends ShardingSphereRule> Optional<T> findSingleRule(final Class<T> clazz) {
	Collection<T> foundRules = findRules(clazz);
	return foundRules.isEmpty() ? Optional.empty() : Optional.of(foundRules.iterator().next());
	}

is empty

[asdxiaoqex]

我是想获取到 表路由的配置 然后修改他

[asdxiaoqex]

因为我现在是把一些由日期动态创建的路由 也加载进去 因为每天都会 新增新的路由表 旧版本可以通过上面那个shardingRule反射去改，新版 没找到

[github-actions]

Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.

[RaigorJiang]

@asdxiaoqex I think you can refer to #16725, and a better way is to execute DistSQL through Proxy for maintenance.