public function testHideUnhidePartialSubtree()
{
$this->insertDatabaseFixture(__DIR__ . '/_fixtures/full_example_tree.php');
$handler = $this->getLocationGateway();
$handler->hideSubtree('/1/2/69/');
$handler->hideSubtree('/1/2/69/70/');
$handler->unhideSubtree('/1/2/69/70/');
$query = $this->handler->createSelectQuery();
$this->assertQueryResult(array(array(1, 0, 0), array(2, 0, 0), array(69, 1, 1), array(70, 0, 1), array(71, 0, 1), array(75, 0, 1)), $query->select('node_id', 'is_hidden', 'is_invisible')->from('ezcontentobject_tree')->where($query->expr->in('node_id', array(1, 2, 69, 70, 71, 75)))->orderBy('node_id'));
}