From 6e0123a1d0343b6b850ef6e3b341acf082fa0dce Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Mon, 20 Jun 2022 17:53:31 +0200 Subject: Revert "add case statement to sql function builder" This reverts commit 2a68819a67045d87a369a8a6413f153b3b2bea5f. Signed-off-by: Robin Appelman --- tests/lib/DB/QueryBuilder/FunctionBuilderTest.php | 17 ----------------- 1 file changed, 17 deletions(-) (limited to 'tests') diff --git a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php index 0ea6e69c956..08392b09d8d 100644 --- a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php +++ b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php @@ -501,21 +501,4 @@ class FunctionBuilderTest extends TestCase { $result->closeCursor(); $this->assertEquals(1, $row); } - - public function testCase() { - $query = $this->connection->getQueryBuilder(); - - $query->select($query->func()->case([ - ['when' => $query->expr()->gt($query->expr()->literal(1, IQueryBuilder::PARAM_INT), $query->expr()->literal(2, IQueryBuilder::PARAM_INT)), 'then' => $query->expr()->literal('first')], - ['when' => $query->expr()->lt($query->expr()->literal(1, IQueryBuilder::PARAM_INT), $query->expr()->literal(2, IQueryBuilder::PARAM_INT)), 'then' => $query->expr()->literal('second')], - ['when' => $query->expr()->eq($query->expr()->literal(1, IQueryBuilder::PARAM_INT), $query->expr()->literal(2, IQueryBuilder::PARAM_INT)), 'then' => $query->expr()->literal('third')], - ], $query->createNamedParameter('else'))); - $query->from('appconfig') - ->setMaxResults(1); - - $result = $query->execute(); - $row = $result->fetchOne(); - $result->closeCursor(); - $this->assertEquals('second', $row); - } } -- cgit v1.2.3