PHP DatabaseConnection::admin_get_fields方法代码示例

 /**
  * 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;
 }

 /**
  * @test
  */
 public function extensionAlteringTable()
 {
     if (!ExtensionManagementUtility::isLoaded('aaa') || !ExtensionManagementUtility::isLoaded('bbb')) {
         self::markTestSkipped('This test can only be run if the extensions aaa and bbb ' . 'from tests/res are installed.');
     }
     $this->importExtensions(array('bbb'), true);
     $tableNames = $this->getDatabaseTables();
     self::assertContains('tx_bbb_test', $tableNames, 'Check that extension bbb is installed. The extension can be found in TestExtensions/.');
     self::assertContains('tx_aaa_test', $tableNames, 'Check that extension aaa is installed. The extension can be found in TestExtensions/.');
     // extension BBB extends an AAA table
     $columns = $this->db->admin_get_fields('tx_aaa_test');
     self::assertContains('tx_bbb_test', array_keys($columns), self::DB_PERMISSIONS_MESSAGE);
 }

 /**
  * Check whether field name is valid.
  * -> prevent sql injection
  *
  * @param string $field field name
  * @return boolean true, if column name is valid
  */
 protected function validateName($field)
 {
     if ($field === 'username') {
         return true;
     }
     $res = $this->databaseHandle->admin_get_fields('fe_users');
     if ($res) {
         while ($row = $this->databaseHandle->sql_fetch_assoc($res)) {
             if ($row['Field'] === $field) {
                 return true;
             }
         }
     }
     return false;
 }

 /**
  * Search
  *
  * @return string
  */
 public function search()
 {
     $SET = $GLOBALS['SOBE']->MOD_SETTINGS;
     $swords = $SET['sword'];
     $out = '';
     $limit = 200;
     if ($swords) {
         foreach ($GLOBALS['TCA'] as $table => $value) {
             // Get fields list
             $conf = $GLOBALS['TCA'][$table];
             // Avoid querying tables with no columns
             if (empty($conf['columns'])) {
                 continue;
             }
             $fieldsInDatabase = $this->databaseConnection->admin_get_fields($table);
             $list = array_intersect(array_keys($conf['columns']), array_keys($fieldsInDatabase));
             // Get query
             $qp = $this->databaseConnection->searchQuery(array($swords), $list, $table);
             // Count:
             $count = $this->databaseConnection->exec_SELECTcountRows('*', $table, $qp . BackendUtility::deleteClause($table));
             if ($count) {
                 $rowArr = array();
                 $res = $this->databaseConnection->exec_SELECTquery('uid,' . $conf['ctrl']['label'], $table, $qp . BackendUtility::deleteClause($table), '', '', $limit);
                 $lrow = null;
                 while ($row = $this->databaseConnection->sql_fetch_assoc($res)) {
                     $rowArr[] = $this->resultRowDisplay($row, $conf, $table);
                     $lrow = $row;
                 }
                 $this->databaseConnection->sql_free_result($res);
                 $markup = [];
                 $markup[] = '<div class="panel panel-default">';
                 $markup[] = '  <div class="panel-heading">';
                 $markup[] = $this->languageService->sL($conf['ctrl']['title'], true) . ' (' . $count . ')';
                 $markup[] = '  </div>';
                 $markup[] = '  <table class="table table-striped table-hover">';
                 $markup[] = $this->resultRowTitles($lrow, $conf, $table);
                 $markup[] = '  </table>';
                 $markup[] = '</div>';
                 $out .= implode(LF, $markup);
             }
         }
     }
     return $out;
 }

 /**
  * 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;
 }

 /**
  * Clear the TYPO3 page cache for the given record.
  * If the record lies on a page, then we clear the cache of this page.
  * If the record has no PID column, we clear the cache of the current page as best-effort.
  *
  * Much of this functionality is taken from DataHandler::clear_cache() which unfortunately only works with logged-in BE user.
  *
  * @param string $tableName Table name of the record
  * @param int $uid UID of the record
  * @return void
  */
 protected function clearPageCache($tableName, $uid)
 {
     $frameworkConfiguration = $this->configurationManager->getConfiguration(\TYPO3\CMS\Extbase\Configuration\ConfigurationManagerInterface::CONFIGURATION_TYPE_FRAMEWORK);
     if (isset($frameworkConfiguration['persistence']['enableAutomaticCacheClearing']) && $frameworkConfiguration['persistence']['enableAutomaticCacheClearing'] === '1') {
     } else {
         // if disabled, return
         return;
     }
     $pageIdsToClear = array();
     $storagePage = NULL;
     $columns = $this->databaseHandle->admin_get_fields($tableName);
     if (array_key_exists('pid', $columns)) {
         $result = $this->databaseHandle->exec_SELECTquery('pid', $tableName, 'uid=' . (int) $uid);
         if ($row = $this->databaseHandle->sql_fetch_assoc($result)) {
             $storagePage = $row['pid'];
             $pageIdsToClear[] = $storagePage;
         }
     } elseif (isset($GLOBALS['TSFE'])) {
         // No PID column - we can do a best-effort to clear the cache of the current page if in FE
         $storagePage = $GLOBALS['TSFE']->id;
         $pageIdsToClear[] = $storagePage;
     }
     if ($storagePage === NULL) {
         return;
     }
     if (!isset($this->pageTSConfigCache[$storagePage])) {
         $this->pageTSConfigCache[$storagePage] = BackendUtility::getPagesTSconfig($storagePage);
     }
     if (isset($this->pageTSConfigCache[$storagePage]['TCEMAIN.']['clearCacheCmd'])) {
         $clearCacheCommands = \TYPO3\CMS\Core\Utility\GeneralUtility::trimExplode(',', strtolower($this->pageTSConfigCache[$storagePage]['TCEMAIN.']['clearCacheCmd']), TRUE);
         $clearCacheCommands = array_unique($clearCacheCommands);
         foreach ($clearCacheCommands as $clearCacheCommand) {
             if (\TYPO3\CMS\Core\Utility\MathUtility::canBeInterpretedAsInteger($clearCacheCommand)) {
                 $pageIdsToClear[] = $clearCacheCommand;
             }
         }
     }
     foreach ($pageIdsToClear as $pageIdToClear) {
         $this->cacheService->getPageIdStack()->push($pageIdToClear);
     }
 }

 /**
  * Builds the page ID checking statement
  *
  * @param string $tableName The database table name
  * @param array &$sql The query parts
  * @param array $storagePageIds list of storage page ids
  * @throws \TYPO3\CMS\Extbase\Persistence\Generic\Exception\InconsistentQuerySettingsException
  * @return void
  */
 protected function addPageIdStatement($tableName, array &$sql, array $storagePageIds)
 {
     $tableColumns = $this->tableColumnCache->get($tableName);
     if ($tableColumns === FALSE) {
         $tableColumns = $this->databaseHandle->admin_get_fields($tableName);
         $this->tableColumnCache->set($tableName, $tableColumns);
     }
     if (is_array($GLOBALS['TCA'][$tableName]['ctrl']) && array_key_exists('pid', $tableColumns)) {
         $rootLevel = (int) $GLOBALS['TCA'][$tableName]['ctrl']['rootLevel'];
         if ($rootLevel) {
             if ($rootLevel === 1) {
                 $sql['additionalWhereClause'][] = $tableName . '.pid = 0';
             }
         } else {
             if (empty($storagePageIds)) {
                 throw new \TYPO3\CMS\Extbase\Persistence\Generic\Exception\InconsistentQuerySettingsException('Missing storage page ids.', 1365779762);
             }
             $sql['additionalWhereClause'][] = $tableName . '.pid IN (' . implode(', ', $storagePageIds) . ')';
         }
     }
 }

 /**
  * Builds the page ID checking statement
  *
  * @param string $tableName The database table name
  * @param string $tableAlias The table alias used in the query.
  * @param array $storagePageIds list of storage page ids
  * @throws InconsistentQuerySettingsException
  * @return string
  */
 protected function getPageIdStatement($tableName, $tableAlias, array $storagePageIds)
 {
     $pageIdStatement = '';
     $tableColumns = $this->tableColumnCache->get($tableName);
     if ($tableColumns === false) {
         $tableColumns = $this->databaseHandle->admin_get_fields($tableName);
         $this->tableColumnCache->set($tableName, $tableColumns);
     }
     if (is_array($GLOBALS['TCA'][$tableName]['ctrl']) && array_key_exists('pid', $tableColumns)) {
         $rootLevel = (int) $GLOBALS['TCA'][$tableName]['ctrl']['rootLevel'];
         switch ($rootLevel) {
             // Only in pid 0
             case 1:
                 return $tableAlias . '.pid = 0';
                 // Pid 0 and pagetree
             // Pid 0 and pagetree
             case -1:
                 if (empty($storagePageIds)) {
                     return $tableAlias . '.pid = 0';
                 }
                 $storagePageIds[] = 0;
                 break;
                 // Only pagetree or not set
             // Only pagetree or not set
             case 0:
                 if (empty($storagePageIds)) {
                     throw new InconsistentQuerySettingsException('Missing storage page ids.', 1365779762);
                 }
                 break;
                 // Invalid configuration
             // Invalid configuration
             default:
                 return '';
         }
         $pageIdStatement = $tableAlias . '.pid IN (' . implode(',', $this->databaseHandle->cleanIntArray($storagePageIds)) . ')';
     }
     return $pageIdStatement;
 }

 /**
  * Check if seo_basics was installed and then transfer the properties from pages and pages_language_overlay
  *
  * @return void
  */
 protected function migrateFromSeoBasics()
 {
     // check if seo_basics fields exists
     $metaseoTableFields = $this->databaseConnection->admin_get_fields('pages');
     if (!array_key_exists('tx_seo_titletag', $metaseoTableFields)) {
         $status = FlashMessage::NOTICE;
         $title = 'seo_basics not found';
         $message = 'No seo_basics properties, so no update needed';
         $this->messageArray[] = [$status, $title, $message];
         return;
     }
     // migrate pages
     $fieldsToMigrate = ['tx_seo_titletag' => 'tx_csseo_title', 'tx_seo_canonicaltag' => 'tx_csseo_canonical'];
     $this->migrateFields($fieldsToMigrate, 'pages');
     $this->migrateFields($fieldsToMigrate, 'pages_language_overlay');
     /**
      * Finished migration from seo_basics
      */
     $message = 'Title and Canonical are migrated. Run <strong>DB compare</strong> in the install tool to remove the fields from metaseo and run the <strong>DB check</strong> to update the reference index.';
     $status = FlashMessage::OK;
     $title = 'Migrated all seo_basics fields!';
     $this->messageArray[] = [$status, $title, $message];
 }

 /**
  * Init Function: here all the needed configuration values are stored in class variables..
  */
 function init()
 {
     $this->db = $GLOBALS['TYPO3_DB'];
     $this->tsfe = $GLOBALS['TSFE'];
     $this->pi_loadLL();
     // Loading language-labels
     $this->pi_setPiVarDefaults();
     // Set default piVars from TS
     $this->SIM_ACCESS_TIME = $GLOBALS['SIM_ACCESS_TIME'];
     // fallback for TYPO3 < 4.2
     if (!$this->SIM_ACCESS_TIME) {
         $simTime = $GLOBALS['SIM_EXEC_TIME'];
         $this->SIM_ACCESS_TIME = $simTime - $simTime % 60;
     }
     $this->initCaching();
     $this->local_cObj = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('TYPO3\\CMS\\Frontend\\ContentObject\\ContentObjectRenderer');
     // Local cObj.
     $this->enableFields = $this->getEnableFields('tt_news');
     if ($this->tt_news_uid === 0) {
         // no tt_news_uid set by displayCurrentRecord
         $this->tt_news_uid = intval($this->piVars['tt_news']);
         // Get the submitted uid of a news (if any)
     }
     if (!isset($this->conf['compatVersion']) || !preg_match('/^\\d+\\.\\d+\\.\\d+$/', $this->conf['compatVersion'])) {
         $this->conf['compatVersion'] = $this->hObj->getCurrentVersion();
     }
     $this->token = md5(microtime());
     if (TYPO3\CMS\Core\Utility\ExtensionManagementUtility::isLoaded('version')) {
         $this->versioningEnabled = true;
     }
     // load available syslanguages
     $this->initLanguages();
     // sys_language_mode defines what to do if the requested translation is not found
     $this->sys_language_mode = $this->conf['sys_language_mode'] ? $this->conf['sys_language_mode'] : $this->tsfe->sys_language_mode;
     if ($this->conf['searchFieldList']) {
         // get fieldnames from the tt_news db-table
         $this->fieldNames = array_keys($this->db->admin_get_fields('tt_news'));
         $searchFieldList = $this->hObj->validateFields($this->conf['searchFieldList'], $this->fieldNames);
         if ($searchFieldList) {
             $this->searchFieldList = $searchFieldList;
         }
     }
     // Archive:
     $archiveMode = trim($this->conf['archiveMode']);
     // month, quarter or year listing in AMENU
     $this->config['archiveMode'] = $archiveMode ? $archiveMode : 'month';
     // arcExclusive : -1=only non-archived; 0=don't care; 1=only archived
     $arcExclusive = $this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'archive', 'sDEF');
     $this->arcExclusive = $arcExclusive ? $arcExclusive : intval($this->conf['archive']);
     $this->config['datetimeDaysToArchive'] = intval($this->conf['datetimeDaysToArchive']);
     $this->config['datetimeHoursToArchive'] = intval($this->conf['datetimeHoursToArchive']);
     $this->config['datetimeMinutesToArchive'] = intval($this->conf['datetimeMinutesToArchive']);
     if ($this->conf['useHRDates']) {
         $this->hObj->convertDates();
     }
     // list of pages where news records will be taken from
     if (!$this->conf['dontUsePidList']) {
         $this->initPidList();
     }
     // itemLinkTarget is only used for categoryLinkMode 3 (catselector) in framesets
     $this->conf['itemLinkTarget'] = trim($this->conf['itemLinkTarget']);
     // id of the page where the search results should be displayed
     $this->config['searchPid'] = intval($this->conf['searchPid']);
     // pages in Single view will be divided by this token
     $this->config['pageBreakToken'] = trim($this->conf['pageBreakToken']) ? trim($this->conf['pageBreakToken']) : '<---newpage--->';
     $this->config['singleViewPointerName'] = trim($this->conf['singleViewPointerName']) ? trim($this->conf['singleViewPointerName']) : 'sViewPointer';
     $maxWordsInSingleView = intval($this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'maxWordsInSingleView', 's_misc'));
     $maxWordsInSingleView = $maxWordsInSingleView ? $maxWordsInSingleView : intval($this->conf['maxWordsInSingleView']);
     $this->config['maxWordsInSingleView'] = $maxWordsInSingleView ? $maxWordsInSingleView : 0;
     $this->config['useMultiPageSingleView'] = $this->conf['useMultiPageSingleView'];
     // pid of the page with the single view. the old var PIDitemDisplay is still processed if no other value is found
     $singlePid = $this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'PIDitemDisplay', 's_misc');
     $this->config['singlePid'] = $singlePid ? $singlePid : intval($this->cObj->stdWrap($this->conf['singlePid'], $this->conf['singlePid.']));
     if (!$this->config['singlePid']) {
         $this->errors[] = 'No singlePid defined';
     }
     // pid to return to when leaving single view
     $backPid = intval($this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'backPid', 's_misc'));
     $backPid = $backPid ? $backPid : intval($this->conf['backPid']);
     $backPid = $backPid ? $backPid : intval($this->piVars['backPid']);
     $backPid = $backPid ? $backPid : $this->tsfe->id;
     $this->config['backPid'] = $backPid;
     // max items per page
     $FFlimit = \TYPO3\CMS\Core\Utility\MathUtility::forceIntegerInRange($this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'listLimit', 's_template'), 0, 1000);
     $limit = \TYPO3\CMS\Core\Utility\MathUtility::forceIntegerInRange($this->cObj->stdWrap($this->conf['limit'], $this->conf['limit.']), 0, 1000);
     $limit = $limit ? $limit : 50;
     $this->config['limit'] = $FFlimit ? $FFlimit : $limit;
     $latestLimit = \TYPO3\CMS\Core\Utility\MathUtility::forceIntegerInRange($this->cObj->stdWrap($this->conf['latestLimit'], $this->conf['latestLimit.']), 0, 1000);
     $latestLimit = $latestLimit ? $latestLimit : 10;
     $this->config['latestLimit'] = $FFlimit ? $FFlimit : $latestLimit;
     // orderBy and groupBy statements for the list Query
     $orderBy = $this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'listOrderBy', 'sDEF');
     $orderByTS = trim($this->conf['listOrderBy']);
     $orderBy = $orderBy ? $orderBy : $orderByTS;
     $this->config['orderBy'] = $orderBy;
     if ($orderBy) {
         $ascDesc = $this->pi_getFFvalue($this->cObj->data['pi_flexform'], 'ascDesc', 'sDEF');
//.........这里部分代码省略.........

 /**
  * Tests if a given table contains a given field.
  *
  * @param string $tablename Table name for which to check whether a given field exists in
  * @param string $fieldname Field name for which to check whether it exists in the given table
  * @param array $info Additional info, will be displayed as debug message, if a key "message" exists this will be appended to the error message
  */
 public static function tableAndFieldExist($tablename, $fieldname, $info = array())
 {
     self::initializeDbObj();
     return self::isArrayKey($fieldname, self::$dbObj->admin_get_fields($tablename), $info);
 }

 /**
  * Removes all array keys which cannot be persisted
  *
  * @param array $data
  *
  * @return array
  */
 protected function cleanUnavailableColumns(array $data)
 {
     return array_intersect_key($data, $this->databaseConnection->admin_get_fields($this->table));
 }

 /**
  * Checks if path cache table is ok.
  *
  * @return bool
  */
 protected function pathCacheNeedsUpdates()
 {
     $fields = $this->databaseConnection->admin_get_fields('tx_realurl_pathcache');
     return isset($fields['cache_id']) || !isset($fields['uid']) || stripos($fields['uid']['Extra'], 'auto_increment') === false;
 }

 /**
  * @param string $table
  * @return array
  */
 protected function fields($table)
 {
     return array_keys($this->db->admin_get_fields($table));
 }