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

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

319
320
321
322
323
324
325
326
327
328
        assertTrue(1 == types.size());
        List<CmisSelector> wheres = qo.getWhereReferences();
        assertTrue(1 == wheres.size());
        for (CmisSelector where : wheres) {
            assertTrue(where instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) where);
            assertEquals(bookType, colRef.getTypeDefinition());
            assertTrue(colRef.getPropertyQueryName().equals(ISBN_PROP));
        }
    }
View Full Code Here
347
348
349
350
351
352
353
354
355
356
        QueryObject qo = walker.queryObj;
        List<CmisSelector> wheres = qo.getWhereReferences();
        assertTrue(1 == wheres.size());
        for (CmisSelector where : wheres) {
            assertTrue(where instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) where);
            assertEquals(colRef.getTypeDefinition(), myType);
            assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
        }
    }
View Full Code Here
362
363
364
365
366
367
368
369
370
371
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) sort.getSelector());
            assertEquals(colRef.getTypeDefinition(), bookType);
            assertTrue(colRef.getPropertyQueryName().equals(TITLE_PROP));
        }
    }
View Full Code Here
377
378
379
380
381
382
383
384
385
386
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) sort.getSelector());
            assertEquals(colRef.getTypeDefinition(), bookType);
            assertTrue(colRef.getPropertyQueryName().equals(AUTHOR_PROP));
        }
    }
View Full Code Here
392
393
394
395
396
397
398
399
400
401
        QueryObject qo = walker.queryObj;
        List<SortSpec> sorts = qo.getOrderBys();
        assertTrue(1 == sorts.size());
        for (SortSpec sort : sorts) {
            assertTrue(sort.getSelector() instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) sort.getSelector());
            assertEquals(colRef.getTypeDefinition(), bookType);
            assertTrue(colRef.getPropertyQueryName().equals(AUTHOR_PROP));
        }
    }
View Full Code Here
407
408
409
410
411
412
413
414
415
416
417
418
419
420
        QueryObject qo = walker.queryObj;
        List<CmisSelector> joins = qo.getJoinReferences();
        assertTrue(2 == joins.size());
        for (CmisSelector join : joins) {
            assertTrue(join instanceof ColumnReference);
            ColumnReference colRef = ((ColumnReference) join);
            if (myType.equals(colRef.getTypeDefinition())) {
                assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
            } else if (bookType.equals(colRef.getTypeDefinition())) {
                assertTrue(colRef.getPropertyQueryName().equals(TITLE_PROP));
            } else
                fail("Unexpected type in JOIN reference");
        }
    }
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
573
574
575
                return true;
        }
    }

    private boolean evalWhereInAny(StoredObject so, Tree node, Tree colNode, Tree listNode) {
        ColumnReference colRef = getColumnReference(colNode);
        TypeDefinition td = colRef.getTypeDefinition();
        PropertyDefinition<?> pd = td.getPropertyDefinitions().get(colRef.getPropertyId());
        PropertyData<?> lVal = so.getProperties().get(colRef.getPropertyId());
        List<Object> literals = onLiteralList(listNode);
        if (pd.getCardinality() != Cardinality.MULTI)
            throw new RuntimeException("Operator ANY...IN only is allowed on multi-value properties ");
        else if (lVal == null)
            return false;
View Full Code Here
585
586
587
588
589
590
591
592
593
594
595
596
597
598
    }

    private boolean evalWhereNotInAny(StoredObject so, Tree node, Tree colNode, Tree listNode) {
        // Note just return !evalWhereInAny(so, node, colNode, listNode) is wrong, because
        // then it evaluates to true for null values (not set properties).
        ColumnReference colRef = getColumnReference(colNode);
        TypeDefinition td = colRef.getTypeDefinition();
        PropertyDefinition<?> pd = td.getPropertyDefinitions().get(colRef.getPropertyId());
        PropertyData<?> lVal = so.getProperties().get(colRef.getPropertyId());
        List<Object> literals = onLiteralList(listNode);
        if (pd.getCardinality() != Cardinality.MULTI)
            throw new RuntimeException("Operator ANY...IN only is allowed on multi-value properties ");
        else if (lVal == null)
            return false;
View Full Code Here
606
607
608
609
610
611
612
613
614
615
616
617
618
619
            return true;
        }   
    }

    private boolean evalWhereEqAny(StoredObject so, Tree node, Tree literalNode, Tree colNode) {
        ColumnReference colRef = getColumnReference(colNode);
        TypeDefinition td = colRef.getTypeDefinition();
        PropertyDefinition<?> pd = td.getPropertyDefinitions().get(colRef.getPropertyId());
        PropertyData<?> lVal = so.getProperties().get(colRef.getPropertyId());
        Object literal = onLiteral(literalNode);
        if (pd.getCardinality() != Cardinality.MULTI)
            throw new RuntimeException("Operator = ANY only is allowed on multi-value properties ");
        else if (lVal == null)
            return false;
View Full Code Here
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
    private boolean evalWhereIsLike(StoredObject so, Tree node, Tree colNode, Tree StringNode) {
        Object rVal = onLiteral(StringNode);
        if (!(rVal instanceof String))
                throw new RuntimeException("LIKE operator requires String literal on right hand side.");
       
        ColumnReference colRef = getColumnReference(colNode);
        TypeDefinition td = colRef.getTypeDefinition();
        PropertyDefinition<?> pd = td.getPropertyDefinitions().get(colRef.getPropertyId());
        PropertyType propType = pd.getPropertyType();
        if (propType != PropertyType.STRING && propType != PropertyType.HTML &&  propType != PropertyType.ID &&
                propType != PropertyType.URI)
            throw new RuntimeException("Property type "+ propType.value() + " is not allowed FOR LIKE");
        if (pd.getCardinality() != Cardinality.SINGLE)
            throw new RuntimeException("LIKE is not allowed for multi-value properties ");
       
        String propVal = (String) so.getProperties().get(colRef.getPropertyId()).getFirstValue();
        String pattern = translatePattern((String) rVal); // SQL to Java regex syntax
        Pattern p = Pattern.compile(pattern);
        return p.matcher(propVal).matches();
    }
View Full Code Here
TOP

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

  • org.apache.chemistry.opencmis.inmemory.query.InMemoryQueryProcessor
  • org.apache.chemistry.opencmis.inmemory.query.InMemoryQueryProcessor$InMemoryWhereClauseWalker
  • org.apache.chemistry.opencmis.inmemory.query.QueryParseTest
  • org.apache.chemistry.opencmis.inmemory.query.QueryTypesTest
    • 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.