/**
*
*
*/
function migrate_18_to_19(&$dbHandler, $tableSet)
{
// Need To Add Some Feedback
echo '<b><br>-------------------------------------<br>';
echo 'Data Migration Process STARTED<br>';
echo '-------------------------------------<br></b>';
migrate_requirements($dbHandler, $tableSet);
migrate_req_specs($dbHandler, $tableSet);
migrate_testcases($dbHandler, $tableSet);
migrate_project_options($dbHandler, $tableSet);
migrate_user_assignments($dbHandler, $tableSet);
migrate_cfield_links($dbHandler, $tableSet);
if ($dbHandler->dbType == 'mssql') {
echo "<b><br>**********************************************************************************<br>";
echo "IMPORTANT NOTICE FOR MSSQL USERS<br>";
echo "**********************************************************************************<br>";
echo "Some updates to DB SCHEMA HAS TO BE DONE manually due to <br>";
echo "MSSQL Restrictions<br>";
echo "ALTER TABLE /*prefix*/requirements ALTER req_doc_id VARCHAR(64)<br>";
echo "ALTER TABLE /*prefix*/custom_fields ALTER COLUMN possible_values varchar(4000)<br>";
echo "ALTER TABLE /*prefix*/custom_fields ALTER COLUMN default_value varchar(4000)<br>";
echo "**********************************************************************************<br></b>";
}
echo '<br>-------------------------------------<br>';
echo 'Data Migration Process Finished<br>';
echo '-------------------------------------<br><br><br>';
}
function migrate_18_to_19(&$dbHandler, $tableSet)
{
migrate_requirements($dbHandler, $tableSet);
migrate_req_specs($dbHandler, $tableSet);
migrate_testcases($dbHandler, $tableSet);
migrate_project_options($dbHandler, $tableSet);
migrate_user_assignments($dbHandler, $tableSet);
}
function requirements_migration()
{
$hhmmss = date("H:i:s");
echo "<a onclick=\"return DetailController.toggle('details-reqtable')\" href=\"tplan/\">\r\n\t\t<img src='../img/icon-foldout.gif' align='top' title='show/hide'> Requirements: {$this->msg_click_to_show} {$hhmmss}</a>";
echo '<div class="detail-container" id="details-reqtable" style="display: none;">';
// 20070103 - franciscom - added filter on NULL
// select everything but the duplicates that will violate the unique constraint in 1.7
$sql = "SELECT * from requirements " . " WHERE req_doc_id <> NULL OR req_doc_id <> '' " . " GROUP BY id_srs, req_doc_id HAVING COUNT(*)=1";
$req = $this->source_db->fetchRowsIntoMap($sql, 'id');
if (is_null($req)) {
echo "<span class='notok'>There are no requirements to be migrated!</span></b>";
} else {
migrate_requirements($this->source_db, $this->target_db, $req, $this->old_new);
}
echo "</div><p>";
}
