PHP Класс Spot\Adapter\Mysql

См. ссылку: http://spot.os.ly

Наследование: extends Spot\Adapter\PDO\BaseAbstract, implements Spot\Adapter\AdapterInterface

Защищенные свойства (Protected)

Свойство	Тип	Описание
$_charset
$_collate
$_engine		Driver-Specific settings
$_fieldTypeMap		@todo Have to improve this to allow custom types, callbacks, and validation
$_format_date		Format for date columns, formatted for PHP's date() function
$_format_datetime
$_format_time

Открытые методы

Метод	Описание
characterSet ( $charset, $collate = 'utf8_unicode_ci' )	Set character set and MySQL collate string
engine ( $engine = null )	Set database engine (InnoDB, MyISAM, etc)
escapeField ( $field )	Escape/quote direct user input
formatMigrateOptions ( array $options )	Ensure migration options are full and have all keys required
migrateSyntaxFieldCreate ( string $fieldName, array $fieldInfo ) : string	Syntax for each column in CREATE TABLE command
migrateSyntaxFieldUpdate ( string $fieldName, array $fieldInfo, $add = false ) : string	Syntax for each column in CREATE TABLE command
migrateSyntaxTableCreate ( string $table, array $formattedFields, array $columnsSyntax, array $options ) : string	Syntax for CREATE TABLE with given fields and column syntax
migrateSyntaxTableUpdate ( string $table, array $formattedFields, array $columnsSyntax, array $options ) : string	Syntax for ALTER TABLE with given fields and column syntax

Защищенные методы

Метод	Описание
getColumnsForTable ( String $table, $source ) : Array	Get columns for current table

Описание методов

characterSet() публичный Метод

Set character set and MySQL collate string

public characterSet ( $charset, $collate = 'utf8_unicode_ci' )

engine() публичный Метод

Set database engine (InnoDB, MyISAM, etc)

public engine ( $engine = null )

escapeField() публичный Метод

Escape/quote direct user input

public escapeField ( $field )

formatMigrateOptions() публичный Метод

Ensure migration options are full and have all keys required

public formatMigrateOptions ( array $options )
$options	array

getColumnsForTable() защищенный Метод

Get columns for current table

protected getColumnsForTable ( String $table, $source ) : Array
$table	String	Table name
Результат	Array

migrateSyntaxFieldCreate() публичный Метод

Syntax for each column in CREATE TABLE command

public migrateSyntaxFieldCreate ( string $fieldName, array $fieldInfo ) : string
$fieldName	string	Field name
$fieldInfo	array	Array of field settings
Результат	string	SQL syntax

migrateSyntaxFieldUpdate() публичный Метод

Syntax for each column in CREATE TABLE command

public migrateSyntaxFieldUpdate ( string $fieldName, array $fieldInfo, $add = false ) : string
$fieldName	string	Field name
$fieldInfo	array	Array of field settings
Результат	string	SQL syntax

migrateSyntaxTableCreate() публичный Метод

Syntax for CREATE TABLE with given fields and column syntax

public migrateSyntaxTableCreate ( string $table, array $formattedFields, array $columnsSyntax, array $options ) : string
$table	string	Table name
$formattedFields	array	Array of fields with all settings
$columnsSyntax	array	Array of SQL syntax of columns produced by 'migrateSyntaxFieldCreate' function
$options	array	Options that may affect migrations or how tables are setup
Результат	string	SQL syntax

migrateSyntaxTableUpdate() публичный Метод

Syntax for ALTER TABLE with given fields and column syntax

public migrateSyntaxTableUpdate ( string $table, array $formattedFields, array $columnsSyntax, array $options ) : string
$table	string	Table name
$formattedFields	array	Array of fields with all settings
$columnsSyntax	array	Array of SQL syntax of columns produced by 'migrateSyntaxFieldUpdate' function
$options	array
Результат	string	SQL syntax

Описание свойств

$_charset защищенное свойство

protected $_charset

$_collate защищенное свойство

protected $_collate

$_engine защищенное свойство

Driver-Specific settings

protected $_engine

$_fieldTypeMap защищенное свойство

@todo Have to improve this to allow custom types, callbacks, and validation

protected $_fieldTypeMap

$_format_date защищенное свойство

Format for date columns, formatted for PHP's date() function

protected $_format_date

$_format_datetime защищенное свойство

protected $_format_datetime

$_format_time защищенное свойство

protected $_format_time