xplo.re Medusa Core Framework 3.1
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Event
  • Todo
  • Download

Namespaces

  • Core
    • Authentication
      • Auto
        • Driver
      • Driver
    • Cache
      • Driver
    • Charset
      • Driver
    • Configuration
    • Controller
    • Converter
      • Driver
    • Decoder
      • Driver
    • Encoder
      • Driver
    • Env
      • Authentication
      • Locale
      • Proxy
      • Server
        • HTTP
        • Redirect
        • X
    • Exception
    • Exchange
      • Driver
    • Field
    • Filter
      • Driver
    • Formatter
      • Driver
        • coreuimarkup
          • Token
    • Hash
    • Loader
    • Locale
    • Log
      • Driver
    • Module
      • Dependency
        • Requirement
          • Core
          • PHP
      • Linkage
        • Driver
    • PDF
    • Plugin
    • Query
      • Driver
    • Server
      • Driver
    • Session
      • Driver
    • Set
    • Storage
      • Driver
      • Field
        • Element
    • Stream
      • Driver
    • String
    • Translation
      • Driver
      • Language
        • Driver
    • URI
      • Driver
    • Version
    • View
      • Driver
        • coreui
          • Control
            • Button
            • Table
          • Element
        • htmlbuilder
          • Tags
        • yui
          • Modules
  • None
  • PHP

Classes

  • mysql
  • mysql_Result
  • mysql_Result_Statement
  • mysql_Statement
  • odbc
  • odbc_Result
  • odbc_Statement
  • sqlite2
  • sqlite2_Result
  • sqlite2_Statement
  • sqlite3
  • sqlite3_Result
  • sqlite3_Statement

Class sqlite3_Statement

SQLite 3 prepared storage statement.

Core\Object implements Core\Chainable
Extended by Core\Set implements Core\Accessor
Extended by Core\Storage_Statement
Extended by Core\Storage\SQL_Statement
Extended by Core\Storage\Driver\sqlite3_Statement
Namespace: Core\Storage\Driver
Package: Core\Storage
Since: 3.1
Requires: PHP 5.3, SQLite 3
Version: 1.0
Located at Storage/Driver/sqlite3.inc.php

Methods summary

public
# __construct( Core\Storage $driver, Core\Storage\Accessor_Node $query, SQLite3 $db )

Parameters

$driver
Driver that created the prepared statement.
$query
Query to prepare.
$db
SQLite 3 database instance.

Throws

Core\Exception\Storage

Preparation of SQLite 3 query failed. Exception message contains details on the exception, including the query string.

Since

3.0

Overrides

Core\Storage_Statement::__construct
protected string
# _transform_Insert( string $destinationTableName, array $columns, array $values, Core\Storage\Accessor_Update $duplicateKeyUpdate = null )

Actual transformation of an INSERT statement.

Actual transformation of an INSERT statement.

Fixes missing support in SQLite 3 for ON DUPLICATE KEY UPDATE. This fix currently cannot handle update commands with update values different from the INSERT statement. In such a case a Core\Exception\Storage exception is thrown.

Parameters

$destinationTableName
Destination table name.
$columns
Array of column references.
$values
Array of values to insert, for each given column reference respectively.
$duplicateKeyUpdate

Optional associated update node to perform an update instead if a duplicate key was encountered.

Returns

string

Throws

Core\Exception\Storage

Since

3.1

Overrides

Core\Storage\SQL_Statement::_transform_Insert
protected string
# _transform_Core_Storage_Accessor_Now( Core\Storage\Accessor_Now $node )

Transforms node to an expression that represents the current timestamp at the back-end (with respect to timezone settings of the engine or connection).

Transforms node to an expression that represents the current timestamp at the back-end (with respect to timezone settings of the engine or connection).

SQLite does not have a NOW() function. Instead, the same result is obtained by the DATETIME('now') function that is returned instead.

Parameters

$node

Returns

string

Since

3.1

Overrides

Core\Storage\SQL_Statement::_transform_Core_Storage_Accessor_Now
protected string
# _transform_Identifier( string $name )

Escapes identifiers as required by the storage back-end.

Escapes identifiers as required by the storage back-end.

SQLite 3 identifiers use quotation marks.

Parameters

$name
Identifier to escape.

Returns

string
Escaped identifier string.

Since

3.1

Overrides

Core\Storage_Statement::_transform_Identifier

Methods inherited from Core\Storage\SQL_Statement

_tableReference(), _tableReferenceCount(), _tableReferencePop(), _tableReferencePush(), _transform_Conditional(), _transform_Core_Nothing(), _transform_Core_Storage_Accessor_Alias(), _transform_Core_Storage_Accessor_BitwiseAND(), _transform_Core_Storage_Accessor_BitwiseOR(), _transform_Core_Storage_Accessor_BitwiseXOR(), _transform_Core_Storage_Accessor_Call(), _transform_Core_Storage_Accessor_Conditional(), _transform_Core_Storage_Accessor_Conjunction(), _transform_Core_Storage_Accessor_Count(), _transform_Core_Storage_Accessor_Disjunction(), _transform_Core_Storage_Accessor_Eq(), _transform_Core_Storage_Accessor_Eraser(), _transform_Core_Storage_Accessor_GT(), _transform_Core_Storage_Accessor_GTE(), _transform_Core_Storage_Accessor_Grouping(), _transform_Core_Storage_Accessor_Insert(), _transform_Core_Storage_Accessor_Key(), _transform_Core_Storage_Accessor_LT(), _transform_Core_Storage_Accessor_LTE(), _transform_Core_Storage_Accessor_Limit(), _transform_Core_Storage_Accessor_Match(), _transform_Core_Storage_Accessor_NEq(), _transform_Core_Storage_Accessor_Not(), _transform_Core_Storage_Accessor_Ordering(), _transform_Core_Storage_Accessor_Reference(), _transform_Core_Storage_Accessor_Regexp(), _transform_Core_Storage_Accessor_Reverse(), _transform_Core_Storage_Accessor_Selector(), _transform_Core_Storage_Accessor_Similarity(), _transform_Core_Storage_Accessor_Update(), _transform_Core_Storage_Accessor_Value(), _transform_Core_Storage_Accessor_Wildcard(), _transform_SelectorNode(), _transform_TableReferences()

Methods inherited from Core\Storage_Statement

__toString(), _bind(), _transform(), _transform_Boolean(), _transform_Core_Storage_Accessor_Parameter(), _transform_Float(), _transform_Integer(), _transform_Storable(), _transform_String(), execute(), mergeParameters()

Methods inherited from Core\Set

__get(), __isset()

Methods inherited from Core\Object

__autocreateFactory(), __call(), __processParameters(), attachMethod(), chain(), getValueForKey(), getValueForKeyPath(), getValueForUndefinedKey(), hash(), issetValueForKey(), setValueForKey(), setValueForKeyPath(), setValueForUndefinedKey(), uuid()

Constants summary

Constants inherited from Core\Object

AnyParameterType, AutochainParameterType, AutocreateParameterType, BooleanParameterType, CharParameterType, EnumParameterType, IntegerParameterType, RealParameterType, StringParameterType, UserParameterType

Properties summary

protected SQLite3Stmt $_v_preparedStatement

Prepared SQLite 3 statement.

Prepared SQLite 3 statement.

Since

3.0
#

Properties inherited from Core\Storage\SQL_Statement

$_tableReferences

Properties inherited from Core\Storage_Statement

$_v_bindingParameters, $_v_bindings, $_v_driver, $_v_insertID, $_v_query

Magic properties

public read-only SQLite3Stmt $preparedStatement

Prepared SQLite 3 statement.

Magic properties inherited from Core\Storage_Statement

$driver, $insertID, $query

Magic properties inherited from Core\Object

$hash, $uuid

xplo.re Medusa Core Framework 3.1 API documentation generated by ApiGen