/**
* Removes this object from datastore and sets delete attribute.
*
* @param PropelPDO $con
* @return void
* @throws PropelException
* @see BaseObject::setDeleted()
* @see BaseObject::isDeleted()
*/
public function delete(PropelPDO $con = null)
{
if ($this->isDeleted()) {
throw new PropelException("This object has already been deleted.");
}
if ($con === null) {
$con = Propel::getConnection(SfReviewPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$con->beginTransaction();
try {
$ret = $this->preDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BaseSfReview:delete:pre') as $callable) {
if ($ret = call_user_func($callable, $this, $con)) {
return;
}
}
if ($ret) {
SfReviewPeer::doDelete($this, $con);
$this->postDelete($con);
// symfony_behaviors behavior
foreach (sfMixer::getCallables('BaseSfReview:delete:post') as $callable) {
call_user_func($callable, $this, $con);
}
$this->setDeleted(true);
$con->commit();
} else {
$con->commit();
}
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
public static function deleteReviewById($id)
{
// Primero borrar sus opiniones
$c = new Criteria();
$c->add(SfReviewPeer::SF_GUARD_USER_ID, $id);
$reviews = SfReviewPeer::doSelect($c);
foreach ($reviews as $review) {
$c2 = new Criteria();
$c2->add(SfReviewPeer::SF_REVIEW_ID, $review->getId());
$c2->add(SfReviewPeer::SF_REVIEW_TYPE_ID, null);
SfReviewPeer::doDelete($c2);
}
SfReviewPeer::doDelete($c);
}