Cakephp-3.x: How to change the data type of a selected alias?

by

As of CakePHP 3.2

you can use Query::selectTypeMap() to add further types, which are only going to be used for casting the selected fields when data is being retrieved.

$query = $table
    ->find()
    ->select(['alias' => 'actual_field', /* ... */]);

$query
    ->selectTypeMap()
    ->addDefaults([
        'alias' => 'integer'
    ]);

You can use any of the built-in data types, as well as custom ones. In this case the alias field will now be casted as an integer.

See also

With CakePHP 3.1 and earlier

you’ll have to use Query::typeMap(), which will not only affect the selected field when data is being retrieved, but in various other places too where data needs to be casted according to the field types, which might cause unwanted collisions, so use this with care.

$query
    ->typeMap()
    ->addDefaults([
        'alias' => 'integer'
    ]);

See also

Change the type of existing columns

Changing the type of an existing column of a table is possible too, however they need to be set using a specific syntax, ie in the column alias format used by CakePHP, that is, the table alias and the column name seprated by __, eg, for a table with the Articles alias and a column named id, it would be Articles__id.

This can be either set manually, or better yet retrieved via Query::aliasField(), like:

// $field will look like ['Alias__id' => 'Alias.id']
$field = $query->aliasField('id', $table->alias());

$query
    ->selectTypeMap()
    ->addDefaults([
        key($field) => 'string'
    ]);

This would change the the default type of the id column to string.

See also

More Related Contents:

  1. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  2. Encryption/Decryption of Form Fields in CakePHP 3
  3. Where 2 != 2 in PHP
  4. How to limit contained associations per record/group?
  5. “[notice] child pid XXXX exit signal Segmentation fault (11)” in apache error.log [closed]
  6. Converting an integer to a string in PHP
  7. Php-intl installation on XAMPP
  8. How to output custom HTTP body contents with CakePHP 3.4? Echoing causes “Unable to emit headers” error
  9. How to convert string to boolean php
  10. CakePHP 2.0 – How to make custom error pages?
  11. How to use WHERE IN with Doctrine 2
  12. How to use multiple databases dynamically for one model in CakePHP
  13. Request Entity Too Large PHP
  14. Casting an Array with Numeric Keys as an Object
  15. .htaccess for cakephp
  16. Type casting for user defined objects
  17. PHP unexpected result of float to int type cast
  18. How to “Validate” Human Names in CakePHP?
  19. How to safely use reserved SQL names?
  20. How to cast array elements to strings in PHP?
  21. How do you make strings “XML safe”?
  22. CakePHP remember me with Auth
  23. Array to Object and Object to Array in PHP – interesting behaviour
  24. CakePHP Xml utility library triggers DOMDocument warning
  25. Dynamically create PHP object based on string
  26. Undefined variable: $_SESSION
  27. Best way to document Array options in PHPDoc?
  28. PHP typecasting
  29. How to create a `IN` clause in CakePHP query?
  30. Convert a big integer to a full string in PHP

Leave a Comment