PHP DatabaseConnection::admin_query方法代码示例

 /**
  * @test
  *
  * @return void
  */
 public function prepareSelectQueryCreateValidQuery()
 {
     $this->assertTrue($this->subject->admin_query("INSERT INTO {$this->testTable} ({$this->testField}) VALUES ('aTestValue')"));
     $preparedQuery = $this->subject->prepare_SELECTquery("{$this->testField},{$this->anotherTestField}", $this->testTable, 'id=:id', '', '', '', [':id' => 1]);
     $preparedQuery->execute();
     $result = $preparedQuery->fetch();
     $expectedResult = [$this->testField => 'aTestValue', $this->anotherTestField => null];
     $this->assertSame($expectedResult, $result);
 }

 /**
  * Create database if needed, save selected db name in configuration
  *
  * @return array<\TYPO3\CMS\Install\Status\StatusInterface>
  */
 public function execute()
 {
     $result = array();
     $this->initializeDatabaseConnection();
     $postValues = $this->postValues['values'];
     $localConfigurationPathValuePairs = array();
     /** @var $configurationManager \TYPO3\CMS\Core\Configuration\ConfigurationManager */
     $configurationManager = $this->objectManager->get(\TYPO3\CMS\Core\Configuration\ConfigurationManager::class);
     if ($postValues['type'] === 'new') {
         $newDatabaseName = $postValues['new'];
         if ($this->isValidDatabaseName($newDatabaseName)) {
             $createDatabaseResult = $this->databaseConnection->admin_query('CREATE DATABASE ' . $newDatabaseName . ' CHARACTER SET utf8');
             if ($createDatabaseResult) {
                 $localConfigurationPathValuePairs['DB/database'] = $newDatabaseName;
             } else {
                 /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
                 $errorStatus = $this->objectManager->get(\TYPO3\CMS\Install\Status\ErrorStatus::class);
                 $errorStatus->setTitle('Unable to create database');
                 $errorStatus->setMessage('Database with name ' . $newDatabaseName . ' could not be created.' . ' Either your database name contains a reserved keyword or your database' . ' user does not have sufficient permissions to create it.' . ' Please choose an existing (empty) database or contact administration.');
                 $result[] = $errorStatus;
             }
         } else {
             /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
             $errorStatus = $this->objectManager->get(\TYPO3\CMS\Install\Status\ErrorStatus::class);
             $errorStatus->setTitle('Database name not valid');
             $errorStatus->setMessage('Given database name must be shorter than fifty characters' . ' and consist solely of basic latin letters (a-z), digits (0-9), dollar signs ($)' . ' and underscores (_).');
             $result[] = $errorStatus;
         }
     } elseif ($postValues['type'] === 'existing' && !empty($postValues['existing'])) {
         // Only store database information when it's empty
         $this->databaseConnection->setDatabaseName($postValues['existing']);
         $this->databaseConnection->sql_select_db();
         $existingTables = $this->databaseConnection->admin_get_tables();
         $isInitialInstallation = $configurationManager->getConfigurationValueByPath('SYS/isInitialInstallationInProgress');
         if (!$isInitialInstallation || empty($existingTables)) {
             $localConfigurationPathValuePairs['DB/database'] = $postValues['existing'];
         }
     } else {
         /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
         $errorStatus = $this->objectManager->get(\TYPO3\CMS\Install\Status\ErrorStatus::class);
         $errorStatus->setTitle('No Database selected');
         $errorStatus->setMessage('You must select a database.');
         $result[] = $errorStatus;
     }
     if (!empty($localConfigurationPathValuePairs)) {
         $configurationManager->setLocalConfigurationValuesByPathValuePairs($localConfigurationPathValuePairs);
     }
     return $result;
 }

 /**
  * Create database if needed, save selected db name in configuration
  *
  * @return array<\TYPO3\CMS\Install\Status\StatusInterface>
  */
 public function execute()
 {
     $result = array();
     $this->initializeDatabaseConnection();
     $postValues = $this->postValues['values'];
     $localConfigurationPathValuePairs = array();
     /** @var $configurationManager \TYPO3\CMS\Core\Configuration\ConfigurationManager */
     $configurationManager = $this->objectManager->get('TYPO3\\CMS\\Core\\Configuration\\ConfigurationManager');
     if ($postValues['type'] === 'new') {
         $newDatabaseName = $postValues['new'];
         if (strlen($newDatabaseName) <= 50) {
             $createDatabaseResult = $this->databaseConnection->admin_query('CREATE DATABASE ' . $newDatabaseName . ' CHARACTER SET utf8');
             if ($createDatabaseResult) {
                 $localConfigurationPathValuePairs['DB/database'] = $newDatabaseName;
             } else {
                 /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
                 $errorStatus = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\ErrorStatus');
                 $errorStatus->setTitle('Unable to create database');
                 $errorStatus->setMessage('Database with name ' . $newDatabaseName . ' could not be created.' . ' Either your database name contains special chars (only alphanumeric characters are allowed)' . ' or your database user probably does not have sufficient permissions to create it.' . ' Please choose an existing (empty) database or contact administration.');
                 $result[] = $errorStatus;
             }
         } else {
             /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
             $errorStatus = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\ErrorStatus');
             $errorStatus->setTitle('Database name not valid');
             $errorStatus->setMessage('Given database name must be shorter than fifty characters.');
             $result[] = $errorStatus;
         }
     } elseif ($postValues['type'] === 'existing' && !empty($postValues['existing'])) {
         // Only store database information when it's empty
         $this->databaseConnection->setDatabaseName($postValues['existing']);
         $this->databaseConnection->sql_select_db();
         $existingTables = $this->databaseConnection->admin_get_tables();
         $isInitialInstallation = $configurationManager->getConfigurationValueByPath('SYS/isInitialInstallationInProgress');
         if (!$isInitialInstallation || count($existingTables) === 0) {
             $localConfigurationPathValuePairs['DB/database'] = $postValues['existing'];
         }
     } else {
         /** @var $errorStatus \TYPO3\CMS\Install\Status\ErrorStatus */
         $errorStatus = $this->objectManager->get('TYPO3\\CMS\\Install\\Status\\ErrorStatus');
         $errorStatus->setTitle('No Database selected');
         $errorStatus->setMessage('You must select a database.');
         $result[] = $errorStatus;
     }
     if (!empty($localConfigurationPathValuePairs)) {
         $configurationManager->setLocalConfigurationValuesByPathValuePairs($localConfigurationPathValuePairs);
     }
     return $result;
 }

 /**
  * Performs the accordant updates.
  *
  * @param array &$dbQueries Queries done in this update
  * @param mixed &$customMessages Custom messages
  * @return boolean Whether everything went smoothly or not
  */
 public function performUpdate(array &$dbQueries, &$customMessages)
 {
     $oldCategoryTableFields = $this->databaseConnection->admin_get_fields('tx_mooxnews_domain_model_category');
     // A temporary migration column is needed in old category table. Add this when not already present
     if (!array_key_exists('migrate_sys_category_uid', $oldCategoryTableFields)) {
         $this->databaseConnection->admin_query("ALTER TABLE tx_mooxnews_domain_model_category ADD migrate_sys_category_uid int(11) DEFAULT '0' NOT NULL");
     }
     // convert tx_mooxnews_domain_model_category records
     $this->migrateNewsCategoryRecords();
     // set/update all relations
     $oldNewCategoryUidMapping = $this->getOldNewCategoryUidMapping();
     $this->updateParentFieldOfMigratedCategories($oldNewCategoryUidMapping);
     $this->migrateCategoryMmRecords($oldNewCategoryUidMapping);
     $this->updateCategoryPermissionFields('be_groups', $oldNewCategoryUidMapping);
     $this->updateCategoryPermissionFields('be_users', $oldNewCategoryUidMapping);
     $this->migrateCategoryImages();
     $this->markWizardAsDone();
     return TRUE;
 }

 /**
  * Retrieves the default character set of the database.
  *
  * @return string
  */
 protected function getDefaultDatabaseCharset()
 {
     $result = $this->databaseConnection->admin_query('SHOW VARIABLES LIKE "character_set_database"');
     $row = $this->databaseConnection->sql_fetch_assoc($result);
     $key = $row['Variable_name'];
     $value = $row['Value'];
     $databaseCharset = '';
     if ($key == 'character_set_database') {
         $databaseCharset = $value;
     }
     return $databaseCharset;
 }

 /**
  * Migrates old event categories to sys_categories if required
  *
  * @return void
  */
 protected function migrateEventCategoriesToSysCategories()
 {
     // check if tx_sfeventmgt_domain_model_category still exists
     $oldCategoryTableFields = $this->databaseConnection->admin_get_fields('tx_sfeventmgt_domain_model_category');
     if (count($oldCategoryTableFields) === 0) {
         $status = FlashMessage::NOTICE;
         $title = '';
         $message = 'Old category table does not exist anymore so no update needed';
         $this->messageArray[] = [$status, $title, $message];
         return;
     }
     // check if there are categories present else no update is needed
     $oldCategoryCount = $this->databaseConnection->exec_SELECTcountRows('uid', 'tx_sfeventmgt_domain_model_category', 'deleted = 0');
     if ($oldCategoryCount === 0) {
         $status = FlashMessage::NOTICE;
         $title = '';
         $message = 'No categories found in old table, no update needed';
         $this->messageArray[] = [$status, $title, $message];
         return;
     } else {
         $status = FlashMessage::NOTICE;
         $title = '';
         $message = 'Must migrate ' . $oldCategoryCount . ' categories.';
         $this->messageArray[] = [$status, $title, $message];
     }
     // A temporary migration column is needed in old category table. Add this when not already present
     if (!array_key_exists('migrate_sys_category_uid', $oldCategoryTableFields)) {
         $this->databaseConnection->admin_query("ALTER TABLE tx_sfeventmgt_domain_model_category ADD migrate_sys_category_uid int(11) DEFAULT '0' NOT NULL");
     }
     // convert tx_sfeventmgt_domain_model_category records
     $this->migrateEventCategoryRecords();
     // set/update all relations
     $oldNewCategoryUidMapping = $this->getOldNewCategoryUidMapping();
     $this->updateParentFieldOfMigratedCategories($oldNewCategoryUidMapping);
     $this->migrateCategoryMmRecords($oldNewCategoryUidMapping);
     $this->updateFlexformCategories('sfeventmgt_pievent', $oldNewCategoryUidMapping, 'settings.category');
     /**
      * Finished category migration
      */
     $message = 'All categories are updated. Run <strong>DB compare</strong> in the install tool to remove the ' . 'now obsolete `tx_sfeventmgt_domain_model_category` and `tx_sfeventmgt_event_category_mm` tables and ' . 'run the <strong>DB check</strong> to update the reference index.';
     $status = FlashMessage::OK;
     $title = 'Updated all categories!';
     $this->messageArray[] = [$status, $title, $message];
 }

 /**
  * Returns TRUE if upgrade wizard for legacy EXT:eu_ldap records should be run.
  *
  * @return bool
  */
 protected function checkEuLdap()
 {
     $table = 'tx_euldap_server';
     $migrationField = 'tx_igldapssoauth_migrated';
     // We check the database table itself and not whether EXT:eu_ldap is loaded
     // because it may have been deactivated since it is not incompatible
     $existingTables = $this->databaseConnection->admin_get_tables();
     if (!isset($existingTables[$table])) {
         return FALSE;
     }
     // Ensure the column used to flag processed records is present
     $fields = $this->databaseConnection->admin_get_fields($table);
     if (!isset($fields[$migrationField])) {
         $alterTableQuery = 'ALTER TABLE ' . $table . ' ADD ' . $migrationField . ' tinyint(4) NOT NULL default \'0\'';
         // Method admin_query() will parse the query and make it compatible with DBAL, if needed
         $this->databaseConnection->admin_query($alterTableQuery);
     }
     $euLdapConfigurationRecords = $this->databaseConnection->exec_SELECTcountRows('*', $table, $migrationField . '=0');
     return $euLdapConfigurationRecords > 0;
 }

 /**
  * Updates realurl table structure. The code is copied almost 1:1 from
  * ExtensionManagerTables class.
  *
  * We ignore any errors because nothing can be done about those really. The
  * client will have to do database update anyway, so he will see all failed
  * queries.
  *
  * @return void
  */
 protected function updateRealurlTableStructure()
 {
     $updateStatements = array();
     // Get all necessary statements for ext_tables.sql file
     $rawDefinitions = file_get_contents(ExtensionManagementUtility::extPath('realurl', 'ext_tables.sql'));
     $sqlParser = GeneralUtility::makeInstance('TYPO3\\CMS\\Install\\Service\\SqlSchemaMigrationService');
     $fieldDefinitionsFromFile = $sqlParser->getFieldDefinitions_fileContent($rawDefinitions);
     if (count($fieldDefinitionsFromFile)) {
         $fieldDefinitionsFromCurrentDatabase = $sqlParser->getFieldDefinitions_database();
         $diff = $sqlParser->getDatabaseExtra($fieldDefinitionsFromFile, $fieldDefinitionsFromCurrentDatabase);
         $updateStatements = $sqlParser->getUpdateSuggestions($diff);
     }
     foreach ((array) $updateStatements['add'] as $string) {
         $this->databaseConnection->admin_query($string);
     }
     foreach ((array) $updateStatements['change'] as $string) {
         $this->databaseConnection->admin_query($string);
     }
     foreach ((array) $updateStatements['create_table'] as $string) {
         $this->databaseConnection->admin_query($string);
     }
 }

 /**
  * @test
  *
  * @return void
  */
 public function sqlFreeResultReturnsTrueOnSuccess()
 {
     $this->assertTrue($this->subject->admin_query("INSERT INTO {$this->testTable} ({$this->testField}) VALUES ('baz')"));
     $res = $this->subject->admin_query("SELECT * FROM {$this->testTable} WHERE {$this->testField}='baz'");
     $this->assertTrue($this->subject->sql_free_result($res));
 }