You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "netyjq (via GitHub)" <gi...@apache.org> on 2023/06/22 13:42:19 UTC

[GitHub] [shardingsphere] netyjq opened a new issue, #26502: how to config multiple same structure tables for using same encrypt rule ?

netyjq opened a new issue, #26502:
URL: https://github.com/apache/shardingsphere/issues/26502

   I have a table here that automatically generates a new table per day by date, I now want to configure the same encryption rules for these tables, I tested using the wildcard *, but it doesn't work。
   
   tables for example sms_record_20230601, sms_record_20230602,sms_record_20230603,...sms_record_20230630,
   
   i have try this: 
   
   ```java
   EncryptColumnRuleConfiguration columnConfig2 = new EncryptColumnRuleConfiguration("dest_number", "dest_number_cipher", "", "aes");
               EncryptColumnRuleConfiguration columnConfig3 = new EncryptColumnRuleConfiguration("content", "content_cipher", "", "aes");
   
               Map<String, EncryptColumnRuleConfiguration> columnConfigMaps = new HashMap<>();
               columnConfigMaps.put("dest_number", columnConfig2);
               columnConfigMaps.put("content", columnConfig3);
               EncryptTableRuleConfiguration tableConfig = new EncryptTableRuleConfiguration(columnConfigMaps);
               encryptRuleConfig.getTables().put("sms_record*", tableConfig);
   ```
   
   I've read the documentation and searched Google, but I still don't have an answer, need help , thanks!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on issue #26502: how to config multiple same structure tables for using same encrypt rule ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #26502:
URL: https://github.com/apache/shardingsphere/issues/26502#issuecomment-1604470710

   @netyjq 
   Are these sharding tables? If yes, just create encrypt rule for logical table in sharding.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang closed issue #26502: how to config multiple same structure tables for using same encrypt rule ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #26502: how to config multiple same structure tables for using same encrypt rule ?
URL: https://github.com/apache/shardingsphere/issues/26502


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] netyjq commented on issue #26502: how to config multiple same structure tables for using same encrypt rule ?

Posted by "netyjq (via GitHub)" <gi...@apache.org>.
netyjq commented on issue #26502:
URL: https://github.com/apache/shardingsphere/issues/26502#issuecomment-1606845214

   > @netyjq Are these sharding tables? If yes, just create encrypt rule for logical table in sharding.
   
   No,  sharding features are not used yet.   for now, I can only write configuration table rules in the for loop in my code, right?
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] RaigorJiang commented on issue #26502: how to config multiple same structure tables for using same encrypt rule ?

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #26502:
URL: https://github.com/apache/shardingsphere/issues/26502#issuecomment-1612549978

   > > @netyjq Are these sharding tables? If yes, just create encrypt rule for logical table in sharding.
   > 
   > No, sharding features are not used yet. for now, I can only write configuration table rules in the for loop in my code, right?
   
   @netyjq , You are right, we should add config for each table.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org