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

            return;
        }


        SalesforceDataContext dc = new SalesforceDataContext(getUsername(), getPassword(), getSecurityToken());


        DataSet ds;


        // a very simple query
        ds = dc.query().from("Account").select("Name").execute();
        assertTrue(ds instanceof SalesforceDataSet);
        assertTrue(ds.next());
        assertNotNull(ds.getRow().getValue(0));
        assertTrue(ds.next());
        ds.close();


        // a very simple query
        Query query = dc.query().from("Account").select("Id").and("Name").where("Name").like("% %").orderBy("Name")
                .toQuery();
        query.setMaxRows(10);
        ds = dc.executeQuery(query);
        assertTrue(ds instanceof SalesforceDataSet);
        assertTrue(ds.next());
        ds.close();


        // a COUNT() query
        ds = dc.query().from("Account").selectCount().execute();
        assertFalse(ds instanceof SalesforceDataSet);
        assertTrue(ds.next());
        assertTrue(ds.getRow().getValue(0) instanceof Number);
        assertTrue(((Number) ds.getRow().getValue(0)).intValue() > 0);
        assertFalse(ds.next());
        ds.close();
    }

View Full Code Here

            }
        });


        final List<String> ids = new ArrayList<String>();


        DataSet ds;
        ds = dc.query().from(tableName).select("id", "name").where("name").eq(insertedName).execute();
        assertTrue(ds.next());
        Row row = ds.getRow();
        assertNotNull(row.getValue(0));
        ids.add(row.getValue(0).toString());


        while (ds.next()) {
            row = ds.getRow();
            ids.add(row.getValue(0).toString());
            assertEquals("MetaModel TESTER contact", row.getValue(1));
        }


        ds.close();


        // UPDATE


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.update(tableName).where("id").eq(ids.get(0)).value("name", "Another test value").execute();
            }
        });


        ds = dc.query().from(tableName).select("name").where("id").eq(ids.get(0)).execute();
        assertTrue(ds.next());
        assertEquals("Another test value", ds.getRow().getValue(0));
        assertFalse(ds.next());
        ds.close();


        // UPDATE (a record that does not exist)


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.update(tableName).where("id").eq("fooooooobaaaaaaaar")
                        .value("name", "A test value that should never occur").execute();
            }
        });


        // DELETE


        dc.executeUpdate(new UpdateScript() {
            @Override
            public void run(UpdateCallback callback) {
                callback.deleteFrom(tableName).where("id").in(ids).execute();
            }
        });


        ds = dc.query().from(tableName).selectCount().where("name").eq(insertedName).execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[0]]", ds.getRow().toString());
        assertFalse(ds.next());
        ds.close();
    }

View Full Code Here

                callback.insertInto(table).value("FirstName", firstName).value("LastName", lastName)
                        .value("BirthDate", dateValue).execute();
            }
        });


        final DataSet dataSet = dc.query().from(table).select("Id", "BirthDate").where("FirstName").eq(firstName)
                .where("LastName").eq(lastName).execute();


        int rows = 0;


        while (dataSet.next()) {
            final String id = (String) dataSet.getRow().getValue(0);
            try {
                assertNotNull(id);


                final Object dateValueFromDataSet = dataSet.getRow().getValue(1);
                assertTrue(dateValueFromDataSet instanceof Date);
                assertEquals("1980-08-08 00:00:00", dateFormat.format(dateValueFromDataSet));


            } finally {
                // clean up

View Full Code Here

        Arrays.toString(dc.getDefaultSchema().getTableNames()));
    Table table = dc.getDefaultSchema().getTables()[0];
    assertEquals("[col1, col2, foobar]",
        Arrays.toString(table.getColumnNames()));


    DataSet ds = dc.query().from(table).select(table.getColumns())
        .execute();
    assertTrue(ds.next());
    assertEquals("Row[values=[hello, world, elite!]]", ds.getRow()
        .toString());
    assertTrue(ds.next());
    assertEquals("Row[values=[123, 567, elite!]]", ds.getRow().toString());
    assertFalse(ds.next());
  }

View Full Code Here

        ExcelConfiguration conf = new ExcelConfiguration(ExcelConfiguration.DEFAULT_COLUMN_NAME_LINE, true, true);
        ExcelDataContext dc = new ExcelDataContext(new File("src/test/resources/skipped_lines.xlsx"), conf);
        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("[hello, world]", Arrays.toString(table.getColumnNames()));


        DataSet ds = dc.executeQuery(dc.query().from(table).select("hello").toQuery());
        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(0));
    }

View Full Code Here

        assertEquals("[G, H]", Arrays.toString(table.getColumnNames()));


        assertEquals(6, table.getColumnByName("G").getColumnNumber());
        assertEquals(7, table.getColumnByName("H").getColumnNumber());


        DataSet ds = dc.executeQuery(dc.query().from(table).select("G").toQuery());


        // 5 empty lines
        for (int i = 0; i < 5; i++) {
            assertTrue(ds.next());
            Object value = ds.getRow().getValue(0);
            assertNull("Values was: " + value + " at row " + i, value);
        }


        assertTrue(ds.next());
        assertEquals("hello", ds.getRow().getValue(0));
        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(0));
    }

View Full Code Here

        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("[hello, world]", Arrays.toString(table.getColumnNames()));
        assertEquals(6, table.getColumnByName("hello").getColumnNumber());
        assertEquals(7, table.getColumnByName("world").getColumnNumber());


        DataSet ds = dc.executeQuery(dc.query().from(table).select("hello").toQuery());
        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(0));
    }

View Full Code Here


        assertEquals("[name]", Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select("name").toQuery();


        DataSet ds = dc.executeQuery(dc.query().from(table).selectCount().toQuery());
        assertTrue(ds.next());
        assertEquals(3, Integer.parseInt(ds.getRow().getValue(0).toString()));
        assertFalse(ds.next());
        assertFalse(ds.next());
        ds.close();


        ds = dc.executeQuery(q);


        Row row;


        assertTrue(ds.next());
        row = ds.getRow();
        assertEquals("TismmerswerskisMFSTLandsmeers                                                          ", row
                .getValue(0).toString());


        assertTrue(ds.next());
        row = ds.getRow();
        assertEquals("-\"t\" \"houetismfsthueiss\"", row.getValue(0).toString());


        assertTrue(ds.next());
        row = ds.getRow();
        assertEquals("TismmerswerskisMFSTLandsmeers                                                          ", row
                .getValue(0).toString());


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

View Full Code Here

    final Table table = schema.getTableByName("/dependency");
    assertEquals("[row_id, /artifactId, /groupId, /version, /scope]",
        Arrays.toString(table.getColumnNames()));


    // perform a regular query
    DataSet ds = dc.query().from(table).select(table.getColumns())
        .execute();
    assertTrue(ds.next());
    assertEquals("Row[values=[0, joda-time, joda-time, 1.5.2, compile]]",
        ds.getRow().toString());


    assertTrue(ds.next());
    assertEquals("Row[values=[1, commons-math, commons-math, 1.1, null]]",
        ds.getRow().toString());


    assertTrue(ds.next());
    assertTrue(ds.next());
    assertTrue(ds.next());
    assertTrue(ds.next());
    assertEquals("Row[values=[5, hsqldb, hsqldb, 1.8.0.7, null]]", ds
        .getRow().toString());


    assertTrue(ds.next());
    assertTrue(ds.next());
    assertTrue(ds.next());
    assertTrue(ds.next());
    assertTrue(ds.next());
    assertEquals(
        "Row[values=[10, mysql-connector-java, mysql, 5.1.6, test]]",
        ds.getRow().toString());
    assertFalse(ds.next());
    ds.close();


    // perform a constrained query
    Query q = dc.query().from(table).select("row_id").and("/groupId")
        .where("/scope").isNotNull().toQuery();
    q.setMaxRows(2);
    ds = dc.executeQuery(q);


    assertTrue(ds.next());
    assertEquals("Row[values=[0, joda-time]]", ds.getRow().toString());
    assertTrue(ds.next());
    assertEquals("Row[values=[6, junit]]", ds.getRow().toString());
    assertFalse(ds.next());
    ds.close();
  }

View Full Code Here


        assertEquals("[some number, some mixed formula, some int only formula]",
                Arrays.toString(table.getColumnNames()));


        Query q = dc.query().from(table).select(columns).toQuery();
        DataSet ds = dc.executeQuery(q);
        Object value;


        assertTrue(ds.next());
        assertEquals("1", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("1", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("1", value);


        assertTrue(ds.next());
        assertEquals("2", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("3", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("3", value);


        assertTrue(ds.next());
        assertEquals("3", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("8", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("8", value);


        assertTrue(ds.next());
        assertEquals("4", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("12", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("12", value);


        assertTrue(ds.next());
        assertEquals("5", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("yes", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("5", value);


        assertTrue(ds.next());
        assertEquals("6", ds.getRow().getValue(columns[0]));
        value = ds.getRow().getValue(columns[1]);
        assertEquals(String.class, value.getClass());
        assertEquals("no", value);


        value = ds.getRow().getValue(columns[2]);
        assertEquals(String.class, value.getClass());
        assertEquals("6", value);


        assertFalse(ds.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.