private Query buildSubquery(DocumentNode eResource, org.teiid.query.sql.symbol.Expression projected) { Select s1 = new Select(); s1.addSymbol(projected); Query q = new Query(); From from = new From(); from.addGroup(eResource.getGroupSymbol()); q.setFrom(from); q.setCriteria(DocumentNode.buildJoinCriteria(eResource, this.ctxQuery)); q.setSelect(s1); return q; }
public QueryCommand buildRootSubQuery(String element, DocumentNode resource) { Select s1 = new Select(); s1.addSymbol(new ElementSymbol(element, resource.getGroupSymbol())); From f1 = new From(); f1.addGroup(resource.getGroupSymbol()); Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); q1.setCriteria(resource.getCriteria()); return q1; } }
private Query createTestQuery(String group) { GroupSymbol g = new GroupSymbol(group); From from = new From(); from.addGroup(g); Select select = new Select(); select.addSymbol(new MultipleElementSymbol()); Query query1 = new Query(); query1.setSelect(select); query1.setFrom(from); return query1; }
public Query createBaseQuery() throws Exception { Query query = new Query(); Select select = new Select(); select.addSymbol(getElementSymbol(1,1)); query.setSelect(select); From from = new From(); from.addGroup(getPhysicalGroup(1)); query.setFrom(from); return query; }
public static final Query sample2() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("xml")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("xmltest.doc1")); //$NON-NLS-1$ q1.setFrom(from); return q1; }
/** SELECT xml FROM xmltest.doc1 */ public static final Query sample3() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("xml")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("xmltest.doc1")); //$NON-NLS-1$ q1.setFrom(from); return q1; }
public static final Query query1() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$ q1.setFrom(from); return q1; }
public static final Query query2() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("x2")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("g2")); //$NON-NLS-1$ q1.setFrom(from); return q1; }
@Test public void testElementInDoubleQuotes_Update() throws Exception { GroupSymbol g = new GroupSymbol("x"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); ElementSymbol e = new ElementSymbol("foo"); //$NON-NLS-1$ Update query = new Update(); query.setGroup(g); query.addChange(e, new Constant("bar", String.class)); //$NON-NLS-1$ helpTest("update x set \"foo\"='bar'", //$NON-NLS-1$ "UPDATE x SET foo = 'bar'", //$NON-NLS-1$ query); }
@Test public void testElementInDoubleQuotes_delete() throws Exception { GroupSymbol g = new GroupSymbol("x"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); ElementSymbol e = new ElementSymbol("foo"); //$NON-NLS-1$ CompareCriteria c = new CompareCriteria(e, CompareCriteria.EQ, new Constant("bar", String.class)); //$NON-NLS-1$ Delete query = new Delete(g,c); helpTest("delete from x where \"foo\"='bar'", //$NON-NLS-1$ "DELETE FROM x WHERE foo = 'bar'", //$NON-NLS-1$ query); }
@Test public void testQuery1() { Select select = new Select(); select.addSymbol(new MultipleElementSymbol()); From from = new From(); from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); helpTest(query, "SELECT * FROM m.g"); //$NON-NLS-1$ }
@Test public void testFunctionWithUnderscore() { String sql = "SELECT yowza_yowza() FROM a.thing"; //$NON-NLS-1$ Query query = new Query(); Select select = new Select(); Function func1 = new Function("yowza_yowza", new Expression[] { }); //$NON-NLS-1$ select.addSymbol(func1); query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("a.thing")); //$NON-NLS-1$ query.setFrom(from); helpTest(sql, "SELECT yowza_yowza() FROM a.thing", query); //$NON-NLS-1$ }
@Test public void testCommandStatement1() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$ q1.setFrom(from); CommandStatement cmdStmt = new CommandStatement(q1); helpTest(cmdStmt, "SELECT x FROM g;"); //$NON-NLS-1$ }
@Test public void testExistsCriteria1() { Select s1 = new Select(); s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ From f1 = new From(); f1.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); ExistsCriteria ec = new ExistsCriteria(q1); helpTest(ec, "EXISTS (SELECT e1 FROM m.g1)"); //$NON-NLS-1$ }
@Test public void testScalarSubquery() { Select s1 = new Select(); s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ From f1 = new From(); f1.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); ScalarSubquery obj = new ScalarSubquery(q1); helpTest(obj, "(SELECT e1 FROM m.g1)"); //$NON-NLS-1$ }
@Test public void testUnicode4() { String sql = "SELECT \u05e0 FROM g"; //$NON-NLS-1$ Query query = new Query(); Select select = new Select(); ElementSymbol e = new ElementSymbol("\u05e0"); //$NON-NLS-1$ select.addSymbol(e); From from = new From(); from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$ query.setSelect(select); query.setFrom(from); helpTest(sql, query.toString(), query); }
@Test public void testSubqueryFromClause1() { Select s1 = new Select(); s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ From f1 = new From(); f1.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); SubqueryFromClause sfc = new SubqueryFromClause("temp", q1); //$NON-NLS-1$ helpTest(sfc, "(SELECT e1 FROM m.g1) AS temp"); //$NON-NLS-1$ }
@Test public void testOptionalSubqueryFromClause1() { Select s1 = new Select(); s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ From f1 = new From(); f1.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); SubqueryFromClause sfc = new SubqueryFromClause("temp", q1); //$NON-NLS-1$ sfc.setOptional(true); helpTest(sfc, "/*+ optional */ (SELECT e1 FROM m.g1) AS temp"); //$NON-NLS-1$ }
@Test public void testCommandStatement1a() { Query q1 = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$ q1.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("g")); //$NON-NLS-1$ q1.setFrom(from); CommandStatement cmdStmt = new CommandStatement(q1); cmdStmt.setReturnable(false); helpTest(cmdStmt, "SELECT x FROM g WITHOUT RETURN;"); //$NON-NLS-1$ }
@Test public void testSubqueryCompareCriteria2() { Select s1 = new Select(); s1.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$ From f1 = new From(); f1.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$ Query q1 = new Query(); q1.setSelect(s1); q1.setFrom(f1); ElementSymbol expr = new ElementSymbol("e2"); //$NON-NLS-1$ SubqueryCompareCriteria scc = new SubqueryCompareCriteria(expr, q1, SubqueryCompareCriteria.LE, SubqueryCompareCriteria.SOME); helpTest(scc, "e2 <= SOME (SELECT e1 FROM m.g1)"); //$NON-NLS-1$ }