aboutsummaryrefslogtreecommitdiffstats
path: root/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
diff options
context:
space:
mode:
authorJoas Schilling <coding@schilljs.com>2017-07-24 12:01:35 +0200
committerJoas Schilling <coding@schilljs.com>2017-08-02 09:48:16 +0200
commit293dea0625ba76969c05fda47b2f5400bbaf523e (patch)
tree9de88205439db8d6ff5d1fafcb65c7e90eb577be /tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
parentbb58667511b79c2da47be0c08f82527b4088e9fb (diff)
downloadnextcloud-server-293dea0625ba76969c05fda47b2f5400bbaf523e.tar.gz
nextcloud-server-293dea0625ba76969c05fda47b2f5400bbaf523e.zip
Fix querybuilder and functionbuilder tests
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'tests/lib/DB/QueryBuilder/FunctionBuilderTest.php')
-rw-r--r--tests/lib/DB/QueryBuilder/FunctionBuilderTest.php8
1 files changed, 8 insertions, 0 deletions
diff --git a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
index c270e105fc1..e89da0fbc92 100644
--- a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
+++ b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php
@@ -44,6 +44,8 @@ class FunctionBuilderTest extends TestCase {
$query = $this->connection->getQueryBuilder();
$query->select($query->func()->concat($query->createNamedParameter('foo'), new Literal("'bar'")));
+ $query->from('appconfig')
+ ->setMaxResults(1);
$this->assertEquals('foobar', $query->execute()->fetchColumn());
}
@@ -52,6 +54,8 @@ class FunctionBuilderTest extends TestCase {
$query = $this->connection->getQueryBuilder();
$query->select($query->func()->md5($query->createNamedParameter('foobar')));
+ $query->from('appconfig')
+ ->setMaxResults(1);
$this->assertEquals(md5('foobar'), $query->execute()->fetchColumn());
}
@@ -60,6 +64,8 @@ class FunctionBuilderTest extends TestCase {
$query = $this->connection->getQueryBuilder();
$query->select($query->func()->substring($query->createNamedParameter('foobar'), new Literal(2), $query->createNamedParameter(2)));
+ $query->from('appconfig')
+ ->setMaxResults(1);
$this->assertEquals('oo', $query->execute()->fetchColumn());
}
@@ -68,6 +74,8 @@ class FunctionBuilderTest extends TestCase {
$query = $this->connection->getQueryBuilder();
$query->select($query->func()->substring($query->createNamedParameter('foobar'), new Literal(2)));
+ $query->from('appconfig')
+ ->setMaxResults(1);
$this->assertEquals('oobar', $query->execute()->fetchColumn());
}