Java Row.getValue方法代码示例

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
private UpdateScript insertScript() {
	UpdateScript insertScrript = new UpdateScript() {

		public void run(UpdateCallback callback) {
			Object value = null;
			RowInsertionBuilder insertData = callback.insertInto(table);
			for(Row rows: row){
				for (SelectItem column : rows.getSelectItems()) {
					if (!column.getColumn().getType().isTimeBased()) {
						value = rows.getValue(column);
					} else {
						value = ElementParser.getDate(rows.getValue(column));
					}
					insertData.value(column.getColumn(), value);
				}
				requests.mark();
				insertData.execute();
			}
	
			

		}
	};

	return insertScrript;
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
@Override
public Collection<String> getValues() {
    try (final DatastoreConnection con = _datastore.openConnection()) {
        final DataContext dataContext = con.getDataContext();

        final Query q = dataContext.query().from(_column.getTable()).select(_column).toQuery();
        q.selectDistinct();

        try (final DataSet dataSet = dataContext.executeQuery(q)) {
            final List<String> values = new ArrayList<String>();
            while (dataSet.next()) {
                final Row row = dataSet.getRow();
                
                Object value = row.getValue(0);
                if (value != null) {
                    value = value.toString();
                }
                values.add((String) value);
            }
            return values;
        }
    }
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
@Override
public void execute() throws MetaModelException {
    Table table = getTable();
    List<FilterItem> whereItems = getWhereItems();

    CouchDbConnector connector = _updateCallback.getConnector(table.getName());
    CouchDbDataContext dataContext = _updateCallback.getDataContext();

    DataSet dataSet = dataContext.query().from(table)
            .select(CouchDbDataContext.FIELD_ID, CouchDbDataContext.FIELD_REV).where(whereItems).execute();
    try {
        while (dataSet.next()) {
            Row row = dataSet.getRow();
            String id = (String) row.getValue(0);
            String revision = (String) row.getValue(1);
            connector.delete(id, revision);
        }
    } finally {
        dataSet.close();
    }
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
public void testCreateRowWithParsableDates() throws Exception {
    SelectItem item1 = new SelectItem(new MutableColumn("value1", ColumnType.STRING));
    SelectItem item2 = new SelectItem(new MutableColumn("value2", ColumnType.DATE));
    List<SelectItem> selectItems1 = Arrays.asList(item1, item2);
    String documentId = "doc1";
    DataSetHeader header = new SimpleDataSetHeader(selectItems1);
    Map<String, Object> values = new HashMap<>();
    values.put("value1", "theValue");
    values.put("value2", "2013-01-04T15:55:51.217+01:00");
    Row row = ElasticSearchUtils.createRow(values, documentId, header);
    Object stringValue = row.getValue(item1);
    Object dateValue = row.getValue(item2);

    assertTrue(stringValue instanceof String);
    assertTrue(dateValue instanceof Date);
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
private void runConversionTest(SalesforceDataContext dc, String tableName) {
    Query q = dc.query().from(tableName).selectAll().toQuery();
    q.setMaxRows(1);

    final DataSet ds = dc.executeQuery(q);
    final List<SelectItem> selectItems = ds.getSelectItems();
    while (ds.next()) {
        Row row = ds.getRow();

        for (SelectItem selectItem : selectItems) {
            Column column = selectItem.getColumn();
            Object value = row.getValue(column);
            if (value != null) {
                ColumnType type = column.getType();
                Class<?> expected = type.getJavaEquivalentClass();
                Class<? extends Object> actual = value.getClass();
                assertEquals("Unexpected type of value: " + value + ". Expected " + expected.getName()
                        + " but found " + actual.getName() + ". Native type was: " + column.getNativeType(),
                        expected, actual);
            }
        }
    }
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
@Override
public Object evaluate(Row row, Object[] parameters, SelectItem item) {
    final Object value = row.getValue(item);
    if (value == null || value instanceof String) {
        return value;
    }
    if (value instanceof Clob) {
        final Clob clob = (Clob) value;
        try {
            final Reader reader = clob.getCharacterStream();
            final String result = FileHelper.readAsString(reader);
            return result;
        } catch (SQLException e) {
            throw new MetaModelException("Failed to read CLOB to String", e);
        }
    }
    return String.valueOf(value);
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
/**
 * Converts values in a {@link RowBuilder}.
 * 
 * @param rowBuilder
 * @param converters
 * @return
 */
protected static <RB extends RowBuilder<?>> RB convertRow(RB rowBuilder, Map<Column, TypeConverter<?, ?>> converters) {
    Table table = rowBuilder.getTable();
    List<Column> columns = table.getColumns();
    Row row = rowBuilder.toRow();
    for (Column column : columns) {
        @SuppressWarnings("unchecked")
        TypeConverter<?, Object> converter = (TypeConverter<?, Object>) converters.get(column);
        if (converter != null) {
            final int indexInRow = row.indexOf(column);
            final Object value = row.getValue(indexInRow);
            final Object physicalValue = converter.toPhysicalValue(value);
            logger.debug("Converted virtual value {} to {}", value, physicalValue);
            if (value == null && physicalValue == null && !rowBuilder.isSet(column)) {
                logger.debug("Omitting implicit null value for column: {}", column);
            } else {
                final Style style = row.getStyle(indexInRow);
                rowBuilder.value(column, physicalValue, style);
            }
        }
    }
    return rowBuilder;
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
@Override
public Row getRow() {
    Row sourceRow = _dataSet.getRow();
    Object[] values = new Object[_converters.length];
    for (int i = 0; i < values.length; i++) {
        Object value = sourceRow.getValue(i);

        @SuppressWarnings("unchecked")
        TypeConverter<Object, ?> converter = (TypeConverter<Object, ?>) _converters[i];

        if (converter != null) {
            Object virtualValue = converter.toVirtualValue(value);
            logger.debug("Converted physical value {} to {}", value, virtualValue);
            value = virtualValue;
        }
        values[i] = value;
    }
    return new DefaultRow(getHeader(), values);
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
/**
 * Produces an updated row out of the original
 * 
 * @param original
 * @return
 */
private Row update(final Row original) {
    List<SelectItem> items = original.getSelectItems();
    Object[] values = new Object[items.size()];
    for (int i = 0; i < items.size(); i++) {
        final Object value;
        Column column = items.get(i).getColumn();
        if (isSet(column)) {
            // use update statement's value
            value = getValues()[i];
        } else {
            // use original value
            value = original.getValue(i);
        }
        values[i] = value;
    }
    return new DefaultRow(new SimpleDataSetHeader(items), values);
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
public void testNewAggregateFunctions() throws Exception {
    MockDataContext dc = new MockDataContext("sch", "tab", null);
    Table table = dc.getDefaultSchema().getTable(0);
    DataSet dataSet = dc.query().from(table).select(FunctionType.FIRST, "foo").select(FunctionType.LAST, "foo")
            .select(FunctionType.RANDOM, "foo").execute();
    assertTrue(dataSet.next());

    final Row row = dataSet.getRow();
    assertEquals("1", row.getValue(0));
    assertEquals("4", row.getValue(1));

    final Object randomValue = row.getValue(2);
    assertTrue(Arrays.asList("1", "2", "3", "4").contains(randomValue));

    assertFalse(dataSet.next());
    dataSet.close();
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
protected static String[] getSynonyms(final Row row, final Column[] columns) {
    final List<String> synonyms = new ArrayList<>();
    for (final Column synonymColumn : columns) {
        final Object value = row.getValue(synonymColumn);
        if (value != null) {
            final String stringValue = value.toString();
            synonyms.add(stringValue);
        }
    }
    return synonyms.toArray(new String[synonyms.size()]);
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
private static Comparable<?> getComparableValue(final Row row, final int columnIndex, final boolean isNumber,
        final boolean isDate) {
    final String value = (String) row.getValue(columnIndex);
    if (isNumber) {
        final Number result = ConvertToNumberTransformer.transformValue(value);
        if (result instanceof Comparable) {
            return (Comparable<?>) result;
        }
        return NumberComparator.getComparable(result);
    }
    if (isDate) {
        return ConvertToDateTransformer.getInternalInstance().transformValue(value);
    }
    return value.toLowerCase();
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的package包/类
public void testQuery() throws Exception {
	Schema schema = dc.getSchemaByName("report.dbf");
	Table table = schema.getTableByName("report");

	List<Column> columns = table.getColumns();
	Query q = new Query().select(columns).from(table);
	DataSet ds = dc.executeQuery(q);

	while (ds.next()) {
		Row row = ds.getRow();
		List<SelectItem> selectItems = row.getSelectItems();
		for (int i = 0; i < selectItems.size(); i++) {
			SelectItem selectItem = selectItems.get(i);
			Column column = columns.get(i);
			assertSame(selectItem.getColumn(), column);

			Object selectItemValue = row.getValue(selectItem);
			Object columnValue = row.getValue(column);
			assertEquals(selectItemValue, columnValue);

			assertNotNull(columnValue);

			assertTrue(columnValue instanceof Character
					|| columnValue instanceof String);
		}
	}
	ds.close();
}
 

import org.apache.metamodel.data.Row; //导入方法依赖的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.data.Row; //导入方法依赖的package包/类
private String[] getSynonyms(Row row, Column[] columns) {
    List<String> synonyms = new ArrayList<String>();
    for (Column synonymColumn : columns) {
        String value = (String) row.getValue(synonymColumn);
        synonyms.add(value);
    }
    return synonyms.toArray(new String[0]);
}