コード例 #1
0
 /**
  * Compare current and expected database schemas and return the database differences
  *
  * @return array database differences
  */
 protected function getDatabaseDifferences()
 {
     $expectedSchema = $this->expectedSchemaService->getExpectedDatabaseSchema();
     $currentSchema = $this->schemaMigrationService->getFieldDefinitions_database();
     // Difference from expected to current
     return $this->schemaMigrationService->getDatabaseExtra($expectedSchema, $currentSchema);
 }
コード例 #2
0
 /**
  * Perform necessary database schema migrations
  *
  * @param SchemaUpdateType[] $schemaUpdateTypes List of permitted schema update types
  * @return SchemaUpdateResult Result of the schema update
  */
 public function updateSchema(array $schemaUpdateTypes)
 {
     $expectedSchema = $this->expectedSchemaService->getExpectedDatabaseSchema();
     $currentSchema = $this->schemaMigrationService->getFieldDefinitions_database();
     $addCreateChange = $this->schemaMigrationService->getDatabaseExtra($expectedSchema, $currentSchema);
     $dropRename = $this->schemaMigrationService->getDatabaseExtra($currentSchema, $expectedSchema);
     $updateStatements = array();
     ArrayUtility::mergeRecursiveWithOverrule($updateStatements, $this->schemaMigrationService->getUpdateSuggestions($addCreateChange));
     ArrayUtility::mergeRecursiveWithOverrule($updateStatements, $this->schemaMigrationService->getUpdateSuggestions($dropRename, 'remove'));
     $updateResult = new SchemaUpdateResult();
     foreach ($schemaUpdateTypes as $schemaUpdateType) {
         $statementTypes = $this->getStatementTypes($schemaUpdateType);
         foreach ($statementTypes as $statementType) {
             if (isset($updateStatements[$statementType])) {
                 $statements = $updateStatements[$statementType];
                 $result = $this->schemaMigrationService->performUpdateQueries($statements, array_combine(array_keys($statements), array_fill(0, count($statements), TRUE)));
                 if ($result === TRUE) {
                     $updateResult->addPerformedUpdates($schemaUpdateType, count($statements));
                 } elseif (is_array($result)) {
                     $updateResult->addErrors($schemaUpdateType, $result);
                 }
             }
         }
     }
     return $updateResult;
 }
コード例 #3
0
 /**
  * Determine all create table statements which create the sys_file* tables
  *
  * @return array
  */
 protected function getRequiredUpdates()
 {
     $requiredUpdates = array();
     $fileContent = \TYPO3\CMS\Core\Utility\GeneralUtility::getUrl(\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('core') . 'ext_tables.sql');
     $FDfile = $this->installerSql->getFieldDefinitions_fileContent($fileContent);
     $FDdb = $this->installerSql->getFieldDefinitions_database(TYPO3_db);
     $diff = $this->installerSql->getDatabaseExtra($FDfile, $FDdb);
     $update_statements = $this->installerSql->getUpdateSuggestions($diff);
     foreach ((array) $update_statements['create_table'] as $string) {
         if (preg_match('/^CREATE TABLE sys_file($|_)?/', $string)) {
             $requiredUpdates[] = $string;
         }
     }
     return $requiredUpdates;
 }
コード例 #4
0
 /**
  * Gets the differences in the database structure by comparing
  * the current structure with the SQL definitions of all extensions
  * and the TYPO3 core in t3lib/stddb/tables.sql (or typo3/sysext/core/ext_tables.sql,
  * see http://forge.typo3.org/issues/45187).
  *
  * This method searches for fields/tables to be removed.
  *
  * @param string $database
  * @param boolean $allowKeyModifications Whether to allow key modifications
  * @return array The database statements to update the structure
  */
 protected function getStructureDifferencesForRemoval($database, $allowKeyModifications = FALSE)
 {
     $differences = $this->install->getDatabaseExtra($this->install->getFieldDefinitions_database(), $this->getDefinedFieldDefinitions());
     if (!$allowKeyModifications) {
         $differences = $this->removeKeyModifications($differences);
     }
     return $differences;
 }
コード例 #5
0
 /**
  * Gets all create, add and change queries from core/ext_tables.sql
  *
  * @return array
  */
 protected function getUpdateStatements()
 {
     $updateStatements = array();
     // Get all necessary statements for ext_tables.sql file
     $rawDefinitions = \TYPO3\CMS\Core\Utility\GeneralUtility::getUrl(\TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('core') . '/ext_tables.sql');
     $fieldDefinitionsFromFile = $this->installToolSqlParser->getFieldDefinitions_fileContent($rawDefinitions);
     if (count($fieldDefinitionsFromFile)) {
         $fieldDefinitionsFromCurrentDatabase = $this->installToolSqlParser->getFieldDefinitions_database();
         $diff = $this->installToolSqlParser->getDatabaseExtra($fieldDefinitionsFromFile, $fieldDefinitionsFromCurrentDatabase);
         $updateStatements = $this->installToolSqlParser->getUpdateSuggestions($diff);
     }
     return $updateStatements;
 }
コード例 #6
0
 /**
  * @test
  */
 public function columnAndKeyDeletionDoesNotReturnAnError()
 {
     // Get the current database fields.
     $currentDatabaseSchema = $this->sqlSchemaMigrationService->getFieldDefinitions_database();
     // Limit our scope to the be_users table:
     $currentDatabaseSchemaForBeUsers = array();
     $currentDatabaseSchemaForBeUsers['be_users'] = $currentDatabaseSchema['be_users'];
     unset($currentDatabaseSchema);
     // Create a key and a field that belongs to that key:
     $expectedDatabaseSchemaForBeUsers = $currentDatabaseSchemaForBeUsers;
     $expectedDatabaseSchemaForBeUsers['be_users']['fields']['functional_test_field_1'] = "tinyint(1) unsigned NOT NULL default '0'";
     $expectedDatabaseSchemaForBeUsers['be_users']['keys']['functional_test_key_1'] = 'KEY functional_test_key_1 (functional_test_field_1)';
     $createFieldDiff = $this->sqlSchemaMigrationService->getDatabaseExtra($expectedDatabaseSchemaForBeUsers, $currentDatabaseSchemaForBeUsers);
     $createFieldDiff = $this->sqlSchemaMigrationService->getUpdateSuggestions($createFieldDiff);
     $this->sqlSchemaMigrationService->performUpdateQueries($createFieldDiff['add'], $createFieldDiff['add']);
     // Now remove the fields again (without the renaming step).
     unset($currentDatabaseSchemaForBeUsers['be_users']['fields']['functional_test_field_1']);
     unset($currentDatabaseSchemaForBeUsers['be_users']['keys']['functional_test_key_1']);
     $this->sqlSchemaMigrationService->setDeletedPrefixKey('');
     $removeFieldDiff = $this->sqlSchemaMigrationService->getDatabaseExtra($expectedDatabaseSchemaForBeUsers, $currentDatabaseSchemaForBeUsers);
     $removeFieldDiff = $this->sqlSchemaMigrationService->getUpdateSuggestions($removeFieldDiff, 'remove');
     $result = $this->sqlSchemaMigrationService->performUpdateQueries($removeFieldDiff['drop'], $removeFieldDiff['drop']);
     $this->assertTrue($result, 'performUpdateQueries() did not return TRUE, this means an error occurred: ' . (is_array($result) ? array_pop($result) : ''));
 }
コード例 #7
0
 /**
  * Update database / process db updates from ext_tables
  *
  * @param string $rawDefinitions The raw SQL statements from ext_tables.sql
  * @return void
  */
 public function updateDbWithExtTablesSql($rawDefinitions)
 {
     $fieldDefinitionsFromFile = $this->installToolSqlParser->getFieldDefinitions_fileContent($rawDefinitions);
     if (count($fieldDefinitionsFromFile)) {
         $fieldDefinitionsFromCurrentDatabase = $this->installToolSqlParser->getFieldDefinitions_database();
         $diff = $this->installToolSqlParser->getDatabaseExtra($fieldDefinitionsFromFile, $fieldDefinitionsFromCurrentDatabase);
         $updateStatements = $this->installToolSqlParser->getUpdateSuggestions($diff);
         $db = $this->getDatabaseConnection();
         foreach ((array) $updateStatements['add'] as $string) {
             $db->admin_query($string);
         }
         foreach ((array) $updateStatements['change'] as $string) {
             $db->admin_query($string);
         }
         foreach ((array) $updateStatements['create_table'] as $string) {
             $db->admin_query($string);
         }
     }
 }
コード例 #8
0
 /**
  * Stub function for the extension manager
  *
  * @return    boolean    true to allow access
  */
 protected function init()
 {
     $this->objectManager = GeneralUtility::makeInstance('TYPO3\\CMS\\Extbase\\Object\\ObjectManager');
     $this->schemaMigrationService = $this->objectManager->get('TYPO3\\CMS\\Install\\Service\\SqlSchemaMigrationService');
     $this->currentSchema = $this->schemaMigrationService->getFieldDefinitions_database();
 }