/install/migration/migrate_17/migrate_17_to_18_functions.php

<?php

/**

 * TestLink Open Source Project - http://testlink.sourceforge.net/ 

 * This script is distributed under the GNU General Public License 2 or later. 

 *

 * Support functions for migration from 1.7.2 to 1.8.0

 * 

 * @package 	TestLink

 * @author 		franciscom

 * @copyright 	2008, TestLink community 

 * @version    	CVS: $Id: migrate_17_to_18_functions.php,v 1.10 2009/08/30 00:56:06 havlat Exp $

 *

 * @internal 

 * rev: 20090127 - franciscom - added checkTableFields()

 *    20081210 - BUGID 1921 - missing update of attachment table

 *    	added updateExecutionsTCVersionInfo()

 */



function reqSpecMigration(&$source_db,&$treeMgr)

{

	$mapping_old_new = null;

	$hhmmss=date("H:i:s");

	$msg_click_to_show="click to show";

	echo "<a onclick=\"return DetailController.toggle('details-req_spec_table')\" href=\"tplan/\">

	<img src='../../img/icon-foldout.gif' align='top' title='show/hide'> Requirement Specification: {$msg_click_to_show} {$hhmmss}</a>";

	echo '<div class="detail-container" id="details-req_spec_table" style="display: none;">';

	

	$sql="SELECT * from req_specs";

	$rspec=$source_db->fetchRowsIntoMap($sql,'id');

	if(is_null($rspec)) 

	{

		echo "<span class='notok'>There are no req specs to be migrated!</span></b>";

	}

	else

	{

	  $mapping_old_new->req_spec=migrateReqSpecs($source_db,$treeMgr,$rspec);

	}

	echo "</div><p>";

	return $mapping_old_new;

}



/*

  function: migrateReqSpecs



  args:

  

  returns: 



*/

function migrateReqSpecs(&$source_db,&$treeMgr,&$rspec)

{

    $oldNewMapping=array();

    $mappingDescrID=$treeMgr->get_available_node_types();

    $counter=0;

    $rspec_qty=count($rspec);

    echo "<pre>Number of Requirements Specifications (SRS): " . $rspec_qty; echo "</pre>";

        

    foreach($rspec as $req_id => $rdata)

    {

        $nodeID=$treeMgr->new_node($rdata['testproject_id'],

                                   $mappingDescrID['requirement_spec'],$rdata['title']);

        $oldNewMapping[$req_id]=$nodeID;

    }

    

    return $oldNewMapping;  

}





function requirementsMigration(&$source_db,&$treeMgr,&$oldNewMapping)

{

  	$msg_click_to_show="click to show";

	  $hhmmss=date("H:i:s");

	  echo "<a onclick=\"return DetailController.toggle('details-reqtable')\" href=\"tplan/\">

	  <img src='../../img/icon-foldout.gif' align='top' title='show/hide'> Requirements: {$msg_click_to_show} {$hhmmss}</a>";

	  echo '<div class="detail-container" id="details-reqtable" style="display: none;">';

    

	  $sql="SELECT * from requirements";

	  $req=$source_db->fetchRowsIntoMap($sql,'id');

	  if(is_null($req)) 

	  {

	  	echo "<span class='notok'>There are no requirements to be migrated!</span></b>";

	  }

	  else

	  {

	    $oldNewMapping=migrateRequirements($source_db,$treeMgr,$req,$oldNewMapping);

	  }

	  echo "</div><p>";

	  

	  return $oldNewMapping;

}





function migrateRequirements(&$source_db,&$treeMgr,&$req,&$oldNewMapping)

{

  

    $mappingDescrID=$treeMgr->get_available_node_types();

    $req_qty=count($req);

    echo "<pre>Number of requirements: " . $req_qty; echo "</pre>";

       

    foreach($req as $req_id => $rdata)

    {

        $parentID=$oldNewMapping->req_spec[$rdata['srs_id']];

        $nodeID=$treeMgr->new_node($parentID,

                                   $mappingDescrID['requirement'],

                                   $rdata['title'],$rdata['node_order']);

        $oldNewMapping->req[$req_id]=$nodeID;

    }

    return $oldNewMapping;  

}





function updateReqInfo(&$source_db,&$treeMgr,&$oldNewMapping)

{



    $sql="SELECT id,srs_id FROM requirements ";

	  $requirements=$source_db->fetchRowsIntoMap($sql,'id');



    // Update ID in descending order to avoid wrong replacement

    // because we can not be certain that new generated ID will

    // be crash with old IDs.

    //

    // krsort

    krsort($oldNewMapping->req_spec);

    krsort($oldNewMapping->req);



    foreach($oldNewMapping->req_spec as $oldID => $newID)

    {

        $sql="UPDATE req_specs " .

             "SET id={$newID} WHERE id={$oldID}";

        $source_db->exec_query($sql);       

    } 



    foreach($oldNewMapping->req as $oldID => $newID)

    {

        $parentID=$oldNewMapping->req_spec[$requirements[$oldID]['srs_id']];

        

        $sql="UPDATE requirements " .

             " SET id={$newID}, srs_id={$parentID} " .

             " WHERE id={$oldID}";

        $source_db->exec_query($sql);       

        

        $sql="UPDATE req_coverage " .

             " SET req_id={$newID} " .

             " WHERE req_id={$oldID}";

        $source_db->exec_query($sql);       



        // BUGID - Missing update of attachments

        $sql="UPDATE attachments " .

             "SET fk_id={$newID} ".

             " WHERE fk_id={$oldID} AND fk_table='requirements'";

        $source_db->exec_query($sql);       

        

    } 

}





function updateTProjectInfo(&$source_db,&$tprojectMgr)

{

    $all_tprojects=$tprojectMgr->get_all();

    if( !is_null($all_tprojects) )

    {

        initNewTProjectProperties($source_db,$all_tprojects,$tprojectMgr);  

        updateTestCaseExternalID($source_db,$all_tprojects,$tprojectMgr);

    }

  

}





function initNewTProjectProperties(&$db,&$tprojectMap,&$tprojectMgr)

{

    if( !is_null($tprojectMap) )

    {

        // test case prefix

        foreach($tprojectMap as $key => $value)

        {

            $tcPrefix=trim(substr($value['name'],0,5) . " (ID={$value['id']})"); 

            $sql="UPDATE testprojects " .

                 "SET prefix='" . $db->prepare_string($tcPrefix) ."', " . 

                 "    tc_counter=0 " .

                 "WHERE id={$value['id']}";

            $db->exec_query($sql);     

        }  

    }

}





function updateTestCaseExternalID(&$db,&$all_tprojects,&$tprojectMgr)

{

    $show_memory=true;

    if( !is_null($all_tprojects) )

    {

        $numtproject=count($all_tprojects);

        echo "Total number of Test Projects to process: {$numtproject}<br>";

        ob_flush();flush();

        $feedback_counter=0;

        $tproject_counter=0;

        

        foreach($all_tprojects as $tproject_key => $tproject_value)

        {

            $feedback_counter=0;

            $tproject_counter++;

            $tcaseSet = array();

            $tprojectMgr->get_all_testcases_id($tproject_value['id'],$tcaseSet);

            echo "Working on Test Project ({$tproject_counter}/{$numtproject}) : {$tproject_value['name']}<br>";

            if( function_exists('memory_get_usage') && function_exists('memory_get_peak_usage') && $show_memory)

            {

               echo "(Memory Usage: ".memory_get_usage() . " | Peak: " . memory_get_peak_usage() . ")<br><br>";

            }

            ob_flush();flush();



            if( !is_null($tcaseSet) && ($numtc=count($tcaseSet)) > 0 )

            {

               $do_feedback=$numtc > 100;

               echo "Test Cases to process: {$numtc}<br><br>";

               ob_flush();flush();



               foreach($tcaseSet as $tckey => $tcvalue)

               {

                   $feedback_counter++;

                   $eid=$tckey+1;

                   $sql="UPDATE tcversions " .

                        "SET tc_external_id={$eid} " .

                        "WHERE id IN (SELECT id FROM nodes_hierarchy WHERE parent_id={$tcvalue})";

                    $db->exec_query($sql);

                   

                   if( $do_feedback && $feedback_counter%100 == 0)

                   {

                       echo "Test Cases Processed: {$feedback_counter} - " . date("H:i:s") . "<br>";

                       ob_flush();flush();

                   }

               }         

               echo "ALL Test Cases Processed: {$feedback_counter} - " . date("H:i:s") ."<br><br>";

 

               $sql="UPDATE testprojects " .

                    "SET tc_counter={$eid} " .

                    "WHERE id={$tproject_value['id']}";

               $db->exec_query($sql);

			}

			unset($tcaseSet);

        }

    }

}





function updateExecutionsTCVersionInfo(&$db)

{

	if (!isset($cfg['db_type']) || strtolower($cfg['db_type']) == 'postgres') 

	{

		// Bug #2325

    	$sql = "UPDATE executions SET tcversion_number = " .

    	 "(SELECT version FROM tcversions WHERE id = executions.tcversion_id)";

	} else {

    	$sql = "UPDATE executions E,tcversions TCV " .

			"SET tcversion_number=TCV.version " .

			"WHERE TCV.id = E.tcversion_id";

	}

    $db->exec_query($sql);

}





/*

  function: checkTableFields



  args: adoObj: reference to ado object

        table: table name

        fields2check: array with field names

  

  returns: array($status_ok,$msg)

  

  rev: 20090127 - franciscom



*/ 

function checkTableFields(&$adoObj,$table,$fields2check)

{

    $status_ok=true;

    $msg='';

    $fields=$adoObj->MetaColumns($table);

    foreach($fields2check as $field_name)

    {

        if( !isset($fields[strtoupper($field_name)]) )  

        {

            $msg="Table {$table} - Missing field {$field_name}";

            $status_ok=false;

            break;  

        }

    }

    return array($status_ok,$msg);

}

    





?>