ORDER BY对MySQL存储函数在CakePHP 3 [英] ORDER BY on MySQL stored function in CakePHP 3

问题描述

我正在使用cakePHP 3.我在mysql数据库中有一个用户定义的函数（UDF或Routine）。该函数接受一个参数并返回一个整数值。我必须在MySQL订单子句中订购返回值。

I'm working on cakePHP 3. I have a user defined function(UDF or Routine) in mysql database. That function takes a parameter and returns an integer value. I have to order that returned value in MySQL order clause.

我知道mysql查询使用那个函数。即

I know mysql query to use that function. i.e,

SELECT customer_id FROM table_name ORDER BY routine_name(param1);         //param1 is 'customer_id' which I have written after SELECT

但我不知道在cakePHP中构建此查询3.如果有人知道解决方案，回答将会感激。

But I don't know that how to build this query in cakePHP 3. If anyone knows the solution, answer will be appreciate.

这是我的cakePHP 3代码。

Here is my cakePHP 3 code.

$purchasesTable = TableRegistry::get("Purchases");
$query = $purchasesTable->find();

$sf_val = $query->func()->routine_name(['Purchases.customer_id' => 'literal']);
$query->select();
$query->order(
    //    Routine/Function call should be here as per MySQL query.
    //    So, I think here I have to do something.
);

推荐答案

我建议你仔细看看（API）文档，它都提到了。你可以传递表达式对象到 Query :: order（），如果你需要指定方向，还有 Query :: orderAsc 和查询:: orderDesc（）。

I'd suggest that you have a closer look at the (API) docs, it's all mentioned there. You can pass expression objects to Query::order(), and in case you need to specify the direction, there's also Query::orderAsc() and Query::orderDesc().

$ b

So

$expression = $query->func()->routine_name(['Purchases.customer_id' => 'literal']);
$query->order($expression);

或

$query->orderAsc($expression);

或

$query->orderDesc($expression);

另请参阅

• 食谱>数据库访问& ORM>查询构建器>选择数据

• Cookbook > Database Access & ORM > Query Builder > Selecting Data

API> \Cake\Database\Query :: order（）

API > \Cake\Database\Query::order()

API> \Cake\Database\Query :: orderAsc（）

API > \Cake\Database\Query::orderAsc()

API> \Cake\Database\Query :: orderDesc（）

API > \Cake\Database\Query::orderDesc()

这篇关于ORDER BY对MySQL存储函数在CakePHP 3的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！