Class QSqLite3PdoDatabase

PDO_SqLite3 database driver

QBaseClass

QDatabaseBase

QPdoDatabase

QSqLite3PdoDatabase

Package: DatabaseAdapters
Author:

Christophe Damour [sigeal at sigeal dot com dot fr] Adapted from PDO_PGSQL database driver by Marcos S�nchez [marcosdsanchez at thinkclear dot com dot ar]

Located at includes/database/QSqLite3PdoDatabase.class.php

Methods summary
`public`	# `InsertOrUpdate( string $strTable, array $mixColumnsAndValuesArray, null\|string\|array $strPKNames = null )` INSERTs or UPDATEs a table INSERTs or UPDATEs a table Parameters `$strTable` Table name `$mixColumnsAndValuesArray` column=>value array (they are given to 'EscapeIdentifiersAndValues' method) `$strPKNames` Name(s) of primary key column(s) (expressed as string or array) Overrides `QDatabaseBase::InsertOrUpdate()`
`public`	# `Connect( )` Connects to the database Connects to the database
`public mixed`	# `Close( )` Closes the database connection Closes the database connection Returns mixed Overrides `QPdoDatabase::Close()`
`public string`	# `SqlVariable( mixed $mixData, boolean $blnIncludeEquality = false, boolean $blnReverseEquality = false )` Properly escapes $mixData to be used as a SQL query parameter. If IncludeEquality is set (usually not), then include an equality operator. So for most data, it would just be "=". But, for example, if $mixData is NULL, then most RDBMS's require the use of "IS". Properly escapes $mixData to be used as a SQL query parameter. If IncludeEquality is set (usually not), then include an equality operator. So for most data, it would just be "=". But, for example, if $mixData is NULL, then most RDBMS's require the use of "IS". Parameters `$mixData` `$blnIncludeEquality` whether or not to include an equality operator `$blnReverseEquality` whether the included equality operator should be a "NOT EQUAL", e.g. "!=" Returns string the properly formatted SQL variable Overrides `QDatabaseBase::SqlVariable()`
`public`	# `SqlLimitVariablePrefix( $strLimitInfo )`
`public`	# `SqlLimitVariableSuffix( $strLimitInfo )`
`public`	# `SqlSortByVariable( $strSortByInfo )`
`public mixed\|string[]`	# `GetTables( )` Returns the list of tables in the database (as string) Returns the list of tables in the database (as string) Returns mixed\|string[] List of tables
`public mixed`	# `GetFieldsForTable( string $strTableName )` Get the list of columns/fields for a given table Get the list of columns/fields for a given table Parameters `$strTableName` Name of table whose fields we have to get Returns mixed
`public mixed`	# `InsertId( null\|string $strTableName = null, null\|string $strColumnName = null )` Returns the ID to be inserted in a table column (normally it an autoincrement column) Returns the ID to be inserted in a table column (normally it an autoincrement column) Parameters `$strTableName` Table name where the ID has to be inserted `$strColumnName` Column name where the ID has to be inserted Returns mixed
`public mixed`	# `GetIndexesForTable( string $strTableName )` Get list of indexes for a table Get list of indexes for a table Parameters `$strTableName` Name of table whose column indexes we have to get Returns mixed
`public mixed`	# `GetForeignKeysForTable( string $strTableName )` Get list of foreign keys for a table Get list of foreign keys for a table Parameters `$strTableName` Name of table whose foreign keys we are trying to get Returns mixed
`protected mixed`	# `ExecuteQuery( string $strQuery )` Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement Sends a SQL query for execution to the database In this regard, a query is a 'SELECT' statement Parameters `$strQuery` The Query to be executed Returns mixed Result that the database returns after running the query.

Methods inherited from QPdoDatabase
`ExecuteNonQuery(), ExecuteTransactionBegin(), ExecuteTransactionCommit(), ExecuteTransactionRollBack(), __get()`

Methods inherited from QDatabaseBase
`EnableProfiling(), EscapeIdentifier(), EscapeIdentifiers(), EscapeIdentifiersAndValues(), EscapeValues(), ExecuteProcedure(), ExplainStatement(), ExtractCommentOptions(), NonQuery(), OutputProfiling(), PrepareStatement(), Query(), TransactionBegin(), TransactionCommit(), TransactionRollBack(), __construct(), __set(), transactionCacheFlush(), transactionCacheRestore()`

Methods inherited from QBaseClass
`OverrideAttributes(), __call()`

Constants summary
`string`	`PDO_SQLITE3_DSN_IDENTIFIER`	# `'sqlite'`

Constants inherited from QDatabaseBase
`Adapter`

Properties summary
`protected string`	`$strEscapeIdentifierBegin` The beginning part of characters which can escape identifiers in a SQL query for the database The beginning part of characters which can escape identifiers in a SQL query for the database	# `''`
`protected string`	`$strEscapeIdentifierEnd` The ending part of characters which can escape identifiers in a SQL query for the database The ending part of characters which can escape identifiers in a SQL query for the database	# `''`
`protected string`	`$strEscapeIdentifierBeginInternal`	# `'\''`
`protected string`	`$strEscapeIdentifierEndInternal`	# `'\''`

Properties inherited from QPdoDatabase
`$objMostRecentResult, $objPdo`

Properties inherited from QDatabaseBase
`$blnConnectedFlag, $blnEnableProfiling, $blnOnlyFullGroupBy, $intDatabaseIndex, $intTransactionDepth, $objCacheProviderStack, $objConfigArray, $strProfileArray`

Magic properties inherited from QDatabaseBase
`$Adapter, $AffectedRows, $Caching, $Database, $DatabaseIndex, $DateFormat, $EnableProfiling, $EscapeIdentifierBegin, $EscapeIdentifierEnd, $Host, $OnlyFullGroupBy, $Password, $Port, $Profile, $Protocol, $Server, $Service, $Username`

Packages

Classes

Exceptions

Class QSqLite3PdoDatabase

Parameters

Overrides

Returns

Overrides

Parameters

Returns

Overrides

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns