/**
* @group geometry
*/
public function testSTAsBinary()
{
$lineString1 = array(new Point(0, 0), new Point(2, 2), new Point(5, 5));
$lineString2 = array(new Point(3, 3), new Point(4, 15), new Point(5, 22));
$entity1 = new LineStringEntity();
$entity1->setLineString(new LineString($lineString1));
$this->getEntityManager()->persist($entity1);
$entity2 = new LineStringEntity();
$entity2->setLineString(new LineString($lineString2));
$this->getEntityManager()->persist($entity2);
$this->getEntityManager()->flush();
$this->getEntityManager()->clear();
$query = $this->getEntityManager()->createQuery('SELECT ST_AsBinary(l.lineString) FROM CrEOF\\Spatial\\Tests\\Fixtures\\LineStringEntity l');
$result = $query->getResult();
$this->assertEquals('010200000003000000000000000000000000000000000000000000000000000040000000000000004000000000000014400000000000001440', bin2hex(Utils::toBinary(stream_get_contents($result[0][1]))));
$this->assertEquals('0102000000030000000000000000000840000000000000084000000000000010400000000000002e4000000000000014400000000000003640', bin2hex(Utils::toBinary(stream_get_contents($result[1][1]))));
}
/**
* @param string $input
*/
private function setInput($input)
{
$this->input = Utils::toBinary($input);
}