<?php

namespace UBV\SurUbvBundle\Entity;

use Doctrine\ORM\EntityRepository;

use Doctrine\ORM\Query;

/**
 * NacionalidadRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class NacionalidadRepository extends EntityRepository
{
  public function findNacionalidadByPaisId($pais_id)
  {
    $em = $this->getEntityManager();
    $result = $em->createQueryBuilder();
    
    $dql = $result -> select ('nacionalidad')
                   ->from('UBVSurUbvBundle:Nacionalidad' , 'nacionalidad')
                   ->where('pais.id = :pais_id')
                   ->setParameter('pais_id',$pais_id)
                   ->getQuery()
                   ->getResult(Query::HYDRATE_ARRAY);
           return $dql;
    
  }
}