Orpheus

SqlGeneratorMySql
in package
implements SqlGenerator

The SqlGeneratorMySql class

Use this class to generate entity's table SQL queries and check changes in structure

Table of Contents

Interfaces

SqlGenerator
The Sql interface

Methods

getColumnDefinition()  : string
Get column definition
getColumnInfosFromField()  : array<string|int, mixed>
Get column information from $field
getCreate()  : string
Get create SQL query
getDrop()  : string
getIncrementalChanges()  : string|null
Get changes with entity
getIndexDefinition()  : string
Get index definition
formatHTML_ColumnType()  : string
Format column type into HTML
formatHTML_Command()  : string
Format command into HTML
formatHTML_Identifier()  : string
Format identifier into HTML
formatHTML_InlineBlock()  : string
Format inline block
formatHTML_ReservedWord()  : string
Format reserved word into HTML
formatHTML_SubCommand()  : string
Format subcommand into HTML

Methods

getColumnDefinition()

Get column definition

public getColumnDefinition(array<string|int, mixed> $fieldColumn, AbstractSqlAdapter $sqlAdapter[, bool $withPK = true ]) : string
Parameters
$fieldColumn : array<string|int, mixed>
$sqlAdapter : AbstractSqlAdapter
$withPK : bool = true
Return values
string

getColumnInfosFromField()

Get column information from $field

public getColumnInfosFromField(FieldDescriptor $field) : array<string|int, mixed>
Parameters
$field : FieldDescriptor
Tags
throws
Exception
Return values
array<string|int, mixed>

formatHTML_ColumnType()

Format column type into HTML

protected formatHTML_ColumnType(string $string) : string
Parameters
$string : string
Return values
string

formatHTML_Command()

Format command into HTML

protected formatHTML_Command(string $string) : string
Parameters
$string : string
Return values
string

formatHTML_InlineBlock()

Format inline block

protected formatHTML_InlineBlock(string $string, string $class) : string
Parameters
$string : string
$class : string
Return values
string

formatHTML_ReservedWord()

Format reserved word into HTML

protected formatHTML_ReservedWord(string $string[, string $class = '' ]) : string
Parameters
$string : string
$class : string = ''
Return values
string

formatHTML_SubCommand()

Format subcommand into HTML

protected formatHTML_SubCommand(string $string) : string
Parameters
$string : string
Return values
string 

							

							
						

					

					
					
				
				

			

			

				
				

					On this page
					
					
				

			
			

		

		

			

				

					
Search results