summaryrefslogtreecommitdiffstats
path: root/tests/lib/DB
diff options
context:
space:
mode:
authorRobin Appelman <robin@icewind.nl>2017-12-20 15:51:37 +0100
committerRobin Appelman <robin@icewind.nl>2017-12-20 15:51:37 +0100
commitaad01894e38ff77781934c16b75dac43d49ec74a (patch)
tree2ee2e3354bf6987eea6dfb19a801cb6ac2987d6a /tests/lib/DB
parentac14d02e1e23d8e31e11ed9729285d7fc5924543 (diff)
downloadnextcloud-server-aad01894e38ff77781934c16b75dac43d49ec74a.tar.gz
nextcloud-server-aad01894e38ff77781934c16b75dac43d49ec74a.zip
refactor user searching
add additional user searching tests Signed-off-by: Robin Appelman <robin@icewind.nl>
Diffstat (limited to 'tests/lib/DB')
-rw-r--r--tests/lib/DB/QueryBuilder/FunctionBuilderTest.php10
1 files changed, 10 insertions, 0 deletions
diff --git a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
index e89da0fbc92..869faccc5cc 100644
--- a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
+++ b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
@@ -79,4 +79,14 @@ class FunctionBuilderTest extends TestCase {
$this->assertEquals('oobar', $query->execute()->fetchColumn());
}
+
+ public function testLower() {
+ $query = $this->connection->getQueryBuilder();
+
+ $query->select($query->func()->lower($query->createNamedParameter('FooBar')));
+ $query->from('appconfig')
+ ->setMaxResults(1);
+
+ $this->assertEquals('foobar', $query->execute()->fetchColumn());
+ }
}