示例#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 = ClassePeer::doSelect($criteria, $con);
		foreach ($objects as $obj) {


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

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

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

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

			// delete related JCategoriesMatieresClasses objects
			$criteria = new Criteria(JCategoriesMatieresClassesPeer::DATABASE_NAME);
			
			$criteria->add(JCategoriesMatieresClassesPeer::CLASSE_ID, $obj->getId());
			$affectedRows += JCategoriesMatieresClassesPeer::doDelete($criteria, $con);
		}
		return $affectedRows;
	}
	/**
	 * 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;
	}