From 7b9fea85b6e893aca874b7a0a07866443822005a Mon Sep 17 00:00:00 2001 From: Vitor Mattos Date: Mon, 3 Jan 2022 11:04:05 -0300 Subject: Add unit test and orderBy parameter Signed-off-by: Vitor Mattos --- tests/lib/DB/QueryBuilder/FunctionBuilderTest.php | 26 +++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'tests') diff --git a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php index 71ae3d5c7f6..b824b86fecf 100644 --- a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php +++ b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php @@ -54,6 +54,32 @@ class FunctionBuilderTest extends TestCase { $this->assertEquals('foobar', $column); } + public function testGroupConcatWithoutSeparatorAndOrder() { + $query = $this->connection->getQueryBuilder(); + + $query->select($query->func()->groupConcat('appid')); + $query->from('appconfig') + ->setMaxResults(1); + + $result = $query->execute(); + $column = $result->fetchOne(); + $result->closeCursor(); + $this->assertGreaterThan(1, str_getcsv($column, ',')); + } + + public function testGroupConcatWithSeparatorAndOrder() { + $query = $this->connection->getQueryBuilder(); + + $query->select($query->func()->groupConcat('appid', '#', 'appid')); + $query->from('appconfig') + ->setMaxResults(1); + + $result = $query->execute(); + $column = $result->fetchOne(); + $result->closeCursor(); + $this->assertGreaterThan(1, str_getcsv($column, '#', 'appid')); + } + public function testMd5() { $query = $this->connection->getQueryBuilder(); -- cgit v1.2.3