| 프로퍼티 | 타입 | 설명 | |
|---|---|---|---|
| $_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 = [] ) : |
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. |
| 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 | |
| protected _buildColumn ( array $field ) : string | ||
| $field | array | A field array. |
| 리턴 | string | The SQL column string. |
|
protected _execute ( string $sql, array $options = [] ) : |
||
| $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). |
| 리턴 | Returns a result object if the query was successful. | |
| 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 |
| protected array $_metas | ||
| 리턴 | array | |
| protected array $_quotes | ||
| 리턴 | array | |