Package org.olat.core.commons.persistence

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

407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
  /**
   * @see org.olat.group.context.BGContextManager#findBGContextsForResource(org.olat.resource.OLATResource,
   *      java.lang.String, boolean, boolean)
   */
  public List findBGContextsForResource(OLATResource resource, String groupType, boolean defaultContexts, boolean nonDefaultContexts) {
    DB db = DBFactory.getInstance();
    StringBuilder q = new StringBuilder();
    q.append(" select context from org.olat.group.context.BGContextImpl as context,");
    q.append(" org.olat.group.context.BGContext2Resource as bgcr");
    q.append(" where bgcr.resource = :resource");
    q.append(" and bgcr.groupContext = context");
    if (groupType != null) q.append(" and context.groupType = :gtype");

    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);
    }
View Full Code Here
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
  /**
   * @see org.olat.group.context.BGContextManager#findBGContextsForIdentity(org.olat.core.id.Identity,
   *      boolean, boolean)
   */
  public List findBGContextsForIdentity(Identity identity, boolean defaultContexts, boolean nonDefaultContexts) {
    DB db = DBFactory.getInstance();
    StringBuilder q = new StringBuilder();
    q.append(" select context from org.olat.group.context.BGContextImpl as context,");
    q.append(" org.olat.basesecurity.SecurityGroupMembershipImpl as secgmemb");
    q.append(" where context.ownerGroup = secgmemb.securityGroup");
    q.append(" and secgmemb.identity = :identity");

    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);
    }
   
View Full Code Here
457
458
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
72
73
74
75
76
77
78
79
80
81
82
  /**
   * TearDown is called after each test
   */
  public void tearDown() {
    try {
      DB db = DBFactory.getInstance();
      db.closeSession();
    } catch (Exception e) {
      log.error("Exception in tearDown(): " + e);
    }
  }
View Full Code Here
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
    DBFactory.getInstance().updateObject(identity);
  }

 
  public List<SecurityGroup> getSecurityGroupsForIdentity(Identity identity) {
    DB db = DBFactory.getInstance();
    List<SecurityGroup> secGroups = db.find(
        "select sgi from"
        + " org.olat.basesecurity.SecurityGroupImpl as sgi,"
        + " org.olat.basesecurity.SecurityGroupMembershipImpl as sgmsi "
        + " where sgmsi.securityGroup = sgi and sgmsi.identity = ?",
        new Object[] { identity.getKey() },
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
    UpgradeHistoryData uhd = upgradeManager.getUpgradesHistory(VERSION);
    if (!uhd.getBooleanDataValue(TASK_CREATE_DISCLAIMER_CONFIRMATION)) {
      // Get all system users
      Manager secMgr = ManagerFactory.getManager();
      RegistrationManager regMgr = RegistrationManager.getInstance();
      DB db = DBFactory.getInstance();
      // Get all users
      List<Identity> identities = secMgr.getVisibleIdentitiesByPowerSearch(null, null, false, null, null, null, null, null);
      // Remove the users that did already confirm the disclaimer
      List<Identity> confirmedIdentities = regMgr.getIdentitiesWithConfirmedDisclaimer();
      PersistenceHelper.removeObjectsFromList(identities, confirmedIdentities);
      // Set the disclaimer property for the remaining users
      for (int i = 0; i < identities.size(); i++) {
        Identity identity = identities.get(i);
        regMgr.setHasConfirmedDislaimer(identity);
        // write something to the console after each 100 user, this can take a
        // while with many users and it is handy to know that the system is
        // doing something
        if (i % 250 == 0) {
          log.audit("Busy creating disclaimer confirmation. Done with " + i + " of a total of " + identities.size() + " users. Please wait ...");
          db.intermediateCommit();
        }
      }
      log.audit("Done with creating disclaimer confirmation for " + identities.size() + " users");
     
      uhd.setBooleanDataValue(TASK_CREATE_DISCLAIMER_CONFIRMATION, true);
View Full Code Here
307
308
309
310
311
312
313
314
315
   * Delete all qti-results and qti-result-set entry for certain result-set.
   * @param rSet
   */
  private void deleteResultSet(QTIResultSet rSet) {
    Long rSetKey = rSet.getKey();
    DB db = DBFactory.getInstance();
    db.delete("from res in class org.olat.ims.qti.QTIResult where res.resultSet.key = ?", rSetKey, Hibernate.LONG);
    db.delete("from rset in class org.olat.ims.qti.QTIResultSet where rset.key = ?", rSetKey, Hibernate.LONG);
  }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
  /**
   * @param newBookmark
   */
  public void createAndPersistBookmark(Bookmark newBookmark) {
    DB db = DBFactory.getInstance();
    db.saveObject(newBookmark);
    if (log.isDebug()){
      log.debug("Bookmark has been created: " + newBookmark.getTitle());
    }
    fireBookmarkEvent(newBookmark.getOwner());   
  }
View Full Code Here
130
131
132
133
134
135
136
137
138
139
140
141
142
143
   *
   * @return TemporaryKey
   */
  public TemporaryKeyImpl createTemporaryKeyByEmail(String email, String ip, String action) {
    TemporaryKeyImpl tk = null;
    DB db = DBFactory.getInstance();
    // check if the user is already registered
    // we also try to find it in the temporarykey list
    List tks = db.find("from org.olat.registration.TemporaryKeyImpl as r where r.emailAddress = ?", email,
        Hibernate.STRING);
    if ((tks == null) || (tks.size() != 1)) { // no user found, create a new one
      tk = register(email, ip, action);
    } else {
      tk = (TemporaryKeyImpl) tks.get(0);
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
   * @param email
   *
   * @return the found temporary key or null if none is found
   */
  public TemporaryKeyImpl loadTemporaryKeyByEmail(String email) {
    DB db = DBFactory.getInstance();
    List tks = db.find("from r in class org.olat.registration.TemporaryKeyImpl where r.emailAddress = ?", email,
        Hibernate.STRING);
    if (tks.size() == 1) {
      return (TemporaryKeyImpl) tks.get(0);
    } else {
      return null;
View Full Code Here
TOP

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

  • de.bps.olat.modules.cl.ChecklistManager
  • org.olat.admin.user.bulkChange.UserBulkChangeManager
  • org.olat.basesecurity.IdentityTest
  • org.olat.basesecurity.PersistingManager
  • org.olat.basesecurity.SecurityManagerTest
  • org.olat.bookmark.BookmarkManagerImpl
  • org.olat.catalog.CatalogManager
  • org.olat.catalog.CatalogManagerTest
  • org.olat.core.commons.service.userComments.UserCommentsAndRatingsTest
  • org.olat.core.commons.services.commentAndRating.impl.UserCommentsManagerImpl
    • 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.