/**
  * Tree used for tests
  * t1
  * |  \
  * t2 t3
  *    |  \
  *    t4 t5
  *       |  \
  *       t6 t7
  */
 protected function initTree()
 {
     Table9Peer::doDeleteAll();
     $ret = array();
     // shuffling the results so the db order is not the natural one
     $fixtures = array('t2' => array(2, 3, 1), 't5' => array(7, 12, 2), 't4' => array(5, 6, 2), 't7' => array(10, 11, 3), 't1' => array(1, 14, 0), 't6' => array(8, 9, 3), 't3' => array(4, 13, 1));
     /* in correct order, this is:
            't1' => array(1, 14, 0),
            't2' => array(2, 3, 1),
            't3' => array(4, 13, 1),
            't4' => array(5, 6, 2),
            't5' => array(7, 12, 2),
            't6' => array(8, 9, 3),
            't7' => array(10, 11, 3),
        */
     foreach ($fixtures as $key => $data) {
         $t = new PublicTable9();
         $t->setTitle($key);
         $t->setLeftValue($data[0]);
         $t->setRightValue($data[1]);
         $t->setLevel($data[2]);
         $t->save();
         $ret[$key] = $t;
     }
     // reordering the results in the fixtures
     ksort($ret);
     return array_values($ret);
 }