Examples of org.apache.metamodel.data.DataSet

org.apache.metamodel.data.DataSet
Represents a tabular DataSet where values are bound to columns and rows. A DataSet works similarly to a slightly modularized ResultSet when you traverse it - use the next() method to loop through the rows of the DataSet and use the getRow() method to get the current row. @author Kasper Sørensen

                new CsvConfiguration(1, false, false));
        testHandlingOfEmptyLines(dc);
    }


    public void testHandlingOfEmptyLines(DataContext dc) throws Exception {
        DataSet ds = dc.query().from(dc.getDefaultSchema().getTable(0)).selectAll().execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[hello, world]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[hi, there]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();
    }

View Full Code Here


    public void testInconsistentColumns() throws Exception {
        CsvConfiguration conf = new CsvConfiguration(CsvConfiguration.DEFAULT_COLUMN_NAME_LINE, "UTF8", ',', '"', '\\',
                true);
        DataContext dc = new CsvDataContext(new File("src/test/resources/csv_inconsistent_columns.csv"), conf);
        DataSet ds = dc.query().from("csv_inconsistent_columns.csv").select("hello").and("world").execute();
        assertTrue(ds.next());
        assertTrue(ds.next());


        try {
            ds.next();
            fail("Exception expected");
        } catch (InconsistentRowLengthException e) {
            assertEquals("Inconsistent length of row no. 3. Expected 2 columns but found 3.", e.getMessage());
            Row proposedRow = e.getProposedRow();
            assertEquals("[5, 6]", Arrays.toString(proposedRow.getValues()));


            String[] sourceLine = e.getSourceLine();
            assertEquals("[5, 6, 7]", Arrays.toString(sourceLine));
        }


        assertTrue(ds.next());


        try {
            ds.next();
            fail("Exception expected");
        } catch (InconsistentRowLengthException e) {
            assertEquals("Inconsistent length of row no. 5. Expected 2 columns but found 1.", e.getMessage());
            Row proposedRow = e.getProposedRow();
            assertEquals("[10, null]", Arrays.toString(proposedRow.getValues()));


            String[] sourceLine = e.getSourceLine();
            assertEquals("[10]", Arrays.toString(sourceLine));
        }


        assertTrue(ds.next());
        assertFalse(ds.next());
    }

View Full Code Here

            public void run(UpdateCallback callback) {
                final Table sourceTable = getSourceTable();
                final Table targetTable = callback.createTable(targetDataContext.getDefaultSchema(), _collectionName)
                        .like(sourceTable).execute();
                final Column[] sourceColumns = sourceTable.getColumns();
                final DataSet dataSet = _sourceDataContext.query().from(sourceTable).select(sourceColumns).execute();
                while (dataSet.next()) {
                    final Row row = dataSet.getRow();


                    RowInsertionBuilder insertBuilder = callback.insertInto(targetTable);
                    for (Column column : sourceColumns) {
                        insertBuilder = insertBuilder.value(column.getName(), row.getValue(column));
                    }
                    insertBuilder.execute();
                }
                dataSet.close();
            }
        });
    }

View Full Code Here

        Table table = dc.getDefaultSchema().getTables()[0];
        Query q = dc.query().from(table).selectCount().toQuery();
        SelectItem selectItem = q.getSelectClause().getItem(0);
        selectItem.setFunctionApproximationAllowed(true);


        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        Object[] values = ds.getRow().getValues();
        assertEquals(1, values.length);
        assertEquals(9, ((Long) ds.getRow().getValue(selectItem)).intValue());
        assertEquals(9, ((Long) values[0]).intValue());
        assertFalse(ds.next());
    }

View Full Code Here

        Table table = schema.getTable(0);
        Column column = table.getColumn(0);


        // query another DataContext using the schemas of the one above
        ExcelDataContext dc2 = new ExcelDataContext(new File("src/test/resources/Spreadsheet2007.xlsx"));
        DataSet ds = dc2.executeQuery(new Query().from(table).select(column));


        // previously we would crash at this point!


        assertNotNull(ds);
        ds.close();
    }

View Full Code Here


    public void doTicketFileTests(DataContext dc) {
        Table table = dc.getDefaultSchema().getTables()[0];
        Query q = dc.query().from(table).select(table.getColumns()).toQuery();


        DataSet dataSet = dc.executeQuery(q);
        List<Object[]> objectArrays = dataSet.toObjectArrays();
        assertEquals(13, objectArrays.get(0).length);
        assertEquals(36, objectArrays.size());
        assertEquals("2", objectArrays.get(0)[0].toString());


        Object description = objectArrays.get(0)[11];

View Full Code Here

        assertEquals("male", columns[2].getName());
        assertEquals("19", columns[3].getName());


        Query query = dc.query().from(table).select(table.getColumnByName("michael")).toQuery();


        DataSet dataSet = dc.executeQuery(query);
        assertTrue(dataSet.next());
        assertEquals("peter", dataSet.getRow().getValue(0));
        assertTrue(dataSet.next());
        assertEquals("bob", dataSet.getRow().getValue(0));
        assertTrue(dataSet.next());
        assertEquals("barbara, barb", dataSet.getRow().getValue(0));
    }

View Full Code Here

        assertEquals("C", columns[2].getName());
        assertEquals("D", columns[3].getName());


        Query query = dc.query().from(table).select(table.getColumnByName("B")).toQuery();


        DataSet dataSet = dc.executeQuery(query);
        assertTrue(dataSet.next());
        assertEquals("name", dataSet.getRow().getValue(0));
        assertTrue(dataSet.next());
        assertEquals("mike", dataSet.getRow().getValue(0));
        assertTrue(dataSet.next());
        assertEquals("michael", dataSet.getRow().getValue(0));
    }

View Full Code Here

                    // no need to iterate old records, they should all be
                    // removed
                    return;
                }


                final DataSet dataSet = _updateCallback.getDataContext().query().from(originalTable)
                        .select(originalTable.getColumns()).execute();
                try {
                    while (dataSet.next()) {
                        final Row row = dataSet.getRow();
                        if (!deleteRow(row)) {
                            callback.insertInto(copyTable).like(row).execute();
                        }
                    }
                } finally {
                    dataSet.close();
                }
            }
        });


        // copy the copy (which does not have deleted records) to overwrite the

View Full Code Here


        Query q = new Query();
        q.from(table);
        q.where(new FilterItem(new SelectItem(table.getColumnByName("id")), OperatorType.EQUALS_TO, 1));
        q.select(table.getColumnByName("name"));
        DataSet data = dc.executeQuery(q);
        assertTrue(data.next());
        assertEquals("Row[values=[mike]]", data.getRow().toString());
        assertFalse(data.next());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.metamodel.data.DataSet

org.apache.metamodel.AbstractDataContext

org.apache.metamodel.CompositeDataContextTest

org.apache.metamodel.convert.ConvertedDataSetInterceptorTest

org.apache.metamodel.convert.Converters

org.apache.metamodel.convert.ConvertersTest

org.apache.metamodel.couchdb.CouchDbDataContextTest

org.apache.metamodel.couchdb.CouchDbRowDeletionBuilder

org.apache.metamodel.couchdb.CouchDbRowUpdationBuilder

org.apache.metamodel.csv.CsvBigFileMemoryTest

org.apache.metamodel.csv.CsvDataContextTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.