diff options
| author | Robin Appelman <robin@icewind.nl> | 2018-04-12 12:09:43 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2018-04-12 12:09:43 +0200 |
| commit | fb34ef10936fc5a3cb3d238cc6c7029dbc6a0f4a (patch) | |
| tree | 1deb7853ac6eecf9f598f23e5d8aba6414852cb5 /tests/lib/DB/QueryBuilder/FunctionBuilderTest.php | |
| parent | e275b9a2cf8cba45a484265c7f4998b6056d699f (diff) | |
| parent | 89a9d35d90b7264d66411dfefec0aa84491d5cf9 (diff) | |
| download | nextcloud-server-fb34ef10936fc5a3cb3d238cc6c7029dbc6a0f4a.tar.gz nextcloud-server-fb34ef10936fc5a3cb3d238cc6c7029dbc6a0f4a.zip | |
Merge pull request #9134 from nextcloud/db-locks-cli
dont keep shared database locks when running cli scripts
Diffstat (limited to 'tests/lib/DB/QueryBuilder/FunctionBuilderTest.php')
| -rw-r--r-- | tests/lib/DB/QueryBuilder/FunctionBuilderTest.php | 21 |
1 files changed, 21 insertions, 0 deletions
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()); + } } |