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

    }
    
    @Test public void testCriteriaSelector7() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.LIKE);
        critSelector.addElement(a);        
       
        helpCriteriaSelectorTest("LIKE CRITERIA ON (a)", "LIKE CRITERIA ON (a)", critSelector);     //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

    
    
    @Test public void testCriteriaSelector8() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.IN);
        critSelector.addElement(a);        
       
        helpCriteriaSelectorTest("IN CRITERIA ON (a)", "IN CRITERIA ON (a)", critSelector);     //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

    }


    @Test public void testCriteriaSelector9() throws Exception {
        //ElementSymbol a = new ElementSymbol("a");
        
        CriteriaSelector critSelector = new CriteriaSelector();
        //critSelector.setSelectorType(CriteriaSelector.IS_NULL);
        //critSelector.addElement(a);        
       
        helpCriteriaSelectorTest("CRITERIA", "CRITERIA", critSelector);     //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

    }
    
    @Test public void testCriteriaSelector10() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.BETWEEN);
        critSelector.addElement(a);        
       
        helpCriteriaSelectorTest("BETWEEN CRITERIA ON (a)", "BETWEEN CRITERIA ON (a)", critSelector);     //$NON-NLS-1$ //$NON-NLS-2$
    }

View Full Code Here

    @Test public void testHasIsNullCriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.IS_NULL);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS IS NULL CRITERIA ON (a)", "HAS IS NULL CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

View Full Code Here

    @Test public void testHasLikeCriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.LIKE);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS LIKE CRITERIA ON (a)", "HAS LIKE CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

View Full Code Here

    @Test public void testHasEQCriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.COMPARE_EQ);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS = CRITERIA ON (a)", "HAS = CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

View Full Code Here

    @Test public void testHasNECriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.COMPARE_NE);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS <> CRITERIA ON (a)", "HAS <> CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

View Full Code Here

    @Test public void testHasInCriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.IN);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS IN CRITERIA ON (a)", "HAS IN CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

View Full Code Here

    @Test public void testHasLTCriteria() throws Exception {
        ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$
        List elements = new ArrayList();
        elements.add(a);
        
        CriteriaSelector critSelector = new CriteriaSelector();
        critSelector.setSelectorType(CriteriaSelector.COMPARE_LT);
        critSelector.setElements(elements);
        
        HasCriteria hasSelector = new HasCriteria();
        hasSelector.setSelector(critSelector);
        
        helpCriteriaTest("HAS < CRITERIA ON (a)", "HAS < CRITERIA ON (a)", //$NON-NLS-1$ //$NON-NLS-2$

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.