/**
* Exchange the rank of the object with the one passed as argument, and saves both objects
*
* @param Store $object
* @param PropelPDO $con optional connection
*
* @return Store the current object
*
* @throws Exception if the database cannot execute the two updates
*/
public function swapWith($object, PropelPDO $con = null)
{
if ($con === null) {
$con = Propel::getConnection(StorePeer::DATABASE_NAME);
}
$con->beginTransaction();
try {
$oldRank = $this->getSortableRank();
$newRank = $object->getSortableRank();
$this->setSortableRank($newRank);
$this->save($con);
$object->setSortableRank($oldRank);
$object->save($con);
$con->commit();
return $this;
} catch (Exception $e) {
$con->rollback();
throw $e;
}
}
/**
* 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 corresponding set
// method. This object relates to these object(s) by a
// foreign key reference.
if ($this->aUser !== null) {
if ($this->aUser->isModified() || $this->aUser->isNew()) {
$affectedRows += $this->aUser->save($con);
}
$this->setUser($this->aUser);
}
if ($this->aStore !== null) {
if ($this->aStore->isModified() || $this->aStore->isNew()) {
$affectedRows += $this->aStore->save($con);
}
$this->setStore($this->aStore);
}
if ($this->isNew() || $this->isModified()) {
// persist changes
if ($this->isNew()) {
$this->doInsert($con);
} else {
$this->doUpdate($con);
}
$affectedRows += 1;
$this->resetModified();
}
if ($this->transactionsScheduledForDeletion !== null) {
if (!$this->transactionsScheduledForDeletion->isEmpty()) {
TransactionQuery::create()->filterByPrimaryKeys($this->transactionsScheduledForDeletion->getPrimaryKeys(false))->delete($con);
$this->transactionsScheduledForDeletion = null;
}
}
if ($this->collTransactions !== null) {
foreach ($this->collTransactions as $referrerFK) {
if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) {
$affectedRows += $referrerFK->save($con);
}
}
}
$this->alreadyInSave = false;
}
return $affectedRows;
}
