[GitHub] [shardingsphere] lmhmhl commented on pull request #9249: Test encrypt rule, replicaQuery rule and sharding rule all exist when do query in calcite.

[GitBox <gi...@apache.org>]

lmhmhl commented on pull request #9249:
URL: https://github.com/apache/shardingsphere/pull/9249#issuecomment-773729643


   @tristaZero 
   I have to say to there do exist some problems in my test, the datasource is created by `YamlShardingSphereDataSourceFactory` using yml file, in order to create two connections to different database instances to build different table structures, I separately get connections from `dataSourceMap` using database name. But the yml configuration are not work on these two sub connection, so I can only construct the sharding data all by myself, and the encrypt or replica query are not easy to test. Basically, I have to figure out why yml configuration are not work on sub connection fetched by `dataSourceMap`. Should I create two yml file or two datasources, and I have tried a lot but all failed, so this PR is  just a compromise, I am in confused now, I would be very glad if u can give me some advices. 
   ```java
       @Before
       public void initTable() {
           try {
               ShardingSphereConnection conn = dataSource.getConnection();
               Map<String, DataSource> dataSourceMap = conn.getDataSourceMap();
               Connection database0 = dataSourceMap.get("calcite_jdbc_0").getConnection();
               Connection database1 = dataSourceMap.get("calcite_jdbc_1").getConnection();
               RunScript.execute(database0, new InputStreamReader(Objects.requireNonNull(AbstractSQLTest.class.getClassLoader().getResourceAsStream("sql/calcite_data_0.sql"))));
               RunScript.execute(database1, new InputStreamReader(Objects.requireNonNull(AbstractSQLTest.class.getClassLoader().getResourceAsStream("sql/calcite_data_1.sql"))));
               conn.close();
           } catch (final SQLException ex) {
               throw new RuntimeException(ex);
           }
       }
   ```


----------------------------------------------------------------
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.

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