Package org.olat.core.commons.persistence

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

264
265
266
267
268
269
270
271
272
  public List getBGOwnersOfBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select distinct id from org.olat.basesecurity.IdentityImpl as id inner join fetch id.user as iuser"
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl sgm" + ", org.olat.group.BusinessGroupImpl bg"
        + " where bg.groupContext = :context" + " and bg.ownerGroup = sgm.securityGroup" + " and sgm.identity = id";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    return query.list();
  }
View Full Code Here
277
278
279
280
281
282
283
284
285
286
287
288
289
  public int countBGOwnersOfBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select count(distinct id) from org.olat.basesecurity.IdentityImpl id"
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl sgm" + ", org.olat.group.BusinessGroupImpl bg"
        + " where bg.groupContext = :context" + " and bg.ownerGroup = sgm.securityGroup" + " and sgm.identity = id";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    List resultList = query.list();

    int result = 0;
    // if no join/group by matches, result list size is 0 and count undefined ->
    // result is 0
    if (resultList.size() > 0) {
View Full Code Here
300
301
302
303
304
305
306
307
308
  public List getBGParticipantsOfBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select distinct id from org.olat.basesecurity.IdentityImpl as id inner join fetch id.user as iuser"
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl sgm" + ", org.olat.group.BusinessGroupImpl bg"
        + " where bg.groupContext = :context" + " and bg.partipiciantGroup = sgm.securityGroup" + " and sgm.identity = id";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    return query.list();
  }
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
324
325
  public int countBGParticipantsOfBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = "select count(distinct id) from org.olat.basesecurity.IdentityImpl id"
        + ", org.olat.basesecurity.SecurityGroupMembershipImpl sgm" + ", org.olat.group.BusinessGroupImpl bg"
        + " where bg.groupContext = :context" + " and bg.partipiciantGroup = sgm.securityGroup" + " and sgm.identity = id";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    List resultList = query.list();
    int result = 0;
    // if no join/group by matches, result list size is 0 and count undefined ->
    // result is 0
    if (resultList.size() > 0) {
      Object obj = resultList.get(0);
View Full Code Here
352
353
354
355
356
357
358
359
360
361
362
363
364
365
      q.append(ownRestr);
    } else {
      throw new AssertException("illegal arguments: at leas one of asOwner or asParticipant must be true");
    }

    DBQuery query = db.createQuery(q.toString());
    query.setEntity("id", identity);
    query.setEntity("context", bgContext);
    query.setCacheable(true);
    List result = query.list();

    if (result.size() == 0) return false;
    return (((Long) result.get(0)).intValue() > 0);
  }
View Full Code Here
419
420
421
422
423
424
425
426
427
428
429
430
431
    boolean checkDefault = defaultContexts != nonDefaultContexts;
    if (checkDefault){
      q.append(" and context.defaultContext = :isDefault");
    }
    DBQuery query = db.createQuery(q.toString());
    query.setEntity("resource", resource);
    if (groupType != null) query.setString("gtype", groupType);
    if (checkDefault){
      query.setBoolean("isDefault", defaultContexts ? true : false);
    }
    return query.list();
  }
View Full Code Here
444
445
446
447
448
449
450
451
452
453
454
455
456
    boolean checkDefault = defaultContexts != nonDefaultContexts;
    if (checkDefault){
      q.append(" and context.defaultContext = :isDefault");
    }
    DBQuery query = db.createQuery(q.toString());
    query.setEntity("identity", identity);
    if (checkDefault){
      query.setBoolean("isDefault", defaultContexts ? true : false);
    }
   
    return query.list();
  }
View Full Code Here
459
460
461
462
463
464
465
466
467
   * @see org.olat.group.context.BGContextManager#findOLATResourcesForBGContext(org.olat.group.context.BGContext)
   */
  public List findOLATResourcesForBGContext(BGContext bgContext) {
    DB db = DBFactory.getInstance();
    String q = " select bgcr.resource from org.olat.group.context.BGContext2Resource as bgcr where bgcr.groupContext = :context";
    DBQuery query = db.createQuery(q);
    query.setEntity("context", bgContext);
    return query.list();
  }
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
    }
   
    String query = "select v from org.olat.repository.RepositoryEntry v"+
      " inner join fetch v.olatResource as ores"+
      " where ores.key = :oreskey";
    DBQuery dbQuery = DBFactory.getInstance().createQuery(query);
    dbQuery.setLong("oreskey", ores.getKey().longValue());
    dbQuery.setCacheable(true);
   
    List result = dbQuery.list();
    int size = result.size();
    if (strict) {
      if (size != 1)
        throw new AssertException("Repository resourceable lookup returned zero or more than one result: " + size);
    }
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
266
267
  public RepositoryEntry lookupRepositoryEntryBySoftkey(String softkey, boolean strict) {
    String query = "select v from org.olat.repository.RepositoryEntry v" +
      " inner join fetch v.olatResource as ores"+
      " where v.softkey = :softkey";
   
    DBQuery dbQuery = DBFactory.getInstance().createQuery(query);
    dbQuery.setString("softkey", softkey);
    dbQuery.setCacheable(true);
    List result = dbQuery.list();
   
    int size = result.size();
    if (strict) {
      if (size != 1)
        throw new AssertException("Repository softkey lookup returned zero or more than one result: " + size+", softKey = "+softkey);
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.