Package org.teiid.language

Examples of org.teiid.language.SetQuery

211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
    @Override
    public List<?> translateCommand(Command command, ExecutionContext context) {
      if (!(command instanceof SetQuery)) {
        return null;
      }
      SetQuery queryCommand = (SetQuery)command;
    if (queryCommand.getLimit() == null) {
      return null;
      }
    Limit limit = queryCommand.getLimit();
    OrderBy orderBy = queryCommand.getOrderBy();
    queryCommand.setLimit(null);
    queryCommand.setOrderBy(null);
    List<Object> parts = new ArrayList<Object>(6);
    parts.add("SELECT "); //$NON-NLS-1$
    parts.addAll(translateLimit(limit, context));
    parts.add(" * FROM ("); //$NON-NLS-1$
    parts.add(queryCommand);
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
       
        Select secondQuery = new Select(symbols2, false, items2, null, null, null, null);
       
        Select query = new Select(symbols, false, items, null, null, null, null);
       
        SetQuery setQuery = new SetQuery();
        setQuery.setOperation(SetQuery.Operation.UNION);
        setQuery.setAll(true);
        setQuery.setLeftQuery(query);
        setQuery.setRightQuery(secondQuery);
       
        return setQuery;
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
       
        return setQuery;
    }
   
    public static SetQuery example3() throws Exception {
        SetQuery union = example2();
       
        List<SortSpecification> items = new ArrayList<SortSpecification>();
        items.add(new SortSpecification(Ordering.ASC, new ColumnReference(null, "nugent", null, DataTypeManager.DefaultDataClasses.STRING))); //$NON-NLS-1$
        OrderBy orderBy = new OrderBy(items);
       
        union.setOrderBy(orderBy);
        return union;
    }
View Full Code Here
101
102
103
104
105
106
107
108
109
    }
   
    public void testNestedSetQuery() throws Exception {
        org.teiid.query.sql.lang.SetQuery query = new org.teiid.query.sql.lang.SetQuery(org.teiid.query.sql.lang.SetQuery.Operation.EXCEPT, true, helpExampleSetQuery(), helpExampleSetQuery());
       
        SetQuery setQuery = TstLanguageBridgeFactory.factory.translate(query);
        assertTrue(setQuery.getLeftQuery() instanceof SetQuery);
        assertTrue(setQuery.getRightQuery() instanceof SetQuery);
    }
View Full Code Here
TOP

Related Classes of org.teiid.language.SetQuery

  • org.teiid.dqp.internal.datamgr.TestSetQueryImpl
  • org.teiid.translator.jdbc.sybase.SybaseExecutionFactory
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.