Public Member Functions
	__construct (EventDispatcherInterface $eventDispatcher, PackageManager $packageManager)

string	getTablesDefinitionString (bool $withStatic=false)

array	getStatementArray (string $dumpContent, string $queryRegex=null)

	getInsertStatementArray (string $dumpContent)

	getCreateTableStatementArray (string $dumpContent)

Protected Attributes
EventDispatcherInterface	$eventDispatcher

PackageManager	$packageManager

Detailed Description

Helper methods to handle raw SQL input and transform it into individual statements for further processing.

not part of public core API.

Definition at line 30 of file SqlReader.php.

Constructor & Destructor Documentation

◆ __construct()

TYPO3\CMS\Core\Database\Schema\SqlReader::__construct	(	EventDispatcherInterface	$eventDispatcher,
		PackageManager	$packageManager
	)

Exceptions

Definition at line 43 of file SqlReader.php.

References TYPO3\CMS\Core\Database\Schema\SqlReader\$eventDispatcher, and TYPO3\CMS\Core\Database\Schema\SqlReader\$packageManager.

Member Function Documentation

◆ getCreateTableStatementArray()

TYPO3\CMS\Core\Database\Schema\SqlReader::getCreateTableStatementArray ( string $dumpContent )

Extract only CREATE TABLE statements from SQL dump

Definition at line 138 of file SqlReader.php.

References TYPO3\CMS\Core\Database\Schema\SqlReader\getStatementArray().

◆ getInsertStatementArray()

TYPO3\CMS\Core\Database\Schema\SqlReader::getInsertStatementArray ( string $dumpContent )

Extract only INSERT statements from SQL dump

Definition at line 130 of file SqlReader.php.

References TYPO3\CMS\Core\Database\Schema\SqlReader\getStatementArray().

◆ getStatementArray()

array TYPO3\CMS\Core\Database\Schema\SqlReader::getStatementArray	(	string	$dumpContent,
		string	$queryRegex = `null`
	)

Returns an array where every entry is a single SQL-statement. Input must be formatted like an ordinary MySQL dump file. Every statements needs to be terminated by a ';' and there may only be one statement (or partial statement) per line.

Parameters

string	$dumpContent	‪The SQL dump content.
string	$queryRegex	‪Regex to select which statements to return.

Returns: ‪array Array of SQL statements

Definition at line 85 of file SqlReader.php.

Referenced by TYPO3\CMS\Core\Database\Schema\SqlReader\getCreateTableStatementArray(), and TYPO3\CMS\Core\Database\Schema\SqlReader\getInsertStatementArray().

◆ getTablesDefinitionString()

string TYPO3\CMS\Core\Database\Schema\SqlReader::getTablesDefinitionString ( bool $withStatic = false )

Cycle through all loaded extensions and get full table definitions as concatenated string

Parameters

bool $withStatic ‪TRUE if sql from ext_tables_static+adt.sql should be loaded, too.

Returns: ‪string Concatenated SQL of loaded extensions ext_tables.sql

Definition at line 55 of file SqlReader.php.

Member Data Documentation

◆ $eventDispatcher

EventDispatcherInterface TYPO3\CMS\Core\Database\Schema\SqlReader::$eventDispatcher

protected

Definition at line 34 of file SqlReader.php.

Referenced by TYPO3\CMS\Core\Database\Schema\SqlReader\__construct().

◆ $packageManager

PackageManager TYPO3\CMS\Core\Database\Schema\SqlReader::$packageManager