Package org.olat.core.commons.persistence

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

182
183
184
185
186
187
188
189
190
191
192
193
   * @param action
   *
   * @return the found temporary key or null if none is found
   */
  public List<TemporaryKey> loadTemporaryKeyByAction(String action) {
    DB db = DBFactory.getInstance();
    List<TemporaryKey> tks = db.find("from r in class org.olat.registration.TemporaryKeyImpl where r.regAction = ?", action, Hibernate.STRING);
    if (tks.size() > 0) {
      return tks;
    } else {
      return null;
    }
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
210
   * @param regkey the encrypted registrationkey
   *
   * @return the found TemporaryKey or null if none is found
   */
  public TemporaryKeyImpl loadTemporaryKeyByRegistrationKey(String regkey) {
    DB db = DBFactory.getInstance();
    List tks = db.find("from r in class org.olat.registration.TemporaryKeyImpl where r.registrationKey = ?", regkey,
        Hibernate.STRING);
    if (tks.size() == 1) {
      return (TemporaryKeyImpl) tks.get(0);
    } else {
      return null;
View Full Code Here
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
   * recursively delete the structure starting from the catalog entry.
   *
   * @param ce
   */
  private void deleteCatalogSubtree(CatalogEntry ce, List secGroupsToBeDeleted) {
    DB db = DBFactory.getInstance();

    List children = getChildrenOf(ce);
    Iterator iter = children.iterator();
    while (iter.hasNext()) {
      CatalogEntry nextCe = (CatalogEntry) iter.next();
      deleteCatalogSubtree(nextCe,secGroupsToBeDeleted);
    }
    ce = (CatalogEntry) db.loadObject(ce);
    //mark owner group for deletion.
    SecurityGroup owner = ce.getOwnerGroup();
    if (owner != null) secGroupsToBeDeleted.add(owner);
    // delete user bookmarks
    OLATResourceable ores = createOLATResouceableFor(ce);
    BookmarkManager.getInstance().deleteAllBookmarksFor(ores);
    // delete catalog entry itself
    db.deleteObject(ce);
  }
View Full Code Here
334
335
336
337
338
339
340
341
342
343
344
345
346
347
    if (!uhd.getBooleanDataValue(TASK_MIGRATE_WIKICODE_REPOENTRY)) {
      log.audit("+---------------------------------------------------------------+");
      log.audit("+...     " + TASK_MIGRATE_WIKICODE_REPOENTRY + "     ...+");
      log.audit("+---------------------------------------------------------------+");

      DB db = DBFactory.getInstance();
      StringBuilder q = new StringBuilder();
      q.append(" select repoEntry from org.olat.repository.RepositoryEntry as repoEntry");
      DBQuery query = db.createQuery(q.toString());
      List<RepositoryEntry> entries = (List<RepositoryEntry>) query.list();
      RepositoryManager repoManager = RepositoryManager.getInstance();
      if (log.isDebug()) log.info("Migrating " + entries.size() + " Repository Entires.");
      int counter = 0;
      for (RepositoryEntry entry : entries) {
View Full Code Here
374
375
376
377
378
379
380
381
382
383
384
385
386
387
    if (!uhd.getBooleanDataValue(TASK_MIGRATE_WIKICODE_BGCONTEXT)) {
      log.audit("+---------------------------------------------------------------+");
      log.audit("+...     " + TASK_MIGRATE_WIKICODE_BGCONTEXT + "     ...+");
      log.audit("+---------------------------------------------------------------+");

      DB db = DBFactory.getInstance();
      StringBuilder q = new StringBuilder();
      q.append(" select context from org.olat.group.context.BGContextImpl as context");
      DBQuery query = db.createQuery(q.toString());

      List<BGContext> contexts = (List<BGContext>) query.list();
      if (log.isDebug()) log.info("Migrating " + contexts.size() + " BG Contexts.");
      BGContextManager contextManager = BGContextManagerImpl.getInstance();
      int bgcounter = 0;
View Full Code Here
417
418
419
420
421
422
423
424
425
426
427
428
429
    if (!uhd.getBooleanDataValue(TASK_MIGRATE_WIKICODE_BGAREA)) {
      log.audit("+---------------------------------------------------------------+");
      log.audit("+...     " + TASK_MIGRATE_WIKICODE_BGAREA + "     ...+");
      log.audit("+---------------------------------------------------------------+");

      DB db = DBFactory.getInstance();
      String q = "select area from org.olat.group.area.BGAreaImpl area ";
      DBQuery query = db.createQuery(q);
      List<BGArea> areas = query.list();
      if (log.isDebug()) log.info("Migrating " + areas.size() + " BG areas.");
      BGAreaManager bgM = BGAreaManagerImpl.getInstance();
      int bgcounter = 0;
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
153
154
   * @param identity
   * @return List of Subscriber Objects which belong to the identity
   */
  @SuppressWarnings("unchecked")
  public List<Subscriber> getSubscribers(Identity identity) {
    DB db = DBFactory.getInstance();
    String q = "select sub from org.olat.notifications.SubscriberImpl sub"
        + " inner join fetch sub.publisher where sub.identity = :anIdentity";
    DBQuery query = db.createQuery(q);
    query.setEntity("anIdentity", identity);
    List<Subscriber> res = query.list();
    return res;
  }
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
170
171
172
   *         publishers are valid
   */
  @SuppressWarnings("unchecked")
  public List<Subscriber> getValidSubscribers(Identity identity) {
    //pub.getState() == PUB_STATE_OK;
    DB db = DBFactory.getInstance();
    String q = "select sub from org.olat.notifications.SubscriberImpl sub" + " inner join fetch sub.publisher as pub"
        + " where sub.identity = :anIdentity" + " and pub.state = :aState";
    DBQuery query = db.createQuery(q);
    query.setEntity("anIdentity", identity);
    query.setLong("aState", PUB_STATE_OK);
    List<Subscriber> res = query.list();
    return res;
  }
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
185
186
187
  /**
   * @see org.olat.core.util.notifications.NotificationsManager#getValidSubscribersOf(org.olat.core.util.notifications.Publisher)
   */
  @SuppressWarnings("unchecked")
  public List<Subscriber> getValidSubscribersOf(Publisher publisher) {
    DB db = DBFactory.getInstance();
    String q = "select sub from org.olat.notifications.SubscriberImpl sub inner join fetch sub.identity"
        + " where sub.publisher = :publisher"
        + " and sub.publisher.state = "+PUB_STATE_OK;
    DBQuery query = db.createQuery(q);
    query.setEntity("publisher", publisher);
    List<Subscriber> res = query.list();
    return res;
  }
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
202
203
   * @return a list of subscribers ordered by the name of the identity of the
   *         subscription
   */
  @SuppressWarnings("unchecked")
  private List<Subscriber> getAllValidSubscribers() {
    DB db = DBFactory.getInstance();
    String q = "select sub from org.olat.notifications.SubscriberImpl sub" + " inner join fetch sub.publisher as pub"
        + " where pub.state = :aState" + " order by sub.identity.name";
    DBQuery query = db.createQuery(q);
    query.setLong("aState", PUB_STATE_OK);
    List<Subscriber> res = query.list();
    return res;
  }
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.