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

Example 16 with Select

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

the class TestExpressionMappingVisitor method testSelectAlias1.

@Test
public void testSelectAlias1() {
    // $NON-NLS-1$
    ElementSymbol x = new ElementSymbol("y.x");
    // $NON-NLS-1$
    ElementSymbol y = new ElementSymbol("z.x");
    HashMap<ElementSymbol, ElementSymbol> map = new HashMap<ElementSymbol, ElementSymbol>();
    map.put(x, y);
    LanguageObject toMap = new Select(Arrays.asList(x));
    ExpressionMappingVisitor.mapExpressions(toMap, map);
    // $NON-NLS-1$ //$NON-NLS-2$
    assertEquals("Did not get expected mapped expression", " z.x", toMap.toString());
}

Example 17 with Select

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

the class TestExpressionMappingVisitor method testSelectAlias.

@Test
public void testSelectAlias() {
    // $NON-NLS-1$
    ElementSymbol x = new ElementSymbol("y.x");
    // $NON-NLS-1$
    ElementSymbol y = new ElementSymbol("z.X");
    HashMap<Expression, Expression> map = new HashMap<Expression, Expression>();
    map.put(x, y);
    LanguageObject toMap = new Select(Arrays.asList(x));
    ExpressionMappingVisitor.mapExpressions(toMap, map);
    // $NON-NLS-1$ //$NON-NLS-2$
    assertEquals("Did not get expected mapped expression", " z.X AS x", toMap.toString());
}

Example 18 with Select

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

the class TestASTQueries method sampleQuery.

private Query sampleQuery() {
    List<ElementSymbol> symbols = new ArrayList<ElementSymbol>();
    // $NON-NLS-1$
    symbols.add(new ElementSymbol("e1"));
    // $NON-NLS-1$
    symbols.add(new ElementSymbol("e2"));
    Select select = new Select(symbols);
    From from = new From();
    // $NON-NLS-1$
    from.addGroup(new GroupSymbol("G1"));
    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    return query;
}

Example 19 with Select

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

the class TestLimitParsing method testLimitWithReferences3.

@Test
public void testLimitWithReferences3() {
    Query query = new Query();
    Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
    // $NON-NLS-1$
    From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a"))));
    query.setSelect(select);
    query.setFrom(from);
    query.setLimit(new Limit(new Reference(0), new Reference(1)));
    // $NON-NLS-1$ //$NON-NLS-2$
    helpTest("Select * from a limit ?,?", "SELECT * FROM a LIMIT ?, ?", query);
}

Example 20 with Select

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

the class TestLimitParsing method testLimitWithOffset.

@Test
public void testLimitWithOffset() {
    Query query = new Query();
    Select select = new Select(Arrays.asList(new MultipleElementSymbol()));
    // $NON-NLS-1$
    From from = new From(Arrays.asList(new UnaryFromClause(new GroupSymbol("a"))));
    query.setSelect(select);
    query.setFrom(from);
    query.setLimit(new Limit(new Constant(new Integer(50)), new Constant(new Integer(100))));
    // $NON-NLS-1$ //$NON-NLS-2$
    helpTest("Select * from a limit 50,100", "SELECT * FROM a LIMIT 50, 100", query);
}