Examples with Query org.alfresco.webservice.types.Query used on opensource projects

Example 1 with Query

use of org.alfresco.webservice.types.Query in project trainning by fernandotomasio.

the class AlfrescoContentDAO method findAllContentByPath.

@Override
public ContentDTO[] findAllContentByPath(String path) {
    ContentDTO[] contents = null;
    try {
        AuthenticationUtils.startSession(USERNAME, PASSWORD);
        RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();
        // Get a reference to the space we have named
        Reference reference = new Reference(STORE, null, encodePath(path));
        Predicate predicate = new Predicate(new Reference[] { reference }, null, null);
        Node[] nodes = repositoryService.get(predicate);
        // Create a query object, looking for all items with alfresco in the
        // name of text
        Query query = new Query(Constants.QUERY_LANG_LUCENE, "+PARENT:\"workspace://SpacesStore/" + nodes[0].getReference().getUuid() + "\"");
        // Execute the query
        QueryResult queryResult = repositoryService.query(STORE, query, false);
        // Display the results
        ResultSet resultSet = queryResult.getResultSet();
        ResultSetRow[] rows = resultSet.getRows();
        if (rows != null) {
            contents = new ContentDTO[rows.length];
            // Get the infomation from the result set
            for (int i = 0; i < rows.length; i++) {
                ResultSetRow row = (ResultSetRow) rows[i];
                String nodeId = row.getNode().getId();
                ContentDTO content = new ContentDTO();
                content.setUid(nodeId);
                for (NamedValue namedValue : row.getColumns()) {
                    if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true) {
                    // contentResult.setCreateDate(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_NAME) == true) {
                        content.setName(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_DESCRIPTION) == true) {
                        content.setDescription(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_TITLE) == true) {
                        content.setTitle(namedValue.getValue());
                    }
                }
                contents[i] = content;
            // results.add(contentResult);
            }
        }
    } catch (AuthenticationFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Autenticação");
    } catch (RepositoryFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.INFO, "Conteúdo não disponível");
    } catch (RemoteException e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Acesso a Serviço Web");
    } finally {
        // End the session
        AuthenticationUtils.endSession();
    }
    return contents;
}

Example 2 with Query

use of org.alfresco.webservice.types.Query in project trainning by fernandotomasio.

the class AlfrescoContentDAO method findAllContentByUUID.

@Override
public ContentDTO[] findAllContentByUUID(String uuid) {
    ContentDTO[] contents = null;
    try {
        AuthenticationUtils.startSession(USERNAME, PASSWORD);
        RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();
        Reference node = new Reference();
        node.setStore(STORE);
        node.setUuid(uuid);
        Node[] nodes = null;
        nodes = repositoryService.get(new Predicate(new Reference[] { node }, STORE, null));
        // Create a query object, looking for all items with alfresco in the
        // name of text
        Query query = new Query(Constants.QUERY_LANG_LUCENE, "+PARENT:\"workspace://SpacesStore/" + nodes[0].getReference().getUuid() + "\"");
        // Execute the query
        QueryResult queryResult = repositoryService.query(STORE, query, false);
        // Display the results
        ResultSet resultSet = queryResult.getResultSet();
        ResultSetRow[] rows = resultSet.getRows();
        if (rows != null) {
            contents = new ContentDTO[rows.length];
            // Get the infomation from the result set
            for (int i = 0; i < rows.length; i++) {
                ResultSetRow row = (ResultSetRow) rows[i];
                String nodeId = row.getNode().getId();
                ContentDTO content = new ContentDTO();
                content.setUid(nodeId);
                for (NamedValue namedValue : row.getColumns()) {
                    if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true) {
                    // contentResult.setCreateDate(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_NAME) == true) {
                        content.setName(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_DESCRIPTION) == true) {
                        content.setDescription(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_TITLE) == true) {
                        content.setTitle(namedValue.getValue());
                    }
                }
                contents[i] = content;
            // results.add(contentResult);
            }
        }
    } catch (AuthenticationFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Autenticação");
    } catch (RepositoryFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.INFO, "Conteúdo não disponível");
    } catch (RemoteException e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Acesso a Serviço Web");
    } finally {
        // End the session
        AuthenticationUtils.endSession();
    }
    return contents;
}

Example 3 with Query

use of org.alfresco.webservice.types.Query in project trainning by fernandotomasio.

the class ImportTurmasImplEfetivasFromTabelao method findAllContentByPath.

public ContentDTO[] findAllContentByPath(String path) {
    ContentDTO[] contents = null;
    try {
        AuthenticationUtils.startSession(USERNAME, PASSWORD);
        RepositoryServiceSoapBindingStub repositoryService = WebServiceFactory.getRepositoryService();
        // Get a reference to the space we have named
        Reference reference = new Reference(STORE, null, encodePath(path));
        Predicate predicate = new Predicate(new Reference[] { reference }, null, null);
        Node[] nodes = repositoryService.get(predicate);
        // Create a query object, looking for all items with alfresco in the
        // name of text
        Query query = new Query(Constants.QUERY_LANG_LUCENE, "+PARENT:\"workspace://SpacesStore/" + nodes[0].getReference().getUuid() + "\"");
        // Execute the query
        QueryResult queryResult = repositoryService.query(STORE, query, false);
        // Display the results
        org.alfresco.webservice.types.ResultSet resultSet = queryResult.getResultSet();
        ResultSetRow[] rows = resultSet.getRows();
        if (rows != null) {
            contents = new ContentDTO[rows.length];
            // Get the infomation from the result set
            for (int i = 0; i < rows.length; i++) {
                ResultSetRow row = (ResultSetRow) rows[i];
                String nodeId = row.getNode().getId();
                ContentDTO content = new ContentDTO();
                content.setUid(nodeId);
                for (NamedValue namedValue : row.getColumns()) {
                    if (namedValue.getName().endsWith(Constants.PROP_CREATED) == true) {
                    // contentResult.setCreateDate(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_NAME) == true) {
                        content.setName(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_DESCRIPTION) == true) {
                        content.setDescription(namedValue.getValue());
                    } else if (namedValue.getName().endsWith(Constants.PROP_TITLE) == true) {
                        content.setTitle(namedValue.getValue());
                    }
                }
                contents[i] = content;
            // results.add(contentResult);
            }
        }
    } catch (AuthenticationFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Autenticação");
    } catch (RepositoryFault e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.INFO, "Conteúdo não disponível");
    } catch (RemoteException e) {
        Logger.getLogger(AlfrescoContentDAO.class.getName()).log(Level.SEVERE, "Erro de Acesso a Serviço Web");
    } finally {
        // End the session
        AuthenticationUtils.endSession();
    }
    return contents;
}