Beispiel #1
0
 /**
  * Performs the work of inserting or updating the row in the database.
  *
  * If the object is new, it inserts it; otherwise an update is performed.
  * All related objects are also updated in this method.
  *
  * @param      PropelPDO $con
  * @return     int The number of rows affected by this insert/update and any referring fk objects' save() operations.
  * @throws     PropelException
  * @see        save()
  */
 protected function doSave(PropelPDO $con)
 {
     $affectedRows = 0;
     // initialize var to track total num of affected rows
     if (!$this->alreadyInSave) {
         $this->alreadyInSave = true;
         // We call the save method on the following object(s) if they
         // were passed to this object by their coresponding set
         // method.  This object relates to these object(s) by a
         // foreign key reference.
         if ($this->aQueryComment !== null) {
             if ($this->aQueryComment->isModified() || $this->aQueryComment->isNew()) {
                 $affectedRows += $this->aQueryComment->save($con);
             }
             $this->setQueryComment($this->aQueryComment);
         }
         if ($this->isNew()) {
             $this->modifiedColumns[] = QueryCommentTrackPeer::ID;
         }
         // If this object has been modified, then save it to the database.
         if ($this->isModified()) {
             if ($this->isNew()) {
                 $pk = QueryCommentTrackPeer::doInsert($this, $con);
                 $affectedRows += 1;
                 // we are assuming that there is only 1 row per doInsert() which
                 // should always be true here (even though technically
                 // BasePeer::doInsert() can insert multiple rows).
                 $this->setId($pk);
                 //[IMV] update autoincrement primary key
                 $this->setNew(false);
             } else {
                 $affectedRows += QueryCommentTrackPeer::doUpdate($this, $con);
             }
             $this->resetModified();
             // [HL] After being saved an object is no longer 'modified'
         }
         $this->alreadyInSave = false;
     }
     return $affectedRows;
 }
Beispiel #2
0
 public static function getComment($querytrackid, $featurevectortypeid, $distancetypeid, $userid = null)
 {
     if ($userid === null) {
         $user = sfContext::getInstance()->getUser();
         $userid = $user->getAttribute('userid');
     }
     $criteria = new Criteria();
     $criteria->add(QueryCommentPeer::SMINT_USER_ID, $userid);
     $criteria->add(QueryCommentPeer::QUERYTRACKID, $querytrackid);
     $criteria->add(QueryCommentPeer::FEATUREVECTORTYPEID, $featurevectortypeid);
     $criteria->add(QueryCommentPeer::DISTANCETYPEID, $distancetypeid);
     // get querycomment
     $comment = QueryCommentPeer::doSelectOne($criteria);
     // create if querycomment does not exist already
     if (is_null($comment)) {
         $comment = new QueryComment();
         $comment->setSmintUserId($userid);
         $comment->setQuerytrackid($querytrackid);
         $comment->setFeaturevectortypeid($featurevectortypeid);
         $comment->setDistancetypeid($distancetypeid);
         $comment->save();
     }
     return $comment;
 }