Examples of CmisQueryWalker

org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker
CMISQL tree grammar, walker for the inmemory implementation. This aims at implementing proper semantics without any speed optimization.

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    }
    
    @Test
    public void simpleSortTest2() throws Exception {
        String statement = "SELECT * FROM MyType ORDER BY def DESC";        
        CmisQueryWalker walker = traverseStatementAndCatchExc(statement);
        List<SortSpec> orderBys = walker.queryObj.getOrderBys();
        assertTrue(1 == orderBys.size());
        SortSpec sp = orderBys.get(0);
        assertFalse(sp.isAscending());
        CmisSelector sortSpec = sp.getSelector();

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker


    @Test
    public void doubleFromTest() throws Exception {
        String statement = "SELECT * FROM MyType JOIN YourType WHERE a='1'"; 
        
        CmisQueryWalker walker = traverseStatementAndCatchExc(statement);
        QueryObject from = walker.queryObj;
        Map<String,String> types = from.getTypes();
        assertTrue(2 == types.size());
    }

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

        String statement = "SELECT BookType.Author, BookType.Title TitleAlias FROM BookType WHERE TitleAlias <> 'Harry Potter'"; 
        verifyResolveSelect(statement);
    }


    private void verifyResolveSelect(String statement) throws Exception {
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(1 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(2 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    
    @Test
    public void resolveTypesWithTwoFromsQualified() throws Exception {
        String statement = "SELECT BookType.Title, MyDocType.MyStringProp FROM BookType JOIN MyDocType WHERE BookType.ISBN = '100'"; 
        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(2 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(2 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker


    @Test
    public void resolveTypesWithTwoFromsUnqualified() throws Exception {
        String statement = "SELECT Title, MyStringProp FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'"; 
        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(2 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(2 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker


    @Test
    public void resolveTypesWithTwoFromsUniqueByQualifying() throws Exception {
        String statement = "SELECT MyDocType.MyStringProp FROM MyDocTypeCopy JOIN MyDocType"; 
        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(2 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(1 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    }


    @Test
    public void resolveTypesTest11() throws Exception {
        String statement = "SELECT BookType.* FROM BookType WHERE ISBN = '100'"; 
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(1 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(1 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    }


    @Test
    public void resolveTypesTest12() throws Exception {
        String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType"; 
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(2 == types.size());
        List<CmisSelector> selects = qo.getSelectReferences();
        assertTrue(1 == selects.size());

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    }


    @Test
    public void resolveTypesWhereWithTwoFromsUnqualified() throws Exception {
        String statement = "SELECT * FROM BookType JOIN MyDocType WHERE ISBN = '100'"; 
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<CmisSelector> wheres = qo.getWhereReferences();
        assertTrue(1 == wheres.size());
        for (CmisSelector where : wheres) {
            assertTrue(where instanceof ColumnReference);

View Full Code Here

Examples of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

    }


    @Test
    public void resolveTypesWhereWithTwoFromsQualified() throws Exception {
        String statement = "SELECT * FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'"; 
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<CmisSelector> wheres = qo.getWhereReferences();
        assertTrue(1 == wheres.size());
        for (CmisSelector where : wheres) {
            assertTrue(where instanceof ColumnReference);

View Full Code Here

0 1 2 3 4 5

TOP

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.