Search in sources :

Example 6 with MycatRelDataType

use of io.mycat.beans.mycat.MycatRelDataType in project Mycat2 by MyCATApache.

the class DatasourcePoolTest method main.

@SneakyThrows
public static void main(String[] args) {
    DatasourceConfig datasourceConfig = new DatasourceConfig();
    datasourceConfig.setDbType("mysql");
    datasourceConfig.setUser("root");
    datasourceConfig.setPassword("123456");
    datasourceConfig.setName("prototypeDs");
    datasourceConfig.setUrl("jdbc:mysql://localhost:3307/mysql");
    datasourceConfig.setMaxCon(10);
    Map<String, DatasourceConfig> datasources = Maps.of("prototypeDs", datasourceConfig);
    MetaClusterCurrent.register(JdbcConnectionManager.class, new JdbcConnectionManager(datasources, new DruidDatasourceProvider()));
    MetaClusterCurrent.register(IOExecutor.class, IOExecutor.DEFAULT);
    MycatDatasourcePool jdbcDs = new JdbcDatasourcePoolImpl("prototypeDs");
    NewMycatConnection newMycatConnection = jdbcDs.getConnection().toCompletionStage().toCompletableFuture().get();
    Observable<VectorSchemaRoot> observable = newMycatConnection.prepareQuery("select 1", Collections.emptyList(), new RootAllocator());
    List<VectorSchemaRoot> vectorSchemaRoots = observable.toList().blockingGet();
    System.out.println();
    // ///////////////////////////////////////////////////////////////////////////////////////////////////////////
    MycatDatasourcePool nativeDs = new VertxMySQLDatasourcePoolImpl(datasourceConfig, "prototypeDs");
    MycatRelDataType sqlMycatRelType = getSqlMycatRelDataType();
    TestResult testResult = getTestResult(jdbcDs);
    TestResult testResult2 = getTestResult(nativeDs);
    // List<String> collect = newMycatConnection.prepareQuery(querySql, Collections.emptyList()).toList().blockingGet().stream().map(i -> i.toString()).collect(Collectors.toList());
    MycatRowMetaData mycatRowMetaData1 = testResult.queryResult.getMycatRowMetaData();
    MycatRowMetaData mycatRowMetaData2 = testResult2.queryResult.getMycatRowMetaData();
    MycatRelDataType mycatRelDataType1 = mycatRowMetaData1.getMycatRelDataType();
    MycatRelDataType mycatRelDataType2 = mycatRowMetaData2.getMycatRelDataType();
    System.out.println(mycatRelDataType1);
    System.out.println(mycatRelDataType2);
    System.out.println("=====================================================================================================");
    boolean equals = mycatRelDataType1.equals(mycatRelDataType2);
    // Assert.assertTrue(equals);
    equals = mycatRelDataType1.equals(sqlMycatRelType);
    System.out.println(sqlMycatRelType);
    System.out.println(mycatRelDataType1);
    observable = newMycatConnection.prepareQuery("select * from testSchema.testColumnTable", Collections.emptyList(), new RootAllocator());
    vectorSchemaRoots = observable.toList().blockingGet();
    System.out.println();
}
Also used : VectorSchemaRoot(org.apache.arrow.vector.VectorSchemaRoot) MycatDatasourcePool(io.mycat.commands.MycatDatasourcePool) NewMycatConnection(io.mycat.newquery.NewMycatConnection) MycatRelDataType(io.mycat.beans.mycat.MycatRelDataType) ToString(lombok.ToString) DruidDatasourceProvider(io.mycat.datasource.jdbc.DruidDatasourceProvider) DatasourceConfig(io.mycat.config.DatasourceConfig) JdbcDatasourcePoolImpl(io.mycat.commands.JdbcDatasourcePoolImpl) VertxMySQLDatasourcePoolImpl(io.mycat.commands.VertxMySQLDatasourcePoolImpl) JdbcConnectionManager(io.mycat.datasource.jdbc.datasource.JdbcConnectionManager) MycatRowMetaData(io.mycat.beans.mycat.MycatRowMetaData) SneakyThrows(lombok.SneakyThrows)

Aggregations

MycatRelDataType (io.mycat.beans.mycat.MycatRelDataType)6 TableHandler (io.mycat.TableHandler)3 MycatLogicTable (io.mycat.calcite.table.MycatLogicTable)3 Schema (org.apache.arrow.vector.types.pojo.Schema)3 ImmutableList (com.google.common.collect.ImmutableList)2 FactoryUtil.toArrowSchema (io.ordinate.engine.factory.FactoryUtil.toArrowSchema)2 ToString (lombok.ToString)2 RelOptTable (org.apache.calcite.plan.RelOptTable)2 MySqlCreateTableStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlCreateTableStatement)1 MetadataManager (io.mycat.MetadataManager)1 MycatField (io.mycat.beans.mycat.MycatField)1 MycatRowMetaData (io.mycat.beans.mycat.MycatRowMetaData)1 AbstractMycatTable (io.mycat.calcite.table.AbstractMycatTable)1 JdbcDatasourcePoolImpl (io.mycat.commands.JdbcDatasourcePoolImpl)1 MycatDatasourcePool (io.mycat.commands.MycatDatasourcePool)1 VertxMySQLDatasourcePoolImpl (io.mycat.commands.VertxMySQLDatasourcePoolImpl)1 DatasourceConfig (io.mycat.config.DatasourceConfig)1 DruidDatasourceProvider (io.mycat.datasource.jdbc.DruidDatasourceProvider)1 JdbcConnectionManager (io.mycat.datasource.jdbc.datasource.JdbcConnectionManager)1 NewMycatConnection (io.mycat.newquery.NewMycatConnection)1