Examples with OrderByExpression com.pogeyan.cmis.api.uri.expression.OrderByExpression used on opensource projects

Example 1 with OrderByExpression

use of com.pogeyan.cmis.api.uri.expression.OrderByExpression in project copper-cms by PogeyanOSS.

the class MNavigationServiceDAOImpl method getChildren.

/*
	 * (non-Javadoc) filterExpression supports eq, ne, ge, gt, le, lt, startswith,
	 * endswith. example filter:
	 * "properties.orderId eq 100 and name eq pogeyan or startswith (name::'a')"
	 * "*,modifiedAt le 123456789 and typeId eq cmis:folder" -->* represents to get
	 * all properties data in that object
	 * "properties.isRead eq false and typeId ne cmis:folder"
	 * "properties.orderId gt 100 properties.purchaseOrder ge 100"
	 * "startswith (name::'a') and properties.orderId lt 100"
	 * "properties.orderId le 100"
	 * 
	 * example order: "name asc, repositoryId" "name desc"
	 * 
	 * @see
	 * com.pogeyan.cmis.api.data.services.MNavigationServiceDAO#getChildren(java
	 * .lang.String, java.lang.String[], boolean, int, int, java.lang.String,
	 * java.lang.String[], java.lang.String)
	 */
@SuppressWarnings("unchecked")
@Override
public List<MBaseObject> getChildren(String path, String[] principalIds, boolean aclPropagation, int maxItems, int skipCount, String orderBy, String[] mappedColumns, String filterExpression) {
    Query<MBaseObject> query = createQuery().disableValidation().filter("internalPath", path).field("token.changeType").notEqual(TokenChangeType.DELETED.value());
    if (!StringUtils.isEmpty(orderBy)) {
        if (this.isOrderByParsable(orderBy)) {
            try {
                OrderByExpression orderByExpression = UriParser.parseOrderBy(orderBy);
                query = (Query<MBaseObject>) orderByExpression.accept(new MongoExpressionVisitor<MBaseObject>(query));
            } catch (ExpressionParserException | ExceptionVisitExpression e) {
            }
        } else {
            query = query.order(orderBy);
        }
    }
    if (!StringUtils.isEmpty(filterExpression)) {
        try {
            FilterExpression expression = UriParser.parseFilter(filterExpression);
            query = (Query<MBaseObject>) expression.accept(new MongoExpressionVisitor<MBaseObject>(query));
        } catch (ExpressionParserException | ExceptionVisitExpression e) {
        }
    }
    if (maxItems > 0) {
        query = query.offset(skipCount).limit(maxItems);
    }
    if (mappedColumns != null && mappedColumns.length > 0) {
        query = query.retrievedFields(true, mappedColumns);
    }
    if (aclPropagation) {
        query.or(getAclCriteria(principalIds, query));
        return query.asList();
    } else {
        return query.asList();
    }
}

Example 2 with OrderByExpression

use of com.pogeyan.cmis.api.uri.expression.OrderByExpression in project copper-cms by PogeyanOSS.

the class App method main.

public static void main(String[] args) throws Exception, ExpressionParserException, ExpressionParserInternalError, ExceptionVisitExpression {
    RepositoryManagerFactory.getInstance().init(new LocalRepoImpl());
    MongoClientFactory dbFactory = (MongoClientFactory) MongoClientFactory.createDatabaseService();
    MDocumentObjectDAOImpl dao = (MDocumentObjectDAOImpl) dbFactory.getObjectService("TestRepo", MDocumentObjectDAO.class);
    Query<MDocumentObject> query = dao.createQuery();
    // String filterExpressionQuery = "name eq 'fd' and name ne 'sd'";
    String filterExpressionQuery = "contains(name, 'fd')";
    FilterExpression expression = UriParser.parseFilter(filterExpressionQuery);
    Object filterExp = expression.accept(new MongoExpressionVisitor<MDocumentObject>(query));
    System.out.print("output: " + filterExp != null ? filterExp.toString() : "error");
    String orderByExpressionQuery = "name asc, repositoryId desc";
    OrderByExpression orderByExpression = UriParser.parseOrderBy(orderByExpressionQuery);
    Object orderByExp = orderByExpression.accept(new MongoExpressionVisitor<MDocumentObject>(query));
    System.out.print("output: " + orderByExp != null ? orderByExp.toString() : "error");
}