SqlReader

class \TYPO3\CMS\Core\Database\Schema\SqlReader

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

Attributes

#[Autoconfigure]
$public: true

Table of Contents

Properties

$eventDispatcher  : EventDispatcherInterface
$packageManager  : PackageManager

Methods

__construct()  : mixed
getCreateTableStatementArray()  : array
Extract only CREATE TABLE statements from SQL dump
getInsertStatementArray()  : array
Extract only INSERT statements from SQL dump
getStatementArray()  : array
Returns an array where every entry is a single SQL-statement.
getTablesDefinitionString()  : string
Cycle through all loaded extensions and get full table definitions as concatenated string

Properties

$eventDispatcher

protected EventDispatcherInterface $eventDispatcher

Methods

__construct()

public __construct(EventDispatcherInterface $eventDispatcher, PackageManager $packageManager) : mixed

Parameters

$eventDispatcher : EventDispatcherInterface
$packageManager : PackageManager

Tags

throws
InvalidArgumentException

getCreateTableStatementArray()

Extract only CREATE TABLE statements from SQL dump

public getCreateTableStatementArray(string $dumpContent) : array

Parameters

$dumpContent : string

Return values

array

getInsertStatementArray()

Extract only INSERT statements from SQL dump

public getInsertStatementArray(string $dumpContent) : array

Parameters

$dumpContent : string

Return values

array

getStatementArray()

Returns an array where every entry is a single SQL-statement.

public getStatementArray(string $dumpContent[, string|null $queryRegex = null ]) : array

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

$dumpContent : string

The SQL dump content.

$queryRegex : string|null = null

Regex to select which statements to return.

Return values

array —

Array of SQL statements

getTablesDefinitionString()

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

public getTablesDefinitionString([bool $withStatic = false ]) : string

Parameters

$withStatic : bool = false

TRUE if sql from ext_tables_static+adt.sql should be loaded, too.

Return values

string —

Concatenated SQL of loaded extensions ext_tables.sql

On this page