PHP Class Spot\Adapter\Mysql

See link: http://spot.os.ly
Inheritance: extends Spot\Adapter\PDO\BaseAbstract, implements Spot\Adapter\AdapterInterface
Afficher le fichier Open project: vlucas/spot

Protected Properties

Свойство Type Description
$_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

Méthodes publiques

Méthode Description
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

Méthodes protégées

Méthode Description
getColumnsForTable ( String $table, $source ) : Array Get columns for current table

Method Details

characterSet() public méthode

Set character set and MySQL collate string
public characterSet ( $charset, $collate = 'utf8_unicode_ci' )

engine() public méthode

Set database engine (InnoDB, MyISAM, etc)
public engine ( $engine = null )

escapeField() public méthode

Escape/quote direct user input
public escapeField ( $field )

formatMigrateOptions() public méthode

Ensure migration options are full and have all keys required
public formatMigrateOptions ( array $options )
$options array

getColumnsForTable() protected méthode

Get columns for current table
protected getColumnsForTable ( String $table, $source ) : Array
$table String Table name
Résultat Array

migrateSyntaxFieldCreate() public méthode

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
Résultat string SQL syntax

migrateSyntaxFieldUpdate() public méthode

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
Résultat string SQL syntax

migrateSyntaxTableCreate() public méthode

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
Résultat string SQL syntax

migrateSyntaxTableUpdate() public méthode

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
Résultat string SQL syntax

Property Details

$_charset protected_oe property

protected $_charset

$_collate protected_oe property

protected $_collate

$_engine protected_oe property

Driver-Specific settings
protected $_engine

$_fieldTypeMap protected_oe property

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

$_format_date protected_oe property

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

$_format_datetime protected_oe property

protected $_format_datetime

$_format_time protected_oe property

protected $_format_time