Package com.dotmarketing.db

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

264
265
266
267
268
269
270
271
272
273
274
      }

      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
317
318
319
320
321
322
323
324
325
326
327
  @Override
  public List<HTMLPage> getPagesUsingTemplate(Template template) throws DotDataException {
    HibernateUtil hu = new HibernateUtil(HTMLPage.class);
    hu.setSQLQuery(workingVersionPagesUsingTemplateSQL);
    hu.setParam(template.getIdentifier());
    List<HTMLPage> workingPages = new ArrayList<HTMLPage>(new HashSet<HTMLPage>(hu.list()));
    if(workingPages.size() > 0){
      return workingPages;
    }else{
      HibernateUtil hu1 = new HibernateUtil(HTMLPage.class);
      hu1.setSQLQuery(nonWorkingVersionPagesUsingTemplateSQL);
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
      return workingPages;
    }else{
      HibernateUtil hu1 = new HibernateUtil(HTMLPage.class);
      hu1.setSQLQuery(nonWorkingVersionPagesUsingTemplateSQL);
      hu1.setParam(template.getIdentifier());
      List<HTMLPage> nonWorkingPages = new ArrayList<HTMLPage>(new HashSet<HTMLPage>(hu1.list()));
      return nonWorkingPages; 
    }
  }
  @Override
  public void associateContainers(List<Container> containerIdentifiers,Template template) throws DotHibernateException{
View Full Code Here
418
419
420
421
422
423
424
425
426
427
428
        clazz = InodeUtils.getClassByDBType(type);
        dh = new HibernateUtil(clazz);
      dh.setQuery("from inode in class " + clazz.getName() + " where inode.identifier = ? and inode.type='"+type+"' order by mod_date desc");
      dh.setParam(currWebAsset.getIdentifier());
      Logger.debug(BaseWebAssetAPI.class, "findAllVersions query: " + dh.getQuery());
      webAssetList.addAll( (List<Versionable>) dh.list() );
    }
    return auxVersionInfo;
  }

  @SuppressWarnings("unchecked")
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
  @SuppressWarnings("unchecked")
  public List<Template> findTemplatesUnder(Folder parentFolder) throws DotStateException, DotDataException {
    HibernateUtil hu = new HibernateUtil(Template.class);
    hu.setSQLQuery(subTemplatesSQL);
    hu.setParam(APILocator.getIdentifierAPI().find(parentFolder).getPath());
    return new ArrayList<Template>(new HashSet<Template>(hu.list()));
  }

 
  @SuppressWarnings("unchecked")
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
  public List<Template> findTemplatesAssignedTo(Host parentHost, boolean includeArchived) throws DotHibernateException {
    HibernateUtil hu = new HibernateUtil(Template.class);
    String query = !includeArchived?templatesUnderHostSQL + " and vi.deleted = " + DbConnectionFactory.getDBFalse():templatesUnderHostSQL;
    hu.setSQLQuery(templatesUnderHostSQL);
    hu.setParam(parentHost.getIdentifier());
    return new ArrayList<Template>(new HashSet<Template>(hu.list()));
  }


  @SuppressWarnings("unchecked")
  public List<Template> findTemplatesUserCanUse(User user, String hostName, String query,boolean searchHost ,int offset, int limit) throws DotDataException, DotSecurityException {
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
    List<UserFilter> list =null;
    try {
      dh.setSQLQuery("select user_filter.* from user_filter user_filter, inode inode where lower(user_filter.title) like ? and user_filter.inode=inode.inode and inode.owner=? order by title");
      dh.setParam("%" + title.toLowerCase() + "%");
      dh.setParam(user.getUserId());
      list = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(UserFilterFactory.class, "getUserFilterByTitleAndUser failed:" + e, e);
    }
    return list;
  }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
  public static void getReportParameters(Report report)throws DotHibernateException{
    if(report.isRequiresInput()){
      HibernateUtil hu = new HibernateUtil(ReportParameter.class);
      hu.setQuery(GETAllRPHQL);
      hu.setParam(report.getInode());
      report.setParameters(new ArrayList<ReportParameter>(hu.list()));
    }
  }
  /**
   * Deletes all ReportParamters for a Report Object.
   * @param report Report to delete all paramters for
View Full Code Here
14
15
16
17
18
19
20
21
22
23
24
      List<Structure> list = null ;
        String query = "select {structure.*} from structure, field, inode as structure_1_ where field.field_name='Average Rating' and structure.inode=field.structure_inode and structure.inode=structure_1_.inode";
        HibernateUtil dh = new HibernateUtil (Structure.class);
        try {
      dh.setSQLQuery(query);
      list = dh.list();
    } catch (DotHibernateException e) {
      Logger.error(ContentRatingsFactory.class, e.getMessage(), e);
    }
        return list;
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
      try {
        String query = "select {content_rating.*} from content_rating, contentlet,inode where content_rating.identifier = contentlet.identifier and inode.inode = contentlet.inode and structure_inode=?";
        HibernateUtil dh = new HibernateUtil (Rating.class);
        dh.setSQLQuery(query);
        dh.setParam(inode);
        result = dh.list();
      } catch (Exception e) {
        Logger.error(ContentRatingsFactory.class, "", e);
        return null;
      }
     
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.