diff options
| author | Vitor Mattos <vitor@php.rio> | 2022-01-03 11:04:05 -0300 |
|---|---|---|
| committer | Vitor Mattos <vitor@php.rio> | 2022-01-03 12:45:00 -0300 |
| commit | 7b9fea85b6e893aca874b7a0a07866443822005a (patch) | |
| tree | c5f96ba7800a8ae60edcb3921fc83d01ebedffd8 /lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php | |
| parent | 79b3df00f82f3d0eee397f5389d23c8af1727afd (diff) | |
| download | nextcloud-server-7b9fea85b6e893aca874b7a0a07866443822005a.tar.gz nextcloud-server-7b9fea85b6e893aca874b7a0a07866443822005a.zip | |
Add unit test and orderBy parameter
Signed-off-by: Vitor Mattos <vitor@php.rio>
Diffstat (limited to 'lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php')
| -rw-r--r-- | lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php b/lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php index a3a25b7e293..702b71e12b8 100644 --- a/lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php +++ b/lib/private/DB/QueryBuilder/FunctionBuilder/PgSqlFunctionBuilder.php @@ -31,10 +31,15 @@ class PgSqlFunctionBuilder extends FunctionBuilder { return new QueryFunction('(' . $this->helper->quoteColumnName($x) . ' || ' . $this->helper->quoteColumnName($y) . ')'); } - public function groupConcat($expr, ?string $separator = ','): IQueryFunction { + public function groupConcat($expr, ?string $separator = ',', ?string $orderBy = null): IQueryFunction { + if (is_null($orderBy)) { + $orderByClause = ''; + } else { + $orderByClause = ' ORDER BY ' . $orderBy; + } if (is_null($separator)) { - return new QueryFunction('string_agg(' . $this->helper->quoteColumnName($expr)); + return new QueryFunction('string_agg(' . $this->helper->quoteColumnName($expr) . $orderByClause . ')'); } - return new QueryFunction('string_agg(' . $this->helper->quoteColumnName($expr) . ", '$separator')"); + return new QueryFunction('string_agg(' . $this->helper->quoteColumnName($expr) . ", '$separator'$orderByClause)"); } } |