Package com.dotmarketing.db

Examples of com.dotmarketing.db.HibernateUtil

933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
  public static java.util.List getInodesOfClass(Class c, String orderBy, int limit, int offset) {
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {
      HibernateUtil dh = new HibernateUtil(c);
      String type = ((Inode) c.newInstance()).getType();
      dh.setQuery("from inode in class " + c.getName() + " where inode.type='"+type+"' order by " + orderBy);

      if (limit != 0) {
        dh.setFirstResult(offset);
        dh.setMaxResults(limit);
      }

      return dh.list();
    } catch (Exception e) {
      Logger.warn(InodeFactory.class, "getInodesOfClass failed:" + e, e);
    }

    return new java.util.ArrayList();
View Full Code Here
956
957
958
959
960
961
962
963
964
965
966
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    Object obj ;
    try {
      obj = new HibernateUtil(c).load(x);
    } catch (DotHibernateException e) {
      Logger.error(InodeFactory.class, "getObject failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
    return obj;
View Full Code Here
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {
      String tableName = ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);
      String sql = "SELECT {" + tableName + ".*} from " + tableName + " " + tableName + ", tree tree, inode "
      + tableName + "_1_ where tree.child = ? and tree.parent = " + tableName + ".inode and " + tableName
      + "_1_.inode = " + tableName + ".inode and "+tableName+"_1_.type = '"+tableName+"'";

      Logger.debug(InodeFactory.class, "hibernateUtilSQL:getParentOfClass:\n " + sql + "\n");

      dh.setSQLQuery(sql);
      dh.setParam(i);

      Logger.debug(InodeFactory.class, "inode:  " + i + "\n");

      List list = dh.list();

      if ((list != null) && (list.size() != 0)) {
        return list.get(0);
      }
    } catch (Exception e) {
View Full Code Here
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {
      String tableName = ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);
      String sql = "SELECT {" + tableName + ".*} from " + tableName + " " + tableName
      + " with (nolock), tree tree with (nolock), inode " + tableName + "_1_ with (nolock) where tree.child = ? and tree.parent = "
      + tableName + ".inode and " + tableName + "_1_.inode = " + tableName + ".inode and "+tableName+"_1_.type = '"+tableName+"'";

      Logger.debug(InodeFactory.class, "hibernateUtilSQL:getParentOfClass:\n " + sql + "\n");

      dh.setSQLQuery(sql);

      //dh.setQuery("from inode in class " + c.getName() + " where ? in
      // inode.children.elements");
      dh.setParam(p.getInode());

      Logger.debug(InodeFactory.class, "inode:  " + p.getInode() + "\n");

      return dh.list();
    } catch (Exception e) {
      Logger.warn(InodeFactory.class, "getParentsOfClass failed:" + e, e);

      //throw new DotRuntimeException(e.toString());
    }
View Full Code Here
1047
1048
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
1075
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {
      String tableName = ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);

      // dh.setQuery("from inode in class " + c.getName() + " where ? in
      // (select tree.parent from com.dotmarketing.beans.Tree tree
      // where inode.inode = tree.child and tree.relationType = ?)");
      String sql = "SELECT {" + tableName + ".*} from " + tableName + " " + tableName + ", tree tree, inode "
      + tableName + "_1_ where tree.child = ? and tree.parent = " + tableName + ".inode and " + tableName
      + "_1_.inode = " + tableName + ".inode and tree.relation_type = ? and "+tableName+"_1_.type = '"+tableName+"' ";

      Logger.debug(InodeFactory.class, "hibernateUtilSQL:getChildOfClassByRelationType\n " + sql + "\n");

      dh.setSQLQuery(sql);

      Logger.debug(InodeFactory.class, "inode:  " + p.getInode() + "\n");

      dh.setParam(p.getInode());
      dh.setParam(relationType);

      return dh.load();
    } catch (Exception e) {
      Logger.error(InodeFactory.class, "getChildrenClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
  }
View Full Code Here
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
    if( c.equals(Identifier.class)){
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try {
      String tableName = ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);

      String sql = "SELECT {" + tableName + ".*} from " + tableName + " " + tableName + ", tree tree, inode "
      + tableName + "_1_ where tree.child = ? and tree.parent = " + tableName + ".inode and " + tableName
      + "_1_.inode = " + tableName + ".inode and "+tableName+"_1_.type = '"+tableName+"' and " + condition;

      Logger.debug(InodeFactory.class, "hibernateUtilSQL:getParentsOfClassByCondition\n " + sql);

      Logger.debug(InodeFactory.class, "inode:  " + p.getInode() + "\n");

      Logger.debug(InodeFactory.class, "condition:  " + condition + "\n");

      dh.setSQLQuery(sql);
      dh.setParam(p.getInode());

      return dh.list();
    } catch (Exception e) {
      Logger.warn(InodeFactory.class, "getParentsOfClassByCondition failed:" + e, e);

      // throw new DotRuntimeException(e.toString());
    }
View Full Code Here
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
      throw new DotStateException("Identifiers are no longer Inodes!");
    }
    try
    {
      String tableName = ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);

      String sql = "SELECT {" + tableName + ".*} from " + tableName + " " + tableName + ", tree tree, inode "
      + tableName + "_1_ where tree.child = ? and tree.parent = " + tableName + ".inode and " + tableName
      + "_1_.inode = " + tableName + ".inode and "+tableName+"_1_.type = '"+tableName+"' and " + condition;

      if(UtilMethods.isSet(sortOrder))
      {
        sql = sql + " order by "+ sortOrder; 
      }

      //Logger
      Logger.debug(InodeFactory.class, "hibernateUtilSQL:getParentsOfClassByCondition\n " + sql);
      Logger.debug(InodeFactory.class, "inode:  " + p.getInode() + "\n");
      Logger.debug(InodeFactory.class, "condition:  " + condition + "\n");
      // END Logger     

      dh.setSQLQuery(sql);
      dh.setParam(p.getInode());

      return dh.list();
    }
    catch (Exception e)
    {
      Logger.warn(InodeFactory.class, "getParentsOfClassByCondition failed:" + e, e);
      // throw new DotRuntimeException(e.toString());
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
  }

  public static java.util.List getChildrenClassByCondition(Inode p1, Inode p2, Class c, String condition) {
    try {
      String tableName =  ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);
     
      String sql = "SELECT {"  + tableName + ".*} from " + tableName + " " + tableName + ", multi_tree multi_tree, inode "+ tableName +"_1_ where multi_tree.parent1 = ? and multi_tree.parent2 = ? and multi_tree.child = " + tableName + ".inode and " + tableName + "_1_.inode = " + tableName + ".inode and " + condition;
            Logger.debug(MultiTreeFactory.class, "hibernateUtilSQL:getChildrenClassByCondition\n " + sql);
      dh.setSQLQuery(sql);
            Logger.debug(MultiTreeFactory.class, "inode p1:  " + p1.getInode() + "\n");
            Logger.debug(MultiTreeFactory.class, "inode p2:  " + p2.getInode() + "\n");
     
      dh.setParam(p1.getInode());
      dh.setParam(p2.getInode());

      return dh.list();
    }
    catch (Exception e) {
            Logger.error(MultiTreeFactory.class, "getChildrenClassByCondition failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
     * @param inode inode of the object tagged
     * @return list of all the TagInode where the tags are associated to the object
     */
  public List getTagInodeByInode(String inode) {
        try {
            HibernateUtil dh = new HibernateUtil(TagInode.class);
            dh.setQuery("from tag_inode in class com.dotmarketing.tag.model.TagInode where inode = ?");
            dh.setParam(inode);

            List list = dh.list();
          return list;

        } catch (Exception e) {
            Logger.warn(Tag.class, "getTagInodeByInode failed:" + e, e);
        }
View Full Code Here
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
  }

  public static java.util.List getChildrenClassByCondition(String p1, String p2, Class c, String condition) {
    try {
      String tableName =  ((Inode) c.newInstance()).getType();
      HibernateUtil dh = new HibernateUtil(c);
     
      String sql = "SELECT {"  + tableName + ".*} from " + tableName + " " + tableName + ", multi_tree multi_tree, inode "+ tableName +"_1_ where multi_tree.parent1 = ? and multi_tree.parent2 = ? and multi_tree.child = " + tableName + ".inode and " + tableName + "_1_.inode = " + tableName + ".inode and " + condition;
            Logger.debug(MultiTreeFactory.class, "hibernateUtilSQL:getChildrenClassByCondition\n " + sql);
      dh.setSQLQuery(sql);
            Logger.debug(MultiTreeFactory.class, "inode p1:  " + p1 + "\n");
            Logger.debug(MultiTreeFactory.class, "inode p2:  " + p2 + "\n");
     
      dh.setParam(p1);
      dh.setParam(p2);

      return dh.list();
    }
    catch (Exception e) {
            Logger.error(MultiTreeFactory.class, "getChildrenClassByCondition failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
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.