diff options
Diffstat (limited to 'tests/lib/DB/QueryBuilder')
| -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()); + } } |