Package org.olat.core.commons.persistence

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

193
194
195
196
197
198
199
200
201
202
203
    getWindowControl().setError("Should generate error for rollback!");
    Tracing.logError("Should generate error for rollback and not reach this code",getClass());
  }
 
  private void doTestMixTransactionalError() {
    DB db = DBFactory.getInstance();
    PropertyManager pm = PropertyManager.getInstance();
    Property p1 = pm.createPropertyInstance(null, null, null, propertyCategory, propertyKey1, null, null, "doTestMixTransactional_1", null);
    pm.saveProperty(p1);
    // name is null => generated DB error => rollback
    Property p2 = pm.createPropertyInstance(null, null, null, propertyCategory, null, null, null, "doTestMixTransactional_2", null);
View Full Code Here
196
197
198
199
200
201
202
203
204
    ForumImpl fo = (ForumImpl) DBFactory.getInstance().loadObject(ForumImpl.class, forumKey);
    return fo;
  }

  private Forum saveForum(Forum forum) {
    DB db = DBFactory.getInstance();
    db.saveObject(forum);
    return forum;
  }
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
231
232
233
   *
   * @param forum
   */
  private void doDeleteForum(Forum forum) {
    Long forumKey = forum.getKey();
    DB db = DBFactory.getInstance();
    //delete read messsages
    db.delete("from readMsg in class org.olat.modules.fo.ReadMessageImpl where readMsg.forum = ? ", forumKey, Hibernate.LONG);
    // delete messages
    db.delete("from message in class org.olat.modules.fo.MessageImpl where message.forum = ?", forumKey, Hibernate.LONG);
    // delete forum
    db.delete("from forum in class org.olat.modules.fo.ForumImpl where forum.key = ?", forumKey, Hibernate.LONG);
    // delete properties   
  }
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
    deleteMessageRecursion(forumKey, m);
  }

  private void deleteMessageRecursion(Long forumKey, Message m) {
    deleteMessageContainer(forumKey, m.getKey());
    DB db = DBFactory.getInstance();
    Long message_id = m.getKey();
    List messages = db
        .find("select msg from msg in class org.olat.modules.fo.MessageImpl where msg.parent = ?", message_id, Hibernate.LONG);

    for (Iterator iter = messages.iterator(); iter.hasNext();) {
      Message element = (Message) iter.next();
      deleteMessageRecursion(forumKey, element);
    }

    /*
     * if (! db.contains(m)){ log.debug("Message " + m.getKey() + " not in
     * hibernate session, reloading before delete"); m =
     * loadMessage(m.getKey()); }
     */
    // make sure the message is reloaded if it is not in the hibernate session
    // cache
    m = (Message) db.loadObject(m);
    // delete all properties of one single message
    deleteMessageProperties(forumKey, m);
    db.deleteObject(m);
   
    if(isLogDebugEnabled()){
      logDebug("Deleting message ", m.getKey().toString());
    }
  }
View Full Code Here
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
   * @param m
   * @return true if the message has children
   */
  public boolean hasChildren(Message m) {
    boolean children = false;
    DB db = DBFactory.getInstance();
    Long message_id = m.getKey();
    String q = " select count(msg) from org.olat.modules.fo.MessageImpl msg where msg.parent = :input ";

    DBQuery query = db.createQuery(q);
    query.setLong("input", message_id.longValue());
    List result = query.list();
    int count = ((Long) result.get(0)).intValue();

    if (count > 0) {
View Full Code Here
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
  /**
   * deletes entry of one message
   */
  private void deleteMessageProperties(Long forumKey, Message m) {
    DB db = DBFactory.getInstance();
    Long messageKey = m.getKey();

    StringBuilder query = new StringBuilder();   
    query.append("from readMsg in class org.olat.modules.fo.ReadMessageImpl ");
    query.append("where readMsg.forum = ? ");
    query.append("and readMsg.message = ? ");

    db.delete(query.toString(), new Object[] { forumKey, messageKey }, new Type[] { Hibernate.LONG, Hibernate.LONG });
  }
View Full Code Here
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
      subthreadList.add(msg);
      getSubthread(msg, threadList, subthreadList);

      Iterator<Message> messageIterator = subthreadList.iterator();
      Message firstMessage = null;
      DB db = DBFactory.getInstance();
      if (messageIterator.hasNext()) {
        firstMessage = messageIterator.next();
        firstMessage = (Message) db.loadObject(firstMessage);
        firstMessage.setParent(null);
        firstMessage.setThreadtop(null);
        this.updateMessage(firstMessage, new ForumChangedEvent("split"));
        newTopMessage = firstMessage;
      }
      while (firstMessage != null && messageIterator.hasNext()) {
        Message message = messageIterator.next();
        message = (Message) db.loadObject(message);
        message.setThreadtop(firstMessage);
        this.updateMessage(message, null);
      } 
    }   
    return newTopMessage;
View Full Code Here
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
   * @param topMsg
   * @return the moved message
   */
  @SuppressWarnings("unchecked")
  public Message moveMessage(Message msg, Message topMsg) {
    DB db = DBFactory.getInstance();
    List<Message> oldThreadList = getThread(msg.getThreadtop().getKey());
    List<Message> subThreadList = new ArrayList<Message>();
    this.getSubthread(msg, oldThreadList, subThreadList);
    // one has to set a new parent for all childs of the moved message
    // first message of sublist has to get the parent from the moved message
    for(Message childMessage : subThreadList) {
      childMessage = (Message)db.loadObject(childMessage);
      childMessage.setParent(msg.getParent());
      updateMessage(childMessage, null);
    }
    // now move the message to the choosen thread
    Message oldMessage = (Message)db.loadObject(msg);
    Message message = createMessage();
    message.setCreator(oldMessage.getCreator());
    message.setForum(oldMessage.getForum());
    message.setModifier(oldMessage.getModifier());
    message.setTitle(oldMessage.getTitle());
View Full Code Here
395
396
397
398
399
400
401
402
403
   *
   * @param assessmentID
   * @return
   */
  public List findQtiResults(long assessmentID) {
    DB persister = DBFactory.getInstance();
    return persister.find("from q in class org.olat.ims.qti.QTIResult where q.assessmentID = ?",
        new Long(assessmentID), Hibernate.LONG);
  }
View Full Code Here
407
408
409
410
411
412
413
414
415
416
   * @param assessmentID
   * @param versionID
   * @return
   */
  public List findQtiResults(long assessmentID, long versionID) {
    DB persister = DBFactory.getInstance();
    return persister.find("from q in class org.olat.ims.qti.QTIResult where "
        + "q.assessmentID = ? and q.versionid = ?", new Object[]{new Long(assessmentID), new Long(versionID)},
        new Type[]{Hibernate.LONG, Hibernate.LONG});
  }
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.