Examples of org.apache.metamodel.DataContext.executeQuery()

org.apache.metamodel.DataContext.executeQuery()
Executes a query against the DataContext. @param query the query object to execute @return the {@link DataSet} produced from executing the query @throws MetaModelException if the specified query does not make sense or cannot be executed because of restraints on the type of datastore.

    DataContext dc = new JdbcDataContext(connection);
    Table customerTable = dc.getDefaultSchema().getTableByName("CUSTOMERS");


    Query q = new Query().from(customerTable).select(
        customerTable.getColumns());
    DataSet dataSet = dc.executeQuery(q);
    IRowFilter filter1 = new IRowFilter() {


      public boolean accept(Row row) {
        // This will only accept five records
        boolean result = ((Integer) row.getValue(0)) > 485;

View Full Code Here


        final long timeAfterDataContext = System.currentTimeMillis();
        System.out.println("time after DataContext: " + timeAfterDataContext);


        final Query q = new Query().select(t.getColumns()).from(t);
        DataSet ds = dc.executeQuery(q);


        long timeAfterQuery = System.currentTimeMillis();
        System.out.println("time after query: " + timeAfterQuery);


        final CountDownLatch countDown = new CountDownLatch(hugeFileRows);

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(3332, ((Long) ds.getRow().getValue(selectItem)).intValue());
        assertEquals(3332, ((Long) values[0]).intValue());

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());

View Full Code Here

        q.groupBy(table.getColumnByName("gender"));
        q.select(new SelectItem(table.getColumnByName("gender")),
                new SelectItem(FunctionType.MAX, table.getColumnByName("age")),
                new SelectItem(FunctionType.MIN, table.getColumnByName("age")), new SelectItem(FunctionType.COUNT, "*",
                        "total"), new SelectItem(FunctionType.MIN, table.getColumnByName("id")).setAlias("firstId"));
        DataSet data = dc.executeQuery(q);
        assertEquals(
                "[csv_people.csv.gender, MAX(csv_people.csv.age), MIN(csv_people.csv.age), COUNT(*) AS total, MIN(csv_people.csv.id) AS firstId]",
                Arrays.toString(data.getSelectItems()));


        String[] expectations = new String[] { "Row[values=[female, 20, 17, 5, 5]]", "Row[values=[male, 19, 17, 4, 1]]" };

View Full Code Here

        q.setFirstRow(3);
        q.setMaxRows(2);


        DataSet ds;


        ds = dc.executeQuery(q);
        assertEquals(1, ds.getSelectItems().length);
        assertTrue(ds.next());
        assertEquals("peter", ds.getRow().getValue(0).toString());
        assertTrue(ds.next());
        assertEquals("bob", ds.getRow().getValue(0).toString());

View Full Code Here

        assertEquals("bob", ds.getRow().getValue(0).toString());
        assertFalse(ds.next());
        ds.close();


        // try with iterator
        ds = dc.executeQuery(q);
        int i = 0;
        for (Row row : ds) {
            assertNotNull(row);
            i++;
        }

View Full Code Here

    Table table = schema.getTableByName("projects_project");
    Query q = new Query().select(table.getColumns()).from(table, "p");
    assertEquals(
        "SELECT p.id, p.project, p.name FROM xml_input_eobjects.xml.projects_project p",
        q.toString());
    DataSet data = dc.executeQuery(q);
    TableModel tableModel = new DataSetTableModel(data);
    assertEquals(3, tableModel.getColumnCount());
    assertEquals(2, tableModel.getRowCount());


    // ID

View Full Code Here

            + "contributors_person_address.contributors_person_id, contributors_person_address.address "
            + "FROM xml_input_eobjects.xml.contributors_person INNER JOIN xml_input_eobjects.xml.contributors_person_address "
            + "ON contributors_person.id = contributors_person_address.contributors_person_id",
        q.toString());


    data = dc.executeQuery(q);
    tableModel = new DataSetTableModel(data);
    assertEquals(4, tableModel.getColumnCount());
    assertEquals(4, tableModel.getRowCount());


    assertEquals("1", tableModel.getValueAt(0, 0).toString());

View Full Code Here

        Table table = dc.getDefaultSchema().getTables()[0];
        MutableColumn col = (MutableColumn) table.getColumns()[0];
        Query q = dc.query().from(table).select(col).toQuery();
        assertEquals("SELECT csv_only_number_one.csv.number FROM resources.csv_only_number_one.csv", q.toSql());


        DataSet ds = dc.executeQuery(q);
        while (ds.next()) {
            assertEquals(true, ds.getRow().getValue(0));
        }
        ds.close();

View Full Code Here

0 1 2 3 4 5

TOP

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.