Examples of org.teiid.query.sql.proc.CriteriaSelector

org.teiid.query.sql.proc.CriteriaSelector

This class represents the criteria present on the user's query. The type of criteria and the elements on which it is specified are listed in this object, this object is used by HasCriteria and TranslateCriteria objects to determine if a particular type of criteria is present on one or more elements on a user's query

        ElementSymbol sy3 = new ElementSymbol("z"); //$NON-NLS-1$
        List elmnts = new ArrayList(3);
        elmnts.add(sy1);
        elmnts.add(sy2);
        elmnts.add(sy3);                
        CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);
        helpTest(cs, "LIKE CRITERIA ON (x, y, z)"); //$NON-NLS-1$
    }

View Full Code Here

        ElementSymbol sy3 = new ElementSymbol("z"); //$NON-NLS-1$
        List elmnts = new ArrayList(3);
        elmnts.add(sy1);
        elmnts.add(sy2);
        elmnts.add(sy3);                
        CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.BETWEEN, elmnts);
        helpTest(cs, "BETWEEN CRITERIA ON (x, y, z)"); //$NON-NLS-1$
    }

View Full Code Here

    ElementSymbol sy3 = new ElementSymbol("z"); //$NON-NLS-1$
    List elmnts = new ArrayList(3);
    elmnts.add(sy1);
    elmnts.add(sy2);
    elmnts.add(sy3);        
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);
    helpTest(new HasCriteria(cs), "HAS LIKE CRITERIA ON (x, y, z)"); //$NON-NLS-1$
    }

View Full Code Here

        ElementSymbol sy3 = new ElementSymbol("z"); //$NON-NLS-1$
        List elmnts = new ArrayList(3);
        elmnts.add(sy1);
        elmnts.add(sy2);
        elmnts.add(sy3);                
        CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);
        helpTest(new HasCriteria(cs), "HAS LIKE CRITERIA ON (x, y, z)"); //$NON-NLS-1$
    }

View Full Code Here

        ElementSymbol sy3 = new ElementSymbol("z"); //$NON-NLS-1$
        List elmnts = new ArrayList(3);
        elmnts.add(sy1);
        elmnts.add(sy2);
        elmnts.add(sy3);                
        CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.BETWEEN, elmnts);
        helpTest(new HasCriteria(cs), "HAS BETWEEN CRITERIA ON (x, y, z)"); //$NON-NLS-1$
    }

View Full Code Here

      Block ifblock = new Block(cmdStmt);
    // construct If criteria      
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);      
      IfStatement ifStmt = new IfStatement(crit, ifblock);      
      
      // other statements
      RaiseErrorStatement errStmt =  new RaiseErrorStatement(new Constant("My Error")); //$NON-NLS-1$

View Full Code Here


    // construct If criteria      
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);
      
      IfStatement ifStmt = new IfStatement(crit, ifblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\na = 1;\nERROR 'My Error';\nEND"); //$NON-NLS-1$
    }

View Full Code Here


    // construct If criteria      
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);
      
      IfStatement ifStmt = new IfStatement(crit, ifblock);
    helpTest(ifStmt, "IF(HAS LIKE CRITERIA ON (x))\nBEGIN\nDELETE FROM g;\nEND"); //$NON-NLS-1$
    }

View Full Code Here


    // construct If criteria      
    ElementSymbol sy1 = new ElementSymbol("x"); //$NON-NLS-1$
    List elmnts = new ArrayList(1);
    elmnts.add(sy1);
    CriteriaSelector cs = new CriteriaSelector(CriteriaSelector.LIKE, elmnts);      
      Criteria crit = new HasCriteria(cs);
      
      Block elseblock = new Block();
      elseblock.addStatement(cmdStmt);

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of org.teiid.query.sql.proc.CriteriaSelector

org.teiid.query.parser.TestOptionsAndHints

org.teiid.query.parser.TestParser

org.teiid.query.rewriter.QueryRewriter

org.teiid.query.sql.proc.TestCriteriaSelector

org.teiid.query.sql.visitor.AbstractSymbolMappingVisitor

org.teiid.query.sql.visitor.TestSQLStringVisitor

org.teiid.query.sql.visitor.TestStaticSymbolMappingVisitor

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.