Advertisement
Guest User

Untitled

a guest
Aug 16th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.11 KB | None | 0 0
  1. doctrine:
  2. dbal:
  3. driver: %database_driver%
  4. host: %database_host%
  5. dbname: %database_name%
  6. user: %database_user%
  7. password: %database_password%
  8.  
  9. orm:
  10. auto_generate_proxy_classes: %kernel.debug%
  11. entity_managers:
  12. default:
  13. auto_mapping: true
  14. dql:
  15. datetime_functions:
  16. YEAR: Acme\DemoBundle\DQL\Year
  17.  
  18. <?php
  19.  
  20. use Doctrine\ORM\Query\AST\Functions\FunctionNode;
  21.  
  22. /**
  23. * DateDiffFunction ::= "YEAR" "(" ArithmeticPrimary ")"
  24. */
  25. class Year extends FunctionNode
  26. {
  27. public $dateExpression = null;
  28.  
  29. public function parse(\Doctrine\ORM\Query\Parser $parser)
  30. {
  31. $parser->match(Lexer::T_IDENTIFIER);
  32. $parser->match(Lexer::T_OPEN_PARENTHESIS);
  33. $this->dateExpression = $parser->ArithmeticPrimary();
  34. $parser->match(Lexer::T_CLOSE_PARENTHESIS);
  35. }
  36.  
  37. public function getSql(\Doctrine\ORM\Query\SqlWalker $sqlWalker)
  38. {
  39. return 'YEAR(' . $this->dateExpression->dispatch($sqlWalker) . ')';
  40. }
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement