1 files changed, 107 insertions, 0 deletions
diff --git a/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SemanticDataSortKeyUpdateDBIntegrationTest.php b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SemanticDataSortKeyUpdateDBIntegrationTest.php
new file mode 100644
index 00000000..6af6b620
--- /dev/null
+++ b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SemanticDataSortKeyUpdateDBIntegrationTest.php
@@ -0,0 +1,107 @@
+<?php
+
+namespace SMW\Tests\Integration;
+
+use SMW\DIProperty;
+use SMW\Tests\MwDBaseUnitTestCase;
+use SMW\Tests\Utils\UtilityFactory;
+use SMWDIBlob as DIBlob;
+use Title;
+
+/**
+ * @group SMW
+ * @group SMWExtension
+ *
+ * @group semantic-mediawiki-integration
+ * @group mediawiki-database
+ *
+ * @group medium
+ *
+ * @license GNU GPL v2+
+ * @since 2.1
+ *
+ * @author mwjames
+ */
+class SemanticDataSortKeyUpdateDBIntegrationTest extends MwDBaseUnitTestCase {
+
+	private $semanticDataFactory;
+	private $subjects = [];
+
+	protected function setUp() {
+		parent::setUp();
+
+		$this->semanticDataFactory = UtilityFactory::getInstance()->newSemanticDataFactory();
+
+		$this->mwHooksHandler = UtilityFactory::getInstance()->newMwHooksHandler();
+		$this->mwHooksHandler->deregisterListedHooks();
+	}
+
+	protected function tearDown() {
+
+		$pageDeleter = UtilityFactory::getInstance()->newPageDeleter();
+		$pageDeleter->doDeletePoolOfPages( $this->subjects );
+		$this->mwHooksHandler->restoreListedHooks();
+
+		parent::tearDown();
+	}
+
+	public function testSubjectSortKeySetter() {
+
+		$semanticData = $this->semanticDataFactory->newEmptySemanticData( __METHOD__ );
+
+		$subject = $semanticData->getSubject();
+		$subject->setSortKey( 'a_b_c' );
+
+		$this->getStore()->updateData( $semanticData );
+
+		$semanticDataFromDB = $this->getStore()->getSemanticData( $subject );
+
+		$this->assertEquals(
+			'a b c',
+			$semanticDataFromDB->getSubject()->getSortKey()
+		);
+
+		foreach ( $semanticDataFromDB->getPropertyValues( new DIProperty( '_SKEY' ) ) as $value ) {
+			$this->assertEquals(
+				'a b c',
+				$value->getString()
+			);
+		}
+
+		$this->subjects[] = $semanticData->getSubject();
+	}
+
+	public function testDefinedSortKeyTakesPrecedenceOverSubjectSortKey() {
+
+		$semanticData = $this->semanticDataFactory
+			->newEmptySemanticData( __METHOD__ );
+
+		$subject = $semanticData->getSubject();
+		$subject->setSortKey( '1_2_3' );
+
+		$semanticData->addPropertyObjectValue(
+			new DIProperty( '_SKEY' ),
+			new DIBlob( 'x_y_z' )
+		);
+
+		$this->getStore()->updateData( $semanticData );
+		$this->getStore()->clear();
+
+		$semanticDataFromDB = $this->getStore()->getSemanticData( $subject );
+
+		$this->assertEquals(
+			'x y z',
+			$semanticDataFromDB->getSubject()->getSortKey()
+		);
+
+		foreach ( $semanticDataFromDB->getPropertyValues( new DIProperty( '_SKEY' ) ) as $value ) {
+			$this->assertEquals(
+				'x y z',
+				$value->getString()
+			);
+		}
+
+		$this->subjects[] = $semanticData->getSubject();
+	}
+
+}