From 89a9d35d90b7264d66411dfefec0aa84491d5cf9 Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Tue, 10 Apr 2018 18:30:43 +0200 Subject: dont keep shared database locks when running cli scripts For cli scripts we don't have the assumption that the universe will be cleaned up soon Signed-off-by: Robin Appelman --- tests/lib/DB/QueryBuilder/FunctionBuilderTest.php | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) (limited to 'tests/lib/DB/QueryBuilder/FunctionBuilderTest.php') diff --git a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php index 869faccc5cc..1b998287c98 100644 --- a/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php +++ b/tests/lib/DB/QueryBuilder/FunctionBuilderTest.php @@ -21,6 +21,7 @@ namespace Test\DB\QueryBuilder; use OC\DB\QueryBuilder\Literal; +use OCP\DB\QueryBuilder\IQueryBuilder; use Test\TestCase; /** @@ -89,4 +90,24 @@ class FunctionBuilderTest extends TestCase { $this->assertEquals('foobar', $query->execute()->fetchColumn()); } + + public function testAdd() { + $query = $this->connection->getQueryBuilder(); + + $query->select($query->func()->add($query->createNamedParameter(2, IQueryBuilder::PARAM_INT), new Literal(1))); + $query->from('appconfig') + ->setMaxResults(1); + + $this->assertEquals(3, $query->execute()->fetchColumn()); + } + + public function testSubtract() { + $query = $this->connection->getQueryBuilder(); + + $query->select($query->func()->subtract($query->createNamedParameter(2, IQueryBuilder::PARAM_INT), new Literal(1))); + $query->from('appconfig') + ->setMaxResults(1); + + $this->assertEquals(1, $query->execute()->fetchColumn()); + } } -- cgit v1.2.3