symfony - How to install Doctrine Extensions in a Symfony2 project

Question

I guess that this is really trivial and stupid question, but I don't know how to install Doctrine Extensions - https://github.com/beberlei/DoctrineExtensions in my Symfony2 project. I need them because of the MONTH, YEAR functions. Where should I put their folder? And should I put the whole DoctrineExtensions folder? And where to write this:

<?php

$classLoader = new DoctrineCommonClassLoader('DoctrineExtensions', "/path/to/extensions");
$classLoader->register(); 

In a separate file? Where to put it and how to call it?

And then is this all I need to use them:

public function findOneByYearMonthDay($year, $month, $day)
{
    $emConfig = $this->getEntityManager()->getConfiguration();
    $emConfig->addCustomDatetimeFunction('YEAR', 'DoctrineExtensionsQueryMysqlYear');
    $emConfig->addCustomDatetimeFunction('MONTH', 'DoctrineExtensionsQueryMysqlMonth');
    $emConfig->addCustomDatetimeFunction('DAY', 'DoctrineExtensionsQueryMysqlDay');

Thank you very much in advance and sorry once again for the question, but I couldn't find a tutorial (which makes me feel even more guilty, because I guess it's too trivial when there isn't even a tutorial)

Answer 1

You can install it via composer. Just add it to your composer.json and then php composer.phar update beberlei/DoctrineExtensions

"beberlei/DoctrineExtensions": "*",

Then you can register functions to your ORM

doctrine:
    orm:
      auto_generate_proxy_classes: %kernel.debug%
      entity_managers:
        default:
          auto_mapping: true
          dql:
            datetime_functions:
              MONTH: DoctrineExtensionsQueryMysqlMonth
              YEAR: DoctrineExtensionsQueryMysqlYear