samsonasik

for f in *.sql; do mysql -u root databasename <  $f; done;

samsonasik

use Zend\Db\Sql;
$sql = new Sql\Sql;
$select = $sql->select($table);
$select->offset(10);
echo $sql->getSqlStringForSqlObject($select);

samsonasik

tar czf changed-files.tar.gz `git diff --name-only HEAD`

samsonasik

<?php 

use Zend\Db\Sql\Sql;
$sql = new Sql($adapter);
$oSelect = $sql->select('table_test');
$oSelect->columns(array('*'))->where(array('test' => 'ok')->limit(1);
$sqlString = $sql->getSqlStringForSqlObject($oSelect);

//see https://github.com/zendframework/zf2/issues/3224

samsonasik

    // adopted from http://stackoverflow.com/questions/17596639/zfcuser-add-user-role-after-registration    
    /** set role after register
     * 
     */
    public function onBootstrap(EventInterface $e)
    {
        $services         =  $e->getApplication()->getServiceManager();
        $zfcServiceEvents = $services->get('zfcuser_user_service')->getEventManager();
        
        $zfcServiceEvents->attach('register', function($e) use ($services) {

samsonasik

<?php

use Zend\Console\Console;

/**
 * This makes our life easier when dealing with paths. Everything is relative
 * to the application root now.
 */
chdir(dirname(__DIR__));

samsonasik

$array = array();
foreach($entities as $entity) {
     $array[] = array(
            'id' => $entity->getId(),
            'municipio' => $entity->getMunicipio(),
     );
}

return $array;

samsonasik

<?php

namespace Application;

use Zend\Mvc\MvcEvent;
use Zend\Validator\AbstractValidator;

class Module
{
    public function onBootstrap(MvcEvent $event)

samsonasik

<?php

namespace Common\Service;

use Doctrine\ORM\EntityManager;
use DoctrineModule\Service\AbstractFactory;
use Zend\ServiceManager\ServiceLocatorInterface;

class EntityManagerFactory extends AbstractFactory
{

samsonasik

{
    "name": "zendframework/skeleton-application",
    "description": "Skeleton Application for ZF2",
    "license": "BSD-3-Clause",
    "keywords": [
        "framework",
        "zf2"
    ],
    "homepage": "http://framework.zend.com/",
    "require": {