/**
* Gets the sql data dump for a specific sql file (for example ext_tables.sql)
*
* @param string $sqlFile
* @return string
*/
protected function getSqlDataDumpForFile($sqlFile)
{
$sqlData = '';
if (file_exists($sqlFile)) {
$sqlContent = \TYPO3\CMS\Core\Utility\GeneralUtility::getUrl($sqlFile);
$fieldDefinitions = $this->installToolSqlParser->getFieldDefinitions_fileContent($sqlContent);
$sqlData = $this->databaseUtility->dumpStaticTables($fieldDefinitions);
}
return $sqlData;
}
/**
* 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(PATH_t3lib . 'stddb/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;
}