Package org.olat.core.commons.persistence

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

284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
   */
  public String lookupDisplayNameByOLATResourceableId(Long resId) {
    String query = "select v from org.olat.repository.RepositoryEntry v"+
      " inner join fetch v.olatResource as ores"+
      " where ores.resId = :resid";
    DBQuery dbQuery = DBFactory.getInstance().createQuery(query);
    dbQuery.setLong("resid", resId.longValue());
    dbQuery.setCacheable(true);
   
    List<RepositoryEntry> result = dbQuery.list();
    int size = result.size();
    if (size > 1) throw new AssertException("Repository lookup returned zero or more than one result: " + size);
    else if (size == 0) return null;
    RepositoryEntry entry = result.get(0);
    return entry.getDisplayname();
View Full Code Here
392
393
394
395
396
397
398
399
400
401
402
    StringBuilder query = new StringBuilder(400);
    query.append("select count(*) from" +
      " org.olat.repository.RepositoryEntry v, " +
      " org.olat.resource.OLATResourceImpl res " +
      " where v.olatResource = res and res.resName= :restrictedType and v.access >= :restrictedAccess ");
    DBQuery dbquery = DBFactory.getInstance().createQuery(query.toString());
    dbquery.setString("restrictedType", restrictedType);
    dbquery.setInteger("restrictedAccess", restrictedAccess);
    dbquery.setCacheable(true);
    return ((Long)dbquery.list().get(0)).intValue();
  }
View Full Code Here
411
412
413
414
415
416
417
418
419
420
  public List queryByType(String restrictedType) {
    String query = "select v from" +
      " org.olat.repository.RepositoryEntry v" +
      " inner join fetch v.olatResource as res"+
      " where res.resName= :restrictedType";
    DBQuery dbquery = DBFactory.getInstance().createQuery(query);
    dbquery.setString("restrictedType", restrictedType);
    dbquery.setCacheable(true);
    return dbquery.list();
  }
View Full Code Here
436
437
438
439
440
441
442
443
444
445
    else {
      if (roles.isAuthor()) query.append(RepositoryEntry.ACC_OWNERS_AUTHORS);
      else if (roles.isGuestOnly()) query.append(RepositoryEntry.ACC_USERS_GUESTS);
      else query.append(RepositoryEntry.ACC_USERS);
    }
    DBQuery dbquery = DBFactory.getInstance().createQuery(query.toString());
    dbquery.setString("restrictedType", restrictedType);
    dbquery.setCacheable(true);
    return dbquery.list();
  }
View Full Code Here
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
          + " and sgmsi.identity = identity"
          + " and identity.user = user"
          +" and user.properties['institutionalName']= :institutionCourseManager "
          + " and res.resName= :restrictedType and v.access = 1");
     
      DBQuery dbquery = DBFactory.getInstance().createQuery(query.toString());
      dbquery.setString("restrictedType", restrictedType);
      dbquery.setString("institutionCourseManager", institution);
      dbquery.setCacheable(true);
     
      List result = dbquery.list();
      result.addAll(queryByTypeLimitAccess(restrictedType, roles));
      return result;
     
    } else {
      return queryByTypeLimitAccess(restrictedType, roles);
View Full Code Here
507
508
509
510
511
512
513
514
515
        }

      }
      query.append(" )");
    }
    DBQuery dbquery = DBFactory.getInstance().createQuery(query.toString());
    dbquery.setEntity("identity", identity);
    return dbquery.list();
  }
View Full Code Here
522
523
524
525
526
527
528
529
530
531
   */
  public List queryByInitialAuthor(String initialAuthor) {
    String query = "select v from" +
      " org.olat.repository.RepositoryEntry v" +
      " where v.initialAuthor= :initialAuthor";
    DBQuery dbquery = DBFactory.getInstance().createQuery(query);
    dbquery.setString("initialAuthor", initialAuthor);
    dbquery.setCacheable(true);
    return dbquery.list();
  }
View Full Code Here
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
      desc = '%' + desc + '%';
      query.append(" and v.description like :desc");
    }
   
    // create query an set query data
    DBQuery dbquery = DBFactory.getInstance().createQuery(query.toString());
    dbquery.setEntity("identity", identity);
    dbquery.setInteger("access", RepositoryEntry.ACC_OWNERS_AUTHORS);
    if (author != null) {
      dbquery.setString("author", author);
    }
    if (displayName != null) {
      dbquery.setString("displayname", displayName);
    }
    if (desc != null) {
      dbquery.setString("desc", desc);
    }
    if (resourceTypes != null) {
      dbquery.setParameterList("resourcetypes", resourceTypes, Hibernate.STRING);
    }
    return dbquery.list();   
   
  }
View Full Code Here
639
640
641
642
643
644
645
646
647
648
      " org.olat.basesecurity.SecurityGroupMembershipImpl as sgmsi" +
      " where" +
      " v.ownerGroup = sgmsi.securityGroup "+
      " and sgmsi.identity = :identity and v.access >= :limitAccess";
   
    DBQuery dbquery = DBFactory.getInstance().createQuery(query);
    dbquery.setEntity("identity", identity);
    dbquery.setInteger("limitAccess", limitAccess);
    return dbquery.list();   
  }
View Full Code Here
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
    Tracing.logDebug("lastLoginLimit=" + lastUsageLimit, this.getClass());
    // 1. get all businness-groups with lastusage > x
    String query = "select gr from org.olat.group.BusinessGroupImpl as gr "
        + " where (gr.lastUsage = null or gr.lastUsage < :lastUsage)"
        + " and gr.type = :type ";
    DBQuery dbq = DBFactory.getInstance().createQuery(query);
    dbq.setDate("lastUsage", lastUsageLimit.getTime());
    dbq.setString("type", BusinessGroup.TYPE_BUDDYGROUP);
    List groups = dbq.list();
    // 2. get all businness-groups in deletion-process (email send)
    query = "select gr from org.olat.group.BusinessGroupImpl as gr"
      + " , org.olat.commons.lifecycle.LifeCycleEntry as le"
      + " where gr.key = le.persistentRef "
      + " and le.persistentTypeName ='org.olat.group.BusinessGroupImpl'"
      + " and le.action ='" + SEND_DELETE_EMAIL_ACTION + "' ";
    dbq = DBFactory.getInstance().createQuery(query);
    List groupsInProcess = dbq.list();
    // 3. Remove all groups in deletion-process from all unused-groups
    groups.removeAll(groupsInProcess);
    return groups;
  }
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.