Package com.dotmarketing.db

Examples of com.dotmarketing.db.HibernateUtil$RunnablesExecutor

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$RunnablesExecutor

  • 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.