Package com.dotmarketing.db

Examples of com.dotmarketing.db.HibernateUtil

1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
        return result;
  }

  @Override
  protected List<File> getRelatedFiles(Contentlet contentlet) throws DotDataException {
      HibernateUtil dh = new HibernateUtil(File.class);

        File f = new File();
        String tableName = f.getType();

        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(this, "HibernateUtilSQL:getRelatedFiles\n " + sql);

        dh.setSQLQuery(sql);

        Logger.debug(this, "inode:  " + contentlet.getInode() + "\n");

        dh.setParam(contentlet.getInode());

        return dh.list();
  }
View Full Code Here
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
            //tableName = ((Inode) Identifier.class.newInstance()).getType();
            tableName = "identifier";
        } catch (Exception e) {
            throw new DotDataException("Unable to instantiate identifier",e);
        }
        HibernateUtil dh = new HibernateUtil(Identifier.class);

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

        Logger.debug(this, "HibernateUtilSQL:getChildOfClassByRelationType\n " + sql + "\n");

        dh.setSQLQuery(sql);

        Logger.debug(this, "contentlet inode:  " + contentlet.getInode() + "\n");

        dh.setParam(contentlet.getInode());
        dh.setParam(relationshipType);

        return (Identifier)dh.load();
  }
View Full Code Here
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
        return (Identifier)dh.load();
  }

  @Override
  protected List<Link> getRelatedLinks(Contentlet contentlet) throws DotDataException {
      HibernateUtil dh = new HibernateUtil(Link.class);

        Link l = new Link();
        String tableName = l.getType();

        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(this, "HibernateUtilSQL:getRelatedLinks\n " + sql);

        dh.setSQLQuery(sql);

        Logger.debug(this, "inode:  " + contentlet.getInode() + "\n");

        dh.setParam(contentlet.getInode());

        return dh.list();
  }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
   * Get a list of all the tags created
   * @return list of all tags created
   */
  public static java.util.List<Tag> getAllTags() {
    try {
      HibernateUtil dh = new HibernateUtil(Tag.class);
      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag");
            List list = dh.list();
          return list;
    }
    catch (Exception e) {}
    return new ArrayList();
  }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
   */
  public static java.util.List<Tag> getTagByName(String name) {
        try {
      name = escapeSingleQuote(name);

      HibernateUtil dh = new HibernateUtil(Tag.class);
            dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where lower(tagName) = ?");
            dh.setParam(name.toLowerCase());

            List list = dh.list();
          return list;
        } catch (Exception e) {
            Logger.warn(Tag.class, "getTagByName failed:" + e, e);
        }
        return new ArrayList();
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
   * @param userId id of the user
   * @return a list of all the tags created
   */
  public static java.util.List<Tag> getTagByUser(String userId) {
        try {
            HibernateUtil dh = new HibernateUtil(Tag.class);
            String userIdParam = "%"+userId+"%";
            dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where user_id like ?");
            dh.setParam(userIdParam);

            List list = dh.list();

          return list;
        } catch (Exception e) {
            Logger.warn(Tag.class, "getTagByUser failed:" + e, e);
        }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
   * @return tag
   */
  public static Tag getTag(String name, String userId) {

    // validating if exists a tag with the name provided
        HibernateUtil dh = new HibernateUtil(Tag.class);
        Tag tag =null;
        try {
      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag where lower(tagName) = ?");
      dh.setParam(name.toLowerCase());

      tag = (Tag) dh.load();
    } catch (DotHibernateException e) {
      Logger.error(TagFactory.class,"getTag failed:" + e, e);
    }
        // if doesn't exists then the tag is created
        if (tag.getTagName() == null) {
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
   */
  public static 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
44
45
46
47
48
49
50
51
52
53
54
55
56
   * Get a list of all the tags created
   * @return list of all tags created
   */
  public java.util.List<Tag> getAllTags() {
    try {
      HibernateUtil dh = new HibernateUtil(Tag.class);
      dh.setQuery("from tag in class com.dotmarketing.tag.model.Tag");
            List list = dh.list();
          return list;
    }
    catch (Exception e) {}
    return new ArrayList();
  }
View Full Code Here
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
   */
  public static 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
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.