Examples of DB


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

    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

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

   * @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

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

  /**
   * 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

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

      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

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

   * @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

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

   *
   * @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

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

   * @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

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

   * @param versionID
   * @param itemIdent
   * @return
   */
  public List findQtiResults(long assessmentID, long versionID, String itemIdent) {
    DB persister = DBFactory.getInstance();
    return persister.find("from q in class org.olat.ims.qti.QTIResult where "
        + "q.assessmentID = ? and q.versionid = ? and q.itemident = ?", new Object[]{new Long(assessmentID),
        new Long(versionID), itemIdent}, new Type[]{Hibernate.LONG, Hibernate.LONG, Hibernate.STRING});
  }
View Full Code Here

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

   * @param olatResourceDetail
   * @return Returns the last recorded QTIResultSet
   */
  public QTIResultSet getLastResultSet(Identity identity, long olatResource, String olatResourceDetail) {
    QTIResultSet returnQTIResultSet=null;
    DB persister = DBFactory.getInstance();
    List resultSetList =  persister.find("from q in class org.olat.ims.qti.QTIResultSet where "
        + "q.identity = ? and q.olatResource = ? and q.olatResourceDetail = ? order by q.creationDate desc", new Object[]{identity.getKey(), new Long(olatResource), new String(olatResourceDetail)},
        new Type[]{Hibernate.LONG, Hibernate.LONG, Hibernate.STRING});
    Iterator resultSetIterator = resultSetList.iterator();
    while(resultSetIterator.hasNext()) {
      returnQTIResultSet = (QTIResultSet)resultSetIterator.next();
View Full Code Here

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

  /**
   * TearDown is called after each test
   */
  public void tearDown() {
    try {
      DB db = DBFactory.getInstance();
      db.closeSession();
    } catch (Exception e) {
      Tracing.logError("Exception in tearDown(): " + e, IMUnitTest.class);
    }
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.