MediaWiki  1.23.1
MockDatabaseSqlite Class Reference
Inheritance diagram for MockDatabaseSqlite:
Collaboration diagram for MockDatabaseSqlite:

Public Member Functions

 __construct ()
 
 query ( $sql, $fname='', $tempIgnore=false)
 Run an SQL query and return the result. More...
 
 replaceVars ( $s)
 Override parent visibility to public. More...
 
- Public Member Functions inherited from DatabaseSqliteStandalone
 __construct ( $fileName, $flags=0)
 
- Public Member Functions inherited from DatabaseSqlite
 __construct ( $p=null)
 Constructor. More...
 
 addQuotes ( $s)
 
 affectedRows ()
 
 attachDatabase ( $name, $file=false, $fname=__METHOD__)
 Attaches external database to our connection, see http://sqlite.org/lang_attach.html for details. More...
 
 buildConcat ( $stringList)
 Build a concatenation list to feed into a SQL query. More...
 
 buildGroupConcatField ( $delim, $table, $field, $conds='', $join_conds=array())
 Build a GROUP_CONCAT or equivalent statement for a query. More...
 
 buildLike ()
 
 checkForEnabledSearch ()
 Check if the searchindext table is FTS enabled. More...
 
 dataSeek ( $res, $row)
 
 deadlockLoop ()
 No-op version of deadlockLoop. More...
 
 decodeBlob ( $b)
 
 duplicateTableStructure ( $oldName, $newName, $temporary=false, $fname=__METHOD__)
 
 encodeBlob ( $b)
 
 fetchObject ( $res)
 
 fetchRow ( $res)
 
 fieldInfo ( $table, $field)
 Get information about a given field Returns false if the field does not exist. More...
 
 fieldName ( $res, $n)
 
 freeResult ( $res)
 
 getSearchEngine ()
 
 getServerInfo ()
 
 getServerVersion ()
 
 getSoftwareLink ()
 
 getType ()
 
 implicitGroupby ()
 
 indexInfo ( $table, $index, $fname=__METHOD__)
 Returns information about an index Returns false if the index does not exist. More...
 
 indexName ( $index)
 Index names have DB scope. More...
 
 indexUnique ( $table, $index, $fname=__METHOD__)
 
 insert ( $table, $a, $fname=__METHOD__, $options=array())
 Based on generic method (parent) with some prior SQLite-sepcific adjustments. More...
 
 insertId ()
 This must be called after nextSequenceVal. More...
 
 isWriteQuery ( $sql)
 
 lastErrno ()
 
 lastError ()
 
 listTables ( $prefix=null, $fname=__METHOD__)
 List all tables on the database. More...
 
 lock ( $lockName, $method, $timeout=5)
 Acquire a named lock. More...
 
 makeInsertOptions ( $options)
 
 makeSelectOptions ( $options)
 Filter the options used in SELECT statements. More...
 
 numFields ( $res)
 
 numRows ( $res)
 The PDO::Statement class implements the array interface so count() will work. More...
 
 open ( $server, $user, $pass, $dbName)
 Open an SQLite database and return a resource handle to it NOTE: only $dbName is used, the other parameters are irrelevant for SQLite databases. More...
 
 openFile ( $fileName)
 Opens a database file. More...
 
 replace ( $table, $uniqueIndexes, $rows, $fname=__METHOD__)
 
 strencode ( $s)
 
 tableName ( $name, $format='quoted')
 Use MySQL's naming (accounts for prefix etc) but remove surrounding backticks. More...
 
 textFieldSize ( $table, $field)
 Returns the size of a text field, or -1 for "unlimited" In SQLite this is SQLITE_MAX_LENGTH, by default 1GB. More...
 
 unionQueries ( $sqls, $all)
 
 unionSupportsOrderAndLimit ()
 
 unlock ( $lockName, $method)
 Release a lock. More...
 
 wasDeadlock ()
 
 wasErrorReissuable ()
 
 wasReadOnlyError ()
 
- Public Member Functions inherited from DatabaseBase
 __destruct ()
 Run a few simple sanity checks. More...
 
 __sleep ()
 Called by serialize. More...
 
 __toString ()
 
 addIdentifierQuotes ( $s)
 Quotes an identifier using backticks or "double quotes" depending on the database type. More...
 
 aggregateValue ( $valuedata, $valuename='value')
 Return aggregated value alias. More...
 
 anyChar ()
 Returns a token for buildLike() that denotes a '_' to be used in a LIKE query. More...
 
 anyString ()
 Returns a token for buildLike() that denotes a '' to be used in a LIKE query. More...
 
 begin ( $fname=__METHOD__)
 Begin a transaction. More...
 
 bitAnd ( $fieldLeft, $fieldRight)
 
 bitNot ( $field)
 
 bitOr ( $fieldLeft, $fieldRight)
 
 bufferResults ( $buffer=null)
 Turns buffering of SQL result sets on (true) or off (false). More...
 
 cascadingDeletes ()
 Returns true if this database supports (and uses) cascading deletes. More...
 
 cleanupTriggers ()
 Returns true if this database supports (and uses) triggers (e.g. More...
 
 clearFlag ( $flag)
 Clear a flag for this connection. More...
 
 clearViewsCache ()
 Reset the views process cache set by listViews() More...
 
 close ()
 Closes a database connection. More...
 
 commit ( $fname=__METHOD__, $flush='')
 Commits a transaction previously started using begin(). More...
 
 conditional ( $cond, $trueVal, $falseVal)
 Returns an SQL expression for a simple conditional. More...
 
 connectionErrorHandler ( $errno, $errstr)
 
 dbSchema ( $schema=null)
 Get/set the db schema. More...
 
 debug ( $debug=null)
 Boolean, controls output of large amounts of debug information. More...
 
 decodeExpiry ( $expiry, $format=TS_MW)
 Decode an expiry time into a DBMS independent format. More...
 
 delete ( $table, $conds, $fname=__METHOD__)
 DELETE query wrapper. More...
 
 deleteJoin ( $delTable, $joinTable, $delVar, $joinVar, $conds, $fname=__METHOD__)
 DELETE where the condition is a join. More...
 
 doneWrites ()
 Returns true if the connection may have been used for write queries. More...
 
 dropTable ( $tableName, $fName=__METHOD__)
 Delete a table. More...
 
 encodeExpiry ( $expiry)
 Encode an expiry time into the DBMS dependent format. More...
 
 endAtomic ( $fname=__METHOD__)
 Ends an atomic section of SQL statements. More...
 
 errorCount ( $count=null)
 Get/set the number of errors logged. More...
 
 estimateRowCount ( $table, $vars=' *', $conds='', $fname=__METHOD__, $options=array())
 Estimate rows in dataset. More...
 
 execute ( $prepared, $args=null)
 Execute a prepared query with the various arguments. More...
 
 fieldExists ( $table, $field, $fname=__METHOD__)
 Determines whether a field exists in a table. More...
 
 fieldNamesWithAlias ( $fields)
 Gets an array of aliased field names. More...
 
 fieldNameWithAlias ( $name, $alias=false)
 Get an aliased field name e.g. More...
 
 fillPrepared ( $preparedQuery, $args)
 For faking prepared SQL statements on DBs that don't support it directly. More...
 
 functionalIndexes ()
 Returns true if this database can use functional indexes. More...
 
 getDBname ()
 Get the current DB name. More...
 
 getDelimiter ()
 
 getFlag ( $flag)
 Returns a boolean whether the flag $flag is set for this connection. More...
 
 getInfinity ()
 Find out when 'infinity' is. More...
 
 getLag ()
 Get slave lag. More...
 
 getLBInfo ( $name=null)
 Get properties passed down from the server info array of the load balancer. More...
 
 getMasterPos ()
 Get the position of this master. More...
 
 getProperty ( $name)
 General read-only accessor. More...
 
 getSchemaPath ()
 Return a path to the DBMS-specific schema file, otherwise default to tables.sql. More...
 
 getServer ()
 Get the server hostname or IP address. More...
 
 getServerUptime ()
 Determines how long the server has been up STUB. More...
 
 getSlavePos ()
 Get the replication position of this slave. More...
 
 getWikiID ()
 
 ignoreErrors ( $ignoreErrors=null)
 Turns on (false) or off (true) the automatic generation and sending of a "we're sorry, but there has been a database error" page on database errors. More...
 
 implicitOrderby ()
 Returns true if this database does an implicit order by when the column has an index For example: SELECT page_title FROM page LIMIT 1. More...
 
 indexExists ( $table, $index, $fname=__METHOD__)
 Determines whether an index exists Usually throws a DBQueryError on failure If errors are explicitly ignored, returns NULL on failure. More...
 
 indexUnique ( $table, $index)
 Determines if a given index is unique. More...
 
 insertSelect ( $destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=array(), $selectOptions=array())
 INSERT SELECT wrapper. More...
 
 isOpen ()
 Is a connection to the database open? More...
 
 isQuotedIdentifier ( $name)
 Returns if the given identifier looks quoted or not according to the database convention for quoting identifiers . More...
 
 isView ( $name)
 Differentiates between a TABLE and a VIEW. More...
 
 lastQuery ()
 Return the last query that went through DatabaseBase::query() More...
 
 limitResult ( $sql, $limit, $offset=false)
 Construct a LIMIT query with optional offset. More...
 
 listViews ( $prefix=null, $fname=__METHOD__)
 Lists all the VIEWs in the database. More...
 
 lockIsFree ( $lockName, $method)
 Check to see if a named lock is available. More...
 
 lockTables ( $read, $write, $method, $lowPriority=true)
 Lock specific tables. More...
 
 lowPriorityOption ()
 A string to insert into queries to show that they're low-priority, like MySQL's LOW_PRIORITY. More...
 
 makeGroupByWithHaving ( $options)
 Returns an optional GROUP BY with an optional HAVING. More...
 
 makeList ( $a, $mode=LIST_COMMA)
 Makes an encoded list of strings from an array. More...
 
 makeOrderBy ( $options)
 Returns an optional ORDER BY. More...
 
 makeWhereFrom2d ( $data, $baseKey, $subKey)
 Build a partial where clause from a 2-d array such as used for LinkBatch. More...
 
 masterPosWait (DBMasterPos $pos, $timeout)
 Wait for the slave to catch up to a given master position. More...
 
 maxListLen ()
 Return the maximum number of items allowed in a list, or 0 for unlimited. More...
 
 nextSequenceValue ( $seqName)
 Returns an appropriately quoted sequence value for inserting a new row. More...
 
 onTransactionIdle ( $callback)
 Run an anonymous function as soon as there is no transaction pending. More...
 
 onTransactionPreCommitOrIdle ( $callback)
 Run an anonymous function before the current transaction commits or now if there is none. More...
 
 patchPath ( $patch)
 Get the full path of a patch file. More...
 
 ping ()
 Ping the server and try to reconnect if it there is no connection. More...
 
 realTimestamps ()
 Returns true if this database uses timestamps rather than integers. More...
 
 reportConnectionError ( $error='Unknown error')
 
 reportQueryError ( $error, $errno, $sql, $fname, $tempIgnore=false)
 Report a query error. More...
 
 resultObject ( $result)
 Take the result from a query, and wrap it in a ResultWrapper if necessary. More...
 
 rollback ( $fname=__METHOD__, $flush='')
 Rollback a transaction previously started using begin(). More...
 
 searchableIPs ()
 Returns true if this database can do a native search on IP columns e.g. More...
 
 select ( $table, $vars, $conds='', $fname=__METHOD__, $options=array(), $join_conds=array())
 Execute a SELECT query constructed using the various parameters provided. More...
 
 selectDB ( $db)
 Change the current database. More...
 
 selectField ( $table, $var, $cond='', $fname=__METHOD__, $options=array())
 A SELECT wrapper which returns a single field from a single result row. More...
 
 selectRow ( $table, $vars, $conds, $fname=__METHOD__, $options=array(), $join_conds=array())
 Single row SELECT wrapper. More...
 
 selectSQLText ( $table, $vars, $conds='', $fname=__METHOD__, $options=array(), $join_conds=array())
 The equivalent of DatabaseBase::select() except that the constructed SQL is returned, instead of being immediately executed. More...
 
 setBigSelects ( $value=true)
 Allow or deny "big selects" for this session only. More...
 
 setFakeMaster ( $enabled=true)
 Make this connection a fake master. More...
 
 setFakeSlaveLag ( $lag)
 Set lag time in seconds for a fake slave. More...
 
 setFileHandle ( $fh)
 Set the filehandle to copy write statements to. More...
 
 setFlag ( $flag)
 Set a flag for this connection. More...
 
 setLBInfo ( $name, $value=null)
 Set the LB info array, or a member of it. More...
 
 setSchemaVars ( $vars)
 Set variables to be used in sourceFile/sourceStream, in preference to the ones in $GLOBALS. More...
 
 setSessionOptions (array $options)
 Override database's default behavior. More...
 
 sourceFile ( $filename, $lineCallback=false, $resultCallback=false, $fname=false, $inputCallback=false)
 Read and execute SQL commands from a file. More...
 
 sourceStream ( $fp, $lineCallback=false, $resultCallback=false, $fname=__METHOD__, $inputCallback=false)
 Read and execute commands from an open file handle. More...
 
 startAtomic ( $fname=__METHOD__)
 Begin an atomic section of statements. More...
 
 streamStatementEnd (&$sql, &$newLine)
 Called by sourceStream() to check if we've reached a statement end. More...
 
 strictIPs ()
 Returns true if this database is strict about what can be put into an IP field. More...
 
 strreplace ( $orig, $old, $new)
 Returns a comand for str_replace function in SQL query. More...
 
 tableExists ( $table, $fname=__METHOD__)
 Query whether a given table exists. More...
 
 tableNames ()
 Fetch a number of table names into an array This is handy when you need to construct SQL for joins. More...
 
 tableNamesN ()
 Fetch a number of table names into an zero-indexed numerical array This is handy when you need to construct SQL for joins. More...
 
 tableNamesWithAlias ( $tables)
 Gets an array of aliased table names. More...
 
 tableNameWithAlias ( $name, $alias=false)
 Get an aliased table name e.g. More...
 
 tablePrefix ( $prefix=null)
 Get/set the table prefix. More...
 
 timestamp ( $ts=0)
 Convert a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting into timestamp fields in this DBMS. More...
 
 timestampOrNull ( $ts=null)
 Convert a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting into timestamp fields in this DBMS. More...
 
 trxLevel ()
 Gets the current transaction level. More...
 
 unlockTables ( $method)
 Unlock specific tables. More...
 
 update ( $table, $values, $conds, $fname=__METHOD__, $options=array())
 UPDATE wrapper. More...
 
 upsert ( $table, array $rows, array $uniqueIndexes, array $set, $fname=__METHOD__)
 INSERT ON DUPLICATE KEY UPDATE wrapper, upserts an array into a table. More...
 
 useIndexClause ( $index)
 USE INDEX clause. More...
 
 wasLockTimeout ()
 Determines if the last failure was due to a lock timeout STUB. More...
 
 writesOrCallbacksPending ()
 Returns true if there is a transaction open with possible write queries or transaction pre-commit/idle callbacks waiting on it to finish. More...
 

Public Attributes

 $lastQuery
 
- Public Attributes inherited from DatabaseSqlite
string $mDatabaseFile
 File name for SQLite database file *. More...
 
- Public Attributes inherited from DatabaseBase
 $mDBname
 
 $mPassword
 
 $mUser
 
const DEADLOCK_DELAY_MAX = 1500000
 Maximum time to wait before retry. More...
 
const DEADLOCK_DELAY_MIN = 500000
 Minimum time to wait before retry, in microseconds. More...
 
const DEADLOCK_TRIES = 4
 Number of times to re-try an operation in case of deadlock. More...
 

Additional Inherited Members

- Static Public Member Functions inherited from DatabaseSqlite
static fixIgnore ( $options)
 
static generateFileName ( $dir, $dbName)
 Generates a database file name. More...
 
static getFulltextSearchModule ()
 Returns version of currently supported SQLite fulltext search module or false if none present. More...
 
- Static Public Member Functions inherited from DatabaseBase
static factory ( $dbType, $p=array())
 Given a DB type, construct the name of the appropriate child class of DatabaseBase. More...
 
static generalizeSQL ( $sql)
 Removes most variables from an SQL query and replaces them with X or N for numbers. More...
 
- Protected Member Functions inherited from DatabaseSqlite
 closeConnection ()
 Does not actually close the connection, just destroys the reference for GC to do its work. More...
 
 doBegin ( $fname='')
 Issues the BEGIN command to the database server. More...
 
 doCommit ( $fname='')
 Issues the COMMIT command to the database server. More...
 
 doQuery ( $sql)
 SQLite doesn't allow buffered results or data seeking etc, so we'll use fetchAll as the result. More...
 
 doRollback ( $fname='')
 Issues the ROLLBACK command to the database server. More...
 
 makeUpdateOptionsArray ( $options)
 
- Protected Member Functions inherited from DatabaseBase
 escapeLikeInternal ( $s)
 
 fillPreparedArg ( $matches)
 preg_callback func for fillPrepared() The arguments should be in $this->preparedArgs and must not be touched while we're doing this. More...
 
 freePrepared ( $prepared)
 Free a prepared query, generated by prepare(). More...
 
 getDefaultSchemaVars ()
 Get schema variables to use if none have been set via setSchemaVars(). More...
 
 getSchemaVars ()
 Get schema variables. More...
 
 indexNameCallback ( $matches)
 Index name callback. More...
 
 installErrorHandler ()
 
 makeUpdateOptions ( $options)
 Make UPDATE options for the DatabaseBase::update function. More...
 
 nativeReplace ( $table, $rows, $fname)
 REPLACE query wrapper for MySQL and SQLite, which have a native REPLACE statement. More...
 
 prepare ( $sql, $func='DatabaseBase::prepare')
 Intended to be compatible with the PEAR::DB wrapper functions. More...
 
 replaceSchemaVars ( $ins)
 Database independent variable replacement. More...
 
 restoreErrorHandler ()
 
 runOnTransactionIdleCallbacks ()
 Actually any "on transaction idle" callbacks. More...
 
 runOnTransactionPreCommitCallbacks ()
 Actually any "on transaction pre-commit" callbacks. More...
 
 tableNameCallback ( $matches)
 Table name callback. More...
 
 tableNamesWithUseIndexOrJOIN ( $tables, $use_index=array(), $join_conds=array())
 Get the aliased table name clause for a FROM clause which might have a JOIN and/or USE INDEX clause. More...
 
- Protected Attributes inherited from DatabaseSqlite
FSLockManager $lockMgr
 (hopefully on the same server as the DB) * More...
 
int $mAffectedRows
 The number of rows affected as an integer *. More...
 
PDO $mConn
 
resource $mLastResult
 
- Protected Attributes inherited from DatabaseBase
string[] $allViews = null
 
 $delimiter = ';'
 
resource $fileHandle = null
 
 $htmlErrors
 
resource $mConn = null
 Database connection *. More...
 
 $mDefaultBigSelects = null
 
 $mDoneWrites = false
 
 $mErrorCount = 0
 
 $mFlags
 
 $mForeign
 
 $mLastQuery = ''
 
 $mLBInfo = array()
 
 $mOpened = false
 
 $mPHPError = false
 
 $mSchema
 
 $mSchemaVars = false
 
 $mServer
 
 $mTablePrefix
 
callable[] $mTrxIdleCallbacks = array()
 
int $mTrxLevel = 0
 Either 1 if a transaction is active or 0 otherwise. More...
 
callable[] $mTrxPreCommitCallbacks = array()
 
 $preparedArgs
 

Detailed Description

Definition at line 3 of file DatabaseSqliteTest.php.

Constructor & Destructor Documentation

◆ __construct()

MockDatabaseSqlite::__construct ( )

Definition at line 6 of file DatabaseSqliteTest.php.

Member Function Documentation

◆ query()

MockDatabaseSqlite::query (   $sql,
  $fname = '',
  $tempIgnore = false 
)

Run an SQL query and return the result.

Normally throws a DBQueryError on failure. If errors are ignored, returns false instead.

In new code, the query wrappers select(), insert(), update(), delete(), etc. should be used where possible, since they give much better DBMS independence and automatically quote or validate user input in a variety of contexts. This function is generally only useful for queries which are explicitly DBMS-dependent and are unsupported by the query wrappers, such as CREATE TABLE.

However, the query wrappers themselves should call this function.

Parameters
string$sqlSQL query
string$fnameName of the calling function, for profiling/SHOW PROCESSLIST comment (you can use METHOD or add some extra info)
bool$tempIgnoreWhether to avoid throwing an exception on errors... maybe best to catch the exception instead?
Exceptions
MWException
Returns
bool|ResultWrapper True for a successful write query, ResultWrapper object for a successful read query, or false on failure if $tempIgnore set

Reimplemented from DatabaseBase.

Definition at line 10 of file DatabaseSqliteTest.php.

References DatabaseBase\lastQuery().

Referenced by DatabaseSqliteTest\getColumns(), DatabaseSqliteTest\getIndexes(), DatabaseSqliteTest\testAddQuotes(), DatabaseSqliteTest\testCaseInsensitiveLike(), DatabaseSqliteTest\testDeleteJoin(), DatabaseSqliteTest\testDuplicateTableStructure(), DatabaseSqliteTest\testDuplicateTableStructureVirtual(), and DatabaseSqliteTest\testInsertIdType().

◆ replaceVars()

MockDatabaseSqlite::replaceVars (   $s)

Override parent visibility to public.

Reimplemented from DatabaseSqlite.

Definition at line 19 of file DatabaseSqliteTest.php.

References $s.

Member Data Documentation

◆ $lastQuery

MockDatabaseSqlite::$lastQuery

Definition at line 4 of file DatabaseSqliteTest.php.


The documentation for this class was generated from the following file: