1. class
  2. Illuminate
  3. \
  4. Database
  5. \
  6. Query
  7. \
  8. Processors
  9. \
  10. MySqlProcessor

MySqlProcessor

class MySqlProcessor extends Processor (View source)

Methods

array
processSelect(Builder $query, array $results)

Process the results of a "select" query.

from  Processor
int
processInsertGetId(Builder $query, string $sql, array $values, string|null $sequence = null)

Process an "insert get ID" query.

list<array{name: string, path: string|null, default: bool}>
processSchemas(list<array<string, mixed>> $results)

Process the results of a schemas query.

from  Processor
list<array{name: string, schema: string|null, schema_qualified_name: string, size: int|null, comment: string|null, collation: string|null, engine: string|null}>
processTables(list<array<string, mixed>> $results)

Process the results of a tables query.

from  Processor
list<array{name: string, schema: string|null, schema_qualified_name: string, definition: string}>
processViews(list<array<string, mixed>> $results)

Process the results of a views query.

from  Processor
list<array{name: string, schema: string, schema_qualified_name: string, type: string, category: string, implicit: bool}>
processTypes(list<array<string, mixed>> $results)

Process the results of a types query.

from  Processor
list<array{name: string, type: string, type_name: string, collation: string|null, nullable: bool, default: mixed, auto_increment: bool, comment: string|null, generation: array{type: string|null, expression: string|null}|null}>
processColumns(list<array<string, mixed>> $results)

No description

list<array{name: string, columns: list<string>, type: string|null, unique: bool, primary: bool}>
processIndexes(list<array<string, mixed>> $results)

No description

list<array{name: string|null, columns: list<string>, foreign_schema: string|null, foreign_table: string, foreign_columns: list<string>, on_update: string|null, on_delete: string|null}>
processForeignKeys(list<array<string, mixed>> $results)

No description

array
processColumnListing(array $results) deprecated

Process the results of a column listing query.

Details

in Processor at line 16
array processSelect(Builder $query, array $results)

Process the results of a "select" query.

Parameters

Builder $query
array $results

Return Value

array

at line 33
int processInsertGetId(Builder $query, string $sql, array $values, string|null $sequence = null)

Process an "insert get ID" query.

Parameters

Builder $query
string $sql
array $values
string|null $sequence

Return Value

int

in Processor at line 45
list<array{name: string, path: string|null, default: bool}> processSchemas(list<array<string, mixed>> $results)

Process the results of a schemas query.

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, path: string|null, default: bool}>

in Processor at line 64
list<array{name: string, schema: string|null, schema_qualified_name: string, size: int|null, comment: string|null, collation: string|null, engine: string|null}> processTables(list<array<string, mixed>> $results)

Process the results of a tables query.

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, schema: string|null, schema_qualified_name: string, size: int|null, comment: string|null, collation: string|null, engine: string|null}>

in Processor at line 87
list<array{name: string, schema: string|null, schema_qualified_name: string, definition: string}> processViews(list<array<string, mixed>> $results)

Process the results of a views query.

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, schema: string|null, schema_qualified_name: string, definition: string}>

in Processor at line 107
list<array{name: string, schema: string, schema_qualified_name: string, type: string, category: string, implicit: bool}> processTypes(list<array<string, mixed>> $results)

Process the results of a types query.

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, schema: string, schema_qualified_name: string, type: string, category: string, implicit: bool}>

at line 43
list<array{name: string, type: string, type_name: string, collation: string|null, nullable: bool, default: mixed, auto_increment: bool, comment: string|null, generation: array{type: string|null, expression: string|null}|null}> processColumns(list<array<string, mixed>> $results)

No description

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, type: string, type_name: string, collation: string|null, nullable: bool, default: mixed, auto_increment: bool, comment: string|null, generation: array{type: string|null, expression: string|null}|null}>

at line 70
list<array{name: string, columns: list<string>, type: string|null, unique: bool, primary: bool}> processIndexes(list<array<string, mixed>> $results)

No description

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string, columns: list<string>, type: string|null, unique: bool, primary: bool}>

at line 86
list<array{name: string|null, columns: list<string>, foreign_schema: string|null, foreign_table: string, foreign_columns: list<string>, on_update: string|null, on_delete: string|null}> processForeignKeys(list<array<string, mixed>> $results)

No description

Parameters

list<array<string, mixed>> $results

Return Value

list<array{name: string|null, columns: list<string>, foreign_schema: string|null, foreign_table: string, foreign_columns: list<string>, on_update: string|null, on_delete: string|null}>

at line 17
array processColumnListing(array $results) deprecated

deprecated Will be removed in a future Laravel version.

Process the results of a column listing query.

Parameters

array $results

Return Value

array

Laravel Cloud is the best place to deploy Laravel, Nuxt, Express, Hono, Node.js, Bun, Go, Flask, Python, and more, with dedicated infrastructure available on AWS through Laravel Private Cloud.