1 files changed, 74 insertions, 0 deletions
diff --git a/tests/lib/DB/QueryBuilder/Partitioned/JoinConditionTest.php b/tests/lib/DB/QueryBuilder/Partitioned/JoinConditionTest.php
new file mode 100644
index 00000000000..8f84d6a0d2c
--- /dev/null
+++ b/tests/lib/DB/QueryBuilder/Partitioned/JoinConditionTest.php
@@ -0,0 +1,74 @@
+<?php
+
+declare(strict_types=1);
+/**
+ * SPDX-FileCopyrightText: 2024 Robin Appelman <robin@icewind.nl>
+ * SPDX-License-Identifier: AGPL-3.0-or-later
+ */
+
+namespace lib\DB\QueryBuilder\Partitioned;
+
+use OC\DB\ConnectionAdapter;
+use OC\DB\QueryBuilder\Partitioned\JoinCondition;
+use OC\DB\QueryBuilder\QueryBuilder;
+use OC\SystemConfig;
+use OCP\DB\QueryBuilder\IQueryBuilder;
+use OCP\IDBConnection;
+use Psr\Log\LoggerInterface;
+use Test\TestCase;
+
+class JoinConditionTest extends TestCase {
+	protected function setUp(): void {
+		parent::setUp();
+	}
+
+	public static function platformProvider(): array {
+		return [
+			[IDBConnection::PLATFORM_SQLITE],
+			[IDBConnection::PLATFORM_POSTGRES],
+			[IDBConnection::PLATFORM_MYSQL],
+			[IDBConnection::PLATFORM_ORACLE],
+		];
+	}
+
+	private function getBuilder(string $platform): IQueryBuilder {
+		$connection = $this->createMock(ConnectionAdapter::class);
+		$connection->method('getDatabaseProvider')->willReturn($platform);
+		return new QueryBuilder(
+			$connection,
+			$this->createMock(SystemConfig::class),
+			$this->createMock(LoggerInterface::class)
+		);
+	}
+
+	#[\PHPUnit\Framework\Attributes\DataProvider('platformProvider')]
+	public function testParseCondition(string $platform): void {
+		$query = $this->getBuilder($platform);
+		$param1 = $query->createNamedParameter('files');
+		$param2 = $query->createNamedParameter('test');
+		$condition = $query->expr()->andX(
+			$query->expr()->eq('tagmap.categoryid', 'tag.id'),
+			$query->expr()->eq('tag.type', $param1),
+			$query->expr()->eq('tag.uid', $param2)
+		);
+		$parsed = JoinCondition::parse($condition, 'vcategory', 'tag', 'tagmap');
+		$this->assertEquals('tagmap.categoryid', $parsed->fromColumn);
+		$this->assertEquals('tag.id', $parsed->toColumn);
+		$this->assertEquals([], $parsed->fromConditions);
+		$this->assertEquals([
+			$query->expr()->eq('tag.type', $param1),
+			$query->expr()->eq('tag.uid', $param2),
+		], $parsed->toConditions);
+	}
+
+	#[\PHPUnit\Framework\Attributes\DataProvider('platformProvider')]
+	public function testParseCastCondition(string $platform): void {
+		$query = $this->getBuilder($platform);
+
+		$condition = $query->expr()->eq($query->expr()->castColumn('m.objectid', IQueryBuilder::PARAM_INT), 'f.fileid');
+		$parsed = JoinCondition::parse($condition, 'filecache', 'f', 'm');
+		$this->assertEquals('m.objectid', $parsed->fromColumn);
+		$this->assertEquals('f.fileid', $parsed->toColumn);
+		$this->assertEquals([], $parsed->fromConditions);
+	}
+}