aboutsummaryrefslogtreecommitdiffstats
path: root/tests
diff options
context:
space:
mode:
authorJulius Härtl <jus@bitgrid.net>2023-07-10 19:41:46 +0200
committerJulius Härtl <jus@bitgrid.net>2023-12-29 10:36:59 +0100
commite50cb0a30ff36181504b7d5f1b46c2f53c5bc9b5 (patch)
treeb0188f25c1a9f38de3f45385a10b9cf661368917 /tests
parent86dc7662763ebc053480c55bc1d113d8c316d01c (diff)
downloadnextcloud-server-e50cb0a30ff36181504b7d5f1b46c2f53c5bc9b5.tar.gz
nextcloud-server-e50cb0a30ff36181504b7d5f1b46c2f53c5bc9b5.zip
tests(DB): Add test for date time comparisons in query builder
Signed-off-by: Julius Härtl <jus@bitgrid.net>
Diffstat (limited to 'tests')
-rw-r--r--tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php86
1 files changed, 86 insertions, 0 deletions
diff --git a/tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php b/tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php
index 35d8b4faa34..33b5824a0dd 100644
--- a/tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php
+++ b/tests/lib/DB/QueryBuilder/ExpressionBuilderDBTest.php
@@ -21,8 +21,12 @@
namespace Test\DB\QueryBuilder;
+use Doctrine\DBAL\Schema\SchemaException;
+use Doctrine\DBAL\Types\Types;
use OC\DB\QueryBuilder\Literal;
use OCP\DB\QueryBuilder\IQueryBuilder;
+use OCP\IConfig;
+use OCP\Server;
use Test\TestCase;
/**
@@ -31,11 +35,13 @@ use Test\TestCase;
class ExpressionBuilderDBTest extends TestCase {
/** @var \Doctrine\DBAL\Connection|\OCP\IDBConnection */
protected $connection;
+ protected $schemaSetup = false;
protected function setUp(): void {
parent::setUp();
$this->connection = \OC::$server->getDatabaseConnection();
+ $this->prepareTestingTable();
}
public function likeProvider() {
@@ -150,6 +156,59 @@ class ExpressionBuilderDBTest extends TestCase {
self::assertEquals('myvalue', $entries[0]['configvalue']);
}
+ public function testDateTimeEquals() {
+ $dateTime = new \DateTime('2023-01-01');
+ $insert = $this->connection->getQueryBuilder();
+ $insert->insert('testing')
+ ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATE)])
+ ->executeStatement();
+
+ $query = $this->connection->getQueryBuilder();
+ $result = $query->select('*')
+ ->from('testing')
+ ->where($query->expr()->eq('datetime', $query->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATE)))
+ ->executeQuery();
+ $entries = $result->fetchAll();
+ $result->closeCursor();
+ self::assertCount(1, $entries);
+ }
+
+ public function testDateTimeLess() {
+ $dateTime = new \DateTime('2022-01-01');
+ $dateTimeCompare = new \DateTime('2022-01-02');
+ $insert = $this->connection->getQueryBuilder();
+ $insert->insert('testing')
+ ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATE)])
+ ->executeStatement();
+
+ $query = $this->connection->getQueryBuilder();
+ $result = $query->select('*')
+ ->from('testing')
+ ->where($query->expr()->lt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATE)))
+ ->executeQuery();
+ $entries = $result->fetchAll();
+ $result->closeCursor();
+ self::assertCount(1, $entries);
+ }
+
+ public function testDateTimeGreater() {
+ $dateTime = new \DateTime('2023-01-02');
+ $dateTimeCompare = new \DateTime('2023-01-01');
+ $insert = $this->connection->getQueryBuilder();
+ $insert->insert('testing')
+ ->values(['datetime' => $insert->createNamedParameter($dateTime, IQueryBuilder::PARAM_DATE)])
+ ->executeStatement();
+
+ $query = $this->connection->getQueryBuilder();
+ $result = $query->select('*')
+ ->from('testing')
+ ->where($query->expr()->gt('datetime', $query->createNamedParameter($dateTimeCompare, IQueryBuilder::PARAM_DATE)))
+ ->executeQuery();
+ $entries = $result->fetchAll();
+ $result->closeCursor();
+ self::assertCount(1, $entries);
+ }
+
protected function createConfig($appId, $key, $value) {
$query = $this->connection->getQueryBuilder();
$query->insert('appconfig')
@@ -160,4 +219,31 @@ class ExpressionBuilderDBTest extends TestCase {
])
->execute();
}
+
+ protected function prepareTestingTable(): void {
+ if ($this->schemaSetup) {
+ $this->connection->getQueryBuilder()->delete('testing')->executeStatement();
+ }
+
+ $prefix = Server::get(IConfig::class)->getSystemValueString('dbtableprefix', 'oc_');
+ $schema = $this->connection->createSchema();
+ try {
+ $schema->getTable($prefix . 'testing');
+ $this->connection->getQueryBuilder()->delete('testing')->executeStatement();
+ } catch (SchemaException $e) {
+ $this->schemaSetup = true;
+ $table = $schema->createTable($prefix . 'testing');
+ $table->addColumn('id', Types::BIGINT, [
+ 'autoincrement' => true,
+ 'notnull' => true,
+ ]);
+
+ $table->addColumn('datetime', Types::DATETIME_MUTABLE, [
+ 'notnull' => false,
+ ]);
+
+ $table->setPrimaryKey(['id']);
+ $this->connection->migrateToSchema($schema);
+ }
+ }
}