Create prettyurls

create prettyurls on mass

$adapter = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter');

      $results = $this->getPagesTable()->fetchAll();

    	$textUtils = new Text;

    	foreach($results as $page) {
    		$prettyurl = $textUtils->prettyurl($page->name);
    		$sql = "update pages set prettyurl = '".$prettyurl."' where id = ".$page->id;
    		$adapter->query($sql, Adapter::QUERY_MODE_EXECUTE);
    	}
    	die('fin');