예제 #1
0
 /**
  * This is a method for emulating ON DELETE CASCADE for DBs that don't support this
  * feature (like MySQL or SQLite).
  *
  * This method is not very speedy because it must perform a query first to get
  * the implicated records and then perform the deletes by calling those Peer classes.
  *
  * This method should be used within a transaction if possible.
  *
  * @param      Criteria $criteria
  * @param      PropelPDO $con
  * @return int The number of affected rows (if supported by underlying database driver).
  */
 protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
 {
     // initialize var to track total num of affected rows
     $affectedRows = 0;
     // first find the objects that are implicated by the $criteria
     $objects = ExpedientePeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related Expedienteanticipo objects
         $criteria = new Criteria(ExpedienteanticipoPeer::DATABASE_NAME);
         $criteria->add(ExpedienteanticipoPeer::IDEXPEDIENTE, $obj->getIdexpediente());
         $affectedRows += ExpedienteanticipoPeer::doDelete($criteria, $con);
         // delete related Expedientearchivo objects
         $criteria = new Criteria(ExpedientearchivoPeer::DATABASE_NAME);
         $criteria->add(ExpedientearchivoPeer::IDEXPEDIENTE, $obj->getIdexpediente());
         $affectedRows += ExpedientearchivoPeer::doDelete($criteria, $con);
         // delete related Expedientegasto objects
         $criteria = new Criteria(ExpedientegastoPeer::DATABASE_NAME);
         $criteria->add(ExpedientegastoPeer::IDEXPEDIENTE, $obj->getIdexpediente());
         $affectedRows += ExpedientegastoPeer::doDelete($criteria, $con);
         // delete related Expedienteservicio objects
         $criteria = new Criteria(ExpedienteservicioPeer::DATABASE_NAME);
         $criteria->add(ExpedienteservicioPeer::IDEXPEDIENTE, $obj->getIdexpediente());
         $affectedRows += ExpedienteservicioPeer::doDelete($criteria, $con);
     }
     return $affectedRows;
 }
예제 #2
0
 /**
  * This is a method for emulating ON DELETE CASCADE for DBs that don't support this
  * feature (like MySQL or SQLite).
  *
  * This method is not very speedy because it must perform a query first to get
  * the implicated records and then perform the deletes by calling those Peer classes.
  *
  * This method should be used within a transaction if possible.
  *
  * @param      Criteria $criteria
  * @param      PropelPDO $con
  * @return int The number of affected rows (if supported by underlying database driver).
  */
 protected static function doOnDeleteCascade(Criteria $criteria, PropelPDO $con)
 {
     // initialize var to track total num of affected rows
     $affectedRows = 0;
     // first find the objects that are implicated by the $criteria
     $objects = EmpleadoPeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related Cliente objects
         $criteria = new Criteria(ClientePeer::DATABASE_NAME);
         $criteria->add(ClientePeer::IDEMPLEADOCOMERCIAL, $obj->getIdempleado());
         $affectedRows += ClientePeer::doDelete($criteria, $con);
         // delete related Cliente objects
         $criteria = new Criteria(ClientePeer::DATABASE_NAME);
         $criteria->add(ClientePeer::IDEMPLEADOOPERACIONES, $obj->getIdempleado());
         $affectedRows += ClientePeer::doDelete($criteria, $con);
         // delete related Expedientearchivo objects
         $criteria = new Criteria(ExpedientearchivoPeer::DATABASE_NAME);
         $criteria->add(ExpedientearchivoPeer::IDEMPLEADO, $obj->getIdempleado());
         $affectedRows += ExpedientearchivoPeer::doDelete($criteria, $con);
         // delete related Expedientegasto objects
         $criteria = new Criteria(ExpedientegastoPeer::DATABASE_NAME);
         $criteria->add(ExpedientegastoPeer::IDEMPLEADO, $obj->getIdempleado());
         $affectedRows += ExpedientegastoPeer::doDelete($criteria, $con);
     }
     return $affectedRows;
 }