Examples of org.apache.metamodel.query.Query

org.apache.metamodel.query.Query
Represents a query to retrieve data by. A query is made up of six clauses, equivalent to the SQL standard:
- the SELECT clause, which define the wanted columns of the resulting DataSet
- the FROM clause, which define where to retrieve the data from
- the WHERE clause, which define filters on the retrieved data
- the GROUP BY clause, which define if the result should be grouped and aggregated according to some columns acting as categories
- the HAVING clause, which define filters on the grouped data
- the ORDER BY clause, which define sorting of the resulting dataset
In addition two properties are applied to queries to limit the resulting dataset:
- First row: The first row (aka. offset) of the result of the query.
- Max rows: The maximum amount of rows to return when executing the query.
Queries are executed using the DataContext.executeQuery method or can alternatively be used directly in JDBC by using the toString() method. @see DataContext

        assertNotNull(whereItems.get(0).getSelectItem().getColumn());
        assertNotNull(whereItems.get(0).getSelectItem().getFromItem().getTable());
    }


    public void testJoin() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc,
                "SELECT a.foo,b.bar FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo");
        assertEquals("SELECT a.foo, b.bar FROM sch.tbl a INNER JOIN sch.tbl b ON a.foo = b.foo", q.toSql());


        q = MetaModelHelper.parseQuery(dc,
                "SELECT COUNT(*) FROM sch.tbl a LEFT JOIN sch.tbl b ON a.foo = b.foo AND a.bar = b.baz");
        assertEquals("SELECT COUNT(*) FROM sch.tbl a LEFT JOIN sch.tbl b ON a.foo = b.foo AND a.bar = b.baz", q.toSql());
    }

View Full Code Here

                "SELECT COUNT(*) FROM sch.tbl a LEFT JOIN sch.tbl b ON a.foo = b.foo AND a.bar = b.baz");
        assertEquals("SELECT COUNT(*) FROM sch.tbl a LEFT JOIN sch.tbl b ON a.foo = b.foo AND a.bar = b.baz", q.toSql());
    }


    public void testSimpleSelectFromWhere() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE bar = 'baz' AND baz > 5");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.bar = 'baz' AND tbl.baz > 5", q.toSql());


        FilterClause whereClause = q.getWhereClause();
        assertEquals(2, whereClause.getItemCount());
        assertNull("WHERE item was an expression based item, which indicates it was not parsed", whereClause.getItem(0)
                .getExpression());
        assertEquals(2, whereClause.getItemCount());
        assertNull("WHERE item was an expression based item, which indicates it was not parsed", whereClause.getItem(1)

View Full Code Here

        assertEquals("baz", whereClause.getItem(0).getOperand());
        assertEquals(Integer.class, whereClause.getItem(1).getOperand().getClass());
    }
    
    public void testWhereStringEscaped() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE bar = 'ba\\'z'");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.bar = 'ba'z'", q.toSql());
    }

View Full Code Here

    MutableTable table2 = new MutableTable("bar");
    table2.addColumn(new MutableColumn("col1").setTable(table2));
    table2.addColumn(new MutableColumn("col2").setTable(table2));
    table2.addColumn(new MutableColumn("col3").setTable(table2));


    Query query = new Query().from(table1, "f").from(table2, "b");
    GroupedQueryBuilderImpl gqbi = new GroupedQueryBuilderImpl(dataContext,
        query);


    Column col = gqbi.findColumn("b.col2");
    assertEquals("bar.col2", col.getQualifiedLabel());

View Full Code Here

    public void testWhereOperandIsBoolean() throws Exception {
     // set 'baz' column to an integer column (to influence query generation)
        MutableColumn col = (MutableColumn) dc.getColumnByQualifiedLabel("tbl.baz");
        col.setType(ColumnType.BOOLEAN);
        
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE baz = TRUE");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.baz = TRUE", q.toSql());
    }

View Full Code Here


    Column colA = new MutableColumn("colA", null, tableAB, 0, true);
    Column colB = new MutableColumn("colB", null, tableAB, 1, true);
    Column colC = new MutableColumn("colC", null, tableC, 0, true);


    Query q = dc.query().from(tableAB).leftJoin(tableC).on(colB, colC)
        .select(colA).as("a").select(colB).as("b").select(colC).as("c")
        .toQuery();


    assertEquals(
        "SELECT tableAB.colA AS a, tableAB.colB AS b, tableC.colC AS c FROM tableAB LEFT JOIN tableC ON tableAB.colB = tableC.colC",
        q.toSql());
  }

View Full Code Here

    public void testWhereOperandIsDate() throws Exception {
        // set 'baz' column to an integer column (to influence query generation)
           MutableColumn col = (MutableColumn) dc.getColumnByQualifiedLabel("tbl.baz");
           col.setType(ColumnType.TIME);
           
           Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE baz = 10:24");
           assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.baz = TIME '10:24:00'", q.toSql());
       }

View Full Code Here

           Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE baz = 10:24");
           assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.baz = TIME '10:24:00'", q.toSql());
       }


    public void testCoumpoundWhereClause() throws Exception {
        Query q = MetaModelHelper
                .parseQuery(dc, "SELECT foo FROM sch.tbl WHERE (bar = 'baz' OR (baz > 5 AND baz < 7))");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE (tbl.bar = 'baz' OR (tbl.baz > 5 AND tbl.baz < 7))", q.toSql());


        FilterClause wc = q.getWhereClause();
        assertEquals(1, wc.getItemCount());
        FilterItem item = wc.getItem(0);
        assertTrue(item.isCompoundFilter());


        FilterItem[] childItems = item.getChildItems();

View Full Code Here

        FilterItem bazConditions = childItems[1];
        assertTrue(bazConditions.isCompoundFilter());
    }


    public void testWhereSomethingIsNull() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE bar IS NULL");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.bar IS NULL", q.toSql());


        assertEquals(1, q.getWhereClause().getItemCount());
        assertNull("WHERE item was an expression based item, which indicates it was not parsed", q.getWhereClause()
                .getItem(0).getExpression());
        assertNull(q.getWhereClause().getItem(0).getOperand());
        assertEquals(OperatorType.EQUALS_TO, q.getWhereClause().getItem(0).getOperator());
    }

View Full Code Here

        assertNull(q.getWhereClause().getItem(0).getOperand());
        assertEquals(OperatorType.EQUALS_TO, q.getWhereClause().getItem(0).getOperator());
    }


    public void testWhereSomethingIsNotNull() throws Exception {
        Query q = MetaModelHelper.parseQuery(dc, "SELECT foo FROM sch.tbl WHERE bar IS NOT NULL");
        assertEquals("SELECT tbl.foo FROM sch.tbl WHERE tbl.bar IS NOT NULL", q.toSql());


        assertEquals(1, q.getWhereClause().getItemCount());
        assertNull("WHERE item was an expression based item, which indicates it was not parsed", q.getWhereClause()
                .getItem(0).getExpression());
        assertNull(q.getWhereClause().getItem(0).getOperand());
        assertEquals(OperatorType.DIFFERENT_FROM, q.getWhereClause().getItem(0).getOperator());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.metamodel.query.Query

org.apache.metamodel.AbstractDataContext

org.apache.metamodel.CompositeDataContextTest

org.apache.metamodel.CompositeQueryDelegate

org.apache.metamodel.convert.ConvertedDataSetInterceptorTest

org.apache.metamodel.convert.Converters

org.apache.metamodel.convert.ConvertersTest

org.apache.metamodel.csv.CsvBigFileMemoryTest

org.apache.metamodel.csv.CsvDataContextTest

org.apache.metamodel.DB2Test

org.apache.metamodel.dbmains.PostgresqlMain

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.