Examples with Query org.teiid.query.sql.lang.Query used on opensource projects

Example 66 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestSetQueryParsing method testSingleValue.

@Test
public void testSingleValue() {
    Select select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("c1"));
    // $NON-NLS-1$
    select.addSymbol(new Constant("x"));
    Query query = new Query();
    query.setSelect(select);
    // $NON-NLS-1$
    TestParser.helpTest(// $NON-NLS-1$
    "values (c1, 'x')", // $NON-NLS-1$
    "SELECT c1, 'x'", query);
}

Example 67 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestSetQueryParsing method exampleSetQuery.

private SetQuery exampleSetQuery(Operation op) {
    // $NON-NLS-1$
    GroupSymbol g = new GroupSymbol("g");
    From from = new From();
    from.addGroup(g);
    Select select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("a"));
    Query query1 = new Query();
    query1.setSelect(select);
    query1.setFrom(from);
    // $NON-NLS-1$
    g = new GroupSymbol("h");
    from = new From();
    from.addGroup(g);
    select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("b"));
    Query query2 = new Query();
    query2.setSelect(select);
    query2.setFrom(from);
    SetQuery setQuery = new SetQuery(op);
    setQuery.setAll(false);
    setQuery.setLeftQuery(query1);
    setQuery.setRightQuery(query2);
    return setQuery;
}

Example 68 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestSetQueryParsing method testTwoUnions.

/**
 * select c1 from g1 union select c2 from g2 union select c3 from g3
 */
@Test
public void testTwoUnions() {
    SetQuery setQuery = new SetQuery(Operation.UNION);
    setQuery.setAll(false);
    // $NON-NLS-1$
    GroupSymbol g = new GroupSymbol("g1");
    From from = new From();
    from.addGroup(g);
    Select select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("c1"));
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    setQuery.setLeftQuery(query);
    // $NON-NLS-1$
    g = new GroupSymbol("g2");
    from = new From();
    from.addGroup(g);
    select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("c2"));
    query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    setQuery.setRightQuery(query);
    // $NON-NLS-1$
    g = new GroupSymbol("g3");
    from = new From();
    from.addGroup(g);
    select = new Select();
    // $NON-NLS-1$
    select.addSymbol(new ElementSymbol("c3"));
    query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    setQuery = new SetQuery(Operation.UNION, false, setQuery, query);
    // $NON-NLS-1$
    TestParser.helpTest(// $NON-NLS-1$
    "select c1 from g1 union select c2 from g2 union select c3 from g3", // $NON-NLS-1$
    "SELECT c1 FROM g1 UNION SELECT c2 FROM g2 UNION SELECT c3 FROM g3", setQuery);
}

Example 69 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestExpressionEvaluator method testScalarSubquery2.

@Test
public void testScalarSubquery2() throws Exception {
    ScalarSubquery expr = new ScalarSubquery(new Query());
    ArrayList values = new ArrayList(1);
    values.add(null);
    helpTestWithValueIterator(expr, values, null);
}

Example 70 with Query

use of org.teiid.query.sql.lang.Query in project teiid by teiid.

the class TestExpressionEvaluator method testScalarSubquery.

@Test
public void testScalarSubquery() throws Exception {
    ScalarSubquery expr = new ScalarSubquery(new Query());
    ArrayList values = new ArrayList(1);
    // $NON-NLS-1$
    values.add("a");
    // $NON-NLS-1$
    Object expected = "a";
    helpTestWithValueIterator(expr, values, expected);
}