Exemplo n.º 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 = RakPeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related LinkBarangRak objects
         $criteria = new Criteria(LinkBarangRakPeer::DATABASE_NAME);
         $criteria->add(LinkBarangRakPeer::ID_RAK, $obj->getId());
         $affectedRows += LinkBarangRakPeer::doDelete($criteria, $con);
     }
     return $affectedRows;
 }
Exemplo n.º 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 = BarangPeer::doSelect($criteria, $con);
     foreach ($objects as $obj) {
         // delete related DetailBarangMasuk objects
         $criteria = new Criteria(DetailBarangMasukPeer::DATABASE_NAME);
         $criteria->add(DetailBarangMasukPeer::ID_BARANG, $obj->getId());
         $affectedRows += DetailBarangMasukPeer::doDelete($criteria, $con);
         // delete related DetailTransaksi objects
         $criteria = new Criteria(DetailTransaksiPeer::DATABASE_NAME);
         $criteria->add(DetailTransaksiPeer::ID_BARANG, $obj->getId());
         $affectedRows += DetailTransaksiPeer::doDelete($criteria, $con);
         // delete related Harga objects
         $criteria = new Criteria(HargaPeer::DATABASE_NAME);
         $criteria->add(HargaPeer::ID_BARANG, $obj->getId());
         $affectedRows += HargaPeer::doDelete($criteria, $con);
         // delete related LinkBarangRak objects
         $criteria = new Criteria(LinkBarangRakPeer::DATABASE_NAME);
         $criteria->add(LinkBarangRakPeer::ID_BARANG, $obj->getId());
         $affectedRows += LinkBarangRakPeer::doDelete($criteria, $con);
         // delete related LogBarang objects
         $criteria = new Criteria(LogBarangPeer::DATABASE_NAME);
         $criteria->add(LogBarangPeer::ID_BARANG, $obj->getId());
         $affectedRows += LogBarangPeer::doDelete($criteria, $con);
     }
     return $affectedRows;
 }