public function testCountLocationsByContentId()
{
$this->insertDatabaseFixture(__DIR__ . '/_fixtures/full_example_tree.php');
$handler = $this->getLocationGateway();
self::assertSame(0, $handler->countLocationsByContentId(123456789));
self::assertSame(1, $handler->countLocationsByContentId(67));
// Insert a new node and count again
$query = $this->handler->createInsertQuery();
$query->insertInto('ezcontentobject_tree')->set('contentobject_id', $query->bindValue(67, null, \PDO::PARAM_INT))->set('contentobject_version', $query->bindValue(1, null, \PDO::PARAM_INT))->set('path_string', $query->bindValue('/1/2/96'))->set('parent_node_id', $query->bindValue(96, null, \PDO::PARAM_INT))->set('remote_id', $query->bindValue('some_remote_id'));
$query->prepare()->execute();
self::assertSame(2, $handler->countLocationsByContentId(67));
}