From 2a68819a67045d87a369a8a6413f153b3b2bea5f Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Thu, 28 Apr 2022 15:16:07 +0200 Subject: add case statement to sql function builder Signed-off-by: Robin Appelman --- .../DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'lib/private/DB/QueryBuilder/FunctionBuilder') diff --git a/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php b/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php index e0a7549a0ad..408a879d624 100644 --- a/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php +++ b/lib/private/DB/QueryBuilder/FunctionBuilder/FunctionBuilder.php @@ -121,4 +121,15 @@ class FunctionBuilder implements IFunctionBuilder { public function least($x, $y): IQueryFunction { return new QueryFunction('LEAST(' . $this->helper->quoteColumnName($x) . ', ' . $this->helper->quoteColumnName($y) . ')'); } + + public function case(array $whens, $else): IQueryFunction { + if (count($whens) < 1) { + return new QueryFunction($this->helper->quoteColumnName($else)); + } + + $whenParts = array_map(function (array $when) { + return 'WHEN ' . $this->helper->quoteColumnName($when['when']) . ' THEN ' . $this->helper->quoteColumnName($when['then']); + }, $whens); + return new QueryFunction('CASE ' . implode(' ', $whenParts) . ' ELSE ' . $this->helper->quoteColumnName($else) . ' END'); + } } -- cgit v1.2.3