Package com.dotmarketing.db

Examples of com.dotmarketing.db.HibernateUtil

499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
   *
   * @return If the inode has children return true, false otherwise
   */
  public boolean hasParents() {

    HibernateUtil dh = new HibernateUtil();
    String query = "select count(*) from " + Inode.class.getName()
        + "  inode where inode.inode in (select tree.parent from "
        + 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
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import com.liferay.portal.model.User;

public class UserFilterFactory {

  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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
    }
    return list;
  }
 
  public static java.util.List getAllUserFilterByUser(User user) {
    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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
    }
    return list;
  }
 
  public static java.util.List getUserFilterByTitle(String title) {
    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
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
        return findContentlets(inodes);
  }

  @Override
  protected List<Contentlet> findByStructure(String structureInode, int limit, int offset) throws DotDataException, DotStateException, DotSecurityException {
      HibernateUtil hu = new HibernateUtil();
        hu.setQuery("select inode from inode in class " + com.dotmarketing.portlets.contentlet.business.Contentlet.class.getName() +
                ", contentletvi in class "+ContentletVersionInfo.class.getName()+
                " where type = 'contentlet' and structure_inode = '" + structureInode + "' " +
                " 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
905
906
907
908
909
910
911
912
913
914
915
916
917
918
                "on contentlet_1_.inode = contentlet.inode and contentlet_1_.type = 'contentlet' where  contentlet.inode in ('";
       
        for(int init=0; init < inodesNotFound.size(); init+=200) {
            int end = Math.min(init + 200, inodesNotFound.size());
           
            HibernateUtil hu = new HibernateUtil(com.dotmarketing.portlets.contentlet.business.Contentlet.class);
            hu.setSQLQuery( hql + StringUtils.join(inodesNotFound.subList(init, end), "','") + "')");
           
            List<com.dotmarketing.portlets.contentlet.business.Contentlet> fatties =  hu.list();
            for (com.dotmarketing.portlets.contentlet.business.Contentlet fatty : fatties) {
                Contentlet con = convertFatContentletToContentlet(fatty);
                result.add(con);
                cc.add(con.getInode(), con);
            }
View Full Code Here
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
            queryBuffer.append(" and contentvi.lang = ? ");
        }

        queryBuffer.append(" and contentlet.identifier = ? ");

        HibernateUtil hu = new HibernateUtil(com.dotmarketing.portlets.contentlet.business.Contentlet.class);
        hu.setSQLQuery(queryBuffer.toString());
        if(languageId!=null){
          hu.setParam(languageId.longValue());
        }
        hu.setParam(identifier);
        List<com.dotmarketing.portlets.contentlet.business.Contentlet> fatties = hu.list();
        for (com.dotmarketing.portlets.contentlet.business.Contentlet fatty : fatties) {
            Contentlet con = convertFatContentletToContentlet(fatty);
            cc.add(String.valueOf(con.getInode()), con);
            cons.add(con);
        }
View Full Code Here
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
            dc.setSQL(countSQL);
            List<HashMap<String, String>> resultCount = dc.getResults();
            int count = Integer.parseInt(resultCount.get(0).get("count"));
            int limit = 500;

            HibernateUtil hu = new HibernateUtil();
            hu.setQuery("from inode in class com.dotmarketing.portlets.contentlet.business.Contentlet, " +
                        " contentletvi in class "+ContentletVersionInfo.class.getName() +
                        " where contentletvi.identifier=inode.identifier " +
                        " and contentletvi.live_inode=inode.inode " +
                        " and structure_inode= '" + structure.getInode() + "' " +
                        " and " + field.getFieldContentlet() + " is not null" +
                        " and " + field.getFieldContentlet() + "<>'' " +
                        " order by " + field.getFieldContentlet());
            hu.setMaxResults(limit);
            for (int offset = 0; offset < count; offset+=limit) {
                if (offset > 0)
                    hu.setFirstResult(offset);
                List<com.dotmarketing.portlets.contentlet.business.Contentlet> fatties =  hu.list();
                for (com.dotmarketing.portlets.contentlet.business.Contentlet fatty : fatties) {
                    result.add(convertFatContentletToContentlet(fatty));
                }
            }
        } catch (Exception e) {
View Full Code Here
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
            Logger.debug(this, "LanguageId is -1 so we will not use a language to pull contentlets");
        }else{
            condition.append(" and contentletvi.lang = ").append(languageId);
        }

        HibernateUtil hu = new HibernateUtil(com.dotmarketing.portlets.contentlet.business.Contentlet.class);

        if (!UtilMethods.isSet(orderby) || orderby.equals("tree_order")) {
            orderby = "multi_tree.tree_order";
        }
        String query = "SELECT {contentlet.*} FROM contentlet JOIN inode contentlet_1_ ON (contentlet.inode=contentlet_1_.inode) "
          + " JOIN multi_tree ON (multi_tree.child = contentlet.identifier) "
            + " JOIN contentlet_version_info contentletvi ON (contentlet.identifier=contentletvi.identifier) "
            + " where multi_tree.parent1 = ? and multi_tree.parent2 = ? and " + condition.toString() + " order by "
            + orderby;

        hu.setSQLQuery(query);
        hu.setParam(HTMLPageIdentifier);
        hu.setParam(containerIdentifier);

        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(content.getInode(), content);
            result.add(content);
View Full Code Here
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
               .append(" JOIN contentlet_version_info contentletvi ON (contentlet.identifier=contentletvi.identifier) ")
                   .append(" WHERE ")
                   .append((live!=null && live.booleanValue() ?
                           "contentletvi.live_inode" : "contentletvi.working_inode"))
                   .append(" = contentlet.inode and contentlet.identifier = ? ");
        HibernateUtil hu = new HibernateUtil(com.dotmarketing.portlets.contentlet.business.Contentlet.class);
        hu.setSQLQuery(queryBuffer.toString());
        hu.setParam(identifier);
        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(content.getInode(), content);
            result.add(content);
View Full Code Here
TOP

Related Classes of com.dotmarketing.db.HibernateUtil

  • com.dotcms.content.elasticsearch.business.ESContentFactoryImpl
  • com.dotcms.content.elasticsearch.business.ESContentletAPIImpl
  • com.dotcms.repackage.net.sf.hibernate.cfg.Configuration
  • com.dotcms.rest.ContentResource
  • com.dotmarketing.beans.Inode
  • com.dotmarketing.business.BaseWebAssetAPI
  • com.dotmarketing.business.IdentifierFactoryImpl
  • com.dotmarketing.business.LayoutFactoryImpl
  • com.dotmarketing.business.PermissionBitFactoryImpl
  • com.dotmarketing.business.RoleFactoryImpl
    • Copyright © 2018 www.massapicom. 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.