/** * 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; if ($this->isNew()) { $this->modifiedColumns[] = BookPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = BookPeer::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 += BookPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } if ($this->collArticles !== null) { foreach ($this->collArticles as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
public function testIneffectualUpdateUsingBookObject() { $con = Propel::getConnection(BookPeer::DATABASE_NAME); $c = new Criteria(); $book = BookPeer::doSelectOne($c, $con); $count = $con->getQueryCount(); $book->setTitle($book->getTitle()); $book->setISBN($book->getISBN()); try { $rowCount = BookPeer::doUpdate($book, $con); $this->assertEquals(0, $rowCount, 'BookPeer::doUpdate() should indicate zero rows updated'); } catch (Exception $ex) { $this->fail('BookPeer::doUpdate() threw an exception'); } $this->assertEquals($count, $con->getQueryCount(), 'BookPeer::doUpdate() does not execute any queries when there are no changes'); }
/** * 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->aAuthor !== null) { if ($this->aAuthor->isModified() || $this->aAuthor->isNew()) { $affectedRows += $this->aAuthor->save($con); } $this->setAuthor($this->aAuthor); } if ($this->isNew()) { $this->modifiedColumns[] = BookPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $criteria = $this->buildCriteria(); if ($criteria->keyContainsValue(BookPeer::ID)) { throw new PropelException('Cannot insert a value for auto-increment primary key (' . BookPeer::ID . ')'); } $pk = BasePeer::doInsert($criteria, $con); $affectedRows += 1; $this->setId($pk); //[IMV] update autoincrement primary key $this->setNew(false); } else { $affectedRows += BookPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }
protected function doSave(PropelPDO $con) { $affectedRows = 0; if (!$this->alreadyInSave) { $this->alreadyInSave = true; if ($this->isNew()) { $this->modifiedColumns[] = BookPeer::ID; } if ($this->isModified()) { if ($this->isNew()) { $pk = BookPeer::doInsert($this, $con); $affectedRows += 1; $this->setId($pk); $this->setNew(false); } else { $affectedRows += BookPeer::doUpdate($this, $con); } $this->resetModified(); } if ($this->collArticles !== null) { foreach ($this->collArticles as $referrerFK) { if (!$referrerFK->isDeleted()) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
/** * 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->aAuthor !== null) { if ($this->aAuthor->isModified() || $this->aAuthor->isNew()) { $affectedRows += $this->aAuthor->save($con); } $this->setAuthor($this->aAuthor); } if ($this->isNew()) { $this->modifiedColumns[] = BookPeer::ID; } // If this object has been modified, then save it to the database. if ($this->isModified()) { if ($this->isNew()) { $pk = BookPeer::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 += BookPeer::doUpdate($this, $con); } $this->resetModified(); // [HL] After being saved an object is no longer 'modified' } $this->alreadyInSave = false; } return $affectedRows; }