Package org.olat.core.commons.persistence

Examples of org.olat.core.commons.persistence.DBQuery

684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
        // then we would run into an ERROR when we'd do more with this DB
        // hence we just issue a log.info here with the details
        //@TODO: lower to log_.info once we checked that it doesn't occur very often (best for 6.4)
        log_.warn("log: DB is in Error state therefore the UserActivityLoggerImpl cannot update the simpleDuration of log_id "+lastLogObj.getKey()+" with value "+duration+", loggingObject: "+lastLogObj);
      } else {
        DBQuery update = DBFactory.getInstance().createQuery(
            "update org.olat.core.logging.activity.LoggingObject set simpleDuration = :duration where log_id = :logid");
        update.setLong("duration", duration);
        update.setLong("logid", lastLogObj.getKey());
        // we have to do FlushMode.AUTO (which is the default anyway)
        update.executeUpdate(FlushMode.AUTO);
      }
    }
   
    // store the current logging object in the session - for duration calculation at next log
    session_.putEntry(USESS_KEY_USER_ACTIVITY_LOGGING_LAST_LOG, logObj);
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
  /**
   * @see org.olat.core.commons.services.commentAndRating.UserRatingsManager#calculateRatingAverage()
   */
  @Override
  public Float calculateRatingAverage() {
    DBQuery query;
    if (getOLATResourceableSubPath() == null) {
      // special query when sub path is null
      query = DBFactory
          .getInstance()
          .createQuery(
              "select avg(rating) from UserRatingImpl where resName=:resname AND resId=:resId AND resSubPath is NULL");
    } else {
      query = DBFactory
          .getInstance()
          .createQuery(
              "select avg(rating) from UserRatingImpl where resName=:resname AND resId=:resId AND resSubPath=:resSubPath");
      query.setString("resSubPath", getOLATResourceableSubPath());
    }
    query.setString("resname", getOLATResourceable()
        .getResourceableTypeName());
    query.setLong("resId", getOLATResourceable().getResourceableId());
    query.setCacheable(true);
    //
    List results = query.list();
    Double average = (Double) query.list().get(0);
    // When no ratings are found, a null value is returned!
    if (average == null) return Float.valueOf(0);
    else return average.floatValue();     
  }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
  /**
   * @see org.olat.core.commons.services.commentAndRating.UserRatingsManager#countRatings()
   */
  @Override
  public Long countRatings() {
    DBQuery query;
    if (getOLATResourceableSubPath() == null) {
      // special query when sub path is null
      query = DBFactory
          .getInstance()
          .createQuery(
              "select count(*) from UserRatingImpl where resName=:resname AND resId=:resId AND resSubPath is NULL");
    } else {
      query = DBFactory
          .getInstance()
          .createQuery(
              "select count(*) from UserRatingImpl where resName=:resname AND resId=:resId AND resSubPath=:resSubPath");
      query.setString("resSubPath", getOLATResourceableSubPath());
    }
    query.setString("resname", getOLATResourceable()
        .getResourceableTypeName());
    query.setLong("resId", getOLATResourceable().getResourceableId());
    query.setCacheable(true);
    //
    Long count = (Long) query.list().get(0);
    return count;
  }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
   *
   * @see org.olat.core.commons.services.commentAndRating.UserRatingsManager#getRating(org.olat.core.id.Identity)
   */
  @Override
  public UserRating getRating(Identity identity) {
    DBQuery query;
    if (getOLATResourceableSubPath() == null) {
      // special query when sub path is null
      query = DBFactory
          .getInstance()
          .createQuery(
              "select userRating from UserRatingImpl as userRating where creator=:creator AND resName=:resname AND resId=:resId AND resSubPath is NULL ");
    } else {
      query = DBFactory
          .getInstance()
          .createQuery(
              "select userRating from UserRatingImpl as userRating where creator=:creator AND resName=:resname AND resId=:resId AND resSubPath=:resSubPath");
      query.setString("resSubPath", getOLATResourceableSubPath());
    }
    query.setString("resname", getOLATResourceable()
        .getResourceableTypeName());
    query.setLong("resId", getOLATResourceable().getResourceableId());
    query.setEntity("creator", identity);
    query.setCacheable(true);
    //
    List<UserRating> results = query.list();
    if (results.size() == 0) return null;   
    return results.get(0);
  }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
  /**
   * @see org.olat.core.commons.services.commentAndRating.UserCommentsManager#countComments()
   */
  @Override
  public Long countComments() {
    DBQuery query;
    if (getOLATResourceableSubPath() == null) {
      // special query when sub path is null
      query = DBFactory
          .getInstance()
          .createQuery(
              "select count(*) from UserCommentImpl where resName=:resname AND resId=:resId AND resSubPath is NULL");
    } else {
      query = DBFactory
          .getInstance()
          .createQuery(
              "select count(*) from UserCommentImpl where resName=:resname AND resId=:resId AND resSubPath=:resSubPath");
      query.setString("resSubPath", getOLATResourceableSubPath());
    }
    query.setString("resname", getOLATResourceable()
        .getResourceableTypeName());
    query.setLong("resId", getOLATResourceable().getResourceableId());
    query.setCacheable(true);
    //
    Long count = (Long) query.list().get(0);
    return count;
  }
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
  /**
   * @see org.olat.core.commons.services.commentAndRating.UserCommentsManager#getComments()
   */
  @Override
  public List<UserComment> getComments() {
    DBQuery query;
    if (getOLATResourceableSubPath() == null) {
      // special query when sub path is null
      query = DBFactory
          .getInstance()
          .createQuery(
              "select comment from UserCommentImpl as comment where resName=:resname AND resId=:resId AND resSubPath is NULL");
    } else {
      query = DBFactory
          .getInstance()
          .createQuery(
              "select comment from UserCommentImpl as comment where resName=:resname AND resId=:resId AND resSubPath=:resSubPath");
      query.setString("resSubPath", getOLATResourceableSubPath());
    }
    query.setString("resname", getOLATResourceable()
        .getResourceableTypeName());
    query.setLong("resId", getOLATResourceable().getResourceableId());
    query.setCacheable(true);
    //
    List<UserComment> results = query.list();
    return results;
  }
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
221
222
      // Original comment has been deleted in the meantime. Don't delete it again.
      return 0;
    }
    DB db = DBFactory.getInstance();
    // First deal with all direct replies
    DBQuery query = db.createQuery("select comment from UserCommentImpl as comment where parent=:parent");
    query.setEntity("parent", comment);
    List<UserComment> replies = query.list();
    if (deleteReplies) {
      // Since we have a many-to-one we first have to recursively delete
      // the replies to prevent foreign key constraints
      for (UserComment reply : replies) {
        counter += deleteComment(reply, true);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
60
61
62
    return INSTANCE;
  }
 
  LockImpl findLock(String asset) {
    Tracing.logInfo("findLock: "+asset+" START", getClass());
    DBQuery q = DBFactory.getInstance().createQuery(
        "select alock from org.olat.commons.coordinate.cluster.lock.LockImpl as alock inner join fetch alock.owner where alock.asset = :asset");
    q.setParameter("asset", asset);
    List res = q.list();
    if (res.size() == 0) {
      Tracing.logInfo("findLock: null END", getClass());
      return null;
    } else {
      Tracing.logInfo("findLock: "+res.get(0)+" END", getClass());
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
  }
 
  @SuppressWarnings("unchecked")
  List<LockImpl> getAllLocks() {
    Tracing.logInfo("getAllLocks START", getClass());
    DBQuery q = DBFactory.getInstance().createQuery(
        "select alock from org.olat.commons.coordinate.cluster.lock.LockImpl as alock inner join fetch alock.owner");
    List<LockImpl> res = q.list();
    Tracing.logInfo("getAllLocks END. res.length:"+ (res==null ? "null" : res.size()), getClass());
    return res;
  }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
    }
    if (end != null) {
      query = query.concat(" AND (v.creationDate < :createdBefore)");
    }

    DBQuery dbQuery = DBFactory.getInstance().createQuery(query);
    dbQuery.setBoolean("resAdminAction", resourceAdminAction);
    dbQuery.setString("resId", Long.toString(resourceableId));
    if (begin != null) {
      dbQuery.setDate("createdAfter", begin);
    }
    if (end != null) {
      Calendar cal = Calendar.getInstance();
      cal.setTime(end);
      cal.add(Calendar.DAY_OF_MONTH, 1);
      end = cal.getTime();
      dbQuery.setDate("createdBefore", end);
    }

    List queryResult = dbQuery.list();
    result.append(logLineConverter_.getCSVHeader());
    result.append(LINE_SEPARATOR);
   
    for (Object loggingObject : queryResult) {
      result.append(logLineConverter_.getCSVRow((LoggingObject)loggingObject, anonymize, resourceableId ));
View Full Code Here
TOP

Related Classes of org.olat.core.commons.persistence.DBQuery

  • org.olat.admin.user.delete.service.UserDeletionManager
  • org.olat.basesecurity.PersistingManager
  • org.olat.catalog.CatalogManager
  • org.olat.commons.coordinate.cluster.lock.ClusterLockManager
  • org.olat.commons.lifecycle.LifeCycleManager
  • org.olat.core.commons.services.commentAndRating.impl.UserCommentsManagerImpl
  • org.olat.core.commons.services.commentAndRating.impl.UserRatingsManagerImpl
  • org.olat.core.logging.activity.UserActivityLoggerImpl
  • org.olat.course.assessment.NewCachePersistingAssessmentManager
  • org.olat.course.properties.PersistingCoursePropertyManager
    • 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.