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


    Table table = dc.getDefaultSchema().getTables()[0];


    final String expectedStyling = "";


    DataSet dataSet = dc.query().from(table).select("date").execute();
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertFalse(dataSet.next());
    dataSet.close();
  }

View Full Code Here

        "src/test/resources/formulas.xlsx"));
    applyReaderDelegate(dc);


    Table table = dc.getDefaultSchema().getTables()[0];


    DataSet dataSet = dc.query().from(table).select("Foo").and("Bar")
        .where("Foo").isEquals("7").execute();
    assertTrue(dataSet.next());
    Row row = dataSet.getRow();
    assertNotNull(row.getStyle(0));


    final String expectedStyling = "";


    assertEquals(expectedStyling, row.getStyle(0).toCSS());
    assertNotNull(row.getStyle(1));
    assertEquals(expectedStyling, row.getStyle(1).toCSS());
    assertFalse(dataSet.next());
    dataSet.close();


    dataSet = dc.query().from(table).select("Foo").and("Bar").execute();
    assertTrue(dataSet.next());
    row = dataSet.getRow();
    assertNotNull(row.getStyle(0));
    assertEquals(expectedStyling, row.getStyle(0).toCSS());
    assertNotNull(row.getStyle(1));
    assertEquals(expectedStyling, row.getStyle(1).toCSS());


    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertTrue(dataSet.next());
    assertEquals(expectedStyling, dataSet.getRow().getStyle(0).toCSS());
    assertFalse(dataSet.next());
    dataSet.close();
  }

View Full Code Here


        // create datacontext using detected schema
        final String databaseName = getDatabaseName();
        final CouchDbDataContext dc = new CouchDbDataContext(couchDbInstance, databaseName);


        final DataSet ds1 = dc.query().from(databaseName).select("name").and("age").firstRow(2).execute();
        final DataSet ds2 = dc.query().from(databaseName).select("name").and("age").maxRows(1).execute();


        assertTrue("Class: " + ds1.getClass().getName(), ds1 instanceof CouchDbDataSet);
        assertTrue("Class: " + ds2.getClass().getName(), ds2 instanceof CouchDbDataSet);


        assertTrue(ds1.next());
        assertTrue(ds2.next());


        final Row row1 = ds1.getRow();
        final Row row2 = ds2.getRow();


        assertFalse(ds1.next());
        assertFalse(ds2.next());


        assertEquals("Row[values=[Jane Doe, null]]", row1.toString());
        assertEquals("Row[values=[John Doe, 30]]", row2.toString());


        ds1.close();
        ds2.close();
    }

View Full Code Here

        Table table = dc.getTableByQualifiedLabel(getDatabaseName());
        assertNotNull(table);


        assertEquals("[_id, _rev, name, gender, age]", Arrays.toString(table.getColumnNames()));


        DataSet ds;


        // assert not rows in DB
        ds = dc.query().from(getDatabaseName()).selectCount().execute();
        assertTrue(ds.next());
        assertEquals(0, ((Number) ds.getRow().getValue(0)).intValue());
        assertFalse(ds.next());
        ds.close();


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.insertInto(getDatabaseName()).value("name", "foo").value("gender", 'M').execute();
                callback.insertInto(getDatabaseName()).value("name", "bar").value("age", 32).execute();
            }
        });


        // now count should be 2
        ds = dc.query().from(getDatabaseName()).selectCount().execute();
        assertTrue(ds.next());
        assertEquals(2, ((Number) ds.getRow().getValue(0)).intValue());
        assertFalse(ds.next());
        ds.close();


        ds = dc.query().from(getDatabaseName()).select("name", "gender", "age").execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[foo, M, null]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[bar, null, 32]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();
    }

View Full Code Here

        Table table = dc.getTableByQualifiedLabel("sch.tab");
        Query q = dc.query().from(table).select("bar").toQuery();
        q.getSelectClause().setDistinct(true);
        q.orderBy(table.getColumnByName("bar"));


        DataSet ds = dc.executeQuery(q);
        assertTrue(ds.next());
        assertEquals("Row[values=[hello]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[hi]]", ds.getRow().toString());
        assertTrue(ds.next());
        assertEquals("Row[values=[yo]]", ds.getRow().toString());
        assertFalse(ds.next());
    }

View Full Code Here

        q.from(fromItem);
        assertEquals(
                "SELECT contributor.name, role.name FROM MetaModelSchema.contributor INNER JOIN MetaModelSchema.role ON contributor.contributor_id = role.contributor_id",
                q.toString());


        DataSet data = dc.executeQuery(q);
        assertEquals(2, data.getSelectItems().length);
        assertTrue(data.next());
        assertEquals("Row[values=[kasper, founder]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[kasper, developer]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[kasper, developer]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[asbjorn, developer]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[asbjorn, developer]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[daniel, advisor]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[sasidhar, developer]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[jesper, founder]]", data.getRow().toString());
        assertFalse(data.next());
    }

View Full Code Here

        assertEquals(
                "SELECT c.name AS e FROM (SELECT contributor.contributor_id, contributor.name, contributor.country FROM MetaModelSchema.contributor) c",
                q2.toString());


        DataContext dc = getDataContext();
        DataSet data = dc.executeQuery(q2);
        assertEquals(1, data.getSelectItems().length);
        assertTrue(data.next());
        assertEquals("Row[values=[kasper]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[asbjorn]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[johny]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[daniel]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[sasidhar]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[jesper]]", data.getRow().toString());
        assertFalse(data.next());


        // Create a sub-query for a sub-query
        Query q3 = new Query();
        fromItem = new FromItem(q2);
        q3.from(fromItem);
        selectItem = new SelectItem(q2.getSelectClause().getItems().get(0), fromItem);
        selectItem.setAlias("f");
        q3.select(selectItem);
        fromItem.setAlias("d");
        assertEquals(
                "SELECT d.e AS f FROM (SELECT c.name AS e FROM (SELECT contributor.contributor_id, contributor.name, contributor.country FROM MetaModelSchema.contributor) c) d",
                q3.toString());
        data = dc.executeQuery(q3);
        assertEquals(1, data.getSelectItems().length);
        assertTrue(data.next());
        assertEquals("Row[values=[kasper]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[asbjorn]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[johny]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[daniel]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[sasidhar]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[jesper]]", data.getRow().toString());
        assertFalse(data.next());
    }

View Full Code Here


        assertEquals(
                "SELECT c.contributor_id, c.name, c.country FROM MetaModelSchema.contributor c ORDER BY c.country DESC, c.name ASC",
                q.toString());


        DataSet data = getDataContext().executeQuery(q);
        assertTrue(data.next());
        assertEquals("Row[values=[5, sasidhar, unknown]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[3, johny, israel]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[2, asbjorn, denmark]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[6, jesper, denmark]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[1, kasper, denmark]]", data.getRow().toString());
        assertTrue(data.next());
        assertEquals("Row[values=[4, daniel, canada]]", data.getRow().toString());
        assertFalse(data.next());
    }

View Full Code Here

                MutableTable table = new MutableTable("tabl").setSchema(schema);
                return schema.addTable(table.addColumn(new MutableColumn("col").setTable(table)));
            }
        };


        DataSet ds = dc.query().from("sch.tabl").selectCount().execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[1337]]", ds.getRow().toString());
        assertFalse(ds.next());
    }

View Full Code Here

                table.addColumn(new MutableColumn("col2").setTable(table));
                return schema.addTable(table);
            }
        };


        DataSet result = dc.query().from("tabl").select("col2").where("col1").eq("foo").execute();
        assertTrue(result.next());
        assertEquals("Row[values=[hello world]]", result.getRow().toString());
        assertFalse(result.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.