Package org.apache.chemistry.opencmis.server.support.query

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

298
299
300
301
302
303
304
305
306
307
308
   

    @Test
    public void resolveTypesWhereWithTwoFromsQualifiedWithAlias() throws Exception {
        String statement = "SELECT * FROM BookType AS MyBookAlias JOIN MyDocType  WHERE MyBookAlias.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
311
312
313
314
315
316
317
318
319
320
321
            assertTrue(colRef.getPropertyQueryName().equals(ISBN_PROP));
        }
    }

    private void verifyResolveWhere(String statement) throws Exception {
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        Map<String,String> types = qo.getTypes();
        assertTrue(1 == types.size());
        List<CmisSelector> wheres = qo.getWhereReferences();
        assertTrue(1 == wheres.size());
View Full Code Here
330
331
332
333
334
335
336
337
338
339
340
    @Test
    public void resolveTypesWhereWithTwoFromsNotUnique() throws Exception {
        String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyStringProp = '100'";
       
        try {
            CmisQueryWalker walker = traverseStatement(statement);
            fail("Select with an unqualified property that is not unique should fail.");
        } catch (Exception e) {
            assertTrue(e instanceof CmisInvalidArgumentException);
            assertTrue(e.getMessage().contains("is not a unique property query name within the types in from"));
        }
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
    }
   
    @Test
    public void resolveTypesWhereWithTwoFromsUniqueByQualifying() throws Exception {
        String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyDocType.MyStringProp = '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
356
357
358
359
360
361
362
363
364
365
366
    }

    @Test
    public void resolveTypesOrderBy() throws Exception {
        String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY TitleAlias";        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
    }

    @Test
    public void resolveTypesOrderBy2() throws Exception {
        String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY BookType.Author";        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
View Full Code Here
386
387
388
389
390
391
392
393
394
395
396
    }

    @Test
    public void resolveTypesOrderBy3() throws Exception {
        String statement = "SELECT Title FROM BookType WHERE ISBN < '100' ORDER BY Author";        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
View Full Code Here
401
402
403
404
405
406
407
408
409
410
411
    }

    @Test
    public void resolveJoinTypesSimple() throws Exception {
        String statement = "SELECT * FROM MyDocType JOIN BookType ON MyDocType.MyStringProp = BookType.Title";        
        CmisQueryWalker walker = traverseStatement(statement);
        QueryObject qo = walker.queryObj;
        List<CmisSelector> joins = qo.getJoinReferences();
        assertTrue(2 == joins.size());
        for (CmisSelector join : joins) {
            assertTrue(join instanceof ColumnReference);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
    @Test
    public void simpleSelectTest1() throws Exception {
        String statement = "SELECT SCORE() FROM cmis:document";
       
        CmisQueryWalker walker = traverseStatementAndCatchExc(statement);
        QueryObject select = walker.queryObj;
        List<CmisSelector> selects = select.getSelectReferences();
        assertTrue(1 == selects.size());
        assertTrue(selects.get(0) instanceof FunctionReference);
        FunctionReference funcRef = ((FunctionReference)selects.get(0));
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
    }
   
    @Test
    public void simpleSelectTest2() throws Exception {
        String statement = "SELECT abc FROM cmis:document";        
        CmisQueryWalker walker = traverseStatementAndCatchExc(statement);
        QueryObject select = walker.queryObj;
        List<CmisSelector> selects = queryObj.getSelectReferences();
        assertTrue(1 == selects.size());
        // nothing should be in where references
        assertTrue(0 == select.getWhereReferences().size());
View Full Code Here
TOP

Related Classes of org.apache.chemistry.opencmis.server.support.query.CmisQueryWalker

  • org.apache.chemistry.opencmis.inmemory.query.AbstractQueryConditionProcessor
  • org.apache.chemistry.opencmis.inmemory.query.AbstractQueryTest
  • org.apache.chemistry.opencmis.inmemory.query.InMemoryQueryProcessor
  • org.apache.chemistry.opencmis.inmemory.query.QueryParseTest
  • org.apache.chemistry.opencmis.inmemory.query.QueryTypesTest
  • org.apache.chemistry.opencmis.jcr.query.QueryTranslator
  • org.apache.chemistry.opencmis.server.support.query.AbstractQueryConditionProcessor
    • 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.