Class for connecting to SQLite2 and SQLite3 databases and performing common operations.

• copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
• license: New BSD License

Located in /Db/Adapter/Pdo/Sqlite.php (line 39)

Zend_Db_Adapter_Abstract
   |
   --Zend_Db_Adapter_Pdo_Abstract
      |
      --Zend_Db_Adapter_Pdo_Sqlite

array $_numericDataTypes = array(
Zend_Db::INT_TYPE => Zend_Db::INT_TYPE,
Zend_Db::BIGINT_TYPE => Zend_Db::BIGINT_TYPE,
Zend_Db::FLOAT_TYPE => Zend_Db::FLOAT_TYPE,
'INTEGER' => Zend_Db::BIGINT_TYPE,
'REAL' => Zend_Db::FLOAT_TYPE
) (line 60)

Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.

Values are:

1. = 32-bit integer
2. = 64-bit integer
3. = float or decimal

• var: Associative array of datatypes to values 0, 1, or 2.
• access: protected

---

Redefinition of:

Zend_Db_Adapter_Abstract::$_numericDataTypes

Keys are UPPERCASE SQL datatypes or the constants Zend_Db::INT_TYPE, Zend_Db::BIGINT_TYPE, or Zend_Db::FLOAT_TYPE.

string $_pdoType = 'sqlite' (line 47)

PDO type

• access: protected

Inherited Variables

Inherited from Zend_Db_Adapter_Pdo_Abstract

Zend_Db_Adapter_Pdo_Abstract::$_defaultStmtClass

Inherited from Zend_Db_Adapter_Abstract

Zend_Db_Adapter_Abstract::$_allowSerialization
Zend_Db_Adapter_Abstract::$_autoQuoteIdentifiers
Zend_Db_Adapter_Abstract::$_autoReconnectOnUnserialize
Zend_Db_Adapter_Abstract::$_caseFolding
Zend_Db_Adapter_Abstract::$_config
Zend_Db_Adapter_Abstract::$_connection
Zend_Db_Adapter_Abstract::$_defaultProfilerClass
Zend_Db_Adapter_Abstract::$_fetchMode
Zend_Db_Adapter_Abstract::$_profiler

Constructor __construct (line 84)

Constructor.

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

• access: public

Zend_Db_Adapter_Pdo_Sqlite __construct ([ $config = array()])

• array $config: An array of configuration keys.

---

Redefinition of:

Zend_Db_Adapter_Abstract::__construct()

Constructor.

describeTable (line 198)

Returns the column descriptions for a table.

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

• access: public

array describeTable (string $tableName, [string $schemaName = null])

• string $tableName
• string $schemaName: OPTIONAL

---

Redefinition of:

Zend_Db_Adapter_Abstract::describeTable()

Returns the column descriptions for a table.

limit (line 273)

Adds an adapter-specific LIMIT clause to the SELECT statement.

• access: public

string limit (string $sql, integer $count, [integer $offset = 0])

• string $sql
• integer $count
• integer $offset: OPTIONAL

---

Redefinition of:

Zend_Db_Adapter_Abstract::limit()

Adds an adapter-specific LIMIT clause to the SELECT statement.

listTables (line 161)

Returns a list of the tables in the database.

• access: public

array listTables ()

---

Redefinition of:

Zend_Db_Adapter_Abstract::listTables()

Returns a list of the tables in the database.

_checkRequiredOptions (line 104)

Check for config options that are mandatory.

Throw exceptions if any are missing.

• throws: Zend_Db_Adapter_Exception
• access: protected

void _checkRequiredOptions ( $config)

• array $config

---

Redefinition of:

Zend_Db_Adapter_Abstract::_checkRequiredOptions()

Check for config options that are mandatory.

_connect (line 128)

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

• throws: Zend_Db_Adapter_Exception
• access: protected

void _connect ()

---

Redefinition of:

Zend_Db_Adapter_Pdo_Abstract::_connect()

Creates a PDO object and connects to the database.

_dsn (line 117)

DSN builder

• access: protected

void _dsn ()

---

Redefinition of:

Zend_Db_Adapter_Pdo_Abstract::_dsn()

Creates a PDO DSN for the adapter from $this->_config settings.

Inherited Methods

Inherited From Zend_Db_Adapter_Pdo_Abstract

Zend_Db_Adapter_Pdo_Abstract::closeConnection()
Zend_Db_Adapter_Pdo_Abstract::exec()
Zend_Db_Adapter_Pdo_Abstract::getServerVersion()
Zend_Db_Adapter_Pdo_Abstract::isConnected()
Zend_Db_Adapter_Pdo_Abstract::lastInsertId()
Zend_Db_Adapter_Pdo_Abstract::prepare()
Zend_Db_Adapter_Pdo_Abstract::query()
Zend_Db_Adapter_Pdo_Abstract::setFetchMode()
Zend_Db_Adapter_Pdo_Abstract::supportsParameters()
Zend_Db_Adapter_Pdo_Abstract::_beginTransaction()
Zend_Db_Adapter_Pdo_Abstract::_commit()
Zend_Db_Adapter_Pdo_Abstract::_connect()
Zend_Db_Adapter_Pdo_Abstract::_dsn()
Zend_Db_Adapter_Pdo_Abstract::_quote()
Zend_Db_Adapter_Pdo_Abstract::_rollBack()

Inherited From Zend_Db_Adapter_Abstract

Zend_Db_Adapter_Abstract::__construct()
Zend_Db_Adapter_Abstract::beginTransaction()
Zend_Db_Adapter_Abstract::closeConnection()
Zend_Db_Adapter_Abstract::commit()
Zend_Db_Adapter_Abstract::delete()
Zend_Db_Adapter_Abstract::describeTable()
Zend_Db_Adapter_Abstract::fetchAll()
Zend_Db_Adapter_Abstract::fetchAssoc()
Zend_Db_Adapter_Abstract::fetchCol()
Zend_Db_Adapter_Abstract::fetchOne()
Zend_Db_Adapter_Abstract::fetchPairs()
Zend_Db_Adapter_Abstract::fetchRow()
Zend_Db_Adapter_Abstract::foldCase()
Zend_Db_Adapter_Abstract::getConfig()
Zend_Db_Adapter_Abstract::getConnection()
Zend_Db_Adapter_Abstract::getFetchMode()
Zend_Db_Adapter_Abstract::getProfiler()
Zend_Db_Adapter_Abstract::getQuoteIdentifierSymbol()
Zend_Db_Adapter_Abstract::getServerVersion()
Zend_Db_Adapter_Abstract::getStatementClass()
Zend_Db_Adapter_Abstract::insert()
Zend_Db_Adapter_Abstract::isConnected()
Zend_Db_Adapter_Abstract::lastInsertId()
Zend_Db_Adapter_Abstract::lastSequenceId()
Zend_Db_Adapter_Abstract::limit()
Zend_Db_Adapter_Abstract::listTables()
Zend_Db_Adapter_Abstract::nextSequenceId()
Zend_Db_Adapter_Abstract::prepare()
Zend_Db_Adapter_Abstract::query()
Zend_Db_Adapter_Abstract::quote()
Zend_Db_Adapter_Abstract::quoteColumnAs()
Zend_Db_Adapter_Abstract::quoteIdentifier()
Zend_Db_Adapter_Abstract::quoteInto()
Zend_Db_Adapter_Abstract::quoteTableAs()
Zend_Db_Adapter_Abstract::rollBack()
Zend_Db_Adapter_Abstract::select()
Zend_Db_Adapter_Abstract::setFetchMode()
Zend_Db_Adapter_Abstract::setProfiler()
Zend_Db_Adapter_Abstract::setStatementClass()
Zend_Db_Adapter_Abstract::supportsParameters()
Zend_Db_Adapter_Abstract::update()
Zend_Db_Adapter_Abstract::_beginTransaction()
Zend_Db_Adapter_Abstract::_checkRequiredOptions()
Zend_Db_Adapter_Abstract::_commit()
Zend_Db_Adapter_Abstract::_connect()
Zend_Db_Adapter_Abstract::_quote()
Zend_Db_Adapter_Abstract::_quoteIdentifier()
Zend_Db_Adapter_Abstract::_quoteIdentifierAs()
Zend_Db_Adapter_Abstract::_rollBack()
Zend_Db_Adapter_Abstract::_whereExpr()
Zend_Db_Adapter_Abstract::__sleep()
Zend_Db_Adapter_Abstract::__wakeup()