Java Table.getColumnByName方法代码示例

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public Column[] convertToColumns(final String schemaName, final String tableName, final String[] columnNames) {
    if (columnNames == null) {
        return null;
    }

    if (columnNames.length == 0) {
        return new Column[0];
    }

    final Table table = convertToTable(schemaName, tableName);

    final Column[] columns = new Column[columnNames.length];
    for (int i = 0; i < columns.length; i++) {
        columns[i] = table.getColumnByName(columnNames[i]);
    }

    return columns;
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public Column resolveForeignColumn(final DatastoreCatalog datastoreCatalog) {
    final Datastore datastore = datastoreCatalog.getDatastore(getForeignDatastoreName());
    if (datastore == null) {
        return null;
    }
    try (DatastoreConnection connection = datastore.openConnection()) {
        final DataContext dataContext = connection.getDataContext();
        final Schema schema = dataContext.getSchemaByName(getForeignSchemaName());
        if (schema == null) {
            return null;
        }
        final Table table = schema.getTableByName(getForeignTableName());
        if (table == null) {
            return null;
        }
        return table.getColumnByName(getForeignColumnName());
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testConnectAndExplore() throws Exception {
    final SasDatastore ds = new SasDatastore("my sas ds", new File("src/test/resources/sas"));
    try (DatastoreConnection con = ds.openConnection()) {
        final Schema schema = con.getSchemaNavigator().getDefaultSchema();
        assertEquals("[dummy1, dummy2, pizza]", schema.getTableNames().toString());

        final Table table = schema.getTableByName("pizza");
        assertEquals("[id, mois, prot, fat, ash, sodium, carb, cal, brand]",
                table.getColumnNames().toString());

        final Column col = table.getColumnByName("brand");

        final Query q = con.getDataContext().query().from(table).select(col).orderBy(col).toQuery();
        q.getSelectClause().setDistinct(true);

        final List<Object[]> objectArrays = con.getDataContext().executeQuery(q).toObjectArrays();
        assertEquals(10, objectArrays.size());
        assertEquals("a", objectArrays.get(0)[0]);
        assertEquals("b", objectArrays.get(1)[0]);
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public Column[] convertToColumns(String schemaName, String tableName, String[] columnNames) {
    if (columnNames == null) {
        return null;
    }

    if (columnNames.length == 0) {
        return new Column[0];
    }

    final Table table = convertToTable(schemaName, tableName);

    final Column[] columns = new Column[columnNames.length];
    for (int i = 0; i < columns.length; i++) {
        columns[i] = table.getColumnByName(columnNames[i]);
    }

    return columns;
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public Column resolveForeignColumn(DatastoreCatalog datastoreCatalog) {
    Datastore datastore = datastoreCatalog.getDatastore(getForeignDatastoreName());
    if (datastore == null) {
        return null;
    }
    try (DatastoreConnection connection = datastore.openConnection()) {
        DataContext dataContext = connection.getDataContext();
        Schema schema = dataContext.getSchemaByName(getForeignSchemaName());
        if (schema == null) {
            return null;
        }
        Table table = schema.getTableByName(getForeignTableName());
        if (table == null) {
            return null;
        }
        Column column = table.getColumnByName(getForeignColumnName());
        return column;
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testConnectAndExplore() throws Exception {
    final SasDatastore ds = new SasDatastore("my sas ds", new File("src/test/resources/sas"));
    try (final DatastoreConnection con = ds.openConnection()) {
        Schema schema = con.getSchemaNavigator().getDefaultSchema();
        assertEquals("[dummy1, dummy2, pizza]", Arrays.toString(schema.getTableNames()));

        Table table = schema.getTableByName("pizza");
        assertEquals("[id, mois, prot, fat, ash, sodium, carb, cal, brand]",
                Arrays.toString(table.getColumnNames()));

        Column col = table.getColumnByName("brand");

        Query q = con.getDataContext().query().from(table).select(col).orderBy(col).toQuery();
        q.getSelectClause().setDistinct(true);

        List<Object[]> objectArrays = con.getDataContext().executeQuery(q).toObjectArrays();
        assertEquals(10, objectArrays.size());
        assertEquals("a", objectArrays.get(0)[0]);
        assertEquals("b", objectArrays.get(1)[0]);
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
private void setWhere(WhereClauseBuilder<?> whereBuilder, Table table, List<WhereCondition> conditions) {
    for (WhereCondition condition : conditions) {
        final Column column = table.getColumnByName(condition.getColumn());
        if (column == null) {
            throw new IllegalArgumentException("No such column: " + condition.getColumn());
        }
        final OperatorType operator = toOperator(condition.getOperator());
        final FilterItem filterItem = new FilterItem(new SelectItem(column), operator, condition.getOperand());
        whereBuilder.where(filterItem);
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public static List<LicensedProject> getLicensedProjects() {
    final List<LicensedProject> result = new ArrayList<>();
    final URL url = resourceManager.getUrl("licenses/dependency-licenses.csv");
    if (url == null) {
        throw new IllegalStateException("Could not find dependencies file");
    }
    try {
        final DataContext dc = DataContextFactory.createCsvDataContext(url.openStream(), ',', '"');
        final Table table = dc.getDefaultSchema().getTable(0);
        final Column projectColumn = table.getColumnByName("Project");
        final Column websiteColumn = table.getColumnByName("Website");
        final Column licenseColumn = table.getColumnByName("License");
        final Query q = dc.query().from(table).select(table.getColumns()).orderBy(projectColumn).asc().toQuery();
        final DataSet ds = dc.executeQuery(q);
        while (ds.next()) {
            final LicensedProject licensedProject = new LicensedProject();
            final Row row = ds.getRow();
            final String licenseName = row.getValue(licenseColumn).toString();

            licensedProject.name = row.getValue(projectColumn).toString();
            licensedProject.websiteUrl = row.getValue(websiteColumn).toString();
            licensedProject.license = getLicense(licenseName);

            result.add(licensedProject);
        }

    } catch (final IOException e) {
        throw new IllegalStateException("Error occurred while reading dependencies file", e);
    }

    return result;
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testExploreSchema() throws Exception {
	assertEquals("[information_schema, METER.DBF]",
			dc.getSchemaNames().toString());

	Schema schema = dc.getSchemaByName("METER.DBF");
	assertEquals("[Table[name=METER,type=TABLE,remarks=null]]",
			schema.getTables().toString());

	Table table = schema.getTableByName("METER");
	assertEquals(
			"[SCENARIO, P_INST, S_INST, A_INST, R_MULT, M_INST, G_BEG, T_BEG, G_NUM, A_NORM, F_KIND, F_TYPE, F_TOU, DATE_N, UTILCALC, DATE_D, UTIL, NAME, U_NAME, U_KIND, U_UNIT, N_UNIT, C_NAME, P_NAME, S_NAME, A_NAME, V1, V2, V3, V4, V5, V6, V7, V8, V9, V10, V11, V12, N1, N2, N3, N4, N5, N6, N7, N8, N9, N10, N11, N12, N_COUNT]",
			table.getColumnNames().toString());

	Column column = table.getColumnByName("F_TYPE");
	assertEquals(
			"Column[name=F_TYPE,columnNumber=11,type=CHAR,nullable=null,nativeType=C,columnSize=1]",
			column.toString());

	column = table.getColumnByName("V1");
	assertEquals(
			"Column[name=V1,columnNumber=26,type=DOUBLE,nullable=null,nativeType=N,columnSize=12]",
			column.toString());

	column = table.getColumnByName("V12");
	assertEquals(
			"Column[name=V12,columnNumber=37,type=DOUBLE,nullable=null,nativeType=N,columnSize=12]",
			column.toString());

	column = table.getColumnByName("A_NAME");
	assertEquals(
			"Column[name=A_NAME,columnNumber=25,type=CHAR,nullable=null,nativeType=C,columnSize=22]",
			column.toString());
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testDeveloperTable() throws Exception {
    Schema schema = dc.getDefaultSchema();
    assertEquals("developers.mdb", schema.getName());

    assertEquals("[developer, product]", schema.getTableNames().toString());

    Table table = schema.getTableByName("developer");
    assertEquals("[id, name, email, male, developer_since]", table.getColumnNames().toString());
    
    List<Column> primaryKeys = table.getPrimaryKeys();
    assertEquals("[Column[name=id,columnNumber=0,type=INTEGER,nullable=null,nativeType=LONG,columnSize=4]]", primaryKeys.toString());

    Column nameCol = table.getColumnByName("name");
    assertEquals(
            "Column[name=name,columnNumber=1,type=VARCHAR,nullable=null,nativeType=TEXT,columnSize=100]",
            nameCol.toString());

    Column maleCol = table.getColumnByName("male");
    assertEquals(
            "Column[name=male,columnNumber=3,type=BOOLEAN,nullable=null,nativeType=BOOLEAN,columnSize=1]",
            maleCol.toString());

    Column developerSinceCol = table.getColumnByName("developer_since");
    assertEquals(
            "Column[name=developer_since,columnNumber=4,type=TIMESTAMP,nullable=null,nativeType=SHORT_DATE_TIME,columnSize=8]",
            developerSinceCol.toString());

    DataSet ds = dc.executeQuery(new Query().select(nameCol, maleCol, developerSinceCol).from(table));
    while (ds.next()) {
        Row row = ds.getRow();
        assertEquals(3, row.getValues().length);
        Object value = row.getValue(0);
        assertEquals(String.class, value.getClass());
        value = row.getValue(1);
        assertEquals(Boolean.class, value.getClass());
        value = row.getValue(2);
        assertTrue(value instanceof Date);
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
@Test
public void testSerializeDeserializeDatastores() {
    String csv = ConfigurationSerializer.serializeAnalyzerBeansConfigurationDataStores(analyzerBeansConfiguration);
    logger.info("Csv: " + csv);
    AnalyzerBeansConfiguration deserialized = ConfigurationSerializer.deserializeAnalyzerBeansDatastores(csv);
    for (String datastoreName : analyzerBeansConfiguration.getDatastoreCatalog().getDatastoreNames()) {
        logger.info("Datastore: " + datastoreName);
        Datastore datastore = analyzerBeansConfiguration.getDatastoreCatalog().getDatastore(datastoreName);
        Datastore deserializedDatastore = deserialized.getDatastoreCatalog().getDatastore(datastoreName);
        Assert.assertNotNull(deserializedDatastore);

        SchemaNavigator schemaNavigator = datastore.openConnection().getSchemaNavigator();
        SchemaNavigator deserializedSchemaNavigator = deserializedDatastore.openConnection().getSchemaNavigator();
        for (Schema schema : schemaNavigator.getSchemas()) {
            String schemaName = schema.getName();
            logger.info("\tSchema: " + schemaName);
            Schema deserializedSchema = deserializedSchemaNavigator.getSchemaByName(schemaName);
            Assert.assertNotNull(deserializedSchema);

            for (Table table : schema.getTables()) {
                String tableName = table.getName();
                logger.info("\t\tTable: " + tableName);
                Table deserializedTable = deserializedSchema.getTableByName(tableName);
                Assert.assertNotNull(deserializedTable);

                for (Column column : table.getColumns()) {
                    String columnName = column.getName();
                    logger.info("\t\t\tColumn: " + columnName);
                    Column deserializedColumn = deserializedTable.getColumnByName(columnName);
                    Assert.assertNotNull(deserializedColumn);
                }
            }
        }
    }
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public Column getColumn(String database, String primaryKey, String tableName){
	Schema schema = dataContext.getDefaultSchema();
	Table table = schema.getTableByName(tableName);
	Column column = table.getColumnByName(primaryKey);
	return column;
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
protected Column getDefaultMappedColumn(final InputColumn<?> inputColumn, final Table table) {
    // automatically select a column by name, if it exists
    return table.getColumnByName(inputColumn.getName());
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testToAnalysisJob() throws Exception {
    final Table employeeTable =
            datastore.openConnection().getDataContext().getDefaultSchema().getTableByName("EMPLOYEES");
    assertNotNull(employeeTable);

    final Column emailColumn = employeeTable.getColumnByName("EMAIL");
    analysisJobBuilder.addSourceColumns(employeeTable.getColumnByName("EMPLOYEENUMBER"),
            employeeTable.getColumnByName("FIRSTNAME"), emailColumn);

    assertTrue(analysisJobBuilder.containsSourceColumn(emailColumn));
    assertFalse(analysisJobBuilder.containsSourceColumn(null));
    assertFalse(analysisJobBuilder.containsSourceColumn(employeeTable.getColumnByName("LASTNAME")));

    final TransformerComponentBuilder<ConvertToStringTransformer> transformerJobBuilder =
            analysisJobBuilder.addTransformer(ConvertToStringTransformer.class);

    final Collection<InputColumn<?>> numberColumns = analysisJobBuilder.getAvailableInputColumns(Number.class);
    assertEquals(1, numberColumns.size());
    assertEquals("[MetaModelInputColumn[PUBLIC.EMPLOYEES.EMPLOYEENUMBER]]",
            Arrays.toString(numberColumns.toArray()));

    transformerJobBuilder.addInputColumn(numberColumns.iterator().next());
    assertTrue(transformerJobBuilder.isConfigured());

    // the AnalyzerJob has no Analyzers yet, so it is not "configured".
    assertFalse(analysisJobBuilder.isConfigured());

    final AnalyzerComponentBuilder<StringAnalyzer> analyzerJobBuilder =
            analysisJobBuilder.addAnalyzer(StringAnalyzer.class);

    final List<InputColumn<?>> stringInputColumns = analysisJobBuilder.getAvailableInputColumns(String.class);
    final Set<String> columnNames =
            stringInputColumns.stream().map(InputColumn::getName).collect(Collectors.toCollection(TreeSet::new));
    assertEquals("[EMAIL, EMPLOYEENUMBER (as string), FIRSTNAME]", columnNames.toString());

    analyzerJobBuilder.addInputColumns(stringInputColumns);
    assertTrue(analyzerJobBuilder.isConfigured());

    // now there is: source columns, configured analyzers and configured
    // transformers.
    assertTrue(analysisJobBuilder.isConfigured());

    final AnalysisJob analysisJob = analysisJobBuilder.toAnalysisJob();

    assertEquals("ImmutableAnalysisJob[sourceColumns=3,filterJobs=0,transformerJobs=1,analyzerJobs=1]",
            analysisJob.toString());

    // test hashcode and equals
    assertNotSame(analysisJobBuilder.toAnalysisJob(), analysisJob);
    assertEquals(analysisJobBuilder.toAnalysisJob(), analysisJob);
    assertEquals(analysisJobBuilder.toAnalysisJob().hashCode(), analysisJob.hashCode());

    final Collection<InputColumn<?>> sourceColumns = analysisJob.getSourceColumns();
    assertEquals(3, sourceColumns.size());

    try {
        sourceColumns.add(new MockInputColumn<>("bla", Boolean.class));
        fail("Exception expected");
    } catch (final UnsupportedOperationException e) {
        // do nothing
    }

    final Collection<TransformerJob> transformerJobs = analysisJob.getTransformerJobs();
    assertEquals(1, transformerJobs.size());

    final TransformerJob transformerJob = transformerJobs.iterator().next();
    assertEquals("ImmutableTransformerJob[name=null,transformer=Convert to string]", transformerJob.toString());

    assertEquals("[MetaModelInputColumn[PUBLIC.EMPLOYEES.EMPLOYEENUMBER]]",
            Arrays.toString(transformerJob.getInput()));

    final Collection<AnalyzerJob> analyzerJobs = analysisJob.getAnalyzerJobs();
    assertEquals(1, analyzerJobs.size());

    final AnalyzerJob analyzerJob = analyzerJobs.iterator().next();
    assertEquals("ImmutableAnalyzerJob[name=null,analyzer=String analyzer]", analyzerJob.toString());
}
 

import org.apache.metamodel.schema.Table; //导入方法依赖的package包/类
public void testProductTable() throws Exception {
    Schema schema = dc.getDefaultSchema();
    assertEquals("developers.mdb", schema.getName());

    Table table = schema.getTableByName("product");
    assertEquals("[id, name, version, founder_developer]", table.getColumnNames().toString());

    Column idCol = table.getColumnByName("id");
    assertEquals(
            "Column[name=id,columnNumber=0,type=INTEGER,nullable=null,nativeType=LONG,columnSize=4]",
            idCol.toString());

    Column nameCol = table.getColumnByName("name");
    assertEquals(
            "Column[name=name,columnNumber=1,type=VARCHAR,nullable=null,nativeType=TEXT,columnSize=100]",
            nameCol.toString());

    Column versionCol = table.getColumnByName("version");
    assertEquals(
            "Column[name=version,columnNumber=2,type=INTEGER,nullable=null,nativeType=LONG,columnSize=4]",
            versionCol.toString());

    Column founderCol = table.getColumnByName("founder_developer");
    assertEquals(
            "Column[name=founder_developer,columnNumber=3,type=INTEGER,nullable=null,nativeType=LONG,columnSize=4]",
            founderCol.toString());

    DataSet ds;

    ds = dc.executeQuery(new Query().select(nameCol, versionCol, founderCol).from(table));
    assertTrue(ds.next());
    assertEquals("Anthons Algorithms", ds.getRow().getValue(nameCol).toString());
    assertEquals(11, ds.getRow().getValue(versionCol));
    assertEquals(1, ds.getRow().getValue(founderCol));
    assertTrue(ds.next());
    assertEquals("Barbaras Basic Bundle", ds.getRow().getValue(nameCol).toString());
    assertEquals(2, ds.getRow().getValue(versionCol));
    assertEquals(2, ds.getRow().getValue(founderCol));
    assertFalse(ds.next());
    ds.close();

    ds = dc.query().from(table).selectCount().execute();
    assertTrue(ds.next());
    assertEquals("Row[values=[2]]", ds.getRow().toString());
    assertFalse(ds.next());
    ds.close();
}