TYPO3\CMS\Core\Database\Schema\SqlReader Class Reference

Public Member Functions
	__construct (Dispatcher $signalSlotDispatcher=null, PackageManager $packageManager=null)
string	getTablesDefinitionString (bool $withStatic=false)
array	getStatementArray (string $dumpContent, string $queryRegex=null)
array	getInsertStatementArray (string $dumpContent)
array	getCreateTableStatementArray (string $dumpContent)

Protected Member Functions
array	emitTablesDefinitionIsBeingBuiltSignal (array $sqlString)

Protected Attributes
Dispatcher	$signalSlotDispatcher
PackageManager	$packageManager

Detailed Description

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

Definition at line 28 of file SqlReader.php.

Constructor & Destructor Documentation

__construct()

TYPO3\CMS\Core\Database\Schema\SqlReader::__construct	(	Dispatcher	$signalSlotDispatcher = null,
		PackageManager	$packageManager = null
	)

Parameters

Dispatcher	$signalSlotDispatcher
PackageManager	$packageManager

Exceptions

Definition at line 43 of file SqlReader.php.

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

Member Function Documentation

emitTablesDefinitionIsBeingBuiltSignal()

array TYPO3\CMS\Core\Database\Schema\SqlReader::emitTablesDefinitionIsBeingBuiltSignal ( array  $sqlString )

protected

Emits a signal to manipulate the tables definitions

Parameters

array

$sqlString

Returns

‪array

Exceptions

Definition at line 156 of file SqlReader.php.

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

getCreateTableStatementArray()

array TYPO3\CMS\Core\Database\Schema\SqlReader::getCreateTableStatementArray

(

string

$dumpContent

)

Extract only CREATE TABLE statements from SQL dump

Parameters

string

$dumpContent

Returns

‪array

Definition at line 142 of file SqlReader.php.

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

getInsertStatementArray()

array TYPO3\CMS\Core\Database\Schema\SqlReader::getInsertStatementArray

(

string

$dumpContent

)

Extract only INSERT statements from SQL dump

Parameters

string

$dumpContent

Returns

‪array

Definition at line 131 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 87 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

Exceptions

Definition at line 58 of file SqlReader.php.

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

Member Data Documentation

$packageManager

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

protected

Definition at line 36 of file SqlReader.php.

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

$signalSlotDispatcher

Dispatcher TYPO3\CMS\Core\Database\Schema\SqlReader::$signalSlotDispatcher

protected

Definition at line 32 of file SqlReader.php.

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