PHP Класс Spot\Adapter\Sqlite

См. ссылку: http://spot.os.ly

Наследование: extends Spot\Adapter\PDO\BaseAbstract, implements Spot\Adapter\AdapterInterface

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

Свойство	Тип	Описание
$_charset		not supported
$_collate		only UTF_8 supported
$_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

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

Метод	Описание
connection ( ) : object	Get database connection
escapeField ( $field )	Escape/quote direct user input
migrate ( String $table, array $fields, array $options = [] )	Migrate table structure changes to database
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
truncateDatasource ( $datasource )	Truncate a database table Should delete all rows and reset serial/auto_increment keys to 0

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

Метод	Описание
getColumnsForTable ( String $table, string $source ) : Array	Get columns for current table
shouldUpdateMigrateField ( $formattedField, $columnInfo )

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

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

Get database connection

public connection ( ) : object
Результат	object	PDO

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

Escape/quote direct user input

public escapeField ( $field )

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

Get columns for current table

protected getColumnsForTable ( String $table, string $source ) : Array
$table	String	Table name
$source	string
Результат	Array

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

Migrate table structure changes to database

public migrate ( String $table, array $fields, array $options = [] )
$table	String	Table name
$fields	array	Fields and their attributes as defined in the mapper
$options	array	Options that may affect migrations or how tables are setup

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

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
Результат	string	SQL syntax

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

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
Результат	string	SQL syntax

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

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
Результат	string	SQL syntax

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

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
Результат	string	SQL syntax

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

protected shouldUpdateMigrateField ( $formattedField, $columnInfo )

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

Truncate a database table Should delete all rows and reset serial/auto_increment keys to 0

public truncateDatasource ( $datasource )

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

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

not supported

protected $_charset

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

only UTF_8 supported

protected $_collate

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

Driver-Specific settings

protected $_engine

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

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

protected $_fieldTypeMap

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

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

protected $_format_date

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

protected $_format_datetime

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

protected $_format_time