summaryrefslogtreecommitdiff
path: root/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php')
-rw-r--r--www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php318
1 files changed, 318 insertions, 0 deletions
diff --git a/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php
new file mode 100644
index 00000000..535b3faf
--- /dev/null
+++ b/www/wiki/extensions/SemanticMediaWiki/tests/phpunit/Integration/SQLStore/TableBuilder/TableBuilderIntegrationTest.php
@@ -0,0 +1,318 @@
+<?php
+
+namespace SMW\Tests\Integration\SQLStore\TableBuilder;
+
+use Onoi\MessageReporter\MessageReporterFactory;
+use SMW\SQLStore\TableBuilder\FieldType;
+use SMW\SQLStore\TableBuilder\PostgresTableBuilder;
+use SMW\SQLStore\TableBuilder\SQLiteTableBuilder;
+use SMW\SQLStore\TableBuilder\Table;
+use SMW\SQLStore\TableBuilder\TableBuilder;
+use SMW\Tests\MwDBaseUnitTestCase;
+
+/**
+ * @group semantic-mediawiki
+ * @group medium
+ *
+ * @license GNU GPL v2+
+ * @since 2.5
+ *
+ * @author mwjames
+ */
+class TableBuilderIntegrationTest extends MwDBaseUnitTestCase {
+
+ private $messageReporterFactory;
+ private $TableBuilder;
+ private $stringValidator;
+ private $tableName = 'rdbms_test';
+
+ protected function setUp() {
+ parent::setUp();
+
+ $this->messageReporterFactory = MessageReporterFactory::getInstance();
+
+ $this->tableBuilder = TableBuilder::factory(
+ $this->getStore()->getConnection( DB_MASTER )
+ );
+
+ $this->stringValidator = $this->testEnvironment->getUtilityFactory()->newValidatorFactory()->newStringValidator();
+ }
+
+ protected function tearDown() {
+ parent::tearDown();
+ }
+
+ public function testCreateTable() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking table rdbms_test',
+ 'Table not found, now creating',
+ ];
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testUpdateTableWithNewField() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_INT, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking table rdbms_test',
+ 'Table already exists, checking structure',
+ 'creating field t_num',
+ ];
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testUpdateTableWithNewFieldType() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_DOUBLE, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking table rdbms_test',
+ 'Table already exists, checking structure',
+ 'changing type of field t_num',
+ ];
+
+ // Not supported
+ if ( $this->tableBuilder instanceof SQLiteTableBuilder ) {
+ $expected = str_replace( 'changing type of field t_num', 'changing field type is not supported', $expected );
+ }
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testCreateIndex() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_DOUBLE, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $table->addIndex( 'id' );
+ $table->addIndex( 't_int' );
+ $table->addIndex( 't_num' );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking index structures for table rdbms_test',
+ 'index id is fine',
+ 'creating new index t_num'
+ ];
+
+ // ID message, Primary doesn't implicitly exists before
+ if ( $this->tableBuilder instanceof PostgresTableBuilder || $this->tableBuilder instanceof SQLiteTableBuilder ) {
+ $expected = str_replace( 'index id is fine', 'creating new index id', $expected );
+ }
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testUpdateIndex_ReplaceIndex() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_DOUBLE, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $table->addIndex( 'id' );
+ $table->addIndex( 't_num,t_int' );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking index structures for table rdbms_test',
+ 'index id is fine',
+ 'removing index t_num',
+ 'creating new index t_num,t_int',
+ ];
+
+ if ( $this->tableBuilder instanceof SQLiteTableBuilder ) {
+ $expected = str_replace( 'index id is fine', 'creating new index id', $expected );
+ $expected = 'removing index';
+ }
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testUpdateIndex_RemoveIndexWithArrayNotation() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_DOUBLE, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $table->addIndex( [ 'id', 'UNIQUE INDEX' ] );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking index structures for table rdbms_test',
+ 'index id is fine',
+ 'removing index t_num,t_int'
+ ];
+
+ if ( $this->tableBuilder instanceof SQLiteTableBuilder ) {
+ $expected = str_replace( 'index id is fine', 'creating new index id', $expected );
+ $expected = 'removing index';
+ }
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testUpdateIndex_NoIndexChange() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+ $table->addColumn( 'id', FieldType::FIELD_ID_PRIMARY );
+ $table->addColumn( 't_text', [ FieldType::TYPE_BLOB, 'NOT NULL' ] );
+ $table->addColumn( 't_num', [ FieldType::TYPE_DOUBLE, 'NOT NULL' ] );
+ $table->addColumn( 't_int', [ FieldType::TYPE_INT ] );
+
+ $table->addIndex( [ 'id', 'UNIQUE INDEX' ] );
+
+ $this->tableBuilder->create( $table );
+
+ $expected = [
+ 'Checking index structures for table rdbms_test',
+ 'index id is fine'
+ ];
+
+ if ( $this->tableBuilder instanceof SQLiteTableBuilder ) {
+ $expected = str_replace( 'index id is fine', 'creating new index id', $expected );
+ $expected = 'removing index';
+ }
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testDropTable() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( $this->tableName );
+
+ $this->tableBuilder->drop( $table );
+
+ $expected = [
+ 'dropped table rdbms_test'
+ ];
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+ public function testTryToDropTableWhichNotExists() {
+
+ $messageReporter = $this->messageReporterFactory->newSpyMessageReporter();
+
+ $this->tableBuilder->setMessageReporter(
+ $messageReporter
+ );
+
+ $table = new Table( 'foo_test' );
+
+ $this->tableBuilder->drop( $table );
+
+ $expected = [
+ 'foo_test not found, skipping removal'
+ ];
+
+ $this->stringValidator->assertThatStringContains(
+ $expected,
+ $messageReporter->getMessagesAsString()
+ );
+ }
+
+}
generated by cgit v1.2.1 (git 2.18.0) at 2024-05-04 13:35:35 +0000