/** * Constructs an instance of this class given the specified clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setOrderBy( orderBy ); setOption( option ); }
/** * Constructs an instance of this class given the specified clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setOrderBy( orderBy ); setOption( option ); }
/** * Constructs an instance of this class given the specified clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setOrderBy( orderBy ); setOption( option ); }
/** * Constructs an instance of this class given all the clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param groupBy GROUP BY clause * @param having HAVING clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, GroupBy groupBy, Criteria having, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setGroupBy( groupBy ); setHaving( having ); setOrderBy( orderBy ); setOption( option ); }
/** * Constructs an instance of this class given all the clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param groupBy GROUP BY clause * @param having HAVING clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, GroupBy groupBy, Criteria having, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setGroupBy( groupBy ); setHaving( having ); setOrderBy( orderBy ); setOption( option ); }
/** * Constructs an instance of this class given all the clauses * @param select SELECT clause * @param from FROM clause * @param criteria WHERE clause * @param groupBy GROUP BY clause * @param having HAVING clause * @param orderBy ORDER BY clause * @param option OPTION clause */ public Query( Select select, From from, Criteria criteria, GroupBy groupBy, Criteria having, OrderBy orderBy, Option option ) { super(); setSelect( select ); setFrom( from ); setCriteria( criteria ); setGroupBy( groupBy ); setHaving( having ); setOrderBy( orderBy ); setOption( option ); }
ExpressionMappingVisitor.mapExpressions(select, expressionMap, true); outerQuery.setSelect(select); outerQuery.setOption(query.getOption()); query = outerQuery; return query;
ExpressionMappingVisitor.mapExpressions(select, expressionMap, true); outerQuery.setSelect(select); outerQuery.setOption(query.getOption()); query = outerQuery; return query;
query.setOption(nested.getOption()!=null?(Option) nested.getOption().clone():null); from.getClauses().clear(); SubqueryFromClause sqfc = new SubqueryFromClause(inlineGroup.getName());
query.setOption(nested.getOption()!=null?(Option) nested.getOption().clone():null); from.getClauses().clear(); SubqueryFromClause sqfc = new SubqueryFromClause(inlineGroup.getName());
query.setOption(nested.getOption()!=null?(Option) nested.getOption().clone():null); from.getClauses().clear(); SubqueryFromClause sqfc = new SubqueryFromClause(inlineGroup.getName());
@Test public void testOptionNoCache3(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.setNoCache(true); Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option nocache", //$NON-NLS-1$ "SELECT a FROM db.g OPTION NOCACHE", //$NON-NLS-1$ query); }
@Test public void testOptionMakeDependent1(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addDependentGroup("a.b.c"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makedep a.b.c", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKEDEP a.b.c", //$NON-NLS-1$ query); }
@Test public void testOptionMakeNotDependent1(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addNotDependentGroup("a.b.c"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makenotdep a.b.c", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKENOTDEP a.b.c", //$NON-NLS-1$ query); }
@Test public void testOptionNoCache1(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.setNoCache(true); option.addNoCacheGroup("a.b.c"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option nocache a.b.c", //$NON-NLS-1$ "SELECT a FROM db.g OPTION NOCACHE a.b.c", //$NON-NLS-1$ query); }
@Test public void testOptionMakeDependent2(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addDependentGroup("a.b.c"); //$NON-NLS-1$ option.addDependentGroup("d.e.f"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makedep a.b.c, d.e.f", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKEDEP a.b.c, d.e.f", //$NON-NLS-1$ query); }
@Test public void testOptionMakeNotDependent2(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addNotDependentGroup("a.b.c"); //$NON-NLS-1$ option.addNotDependentGroup("d.e.f"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makeNOTdep a.b.c, d.e.f", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKENOTDEP a.b.c, d.e.f", //$NON-NLS-1$ query); }
@Test public void testOptionMakeNotDependent3(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addNotDependentGroup("a.b.c"); //$NON-NLS-1$ option.addNotDependentGroup("d.e.f"); //$NON-NLS-1$ option.addNotDependentGroup("x.y.z"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makenotdep a.b.c, d.e.f, x.y.z", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKENOTDEP a.b.c, d.e.f, x.y.z", //$NON-NLS-1$ query); }
@Test public void testOptionNoCache2(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.setNoCache(true); option.addNoCacheGroup("a.b.c"); //$NON-NLS-1$ option.addNoCacheGroup("d.e.f"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option nocache a.b.c, d.e.f", //$NON-NLS-1$ "SELECT a FROM db.g OPTION NOCACHE a.b.c, d.e.f", //$NON-NLS-1$ query); }
@Test public void testOptionMakeDependent3(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Option option = new Option(); option.addDependentGroup("a.b.c"); //$NON-NLS-1$ option.addDependentGroup("d.e.f"); //$NON-NLS-1$ option.addDependentGroup("x.y.z"); //$NON-NLS-1$ Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setOption(option); TestParser.helpTest("Select a From db.g Option makedep a.b.c, d.e.f, x.y.z", //$NON-NLS-1$ "SELECT a FROM db.g OPTION MAKEDEP a.b.c, d.e.f, x.y.z", //$NON-NLS-1$ query); }