CASTING attributes for Ordering on a Doctrine2 DQL Query

by

You should be able to add your own function to implement this feature.

The class would look something like this:

namespace MyProject\Query;

use Doctrine\ORM\Query\AST\Functions\FunctionNode;
use Doctrine\ORM\Query\Lexer;
use Doctrine\ORM\Query\Parser;
use Doctrine\ORM\Query\SqlWalker;

class CastAsInteger extends FunctionNode
{
    public $stringPrimary;

    public function getSql(SqlWalker $sqlWalker)
    {
        return 'CAST(' . $this->stringPrimary->dispatch($sqlWalker) . ' AS integer)';
    }

    public function parse(Parser $parser)
    {
        $parser->match(Lexer::T_IDENTIFIER);
        $parser->match(Lexer::T_OPEN_PARENTHESIS);

        $this->stringPrimary = $parser->StringPrimary();

        $parser->match(Lexer::T_CLOSE_PARENTHESIS);
    }
}

You’ll need to register your function:

$config = $em->getConfiguration();
$config->addCustomNumericFunction('INT', CastAsInteger::class);

Then you can use it:

SELECT e, INT(e.id) AS HIDDEN orderId
FROM Namespace\Bla\MyEntity e
ORDER BY orderId

PS: By adding the HIDDEN keyword, the alias orderId won’t be in the results (and is only used for ordering).

More Related Contents:

  1. How do I check if a string is a number (float)?
  2. Convert String to double in Java
  3. Struts2 INPUT result: how does it work? How are conversion / validation errors handled?
  4. How do I convert a string to a number in PHP?
  5. Import pandas dataframe column as string not int
  6. How do you emulate nominal typing in TypeScript?
  7. Does it make sense to use “as” instead of a cast even if there is no null check? [closed]
  8. How do I convert between numeric types safely and idiomatically?
  9. How can I convert string to integer in golang
  10. What is the difference between (type)value and type(value)?
  11. Converting an integer to a string in PHP
  12. Build a function object with properties in TypeScript
  13. Dealing with an ArrayStoreException
  14. Is the behaviour of casting a negative double to unsigned int defined in the C standard? Different behaviour on ARM vs. x86
  15. Pandas reading csv as string type
  16. convert double to int
  17. TypeScript or JavaScript type casting
  18. How to select randomly with doctrine
  19. PHP unexpected result of float to int type cast
  20. SQL error “ORA-01722: invalid number”
  21. Invalid cast from ‘System.Int32’ to ‘System.Nullable`1[[System.Int32, mscorlib]]
  22. How do I check if a string represents a number (float or int)?
  23. What is the difference between casting and conversion? [duplicate]
  24. Any difference between type assertions and the newer `as` operator in TypeScript?
  25. Symfony2 and Doctrine – Error: Invalid PathExpression. Must be a StateFieldPathExpression
  26. TypeScript: Index signature is missing in type
  27. Use a DATE() function in a WHERE clause with DQL
  28. Converting a Vec to Vec in-place and with minimal overhead
  29. How to tweak LISTAGG to support more than 4000 character in select query?
  30. Convert a big integer to a full string in PHP

Leave a Comment