PHP Класс lithium\data\source\database\adapter\MySql

For more information on configuring the database connection, see the __construct() method.
См. также: lithium\data\source\database\adapter\MySql::__construct()
Наследование: extends lithium\data\source\Database
Показать файл Открыть проект Примеры использования класса

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

Свойство Тип Описание
$_columns array MySQL column type definitions.
$_constraints array Column contraints
$_metas array By default 'escape' is false and 'join' is ' '.
$_quotes array Pair of opening and closing quote characters used for quoting identifiers in queries.

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

Метод Описание
__construct ( array $config = [] ) : void Constructor. Constructs the MySQL adapter and sets the default port to 3306.
alias ( $alias, $context )
connect ( ) : boolean Connects to the database by constructing DSN string and creating a PDO intance using the parent class. Will set specific options on the connection as provided.
describe ( mixed $entity, array $fields = [], array $meta = [] ) : array Gets the column schema for a given MySQL table.
enabled ( string $feature = null ) : boolean Check for required PHP extension, or supported database feature.
encoding ( $encoding = null ) : mixed Gets or sets the encoding for the connection.
error ( ) : array Retrieves database error message and error code.
sources ( string $model = null ) : array Returns the list of tables in the currently-connected database.
value ( mixed $value, array $schema = [] ) : mixed Converts a given value into the proper type based on a given schema definition.

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

Метод Описание
_buildColumn ( array $field ) : string Helper for Database::column()
_column ( string $real ) : array Converts database-layer column types to basic types.
_dsn ( ) : string Builds DSN string.
_execute ( string $sql, array $options = [] ) : Result Execute a given query.
_init ( ) Initializer. Adds MySQL-specific operators to $_operators.
_insertId ( object $query ) : mixed Gets the last auto-generated ID from the query that inserted a new record.

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

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

Constructor. Constructs the MySQL adapter and sets the default port to 3306.
См. также: lithium\data\source\Database::__construct()
См. также: lithium\data\Source::__construct()
См. также: lithium\data\Connections::add()
public __construct ( array $config = [] ) : void
$config array The available configuration options are the following. Further options are inherited from the parent classes. Typically, these parameters are set in `Connections::add()`, when adding the adapter to the list of active connections. - `'host'` _string_: Defaults to `'localhost:3306'`.
Результат void

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

Helper for Database::column()
См. также: lithium\data\Database::column()
protected _buildColumn ( array $field ) : string
$field array A field array.
Результат string The SQL column string.

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

Converts database-layer column types to basic types.
protected _column ( string $real ) : array
$real string Real database-layer column type (i.e. `"varchar(255)"`)
Результат array Column type (i.e. "string") plus 'length' when appropriate.

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

Builds DSN string.
protected _dsn ( ) : string
Результат string

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

Execute a given query.
См. также: lithium\data\source\Database::renderCommand()
protected _execute ( string $sql, array $options = [] ) : Result
$sql string The sql string to execute
$options array Available options: - 'buffered': If set to `false` uses mysql_unbuffered_query which sends the SQL query query to MySQL without automatically fetching and buffering the result rows as `mysql_query()` does (for less memory usage).
Результат lithium\data\source\Result Returns a result object if the query was successful.

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

Initializer. Adds MySQL-specific operators to $_operators.
См. также: lithium\data\source\database\adapter\MySql::$_operators
См. также: lithium\data\source\Database::$_operators
protected _init ( )

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

Gets the last auto-generated ID from the query that inserted a new record.
protected _insertId ( object $query ) : mixed
$query object The `Query` object associated with the query which generated
Результат mixed Returns the last inserted ID key for an auto-increment column or a column bound to a sequence.

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

public alias ( $alias, $context )

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

Connects to the database by constructing DSN string and creating a PDO intance using the parent class. Will set specific options on the connection as provided.
public connect ( ) : boolean
Результат boolean Returns `true` if a database connection could be established, otherwise `false`.

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

Gets the column schema for a given MySQL table.
public describe ( mixed $entity, array $fields = [], array $meta = [] ) : array
$entity mixed Specifies the table name for which the schema should be returned, or the class name of the model object requesting the schema, in which case the model class will be queried for the correct table name.
$fields array Any schema data pre-defined by the model.
$meta array
Результат array Returns an associative array describing the given table's schema, where the array keys are the available fields, and the values are arrays describing each field, containing the following keys: - `'type'`: The field type name

enabled() публичный статический Метод

Check for required PHP extension, or supported database feature.
public static enabled ( string $feature = null ) : boolean
$feature string Test for support for a specific feature, i.e. `"transactions"` or `"arrays"`.
Результат boolean Returns `true` if the particular feature (or if MySQL) support is enabled, otherwise `false`.

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

Gets or sets the encoding for the connection.
public encoding ( $encoding = null ) : mixed
$encoding
Результат mixed If setting the encoding; returns true on success, else false. When getting, returns the encoding.

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

Retrieves database error message and error code.
public error ( ) : array
Результат array

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

Returns the list of tables in the currently-connected database.
public sources ( string $model = null ) : array
$model string The fully-name-spaced class name of the model object making the request.
Результат array Returns an array of sources to which models can connect.

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

Converts a given value into the proper type based on a given schema definition.
См. также: lithium\data\source\Database::schema()
public value ( mixed $value, array $schema = [] ) : mixed
$value mixed The value to be converted. Arrays will be recursively converted.
$schema array Formatted array from `lithium\data\source\Database::schema()`
Результат mixed Value with converted type.

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

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

MySQL column type definitions.
protected array $_columns
Результат array

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

Column contraints
protected array $_constraints
Результат array

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

By default 'escape' is false and 'join' is ' '.
protected array $_metas
Результат array

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

Pair of opening and closing quote characters used for quoting identifiers in queries.
protected array $_quotes
Результат array