PHP 클래스 lithium\data\source\database\adapter\Sqlite3

상속: extends lithium\data\source\Database
파일 보기 프로젝트 열기: unionofrad/lithium 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
$_columns array Sqlite3 column type definitions.
$_constraints array Column contraints
$_metas array Column specific metas used on table creating By default 'quote' is false and 'join' is ' '
$_quotes array Pair of opening and closing quote characters used for quoting identifiers in queries.
$_regex array Holds commonly regular expressions used in this class.

공개 메소드들

메소드 설명
__construct ( array $config = [] ) : void Constructor.
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 Sqlite3 table.
disconnect ( ) : boolean Disconnects the adapter from the database.
enabled ( string $feature = null ) : boolean Check for required PHP extension, or supported database feature.
encoding ( string $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.

보호된 메소드들

메소드 설명
_buildColumn ( array $field ) : string Helper for Database::column().
_column ( string $real ) : string Converts database-layer column types to basic types.
_execute ( string $sql, array $options = [] ) : Result Execute a given query.
_insertId ( object $query ) : mixed Gets the last auto-generated ID from the query that inserted a new record.

메소드 상세

__construct() 공개 메소드

Constructor.
또한 보기: 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. - `'database'` _string_: Defaults to in-memory database `':memory:'`.
리턴 void

_buildColumn() 보호된 메소드

Helper for Database::column().
또한 보기: lithium\data\Database::column()
protected _buildColumn ( array $field ) : string
$field array A field array.
리턴 string SQL column string.

_column() 보호된 메소드

Converts database-layer column types to basic types.
protected _column ( string $real ) : string
$real string Real database-layer column type (i.e. "varchar(255)")
리턴 string Abstract column type (i.e. "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 No available options.
리턴 lithium\data\source\Result Returns a result object if the query was successful.

_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.

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() 공개 메소드

A column type may not always be available, i.e. when during creation of the column no type was declared. Those columns are internally treated by SQLite3 as having a NONE affinity. The final schema will contain no information about type and length of such columns (both values will be null).
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

disconnect() 공개 메소드

Disconnects the adapter from the database.
public disconnect ( ) : boolean
리턴 boolean True on success, else false.

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'`.
리턴 boolean Returns `true` if the particular feature (or if Sqlite) support is enabled, otherwise `false`.

encoding() 공개 메소드

Gets or sets the encoding for the connection.
public encoding ( string $encoding = null ) : mixed
$encoding string If setting the encoding, this is the name of the encoding to set, i.e. `'utf8'` or `'UTF-8'` (both formats are valid).
리턴 mixed If setting the encoding; returns `true` on success, or `false` on failure. When getting, returns the encoding as a string.

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 objects to which models can connect.

프로퍼티 상세

$_columns 보호되어 있는 프로퍼티

Sqlite3 column type definitions.
protected array $_columns
리턴 array

$_constraints 보호되어 있는 프로퍼티

Column contraints
protected array $_constraints
리턴 array

$_metas 보호되어 있는 프로퍼티

Column specific metas used on table creating By default 'quote' is false and 'join' is ' '
protected array $_metas
리턴 array

$_quotes 보호되어 있는 프로퍼티

Pair of opening and closing quote characters used for quoting identifiers in queries.
링크 보기: http://www.sqlite.org/lang_keywords.html
protected array $_quotes
리턴 array

$_regex 보호되어 있는 프로퍼티

Holds commonly regular expressions used in this class.
또한 보기: lithium\data\source\database\adapter\Sqlite3::describe()
또한 보기: lithium\data\source\database\adapter\Sqlite3::_column()
protected array $_regex
리턴 array