public void test1() { SetQuery sq = sample1(); assertEquals("Union string doesn't match expected: ", //$NON-NLS-1$ "SELECT x FROM g UNION ALL SELECT y FROM h", //$NON-NLS-1$ sq.toString()); }
public void test3() { SetQuery sq = sample2(); assertEquals("Query combiner string doesn't match expected: ", //$NON-NLS-1$ "SELECT x FROM g INTERSECT SELECT y FROM h ORDER BY x", //$NON-NLS-1$ sq.toString()); }
public void testQuery() { Query q = sample3(); List projList = new ArrayList(); projList.add(new ElementSymbol("xml")); //$NON-NLS-1$ assertEquals("result is not as expected.", //$NON-NLS-1$ projList, q.getProjectedSymbols()); } }
public void test2() { 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); Query q2 = new Query(); select = new Select(); select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$ q2.setSelect(select); from = new From(); from.addGroup(new GroupSymbol("h")); //$NON-NLS-1$ q2.setFrom(from); SetQuery sq = new SetQuery(Operation.INTERSECT); sq.setAll(false); sq.setLeftQuery(q1); sq.setRightQuery(q2); assertEquals("Query combiner string doesn't match expected: ", //$NON-NLS-1$ "SELECT x FROM g INTERSECT SELECT y FROM h", //$NON-NLS-1$ sq.toString()); }