Ejemplo n.º 1
0
  @Override
  public void updateSearch(String token, QueryParams params)
      throws AccessDeniedException, RepositoryException, DatabaseException {
    log.debug("updateSearch({}, {})", token, params);
    Session session = null;

    if (Config.SYSTEM_READONLY) {
      throw new AccessDeniedException("System is in read-only mode");
    }

    try {
      // TODO This JCR Session could be removed
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      params.setUser(session.getUserID());
      QueryParamsDAO.update(params);

      // Activity log
      UserActivity.log(
          session.getUserID(), "UPDATE_SEARCH", params.getName(), null, params.toString());
    } catch (javax.jcr.RepositoryException e) {
      throw new RepositoryException(e.getMessage(), e);
    } catch (DatabaseException e) {
      throw e;
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("updateSearch: void");
  }
Ejemplo n.º 2
0
  @Override
  public ResultSet findSimpleQueryPaginated(String token, String statement, int offset, int limit)
      throws RepositoryException, DatabaseException {
    log.debug(
        "findSimpleQueryPaginated({}, {}, {}, {})", new Object[] {token, statement, offset, limit});
    ResultSet rs = new ResultSet();
    Session session = null;

    try {
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      rs = executeSimpleQuery(session, statement, offset, limit);
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("findSimpleQueryPaginated: {}", rs);
    return rs;
  }
Ejemplo n.º 3
0
  /** Get keyword map */
  private Map<String, Integer> getKeywordMapLive(String token, List<String> filter)
      throws RepositoryException, DatabaseException {
    log.debug("getKeywordMapLive({}, {})", token, filter);
    String statement =
        "/jcr:root//*[@jcr:primaryType eq 'okm:document' or @jcr:primaryType eq 'okm:mail' or @jcr:primaryType eq 'okm:folder']";
    HashMap<String, Integer> cloud = new HashMap<String, Integer>();
    Session session = null;

    try {
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      Workspace workspace = session.getWorkspace();
      QueryManager queryManager = workspace.getQueryManager();
      Query query = queryManager.createQuery(statement, Query.XPATH);
      javax.jcr.query.QueryResult qResult = query.execute();

      for (NodeIterator nit = qResult.getNodes(); nit.hasNext(); ) {
        Node doc = nit.nextNode();
        Value[] keywordsValue = doc.getProperty(com.openkm.bean.Property.KEYWORDS).getValues();
        ArrayList<String> keywordCollection = new ArrayList<String>();

        for (int i = 0; i < keywordsValue.length; i++) {
          keywordCollection.add(keywordsValue[i].getString());
        }

        if (filter != null && keywordCollection.containsAll(filter)) {
          for (Iterator<String> it = keywordCollection.iterator(); it.hasNext(); ) {
            String keyword = it.next();

            if (!filter.contains(keyword)) {
              Integer occurs = cloud.get(keyword) != null ? cloud.get(keyword) : 0;
              cloud.put(keyword, occurs + 1);
            }
          }
        }
      }
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("getKeywordMapLive: {}", cloud);
    return cloud;
  }
Ejemplo n.º 4
0
  /** Get keyword map */
  private Map<String, Integer> getKeywordMapCached(String token, List<String> filter)
      throws RepositoryException, DatabaseException {
    log.debug("getKeywordMapCached({}, {})", token, filter);
    HashMap<String, Integer> keywordMap = new HashMap<String, Integer>();
    Session session = null;

    try {
      // TODO This JCR Session could be removed
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      Collection<UserNodeKeywords> userDocKeywords =
          UserNodeKeywordsManager.get(session.getUserID()).values();

      for (Iterator<UserNodeKeywords> kwIt = userDocKeywords.iterator(); kwIt.hasNext(); ) {
        Set<String> docKeywords = kwIt.next().getKeywords();

        if (filter != null && docKeywords.containsAll(filter)) {
          for (Iterator<String> itDocKeywords = docKeywords.iterator(); itDocKeywords.hasNext(); ) {
            String keyword = itDocKeywords.next();

            if (!filter.contains(keyword)) {
              Integer occurs = keywordMap.get(keyword) != null ? keywordMap.get(keyword) : 0;
              keywordMap.put(keyword, occurs + 1);
            }
          }
        }
      }
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("getKeywordMapCached: {}", keywordMap);
    return keywordMap;
  }
Ejemplo n.º 5
0
  @Override
  public void deleteSearch(String token, long qpId)
      throws AccessDeniedException, RepositoryException, DatabaseException {
    log.debug("deleteSearch({}, {})", token, qpId);
    Session session = null;

    if (Config.SYSTEM_READONLY) {
      throw new AccessDeniedException("System is in read-only mode");
    }

    try {
      // TODO This JCR Session could be removed
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      QueryParams qp = QueryParamsDAO.findByPk(qpId);
      QueryParamsDAO.delete(qpId);

      // Purge visited nodes table
      if (qp.isDashboard()) {
        DashboardDAO.deleteVisitedNodes(session.getUserID(), qp.getName());
      }

      // Activity log
      UserActivity.log(session.getUserID(), "DELETE_SAVED_SEARCH", Long.toString(qpId), null, null);
    } catch (DatabaseException e) {
      log.warn(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("deleteSearch: void");
  }
Ejemplo n.º 6
0
  @Override
  public QueryParams getSearch(String token, int qpId)
      throws PathNotFoundException, RepositoryException, DatabaseException {
    log.debug("getSearch({}, {})", token, qpId);
    QueryParams qp = new QueryParams();
    Session session = null;

    try {
      // TODO This JCR Session could be removed
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      qp = QueryParamsDAO.findByPk(qpId);

      // If this is a dashboard user search, dates are used internally
      if (qp.isDashboard()) {
        qp.setLastModifiedFrom(null);
        qp.setLastModifiedTo(null);
      }

      // Activity log
      UserActivity.log(
          session.getUserID(), "GET_SAVED_SEARCH", Integer.toString(qpId), null, qp.toString());
    } catch (javax.jcr.PathNotFoundException e) {
      log.warn(e.getMessage(), e);
      throw new PathNotFoundException(e.getMessage(), e);
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("getSearch: {}", qp);
    return qp;
  }
Ejemplo n.º 7
0
  @Override
  public List<Mail> getCategorizedMails(String token, String categoryId)
      throws RepositoryException, DatabaseException {
    log.debug("getCategorizedMails({}, {})", token, categoryId);
    List<Mail> mails = new ArrayList<Mail>();
    Session session = null;

    try {
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      Node category = session.getNodeByUUID(categoryId);

      for (PropertyIterator it = category.getReferences(); it.hasNext(); ) {
        Property refProp = it.nextProperty();

        if (com.openkm.bean.Property.CATEGORIES.equals(refProp.getName())) {
          Node node = refProp.getParent();

          if (node.isNodeType(Mail.TYPE)) {
            Mail mail = BaseMailModule.getProperties(session, node);
            mails.add(mail);
          }
        }
      }
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("getCategorizedMails: {}", mails);
    return mails;
  }
Ejemplo n.º 8
0
  @Override
  public List<QueryParams> getAllSearchs(String token)
      throws RepositoryException, DatabaseException {
    log.debug("getAllSearchs({})", token);
    List<QueryParams> ret = new ArrayList<QueryParams>();
    Session session = null;

    try {
      // TODO This JCR Session could be removed
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      List<QueryParams> qParams = QueryParamsDAO.findByUser(session.getUserID());

      for (Iterator<QueryParams> it = qParams.iterator(); it.hasNext(); ) {
        QueryParams qp = it.next();

        if (!qp.isDashboard()) {
          ret.add(qp);
        }
      }

      // Activity log
      UserActivity.log(session.getUserID(), "GET_ALL_SEARCHS", null, null, null);
    } catch (javax.jcr.RepositoryException e) {
      throw new RepositoryException(e.getMessage(), e);
    } catch (DatabaseException e) {
      throw e;
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("getAllSearchs: {}", ret);
    return ret;
  }
Ejemplo n.º 9
0
  public ResultSet findByStatementPaginated(
      String token, String statement, String type, int offset, int limit)
      throws RepositoryException, DatabaseException {
    log.debug(
        "findByStatement({}, {}, {}, {}, {})",
        new Object[] {token, statement, type, offset, limit});
    ResultSet rs = new ResultSet();
    Session session = null;

    try {
      if (token == null) {
        session = JCRUtils.getSession();
      } else {
        session = JcrSessionManager.getInstance().get(token);
      }

      if (statement != null && !statement.equals("")) {
        Workspace workspace = session.getWorkspace();
        QueryManager queryManager = workspace.getQueryManager();
        Query query = queryManager.createQuery(statement, type);
        rs = executeQuery(session, query, offset, limit);
      }

      // Activity log
      UserActivity.log(
          session.getUserID(), "FIND_BY_STATEMENT", null, null, type + ", " + statement);
    } catch (javax.jcr.RepositoryException e) {
      log.error(e.getMessage(), e);
      throw new RepositoryException(e.getMessage(), e);
    } finally {
      if (token == null) JCRUtils.logout(session);
    }

    log.debug("findByStatement: {}", rs);
    return rs;
  }