コード例 #1
0
ファイル: BaseGroupePeer.php プロジェクト: rhertzog/lcs
	/**
	 * 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 = GroupePeer::doSelect($criteria, $con);
		foreach ($objects as $obj) {


			// delete related JGroupesProfesseurs objects
			$criteria = new Criteria(JGroupesProfesseursPeer::DATABASE_NAME);
			
			$criteria->add(JGroupesProfesseursPeer::ID_GROUPE, $obj->getId());
			$affectedRows += JGroupesProfesseursPeer::doDelete($criteria, $con);

			// delete related JGroupesMatieres objects
			$criteria = new Criteria(JGroupesMatieresPeer::DATABASE_NAME);
			
			$criteria->add(JGroupesMatieresPeer::ID_GROUPE, $obj->getId());
			$affectedRows += JGroupesMatieresPeer::doDelete($criteria, $con);

			// delete related JGroupesClasses objects
			$criteria = new Criteria(JGroupesClassesPeer::DATABASE_NAME);
			
			$criteria->add(JGroupesClassesPeer::ID_GROUPE, $obj->getId());
			$affectedRows += JGroupesClassesPeer::doDelete($criteria, $con);

			// delete related CahierTexteCompteRendu objects
			$criteria = new Criteria(CahierTexteCompteRenduPeer::DATABASE_NAME);
			
			$criteria->add(CahierTexteCompteRenduPeer::ID_GROUPE, $obj->getId());
			$affectedRows += CahierTexteCompteRenduPeer::doDelete($criteria, $con);

			// delete related CahierTexteTravailAFaire objects
			$criteria = new Criteria(CahierTexteTravailAFairePeer::DATABASE_NAME);
			
			$criteria->add(CahierTexteTravailAFairePeer::ID_GROUPE, $obj->getId());
			$affectedRows += CahierTexteTravailAFairePeer::doDelete($criteria, $con);

			// delete related CahierTexteNoticePrivee objects
			$criteria = new Criteria(CahierTexteNoticePriveePeer::DATABASE_NAME);
			
			$criteria->add(CahierTexteNoticePriveePeer::ID_GROUPE, $obj->getId());
			$affectedRows += CahierTexteNoticePriveePeer::doDelete($criteria, $con);

			// delete related JEleveGroupe objects
			$criteria = new Criteria(JEleveGroupePeer::DATABASE_NAME);
			
			$criteria->add(JEleveGroupePeer::ID_GROUPE, $obj->getId());
			$affectedRows += JEleveGroupePeer::doDelete($criteria, $con);

			// delete related CreditEcts objects
			$criteria = new Criteria(CreditEctsPeer::DATABASE_NAME);
			
			$criteria->add(CreditEctsPeer::ID_GROUPE, $obj->getId());
			$affectedRows += CreditEctsPeer::doDelete($criteria, $con);

			// delete related EdtEmplacementCours objects
			$criteria = new Criteria(EdtEmplacementCoursPeer::DATABASE_NAME);
			
			$criteria->add(EdtEmplacementCoursPeer::ID_GROUPE, $obj->getId());
			$affectedRows += EdtEmplacementCoursPeer::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 = UtilisateurProfessionnelPeer::doSelect($criteria, $con);
		foreach ($objects as $obj) {


			// delete related JGroupesProfesseurs objects
			$criteria = new Criteria(JGroupesProfesseursPeer::DATABASE_NAME);
			
			$criteria->add(JGroupesProfesseursPeer::LOGIN, $obj->getLogin());
			$affectedRows += JGroupesProfesseursPeer::doDelete($criteria, $con);

			// delete related JScolClasses objects
			$criteria = new Criteria(JScolClassesPeer::DATABASE_NAME);
			
			$criteria->add(JScolClassesPeer::LOGIN, $obj->getLogin());
			$affectedRows += JScolClassesPeer::doDelete($criteria, $con);

			// delete related JEleveCpe objects
			$criteria = new Criteria(JEleveCpePeer::DATABASE_NAME);
			
			$criteria->add(JEleveCpePeer::CPE_LOGIN, $obj->getLogin());
			$affectedRows += JEleveCpePeer::doDelete($criteria, $con);

			// delete related JEleveProfesseurPrincipal objects
			$criteria = new Criteria(JEleveProfesseurPrincipalPeer::DATABASE_NAME);
			
			$criteria->add(JEleveProfesseurPrincipalPeer::PROFESSEUR, $obj->getLogin());
			$affectedRows += JEleveProfesseurPrincipalPeer::doDelete($criteria, $con);

			// delete related JAidUtilisateursProfessionnels objects
			$criteria = new Criteria(JAidUtilisateursProfessionnelsPeer::DATABASE_NAME);
			
			$criteria->add(JAidUtilisateursProfessionnelsPeer::ID_UTILISATEUR, $obj->getLogin());
			$affectedRows += JAidUtilisateursProfessionnelsPeer::doDelete($criteria, $con);

			// delete related PreferenceUtilisateurProfessionnel objects
			$criteria = new Criteria(PreferenceUtilisateurProfessionnelPeer::DATABASE_NAME);
			
			$criteria->add(PreferenceUtilisateurProfessionnelPeer::LOGIN, $obj->getLogin());
			$affectedRows += PreferenceUtilisateurProfessionnelPeer::doDelete($criteria, $con);
		}
		return $affectedRows;
	}