Package com.dotmarketing.db

Examples of com.dotmarketing.db.HibernateUtil

216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
   * @return tag
   */
  public Tag getTag(String name, String userId, String hostId) throws Exception {
    String existHostId;
    // validating if exists a tag with the name provided
        HibernateUtil dh = new HibernateUtil(List.class);
      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where lower(tagName) = ?");
        dh.setParam(name.toLowerCase());

        Tag newTag = new Tag();
        List<Tag> tags = (List<Tag>) dh.list();
        // if doesn't exists then the tag is created
        if (tags == null || tags.size() == 0) {
          // creating tag
          return saveTag(name, userId, hostId);
        }
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
  public static java.util.List getChildrenClass(Inode p1, Inode p2, Class c) {

    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 order by multi_tree.tree_order";
            Logger.debug(MultiTreeFactory.class, "getChildrenClass\n " + sql+ "\n");
      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, "getChildrenClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
306
307
308
   * @return tag
   * @throws DotHibernateException
   */
  public Tag getTagByTagId(String tagId) throws DotHibernateException {

        HibernateUtil dh = new HibernateUtil(Tag.class);

      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where tag_id = ?");
        dh.setParam(tagId);

        Tag tag = (Tag) dh.load();

        return tag;
  }
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
      if(c.getName().contains("Identifier")){
        tableName = "identifier";
      }else{
        tableName = ((Inode) c.newInstance()).getType();
      }
      HibernateUtil dh = new HibernateUtil(c);
      if(tableName.equalsIgnoreCase("identifier")){
        sql = "SELECT {"  + tableName + ".*} from " + tableName + " " + tableName + ", multi_tree multi_tree "
        + " where multi_tree.parent1 = ? and multi_tree.parent2 = ? and multi_tree.child = " + tableName + ".id and "
        + " order by multi_tree.tree_order";
      }else {
        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 order by multi_tree.tree_order";
      }
           
      Logger.debug(MultiTreeFactory.class, "getChildrenClass\n " + sql+ "\n");
     
      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, "getChildrenClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
   * @return tag
   * @throws DotHibernateException
   */
  public Tag getTagByTagIdAndHostId(String tagId, String hostId) throws DotHibernateException {

        HibernateUtil dh = new HibernateUtil(Tag.class);

      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where tag_id = ? and host_id = ?");
        dh.setParam(tagId);
        dh.setParam(hostId);

        Tag tag = (Tag) dh.load();

        return tag;
  }
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
  }
 
  public static java.util.List getChildrenClass(Inode p1, Inode p2, Class c, String orderBy) {
    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 order by " + orderBy;
            Logger.debug(MultiTreeFactory.class, "hibernateUtilSQL:getChildrenClass\n " + sql+ "\n");
      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, "getChildrenClass failed:" + e, e);
      throw new DotRuntimeException(e.toString());
    }
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
   */
  public List getAllTag(String userId) {
    try {
      User searcherUser = APILocator.getUserAPI().loadUserById(userId,APILocator.getUserAPI().getSystemUser(),false);

      HibernateUtil dh = new HibernateUtil();
      StringBuffer sb = new StringBuffer();
      sb.append("select Tag.*, User_.firstName, User_.lastName from Tag, User_ ");
      sb.append("where Tag.user_id = User_.userid ");
      sb.append("order by Tag.user_id");
      dh.setQuery(sb.toString());

      List allTags = dh.list();

      java.util.List matchesArray = new ArrayList();
      Iterator it = allTags.iterator();
      for (int i = 0; it.hasNext(); i++) {
        User user = null;
View Full Code Here
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
   */
  public List getTagInfoByName(String name) {
    try {
      name = escapeSingleQuote(name);

      HibernateUtil dh = new HibernateUtil();
      StringBuffer sb = new StringBuffer();
      sb.append("select Tag.*, User_.firstName, User_.lastName from Tag, User_ ");
      sb.append("where Tag.user_id = User_.userid and ");
      sb.append("lower(Tag.tagName) like '%"+name.toLowerCase()+"%' ");
      sb.append("order by Tag.user_id");

      dh.setQuery(sb.toString());

      java.util.List allTags = dh.list();

      return allTags;
    }
    catch (Exception e) {}

View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
                        dc.setSQL(sql);
                        dc.addParam(id);
                        List<Map<String, Object>> versions = dc.loadObjectResults();
                        String inode=versions.get(0).get("inode").toString();
                       
                        HibernateUtil hu=new HibernateUtil(UtilMethods.getVersionableClass(table));
                        Versionable workingVersion=(Versionable) hu.load(inode);
                        APILocator.getVersionableAPI().setWorking(workingVersion);
                       
                        total++;
                    }
                }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    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.parent = ? and tree.child = " + tableName + ".inode and " + tableName
      + "_1_.inode = " + tableName + ".inode and "+tableName+"_1_.type = '"+tableName+"'";

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

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

      dh.setSQLQuery(sql);

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

      return dh.load();
    } catch (Exception e) {
      Logger.error(InodeFactory.class, "getChildrenClass 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.