Java DataSet.next方法代码示例

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
private void insertRowIntoBlockingQueue(DataSet dataset) throws InterruptedException {

		hashedColumn = table.getColumnByName(columnName);
		requests = metrics.meter("read thread");

		while (dataset.next()) {
			Row row = dataset.getRow();
			if (horizontal && isKey(row)) {
				queue.put(row);
				requests.mark();
			} else {
			    if(!horizontal){
				queue.put(row);
				requests.mark();
			    }
			}

		}

	}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
public void readComplexData() throws Exception {
		Column primaryColumn = dataContext.getTableByQualifiedLabel(joinTable).getColumnByName(secondFkey);
		System.out.println(dataContext.query().from(joinTable).select(primaryColumn).groupBy(primaryColumn).toQuery().toString());
		DataSet dataSet = dataContext.query().from(joinTable).select(primaryColumn).groupBy(primaryColumn).execute();
		while (dataSet.next()) {

			arrayData = new ArrayList<Row>();
			Object dataValue = dataSet.getRow().getValue(primaryColumn);
			DataSet dataSetArray = dataContext.query().from(joinTable).select(forgeinKey).where(primaryColumn)
					.eq(dataValue).execute();
			System.out.println( dataContext.query().from(joinTable).select(forgeinKey).where(primaryColumn)
					.eq(dataValue).toQuery().toSql());
			readDataSet(dataSetArray);
			ComplexData complexDataObject = new ComplexData(dataSet.getRow(), arrayData);
			queueComplexData.put(complexDataObject);
			dataSetArray.close();
//			dataContext.executeUpdate();

		}
		insertPosion();
		dataSet.close();

	}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的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.DataSet; //导入方法依赖的package包/类
@Test
public void testSimpleCarthesianProduct() throws Exception {
    DataSet dataSet = MetaModelHelper.getCarthesianProduct(createDataSet1(), createDataSet2());
    List<String> results = new ArrayList<String>();

    while (dataSet.next()) {
        results.add(dataSet.getRow().toString());
    }
    assertEquals(2, dataSet.getSelectItems().size());
    assertEquals(9, results.size());
    assertTrue(results.contains("Row[values=[f, b]]"));
    assertTrue(results.contains("Row[values=[f, a]]"));
    assertTrue(results.contains("Row[values=[f, r]]"));
    assertTrue(results.contains("Row[values=[o, b]]"));
    assertTrue(results.contains("Row[values=[o, a]]"));
    assertTrue(results.contains("Row[values=[o, r]]"));
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
@Test
public void testSelectiveJoin() {
    Stopwatch duration = Stopwatch.createStarted();
    CompositeDataContext compDcon = new CompositeDataContext(this.emp_dcon, this.dep_dcon);

    DataSet ds = compDcon.query().from("employee").innerJoin("department").on("dep_id", "id").selectAll().where(
            compDcon.getTableByQualifiedLabel("department").getColumnByName("id")).eq(1).execute();
    int rowCount = 0;
    while (ds.next()) {
        Row row = ds.getRow();
        Assert.assertNotNull(row);
        rowCount++;
    }
    duration.stop();
    logger.info("Test duration was {} ms", duration.elapsed(TimeUnit.MILLISECONDS));

    Assert.assertEquals(employeesPerDepartment, rowCount);
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
@Test
public void testCarthesianProductScalability() {

    DataSet employees = createDataSet5();
    DataSet departmens = createDataSet6();

    FilterItem fi = new FilterItem(employees.getSelectItems().get(2), OperatorType.EQUALS_TO,
            departmens.getSelectItems().get(0));

    DataSet joined = MetaModelHelper.getCarthesianProduct(new DataSet[] { employees, departmens }, fi);
    int count = 0;
    while (joined.next()) {
        count++;
    }

    assertTrue(count == bigDataSetSize);
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
private DataSet createDataSet() {

		if (numbers == 0 && !isFinish) {
			DataSet number = dataContext.query().from(table).selectCount().execute();
			number.next();
			Number n = (Number) number.getRow().getValue(0);
			numbers = n.intValue();
			limit = BORDER;
			number.close();
		}

		return dataContext.executeQuery(selectAll());

	}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
private void getComplexData(Object object) {
	DataSet dataSet = dataContext.query().from(secondSource).selectAll().where(pkSecond).eq(object).execute();
	while (dataSet.next()) {
		arrayData.add(dataSet.getRow());
	}
	dataSet.close();

}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
public DataSetResult(final DataSet ds) {
    _rows = new ArrayList<>();
    while (ds.next()) {
        _rows.add(ds.getRow());
    }
    ds.close();
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
private Object[] handleDataSet(final InputRow row, final DataSet dataSet) {
    if (!dataSet.next()) {

        logger.info("Result of lookup: None!");
        _annotationFactory.annotate(row, 1, _misses);

        switch (joinSemantic) {
        case LEFT_JOIN_MAX_ONE:
        case LEFT_JOIN:
            return new Object[outputColumns.length];
        default:
            return null;
        }
    }

    _annotationFactory.annotate(row, 1, _matches);

    do {
        final Object[] result = dataSet.getRow().getValues();
        if (logger.isInfoEnabled()) {
            logger.info("Result of lookup: " + Arrays.toString(result));
        }
        switch (joinSemantic) {
        case LEFT_JOIN_MAX_ONE:
            return result;
        default:
            outputRowCollector.putValues(result);
        }

    } while (dataSet.next());

    return null;
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的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.data.DataSet; //导入方法依赖的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.DataSet; //导入方法依赖的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.DataSet; //导入方法依赖的package包/类
private Object[] handleDataSet(DataSet dataSet) {
    if (!dataSet.next()) {
        logger.info("Result of lookup: None!");
        switch (joinSemantic) {
        case LEFT_JOIN_MAX_ONE:
        case LEFT_JOIN:
            return new Object[outputColumns.length];
        default:
            return null;
        }
    }

    do {
        final Object[] result = dataSet.getRow().getValues();
        if (logger.isInfoEnabled()) {
            logger.info("Result of lookup: " + Arrays.toString(result));
        }
        switch (joinSemantic) {
        case LEFT_JOIN_MAX_ONE:
            return result;
        default:
            outputRowCollector.putValues(result);
        }

    } while (dataSet.next());

    return null;
}
 

import org.apache.metamodel.data.DataSet; //导入方法依赖的package包/类
public DataSetResult(DataSet ds) {
    _rows = new ArrayList<Row>();
    while (ds.next()) {
        _rows.add(ds.getRow());
    }
    ds.close();
}