Java ColumnMetaData类代码示例

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Test
public void testIterator() throws Exception {
  assertFalse(emptyList.iterator().hasNext());

  Iterator<ColumnMetaData> iterator1 = oneElementList.iterator();
  assertNotNull(iterator1);
  assertTrue(iterator1.hasNext());
  assertEquals(iterator1.next(), oneElementList.get(0));
  assertFalse(iterator1.hasNext());

  Iterator<ColumnMetaData> iterator2 = twoElementList.iterator();
  assertNotNull(iterator2);
  assertTrue(iterator2.hasNext());
  assertEquals(iterator2.next(), twoElementList.get(0));
  assertTrue(iterator2.hasNext());
  assertEquals(iterator2.next(), twoElementList.get(1));
  assertFalse(iterator2.hasNext());
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
public ResultSet getTableTypes() {
    List<ColumnMetaData> tableTypeMeta = new ArrayList<ColumnMetaData>();
    tableTypeMeta.add(ColumnMetaData.dummy(ColumnMetaData.scalar(Types.VARCHAR, "varchar", Rep.STRING), false));
    List<Object[]> data = new ArrayList<Object[]>();
    Object[] row = new Object[1];
    row[0] = "TABLE";
    data.add(row);

    AvaticaResultSet resultSet = null;
    try {
        resultSet = this.conn.getFactory().newResultSet(this.conn.createStatement(), new KylinPrepare.PrepareResult(null, null, new KylinEnumerator<Object[]>(data), ColumnMetaData.struct(tableTypeMeta)), this.conn.getTimeZone());
        KylinConnectionImpl.TROJAN.execute(resultSet);
    } catch (SQLException e) {
        logger.error(e.getLocalizedMessage(), e);
    }

    return resultSet;
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public DataSet<Object[]> query(AvaticaStatement statement, String sql) throws SQLException {
    SQLResponseStub queryRes = null;

    List<StateParam> params = null;
    if (statement instanceof KylinJdbc41PreparedStatement) {
        params = genPrestateStates(statement);
    }

    queryRes = runKylinQuery(sql, params);

    List<ColumnMetaData> metas = genColumnMeta(queryRes);
    List<Object[]> data = genResultData(queryRes, metas);

    return new DataSet<Object[]>(metas, new KylinEnumerator<Object[]>(data));
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public KylinMetaImpl.MetaProject getMetadata(String project) throws ConnectionException {
    List<ColumnMetaData> meta = new ArrayList<ColumnMetaData>();
    for (int i = 0; i < 10; i++) {
        meta.add(ColumnMetaData.dummy(ColumnMetaData.scalar(Types.VARCHAR, "varchar", Rep.STRING), true));
    }

    List<KylinMetaImpl.MetaTable> tables = new ArrayList<KylinMetaImpl.MetaTable>();
    KylinMetaImpl.MetaTable table = new KylinMetaImpl.MetaTable("dummy", "dummy", "dummy", "dummy", "dummy", "dummy", "dummy", "dummy", "dummy", "dummy", new ArrayList<KylinMetaImpl.MetaColumn>());
    tables.add(table);

    List<KylinMetaImpl.MetaSchema> schemas = new ArrayList<KylinMetaImpl.MetaSchema>();
    schemas.add(new KylinMetaImpl.MetaSchema("dummy", "dummy", tables));
    List<KylinMetaImpl.MetaCatalog> catalogs = new ArrayList<KylinMetaImpl.MetaCatalog>();
    catalogs.add(new KylinMetaImpl.MetaCatalog("dummy", schemas));

    return new KylinMetaImpl.MetaProject(null, catalogs);
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
/**
 * Gets AvaticaType carrying both JDBC {@code java.sql.Type.*} type code
 * and SQL type name for given RPC-level type (from batch schema).
 */
private static AvaticaType getAvaticaType( MajorType rpcDateType ) {
  final String sqlTypeName = Types.getSqlTypeName( rpcDateType );
  final int jdbcTypeId = Types.getJdbcTypeCode( rpcDateType );
  return ColumnMetaData.scalar( jdbcTypeId, sqlTypeName,
                                Rep.BOOLEAN /* dummy value, unused */ );
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Test
public void testToArrayWithParam() throws Exception {
  ColumnMetaData[] colArray0 = emptyList.toArray(new ColumnMetaData[] {});
  assertEquals(0, colArray0.length);
  ColumnMetaData[] colArray1 = oneElementList.toArray(new ColumnMetaData[] {});
  assertEquals(1, colArray1.length);
  ColumnMetaData[] colArray2 = twoElementList.toArray(new ColumnMetaData[] {});
  assertEquals(2, colArray2.length);
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
public PrepareResult(String sql, List<AvaticaParameter> parameterList, Enumerator<Object[]> enumerator, ColumnMetaData.StructType structType) {
    super();
    this.sql = sql;
    this.parameterList = parameterList;
    this.enumerator = enumerator;
    this.structType = structType;
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
private ResultSet mockEmptyResultSet() {
    AvaticaResultSet resultSet = null;
    try {
        List<ColumnMetaData> columnMetas = new ArrayList<ColumnMetaData>();
        List<Object[]> data = new ArrayList<Object[]>();
        resultSet = this.conn.getFactory().newResultSet(this.conn.createStatement(), new KylinPrepare.PrepareResult(null, null, new KylinEnumerator<Object[]>(data), ColumnMetaData.struct(columnMetas)), this.conn.getTimeZone());
        KylinConnectionImpl.TROJAN.execute(resultSet);
    } catch (SQLException e) {
        logger.error(e.getLocalizedMessage(), e);
    }

    return resultSet;
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
public AvaticaPrepareResult prepare(AvaticaStatement statement, String sql) {
    RemoteClient client = factory.newRemoteClient(conn);
    DataSet<Object[]> result = null;

    try {
        result = (DataSet<Object[]>) client.query(statement, sql);
    } catch (Exception e) {
        logger.error(e.getLocalizedMessage(), e);
        throw new RuntimeException("Failed to query kylin server with exception " + e.getLocalizedMessage());
    }

    return new KylinPrepare.PrepareResult(sql, null, (Enumerator<Object[]>) result.getEnumerator(), ColumnMetaData.struct(result.getMeta()));
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public PrepareResult prepare(String sql) {
    List<AvaticaParameter> aps = new ArrayList<AvaticaParameter>();

    int startIndex = 0;
    while (sql.indexOf("?", startIndex) >= 0) {
        AvaticaParameter ap = new AvaticaParameter(false, 0, 0, 0, null, null, null);
        aps.add(ap);
        startIndex = sql.indexOf("?", startIndex) + 1;
    }

    return new KylinPrepare.PrepareResult(sql, aps, null, ColumnMetaData.struct(new ArrayList<ColumnMetaData>()));
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
/**
 * @param queryRes
 * @param metas
 * @return
 */
private List<Object[]> genResultData(SQLResponseStub queryRes, List<ColumnMetaData> metas) {
    List<Object[]> data = new ArrayList<Object[]>();
    for (String[] result : queryRes.getResults()) {
        Object[] row = new Object[result.length];

        for (int i = 0; i < result.length; i++) {
            ColumnMetaData meta = metas.get(i);
            row[i] = SQLTypeMap.wrapObject(result[i], meta.type.type);
        }

        data.add(row);
    }
    return data;
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
/**
 * @param queryRes
 * @return
 */
private List<ColumnMetaData> genColumnMeta(SQLResponseStub queryRes) {
    List<ColumnMetaData> metas = new ArrayList<ColumnMetaData>();
    for (int i = 0; i < queryRes.getColumnMetas().size(); i++) {
        SQLResponseStub.ColumnMetaStub scm = queryRes.getColumnMetas().get(i);
        ScalarType type = ColumnMetaData.scalar(scm.getColumnType(), scm.getColumnTypeName(), Rep.of(SQLTypeMap.convert(scm.getColumnType())));

        ColumnMetaData meta = new ColumnMetaData(i, scm.isAutoIncrement(), scm.isCaseSensitive(), scm.isSearchable(), scm.isCurrency(), scm.getIsNullable(), scm.isSigned(), scm.getDisplaySize(), scm.getLabel(), scm.getName(), scm.getSchemaName(), scm.getPrecision(), scm.getScale(), scm.getTableName(), scm.getSchemaName(), type, scm.isReadOnly(), scm.isWritable(), scm.isWritable(), null);

        metas.add(meta);
    }

    return metas;
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public DataSet<Object[]> query(AvaticaStatement statement, String sql) {
    List<Object[]> data = new ArrayList<Object[]>();
    Object[] row = new Object[] { "foo", "bar", "tool" };
    data.add(row);
    Enumerator<Object[]> enumerator = new KylinEnumerator<Object[]>(data);
    List<ColumnMetaData> meta = new ArrayList<ColumnMetaData>();
    meta.add(ColumnMetaData.dummy(ColumnMetaData.scalar(Types.VARCHAR, "varchar", Rep.STRING), true));
    meta.add(ColumnMetaData.dummy(ColumnMetaData.scalar(Types.VARCHAR, "varchar", Rep.STRING), true));
    meta.add(ColumnMetaData.dummy(ColumnMetaData.scalar(Types.VARCHAR, "varchar", Rep.STRING), true));

    return new DataSet<Object[]>(meta, enumerator);
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public List<ColumnMetaData> getColumnList() {
	System.err.println("GetColList");
	int i = 1;
	return ImmutableList.of( new ColumnMetaData( //
				i, // ordinal
				false, // autoIncrement
				true, // caseSensitive
				false, // searchable
				false, // currency
				ResultSetMetaData.columnNoNulls, //nullability
				false, // signed
				10, // display size.
				"test1", // label
				"test2", // columnname
				"test3", // schemaname
				0, // precision
				0, // scale
				"test3.1", // tablename is null so sqlline doesn't try to retrieve primary keys.
				"test4", // catalogname
				Rep.LONG.ordinal(),  // sql type
				"test5", // typename
				true, // readonly
				false, // writable
				false, // definitely writable
				"none", // column class name
				ColumnMetaData.Rep.BOOLEAN // Dummy value for representation as it doesn't apply in drill's case.
				));
}
 

import net.hydromatic.avatica.ColumnMetaData; //导入依赖的package包/类
@Override
public ColumnMetaData get(int index) {
  return columns.get(index);
}