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