Package com.dotmarketing.db

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

453
454
455
456
457
458
459
460
461
462
463
            Logger.debug(MultiTreeFactory.class, "inode:  " + p.getInode() + "\n");
            Logger.debug(MultiTreeFactory.class, "condition:  " + condition + "\n");
      dh.setSQLQuery(sql);
      dh.setParam(p.getInode());

      return dh.list();
    }
    catch (Exception e) {
            Logger.error(MultiTreeFactory.class, "getParentsOfClassByCondition failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
473
474
475
476
477
478
479
480
481
482
483
      String sql = "SELECT {"  + tableName + ".*} from " + tableName + " " + tableName + ", multi_tree multi_tree, inode "+ tableName +"_1_ where multi_tree.child = ? and (multi_tree.parent1 = " + tableName + ".inode or multi_tree.parent2 = " + tableName + ".inode) and " + tableName + "_1_.inode = " + tableName + ".inode ";
            Logger.debug(MultiTreeFactory.class, "hibernateUtilSQL:getParentOfClass:\n " + sql+ "\n");
      dh.setSQLQuery(sql);
      dh.setParam(p.getInode());
            Logger.debug(MultiTreeFactory.class, "inode:  " + p.getInode() + "\n");
      return dh.list();
    }
    catch (Exception e) {
            Logger.error(MultiTreeFactory.class, "getParentsOfClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
780
781
782
783
784
785
786
787
788
789
790
            dh.setParam(hostId);
          }*/
          //search global
          dh.setParam(selectedHostId);
          dh.setParam(Host.SYSTEM_HOST);
            List<Tag> list = dh.list();
          return list;
    }
    catch (Exception e) {}
    return new ArrayList<Tag>();
  }
View Full Code Here
818
819
820
821
822
823
824
825
826
827
828
              //copy or update tags if the tag storage id has changed when editing the host
              //or if the previous tag storage was global
          HibernateUtil dh = new HibernateUtil(Tag.class);
          dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where host_id = ?");
          dh.setParam(oldTagStorageId);
                List<Tag> list = (List<Tag>)dh.list();           

                HibernateUtil dh1 = new HibernateUtil(Tag.class);
          dh1.setQuery("from tag in class com.dotmarketing.tag.model.Tag where host_id = ?");
          dh1.setParam(hostIdentifier);
          List<Tag> hostTagList = (List<Tag>)dh1.list();
View Full Code Here
823
824
825
826
827
828
829
830
831
832
833
                List<Tag> list = (List<Tag>)dh.list();           

                HibernateUtil dh1 = new HibernateUtil(Tag.class);
          dh1.setQuery("from tag in class com.dotmarketing.tag.model.Tag where host_id = ?");
          dh1.setParam(hostIdentifier);
          List<Tag> hostTagList = (List<Tag>)dh1.list();
         
              for (Tag tag: list){
                  try{
                    if((hostIdentifier.equals(newTagStorageId) && hostTagList.size() == 0) && !newTagStorageId.equals(Host.SYSTEM_HOST)){
                        //copy old tag to host with new tag storage
View Full Code Here
859
860
861
862
863
864
865
866
867
868
869
            HibernateUtil dh = new HibernateUtil(Tag.class);
            dh.setQuery("select tag from com.dotmarketing.tag.model.TagInode tagi, com.dotmarketing.tag.model.Tag tag " +
                    " where tagi.tagId=tag.tagId and tagi.inode = ?");
            dh.setParam(inode);

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

        } catch (Exception e) {
            Logger.warn(Tag.class, "getTagInodeByInode failed:" + e, e);
            throw new RuntimeException(e);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    List<Trackback> tb = null ;
    try {
      HibernateUtil dh = new HibernateUtil();
      dh.setClass(Trackback.class);
      dh.setQuery("from trackback in class com.dotmarketing.beans.Trackback where asset_identifier = '" + assetIdentifier + "'");
      tb = (List<Trackback>) dh.list();
    } catch (DotHibernateException e) {
      Logger.error(TrackbackFactory.class, "getTrackbacksByAssetId failed:" + e, e);
    }
    return tb;
  }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
    List<Trackback> tb = null;
    try {
      HibernateUtil dh = new HibernateUtil();
      dh.setClass(Trackback.class);
      dh.setQuery("from trackback in class com.dotmarketing.beans.Trackback where url like '%"+ url+"%'");
      tb = (List<Trackback>) dh.list();
    } catch (DotHibernateException e) {
      Logger.error(TrackbackFactory.class, "getTrackbakByURL failed:" + e, e);
    }
    return tb;
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
  @Override
  protected List<Plugin> findPlugins() throws DotDataException {
    HibernateUtil hu = new HibernateUtil(Plugin.class);
    try{
      hu.setQuery("from Plugin");
      List<Plugin> plugins =  (List<Plugin>)hu.list();
      for (Plugin plugin : plugins) {
        cache.removePlugin(plugin.getId());
        cache.add(plugin);
      }
      return plugins;
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
      dh
          .setQuery("from tree in class com.dotmarketing.beans.Tree where parent = ? and relation_type = ? order by tree_order asc");
      dh.setParam(parent.getInode());
      dh.setParam(relationType);

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

    return new ArrayList<Tree>();
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.