How to specify the type of field to select a query when using an alias in cakephp?

Question

I use Cakephp 3.2.7 as a framework and create a query with the select alias.

 $posts = $this->Posts->find()
 ->select(['id' => 'Posts.id','userid'=>"Posts.user_id"])->toArray();

I want to get id as a string not integer (the column type in mysql is an integer) and get the user id as an integer (the column type in mysql is also an integer), but use an alias that converts it to a string.

Is there a way to get all the Id columns in the entire model as a string, or at least determine the data type in the query?

Answer 1

Finally, I found a solution. I add a mutator to the post class object.

protected function _getId()
{
    return (string)$this->_properties['id'];

}

which forcibly returns id as a string.

Answer 2

@drmonkeyninja, , .

, , , , .

. .

$this->Posts->schema()->addColumn('userid', [
    'type' => 'integer',
])
->addColumn('id', [
    'type' => 'string',
]);