org.teiid.query.sql.lang.Query.setCriteria()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(13.0k)|赞(0)|评价(0)|浏览(638)

本文整理了Java中org.teiid.query.sql.lang.Query.setCriteria方法的一些代码示例，展示了Query.setCriteria的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query.setCriteria方法的具体详情如下：
包路径：org.teiid.query.sql.lang.Query
类名称：Query
方法名：setCriteria

Query.setCriteria介绍

[英]Set the criteria clause for the query.
[中]设置查询的条件子句。

代码示例

代码示例来源：origin: org.teiid/teiid-engine

  1. /**
  2.  * Constructs an instance of this class given the specified clauses
  3.  * @param select SELECT clause
  4.  * @param from FROM clause
  5.  * @param criteria WHERE clause
  6.  * @param orderBy ORDER BY clause
  7.  * @param option OPTION clause
  8.  */
  9. public Query( Select select, From from, Criteria criteria, OrderBy orderBy, Option option ) {
  10.   super();
  11.   setSelect( select );
  12.   setFrom( from );
  13.   setCriteria( criteria );
  14.   setOrderBy( orderBy );
  15.   setOption( option );
  16. }

代码示例来源：origin: teiid/teiid

  1. /**
  2.  * Constructs an instance of this class given the specified clauses
  3.  * @param select SELECT clause
  4.  * @param from FROM clause
  5.  * @param criteria WHERE clause
  6.  * @param orderBy ORDER BY clause
  7.  * @param option OPTION clause
  8.  */
  9. public Query( Select select, From from, Criteria criteria, OrderBy orderBy, Option option ) {
  10.   super();
  11.   setSelect( select );
  12.   setFrom( from );
  13.   setCriteria( criteria );
  14.   setOrderBy( orderBy );
  15.   setOption( option );
  16. }

代码示例来源：origin: org.teiid/teiid-olingo

  1. private Query buildSubquery(DocumentNode eResource,
  2.     org.teiid.query.sql.symbol.Expression projected) {
  3.   Select s1 = new Select();
  4.   s1.addSymbol(projected); 
  5.   
  6.   Query q = new Query();
  7.   From from = new From();
  8.   from.addGroup(eResource.getGroupSymbol());
  9.   q.setFrom(from);    
  10.   q.setCriteria(DocumentNode.buildJoinCriteria(eResource, this.ctxQuery));
  11.   
  12.   q.setSelect(s1);
  13.   return q;
  14. }

代码示例来源：origin: org.teiid/teiid-olingo

  1. public QueryCommand buildRootSubQuery(String element, DocumentNode resource) {
  2.     Select s1 = new Select();
  3.     s1.addSymbol(new ElementSymbol(element, resource.getGroupSymbol())); 
  4.     From f1 = new From();
  5.     f1.addGroup(resource.getGroupSymbol());
  6.     Query q1 = new Query();
  7.     q1.setSelect(s1);
  8.     q1.setFrom(f1);    
  9.     q1.setCriteria(resource.getCriteria());  
  10.     return q1;
  11.   }
  12. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testAndOrPrecedence_1575() {
  2.   Select s = new Select();
  3.   s.addSymbol(new MultipleElementSymbol());
  4.   From f = new From();
  5.   f.addGroup(new GroupSymbol("m.g1")); //$NON-NLS-1$
  6.   CompareCriteria c1 = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(0))); //$NON-NLS-1$
  7.   CompareCriteria c2 = new CompareCriteria(new ElementSymbol("e2"), CompareCriteria.EQ, new Constant(new Integer(1))); //$NON-NLS-1$
  8.   CompareCriteria c3 = new CompareCriteria(new ElementSymbol("e3"), CompareCriteria.EQ, new Constant(new Integer(3))); //$NON-NLS-1$
  9.   CompoundCriteria cc1 = new CompoundCriteria(CompoundCriteria.AND, c2, c3);        
  10.   CompoundCriteria cc2 = new CompoundCriteria(CompoundCriteria.OR, c1, cc1);
  11.   Query q = new Query();
  12.   q.setSelect(s);
  13.   q.setFrom(f);
  14.   q.setCriteria(cc2);
  15.   
  16.   helpTest("SELECT * FROM m.g1 WHERE e1=0 OR e2=1 AND e3=3", //$NON-NLS-1$
  17.   "SELECT * FROM m.g1 WHERE (e1 = 0) OR ((e2 = 1) AND (e3 = 3))", q);                          //$NON-NLS-1$
  18. }

代码示例来源：origin: teiid/teiid

  1. public void testHasNoCriteria2() {
  2.   Query query = new Query();
  3.   CompareCriteria crit = new CompareCriteria(new Constant("a"), CompareCriteria.EQ, new Constant("b")); //$NON-NLS-1$ //$NON-NLS-2$
  4.   query.setCriteria(crit);        
  5.   assertEquals("Got incorrect answer checking for no criteria", false, RuleValidateWhereAll.hasNoCriteria(query)); //$NON-NLS-1$
  6. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testQuery6() {
  2.   Select select = new Select();
  3.   select.addSymbol(new MultipleElementSymbol());
  4.   From from = new From();
  5.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  6.   CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
  7.   GroupBy groupBy = new GroupBy();
  8.   groupBy.addSymbol(new ElementSymbol("e1")); //$NON-NLS-1$
  9.   CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
  10.   
  11.   Query query = new Query();
  12.   query.setSelect(select);
  13.   query.setFrom(from);
  14.   query.setCriteria(cc);
  15.   query.setGroupBy(groupBy);
  16.   query.setHaving(having);
  17.   
  18.   helpTest(query, "SELECT * FROM m.g WHERE e1 = 5 GROUP BY e1 HAVING e1 > 0");		     //$NON-NLS-1$
  19. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testQuery4() {
  2.   Select select = new Select();
  3.   select.addSymbol(new MultipleElementSymbol());
  4.   From from = new From();
  5.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  6.   CompareCriteria cc = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, new Constant(new Integer(5))); //$NON-NLS-1$
  7.   CompareCriteria having = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.GT, new Constant(new Integer(0))); //$NON-NLS-1$
  8.   OrderBy orderBy = new OrderBy();
  9.   orderBy.addVariable(new ElementSymbol("e1")); //$NON-NLS-1$
  10.   
  11.   Query query = new Query();
  12.   query.setSelect(select);
  13.   query.setFrom(from);
  14.   query.setCriteria(cc);
  15.   query.setHaving(having);
  16.   query.setOrderBy(orderBy);
  17.   
  18.   helpTest(query, "SELECT * FROM m.g WHERE e1 = 5 HAVING e1 > 0 ORDER BY e1");		     //$NON-NLS-1$
  19. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testEscapedFunction3() {
  2.   String sql = "SELECT * FROM a.thing WHERE e1 = {fn cast(5 as string)}"; //$NON-NLS-1$
  3.   
  4.   Query query = new Query();
  5.   Select select = new Select();
  6.   select.addSymbol(new MultipleElementSymbol());
  7.   query.setSelect(select);
  8.   From from = new From();
  9.   from.addGroup(new GroupSymbol("a.thing")); //$NON-NLS-1$
  10.   query.setFrom(from);           
  11.   Function function = new Function("cast", new Expression[] { new Constant(new Integer(5)), new Constant("string")}); //$NON-NLS-1$ //$NON-NLS-2$
  12.   CompareCriteria crit = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, function); //$NON-NLS-1$
  13.   query.setCriteria(crit);
  14.   helpTest(sql, "SELECT * FROM a.thing WHERE e1 = cast(5 AS string)", query);         //$NON-NLS-1$
  15. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testEscapedFunction2() {
  2.   String sql = "SELECT * FROM a.thing WHERE e1 = {fn convert(5, string)}"; //$NON-NLS-1$
  3.   
  4.   Query query = new Query();
  5.   Select select = new Select();
  6.   select.addSymbol(new MultipleElementSymbol());
  7.   query.setSelect(select);
  8.   From from = new From();
  9.   from.addGroup(new GroupSymbol("a.thing")); //$NON-NLS-1$
  10.   query.setFrom(from);           
  11.   Function function = new Function("convert", new Expression[] { new Constant(new Integer(5)), new Constant("string")}); //$NON-NLS-1$ //$NON-NLS-2$
  12.   CompareCriteria crit = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, function); //$NON-NLS-1$
  13.   query.setCriteria(crit);
  14.   helpTest(sql, 
  15.     "SELECT * FROM a.thing WHERE e1 = convert(5, string)",  //$NON-NLS-1$
  16.     query);        
  17. }

代码示例来源：origin: teiid/teiid

  1. public static SubqueryFromClause example1() {
  2.   Query query = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
  5.   select.addSymbol(new ElementSymbol("b"));         //$NON-NLS-1$
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  9.   query.setFrom(from);
  10.   CompareCriteria crit = new CompareCriteria();
  11.   crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
  12.   crit.setRightExpression(new Constant(new Integer(5)));
  13.   crit.setOperator(CompareCriteria.EQ);
  14.   query.setCriteria(crit);
  15.   
  16.   return new SubqueryFromClause("temp", query); //$NON-NLS-1$
  17. }

代码示例来源：origin: teiid/teiid

  1. public static SubqueryFromClause example3() {
  2.   Query query = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
  5.   select.addSymbol(new ElementSymbol("b"));         //$NON-NLS-1$
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  9.   query.setFrom(from);
  10.   CompareCriteria crit = new CompareCriteria();
  11.   crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
  12.   crit.setRightExpression(new Constant(new Integer(5)));
  13.   crit.setOperator(CompareCriteria.EQ);
  14.   query.setCriteria(crit);
  15.   
  16.   return new SubqueryFromClause("temp2", query); //$NON-NLS-1$
  17. }

代码示例来源：origin: teiid/teiid

  1. public static SubqueryFromClause example2() {
  2.   Query query = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("c")); //$NON-NLS-1$
  5.   select.addSymbol(new ElementSymbol("d"));         //$NON-NLS-1$
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("m.g2")); //$NON-NLS-1$
  9.   query.setFrom(from);
  10.   CompareCriteria crit = new CompareCriteria();
  11.   crit.setLeftExpression(new ElementSymbol("c")); //$NON-NLS-1$
  12.   crit.setRightExpression(new Constant(new Integer(10)));
  13.   crit.setOperator(CompareCriteria.EQ);
  14.   query.setCriteria(crit);
  15.   
  16.   return new SubqueryFromClause("temp", query); //$NON-NLS-1$
  17. }

代码示例来源：origin: teiid/teiid

  1. public static SubquerySetCriteria example1() {
  2.   Query query = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
  5.   select.addSymbol(new ElementSymbol("b"));         //$NON-NLS-1$
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  9.   query.setFrom(from);
  10.   CompareCriteria crit = new CompareCriteria();
  11.   crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
  12.   crit.setRightExpression(new Constant(new Integer(5)));
  13.   crit.setOperator(CompareCriteria.EQ);
  14.   query.setCriteria(crit);                
  15.   
  16.   return new SubquerySetCriteria(new ElementSymbol("temp"), query); //$NON-NLS-1$
  17. }

代码示例来源：origin: teiid/teiid

  1. public static SubquerySetCriteria example3() {
  2.   Query query = new Query();
  3.   Select select = new Select();
  4.   select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$
  5.   select.addSymbol(new ElementSymbol("b"));         //$NON-NLS-1$
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$
  9.   query.setFrom(from);
  10.   CompareCriteria crit = new CompareCriteria();
  11.   crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$
  12.   crit.setRightExpression(new Constant(new Integer(5)));
  13.   crit.setOperator(CompareCriteria.EQ);
  14.   query.setCriteria(crit);
  15.   
  16.   return new SubquerySetCriteria(new ElementSymbol("temp2"), query); //$NON-NLS-1$
  17. }

代码示例来源：origin: teiid/teiid

  1. /** Select a From db.g Where Not a IS NULL */
  2. @Test public void testNotIsNullCriteria(){
  3.   GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$
  4.   From from = new From();
  5.   from.addGroup(g);
  6.   Select select = new Select();
  7.   ElementSymbol a = new ElementSymbol("a");  //$NON-NLS-1$
  8.   select.addSymbol(a);
  9.   Criteria crit = new NotCriteria(new IsNullCriteria(a));
  10.   Query query = new Query();
  11.   query.setSelect(select);
  12.   query.setFrom(from);
  13.   query.setCriteria(crit);
  14.   helpTest("Select a From db.g Where Not a IS NULL",  //$NON-NLS-1$
  15.        "SELECT a FROM db.g WHERE NOT (a IS NULL)",  //$NON-NLS-1$
  16.        query);
  17. }

代码示例来源：origin: teiid/teiid

  1. /** SELECT * FROM model.doc WHERE ab.cd.@ef = 'abc' */
  2. @Test public void testXMLCriteriaWithAttribute() {
  3.   GroupSymbol g = new GroupSymbol("model.doc"); //$NON-NLS-1$
  4.   From from = new From();
  5.   from.addGroup(g);
  6.   Select select = new Select();
  7.   select.addSymbol(new MultipleElementSymbol());
  8.   Query query = new Query();
  9.   query.setSelect(select);
  10.   query.setFrom(from);
  11.   
  12.   ElementSymbol elem = new ElementSymbol("ab.cd.@ef"); //$NON-NLS-1$
  13.   query.setCriteria(new CompareCriteria(elem, CompareCriteria.EQ, new Constant("abc"))); //$NON-NLS-1$
  14.   helpTest("SELECT * FROM model.doc WHERE ab.cd.@ef = 'abc'",  //$NON-NLS-1$
  15.        "SELECT * FROM model.doc WHERE ab.cd.@ef = 'abc'",  //$NON-NLS-1$
  16.        query);   
  17. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testUnicode2() {
  2.   String sql = "SELECT * FROM TestDocument.TestDocument WHERE Subject='\u0041\u005a'";  //$NON-NLS-1$
  3.   Query query = new Query();
  4.   Select select = new Select();
  5.   select.addSymbol(new MultipleElementSymbol());
  6.   query.setSelect(select);
  7.   From from = new From();
  8.   from.addGroup(new GroupSymbol("TestDocument.TestDocument")); //$NON-NLS-1$
  9.   query.setFrom(from);           
  10.   CompareCriteria crit = new CompareCriteria(new ElementSymbol("Subject"), CompareCriteria.EQ, new Constant("AZ")); //$NON-NLS-1$ //$NON-NLS-2$
  11.   query.setCriteria(crit);
  12.   helpTest(sql, query.toString(), query);
  13. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testEscapedFunction1() {
  2.   String sql = "SELECT * FROM a.thing WHERE e1 = {fn concat('a', 'b')}"; //$NON-NLS-1$
  3.   
  4.   Query query = new Query();
  5.   Select select = new Select();
  6.   select.addSymbol(new MultipleElementSymbol());
  7.   query.setSelect(select);
  8.   From from = new From();
  9.   from.addGroup(new GroupSymbol("a.thing")); //$NON-NLS-1$
  10.   query.setFrom(from);           
  11.   Function function = new Function("concat", new Expression[] { new Constant("a"), new Constant("b")}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
  12.   CompareCriteria crit = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, function); //$NON-NLS-1$
  13.   query.setCriteria(crit);
  14.   helpTest(sql, 
  15.     "SELECT * FROM a.thing WHERE e1 = concat('a', 'b')",  //$NON-NLS-1$
  16.     query);        
  17. }

代码示例来源：origin: teiid/teiid

  1. @Test public void testEscapedFunction4() {
  2.   String sql = "SELECT * FROM a.thing WHERE e1 = {fn concat({fn concat('a', 'b')}, 'c')}"; //$NON-NLS-1$
  3.   
  4.   Query query = new Query();
  5.   Select select = new Select();
  6.   select.addSymbol(new MultipleElementSymbol());
  7.   query.setSelect(select);
  8.   From from = new From();
  9.   from.addGroup(new GroupSymbol("a.thing")); //$NON-NLS-1$
  10.   query.setFrom(from);           
  11.   Function func1 = new Function("concat", new Expression[] { new Constant("a"), new Constant("b")}); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$
  12.   Function func2 = new Function("concat", new Expression[] { func1, new Constant("c")}); //$NON-NLS-1$ //$NON-NLS-2$
  13.   CompareCriteria crit = new CompareCriteria(new ElementSymbol("e1"), CompareCriteria.EQ, func2); //$NON-NLS-1$
  14.   query.setCriteria(crit);
  15.   helpTest(sql, "SELECT * FROM a.thing WHERE e1 = concat(concat('a', 'b'), 'c')", query);         //$NON-NLS-1$
  16. }

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com