function testShouldFindStructured()
{
$mapper = new DataMapper($this->db);
$foo_id = $mapper->save(array('name' => 'foo'));
$bar_id = $mapper->save(array('name' => 'bar', 'paths' => array($foo_id)));
$baz_id = $mapper->save(array('name' => 'baz', 'paths' => array($foo_id . '/' . $bar_id)));
$categories = $mapper->findStructuredAll();
$expected = array(array('id' => $foo_id, 'name' => 'foo', 'paths' => array(), 'active' => 1, 'children' => array(array('id' => $bar_id, 'name' => 'bar', 'paths' => array($foo_id), 'active' => 1, 'children' => array(array('id' => $baz_id, 'name' => 'baz', 'paths' => array($foo_id . '/' . $bar_id), 'active' => 1, 'children' => array()))))));
$this->assertEquals($expected, $categories);
}
