<?
include('/var/www/drupal/includes/tree.inc');
$table="term_hierarchy_test";
$parents->vid=1;
$parents->tid=1; //tid of the term we want to save in the tree
$parents->parent=array();


$time_start = microtime_float();
# first save some root level parent (2):
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
tree_term_save(&$parents,$table);
# then a son (8.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+1;
  $parent_array[0]['nv']=8;
  $parent_array[0]['dv']=1;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+50;
  $parent_array[0]['nv']=296;
  $parent_array[0]['dv']=33;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+100;
  $parent_array[0]['nv']=4566;
  $parent_array[0]['dv']=509;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.15.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+150;
  $parent_array[0]['nv']=72760;
  $parent_array[0]['dv']=8111;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.15.4.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+200;
  $parent_array[0]['nv']=383284;
  $parent_array[0]['dv']=42727;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.15.4.1.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+250;
  $parent_array[0]['nv']=844199;
  $parent_array[0]['dv']=94108;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.15.4.1.3.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+300;
  $parent_array[0]['nv']=4759541;
  $parent_array[0]['dv']=530575;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}
# then a son (8.32.15.15.4.1.3.43.50)
for($i=1;$i<51;$i++){
  $parents->tid=$i+350;
  $parent_array[0]['nv']=265539706;
  $parent_array[0]['dv']=29601327;
  $parents->parent=$parent_array;
  tree_term_save(&$parents,$table);
}

#insert each terms new 10 sons
$result = db_query("SELECT nv,dv FROM {term_hierarchy_test}");
$j=400;
while ($record = $result->fetchObject()){
  for($i=1;$i<11;$i++){
    $parents->tid=$i+$j;
    $parent_array[0]['nv']=$record->nv;
    $parent_array[0]['dv']=$record->dv;
    $parents->parent=$parent_array;
    tree_term_save(&$parents,$table);
    $i++;
  }
  $j=$j+10;
}

$time_end = microtime_float();
$time = $time_end - $time_start;
echo 'insertion time' . $time." ";
$time_start = microtime_float();
#we move everything under 8.32 (296/33) under 8.3.3 (35/4)
tree_subtree_move(296,33,8,1,3,1,$table);
$time_end = microtime_float();
$time = $time_end - $time_start;
echo 'move time' . $time." ";
function microtime_float()
{
      list($usec, $sec) = explode(" ", microtime());
          return ((float)$usec + (float)$sec);
}