public function migrateBugScenario(EiTicket $ei_package, EiProjet $ei_project, EiProfil $ei_profile, EiScenario $ei_scenario, sfGuardUser $guard, Doctrine_Connection $conn = null)
{
if ($conn == null) {
$conn = Doctrine_Manager::connection();
}
/* On recherche la version du scénario correspondant au package */
$ei_version = $ei_scenario->findVersionForPackage($ei_package, $conn);
if ($ei_version == null) {
return false;
} else {
$ei_version = $ei_version->getFirst();
}
// On crée le lien entre la version du scénario et la version concernée
$stmt = $conn->prepare("INSERT INTO ei_profil_scenario (profile_id, profile_ref, ei_scenario_id,ei_version_id,created_at,updated_at) " . "VALUES (:profile_id, :profile_ref, :ei_scenario_id,:ei_version_id,:created_at,:updated_at) " . "ON DUPLICATE KEY UPDATE ei_version_id=" . $ei_version->getId());
$stmt->bindValue("profile_id", $ei_profile->getProfileId());
$stmt->bindValue("profile_ref", $ei_profile->getProfileRef());
$stmt->bindValue("ei_scenario_id", $ei_scenario->getId());
$stmt->bindValue("ei_version_id", $ei_version->getId());
$stmt->bindValue("created_at", date('Y-m-d H:i:s'));
$stmt->bindValue("updated_at", date('Y-m-d H:i:s'));
$stmt->execute(array());
return true;
}
