<?php

namespace Rapsys\AirBundle\Repository;

use Symfony\Component\Translation\TranslatorInterface;
use Doctrine\ORM\Query\ResultSetMapping;

/**
 * SnippetRepository
 */
class SnippetRepository extends \Doctrine\ORM\EntityRepository {
	/**
	 * Find snippets by locale and user id
	 *
	 * @param string $locale The locale
	 * @param User|int $user The user
	 * @return array The snippets or empty array
	 */
	public function findByLocaleUserId($locale, $user) {
		//Fetch snippets
		$ret = $this->getEntityManager()
			->createQuery('SELECT s FROM RapsysAirBundle:Snippet s WHERE s.locale = :locale and s.user = :user')
			->setParameter('locale', $locale)
			->setParameter('user', $user)
			->getResult();

		//Send result
		return $ret;
	}
}