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

org.apache.metamodel.DataContext.query()
Starts building a query using the query builder API. This way of building queries is the preferred approach since it provides a more type-safe approach to building API's as well as allows the DataContext implementation to be aware of the query building process. @return a query builder component at the initial position in building aquery.


        dc = Converters.addTypeConverters(dc, converters);


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

View Full Code Here

        TableDataProvider<?> provider2 = new MapTableDataProvider(new SimpleTableDef("titles", new String[] { "name",
                "title" }), titles);


        DataContext dc = new PojoDataContext(Arrays.<TableDataProvider<?>> asList(provider1, provider2));


        DataSet dataSet = dc.query().from("persons").innerJoin("titles").on("name", "name").selectAll().execute();


        assertTrue(dataSet.next());
        assertEquals("Row[values=[Elvis Presley, 42, Elvis Presley, The King]]", dataSet.getRow().toString());
        assertFalse(dataSet.next());
    }

View Full Code Here

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


        String[] columnNames = table.getColumnNames();
        assertEquals("[A, B, C, D]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("A")).toQuery();
        assertEquals("SELECT xls_people.A FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("id", dataSet.getRow().getValue(0));

View Full Code Here

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


        String[] columnNames = table.getColumnNames();
        assertEquals("[1, mike, male, 18]", Arrays.toString(columnNames));


        Query q = dc.query().from(table).select(table.getColumnByName("1")).toQuery();
        assertEquals("SELECT xls_people.1 FROM xls_people.xls.xls_people", q.toSql());


        DataSet dataSet = dc.executeQuery(q);
        assertTrue(dataSet.next());
        assertEquals("2", dataSet.getRow().getValue(0));

View Full Code Here

    public void testGetStyles() throws Exception {
        DataContext dc = new ExcelDataContext(new File("src/test/resources/styles.xlsx"));
        Table table = dc.getDefaultSchema().getTables()[0];
        assertEquals("[style name, example]", Arrays.toString(table.getColumnNames()));


        DataSet ds = dc.query().from(table).select(table.getColumns()).execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[bold, foo]]", ds.getRow().toString());
        assertEquals("", ds.getRow().getStyle(0).toCSS());
        assertEquals("font-weight: bold;", ds.getRow().getStyle(1).toCSS());

View Full Code Here

            assertEquals(ColumnType.VARCHAR, table.getColumnByName("foo").getType());
            assertEquals(ColumnType.LIST, table.getColumnByName("list").getType());
            assertEquals(ColumnType.INTEGER, table.getColumnByName("id").getType());
            assertEquals(ColumnType.ROWID, table.getColumnByName("_id").getType());


            DataSet ds = dataContext.query().from("my_collection").select("name").and("foo").and("baz").and("list").where("id")
                    .greaterThan(800).or("foo").isEquals("bar").execute();
            assertEquals(MongoDbDataSet.class, ds.getClass());
            assertFalse(((MongoDbDataSet) ds).isQueryPostProcessed());
            try {
                assertTrue(ds.next());

View Full Code Here

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


            ds = dataContext.query().from("my_collection").select("id").and("name").where("id").in(2, 6, 8, 9).execute();
            assertTrue(ds.next());
            assertEquals("Row[values=[2, record no. 2]]", ds.getRow().toString());
            assertTrue(ds.next());
            assertEquals("Row[values=[6, record no. 6]]", ds.getRow().toString());
            assertTrue(ds.next());

View Full Code Here

            assertTrue(ds.next());
            assertEquals("Row[values=[9, record no. 9]]", ds.getRow().toString());
            assertFalse(ds.next());
            ds.close();


            ds = dataContext.query().from("my_collection").select("id").and("name").where("foo").isEquals("bar").execute();
            assertEquals(MongoDbDataSet.class, ds.getClass());
            assertFalse(((MongoDbDataSet) ds).isQueryPostProcessed());


            try {
                List<Object[]> objectArrays = ds.toObjectArrays();

View Full Code Here

            } finally {
                ds.close();
            }


            // do a query that we cannot push to mongo
            ds = dataContext.query().from("my_collection")
                    .select(FunctionType.SUM, dataContext.getDefaultSchema().getTables()[0].getColumnByName("id")).where("foo")
                    .isEquals("bar").execute();
            assertEquals(InMemoryDataSet.class, ds.getClass());


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

View Full Code Here

0 1 2 3 4

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.