PHP 클래스 Zend_Db_Adapter_Pdo_Sqlite

상속: extends Zend_Db_Adapter_Pdo_Abstract
파일 보기 프로젝트 열기: kimai/kimai 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
$_numericDataTypes Values are: 0 = 32-bit integer 1 = 64-bit integer 2 = float or decimal
$_pdoType string PDO type

공개 메소드들

메소드 설명
__construct ( array $config = [] ) Constructor.
describeTable ( string $tableName, string $schemaName = null ) : array Returns the column descriptions for a table.
limit ( string $sql, integer $count, integer $offset ) : string Adds an adapter-specific LIMIT clause to the SELECT statement.
listTables ( ) : array Returns a list of the tables in the database.

보호된 메소드들

메소드 설명
_checkRequiredOptions ( array $config ) Check for config options that are mandatory.
_connect ( ) Special configuration for SQLite behavior: make sure that result sets contain keys like 'column' instead of 'table.column'.
_dsn ( ) DSN builder
_quote ( string $value ) : string Quote a raw string.

메소드 상세

__construct() 공개 메소드

$config is an array of key/value pairs containing configuration options. Note that the SQLite options are different than most of the other PDO adapters in that no username or password are needed. Also, an extra config key "sqlite2" specifies compatibility mode. dbname => (string) The name of the database to user (required, use :memory: for memory-based database) sqlite2 => (boolean) PDO_SQLITE defaults to SQLite 3. For compatibility with an older SQLite 2 database, set this to TRUE.
public __construct ( array $config = [] )
$config array An array of configuration keys.

_checkRequiredOptions() 보호된 메소드

Throw exceptions if any are missing.
protected _checkRequiredOptions ( array $config )
$config array

_connect() 보호된 메소드

Special configuration for SQLite behavior: make sure that result sets contain keys like 'column' instead of 'table.column'.
protected _connect ( )

_dsn() 보호된 메소드

DSN builder
protected _dsn ( )

_quote() 보호된 메소드

Quote a raw string.
protected _quote ( string $value ) : string
$value string Raw string
리턴 string Quoted string

describeTable() 공개 메소드

The return value is an associative array keyed by the column name, as returned by the RDBMS. The value of each array element is an associative array with the following keys: SCHEMA_NAME => string; name of database or schema TABLE_NAME => string; COLUMN_NAME => string; column name COLUMN_POSITION => number; ordinal position of column in table DATA_TYPE => string; SQL datatype name of column DEFAULT => string; default expression of column, null if none NULLABLE => boolean; true if column can have nulls LENGTH => number; length of CHAR/VARCHAR SCALE => number; scale of NUMERIC/DECIMAL PRECISION => number; precision of NUMERIC/DECIMAL UNSIGNED => boolean; unsigned property of an integer type PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key IDENTITY => integer; true if column is auto-generated with unique values
public describeTable ( string $tableName, string $schemaName = null ) : array
$tableName string
$schemaName string OPTIONAL
리턴 array

limit() 공개 메소드

Adds an adapter-specific LIMIT clause to the SELECT statement.
public limit ( string $sql, integer $count, integer $offset ) : string
$sql string
$count integer
$offset integer OPTIONAL
리턴 string

listTables() 공개 메소드

Returns a list of the tables in the database.
public listTables ( ) : array
리턴 array

프로퍼티 상세

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

Values are: 0 = 32-bit integer 1 = 64-bit integer 2 = float or decimal
protected $_numericDataTypes

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

PDO type
protected string $_pdoType
리턴 string