Examples of com.dotmarketing.db.HibernateUtil.list()

com.dotmarketing.db.HibernateUtil.list()

      queryBuilder.append(" and vi.working_inode=file_asset.inode ");


    hu.setSQLQuery(queryBuilder.toString());
    hu.setParam(host.getIdentifier());


    return hu.list();
  }


  @SuppressWarnings("unchecked")
  public File getWorkingFileById(String identifier) throws DotDataException {
    HibernateUtil hu = new HibernateUtil(File.class);

View Full Code Here

    HibernateUtil hu = new HibernateUtil(File.class);
    hu.setSQLQuery("select {file_asset.*} from file_asset, inode file_asset_1_, fileasset_version_info vi " +
        " where file_asset.identifier = ? and vi.identifier=file_asset.identifier and vi.working_inode=file_asset.inode "
        + "and file_asset_1_.inode = file_asset.inode");
    hu.setParam(identifier);
    List<File> files = hu.list();
    if (files.size() == 0)
      return null;
    return files.get(0);
  }

View Full Code Here

      }


      while (!done) {
        dh.setFirstResult(internalOffset);
        dh.setMaxResults(internalLimit);
        resultList = dh.list();
        PermissionAPI permAPI = APILocator.getPermissionAPI();
        toReturn.addAll(permAPI.filterCollection(resultList, PermissionAPI.PERMISSION_READ, false, user));
        if (countLimit > 0 && toReturn.size() >= countLimit + offset)
          done = true;
        else if (resultList.size() < internalLimit)

View Full Code Here

                      _dh.setQuery("from " + clazz.getName() + " order by parent_path");
                    } else {
                      _dh.setQuery("from " + clazz.getName() + " order by 1");
                    }


                    _list = _dh.list();
                    if(_list.size() ==0){
                        try {
                        _bout.close();
                        }
                        catch( java.lang.NullPointerException npe){}

View Full Code Here

        + Tree.class.getName() + "  tree where tree.child = "
        + this.inode + ")";
    List results = new ArrayList();
    try {
      dh.setQuery(query);
      results = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(this.getClass(), e.getMessage(), e);
    }
    return ((Integer) results.get(0)).intValue() > 0;
  }

View Full Code Here

  public static java.util.List getAllUserFilter() {
    HibernateUtil dh = new HibernateUtil(UserFilter.class);
    List<UserFilter> list =null;
    try {
      dh.setQuery("from inode in class com.dotmarketing.portlets.userfilter.model.UserFilter order by title");
      list = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(UserFilterFactory.class, "getAllUserFilter failed:" + e, e);
    }
    return list;
  }

View Full Code Here

    HibernateUtil dh = new HibernateUtil(UserFilter.class);
    List<UserFilter> list =null;
    try {
      dh.setSQLQuery("select user_filter.* from user_filter user_filter, inode inode where user_filter.inode=inode.inode and inode.owner=? order by title");
      dh.setParam(user.getUserId());
      list = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(UserFilterFactory.class, "getAllUserFilterByUser failed:" + e, e);
    }
    return list;
  }

View Full Code Here

    HibernateUtil dh = new HibernateUtil(UserFilter.class);
    List<UserFilter> list =null;
    try {
      dh.setQuery("from inode in class com.dotmarketing.portlets.userfilter.model.UserFilter where lower(title) like ? order by title");
      dh.setParam("%" + title.toLowerCase() + "%");
      list = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(UserFilterFactory.class, "getUserFilterByTitle failed:" + e, e);
    }
    return list;
  }

View Full Code Here

        hu.setQuery("select inode from inode in class " + com.dotmarketing.portlets.contentlet.business.Contentlet.class.getName() +
                " , vi in class "+ContentletVersionInfo.class.getName()+" where vi.identifier=inode.identifier and " +
                " inode.inode<>vi.workingInode and "+
                " mod_user <> 'system' and inode.identifier = '" + identifier.getInode() + "'" +
                " and type='contentlet' order by mod_date desc");
        List<com.dotmarketing.portlets.contentlet.business.Contentlet> fatties = hu.list();
        if(fatties == null)
            return cons;
        else{
            for (com.dotmarketing.portlets.contentlet.business.Contentlet fatty : fatties) {
                Contentlet content = convertFatContentletToContentlet(fatty);

View Full Code Here

                " and contentletvi.identifier=inode.identifier and contentletvi.workingInode=inode.inode ");
        if(offset > 0)
            hu.setFirstResult(offset);
        if(limit > 0)
            hu.setMaxResults(limit);
        List<com.dotmarketing.portlets.contentlet.business.Contentlet> fatties =  hu.list();
        List<Contentlet> result = new ArrayList<Contentlet>();
        for (com.dotmarketing.portlets.contentlet.business.Contentlet fatty : fatties) {
            Contentlet content = convertFatContentletToContentlet(fatty);
            cc.add(String.valueOf(content.getInode()), content);
//          result.add(content);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.