MediaWiki
1.33.0
|
Public Member Functions | |
query ( $sql, $fname='', $flags=0) | |
Run an SQL query and return the result. More... | |
replaceVars ( $s) | |
Override parent visibility to public. More... | |
Public Member Functions inherited from Wikimedia\Rdbms\DatabaseSqlite | |
__construct (array $p) | |
Additional params include: More... | |
__toString () | |
addQuotes ( $s) | |
attachDatabase ( $name, $file=false, $fname=__METHOD__) | |
Attaches external database to our connection, see https://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=[]) | |
Build a GROUP_CONCAT or equivalent statement for a query. More... | |
buildStringCast ( $field) | |
buildSubstring ( $input, $startPosition, $length=null) | |
checkForEnabledSearch () | |
Check if the searchindext table is FTS enabled. More... | |
databasesAreIndependent () | |
Returns true if DBs are assumed to be on potentially different servers. More... | |
dataSeek ( $res, $row) | |
deadlockLoop () | |
No-op version of deadlockLoop. More... | |
decodeBlob ( $b) | |
dropTable ( $tableName, $fName=__METHOD__) | |
Override due to no CASCADE support. More... | |
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) | |
getDbFilePath () | |
getServerVersion () | |
getSoftwareLink () | |
getType () | |
implicitGroupby () | |
indexInfo ( $table, $index, $fname=__METHOD__) | |
Returns information about an index Returns false if the index does not exist. More... | |
indexUnique ( $table, $index, $fname=__METHOD__) | |
insert ( $table, $a, $fname=__METHOD__, $options=[]) | |
Based on generic method (parent) with some prior SQLite-sepcific adjustments. More... | |
insertId () | |
This must be called after nextSequenceVal. More... | |
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... | |
replace ( $table, $uniqueIndexes, $rows, $fname=__METHOD__) | |
resetSequenceForTable ( $table, $fname=__METHOD__) | |
setTableAliases (array $aliases) | |
Make certain table names use their own database, schema, and table prefix when passed into SQL queries pre-escaped and without a qualified database name. More... | |
strencode ( $s) | |
tableExists ( $table, $fname=__METHOD__) | |
Query whether a given table exists. More... | |
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... | |
wasConnectionError ( $errno) | |
Do not use this method outside of Database/DBError classes. More... | |
wasDeadlock () | |
wasReadOnlyError () | |
Public Member Functions inherited from Wikimedia\Rdbms\Database | |
__clone () | |
Make sure that copies do not share the same client binding handle. More... | |
__destruct () | |
Run a few simple sanity checks and close dangling connections. More... | |
__sleep () | |
Called by serialize. More... | |
addIdentifierQuotes ( $s) | |
Quotes an identifier, in order to make user controlled input safe. More... | |
affectedRows () | |
Get the number of rows affected by the last write query. 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... | |
assertNoOpenTransactions () | |
Assert that all explicit transactions or atomic sections have been closed. More... | |
begin ( $fname=__METHOD__, $mode=self::TRANSACTION_EXPLICIT) | |
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... | |
buildIntegerCast ( $field) | |
buildLike () | |
LIKE statement wrapper, receives a variable-length argument list with parts of pattern to match containing either string literals that will be escaped or tokens returned by anyChar() or anyString(). More... | |
buildSelectSubquery ( $table, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Equivalent to IDatabase::selectSQLText() except wraps the result in Subqyery. More... | |
cancelAtomic ( $fname=__METHOD__, AtomicSectionIdentifier $sectionId=null) | |
Cancel an atomic section of SQL statements. More... | |
clearFlag ( $flag, $remember=self::REMEMBER_NOTHING) | |
Clear a flag for this connection. More... | |
close () | |
Close the database connection. More... | |
commit ( $fname=__METHOD__, $flush=self::FLUSHING_ONE) | |
Commits a transaction previously started using begin(). More... | |
conditional ( $cond, $trueVal, $falseVal) | |
Returns an SQL expression for a simple conditional. More... | |
connectionErrorLogger ( $errno, $errstr) | |
Error handler for logging errors during database connection This method should not be used outside of Database classes. More... | |
dbSchema ( $schema=null) | |
Get/set the db schema. 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... | |
doAtomicSection ( $fname, callable $callback, $cancelable=self::ATOMIC_NOT_CANCELABLE) | |
Perform an atomic section of reversable SQL statements from a callback. More... | |
doneWrites () | |
Returns true if the connection may have been used for write queries. More... | |
encodeExpiry ( $expiry) | |
Encode an expiry time into the DBMS dependent format. More... | |
endAtomic ( $fname=__METHOD__) | |
Ends an atomic section of SQL statements. More... | |
estimateRowCount ( $table, $var=' *', $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Estimate the number of rows in dataset. More... | |
explicitTrxActive () | |
fieldExists ( $table, $field, $fname=__METHOD__) | |
Determines whether a field exists in a table. More... | |
flushSnapshot ( $fname=__METHOD__) | |
Commit any transaction but error out if writes or callbacks are pending. More... | |
getDBname () | |
Get the current DB name. More... | |
getDomainID () | |
Return the currently selected domain ID. More... | |
getFlag ( $flag) | |
Returns a boolean whether the flag $flag is set for this connection. More... | |
getInfinity () | |
Find out when 'infinity' is. More... | |
getLag () | |
Get the amount of replication lag for this database server. 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) | |
getReplicaPos () | |
Get the replication position of this replica DB. More... | |
getScopedLockAndFlush ( $lockKey, $fname, $timeout) | |
Acquire a named lock, flush any transaction, and return an RAII style unlocker object. More... | |
getServer () | |
Get the server hostname or IP address. More... | |
getServerInfo () | |
A string describing the current software version, and possibly other details in a user-friendly way. More... | |
getServerUptime () | |
Determines how long the server has been up. More... | |
getSessionLagStatus () | |
Get the replica DB lag when the current transaction started or a general lag estimate if not transaction is active. More... | |
getWikiID () | |
Alias for getDomainID() More... | |
ignoreIndexClause ( $index) | |
IGNORE INDEX clause. 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... | |
initConnection () | |
Initialize the connection to the database over the wire (or to local files) More... | |
insertSelect ( $destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[], $selectJoinConds=[]) | |
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... | |
isReadOnly () | |
lastDoneWrites () | |
Returns the last time the connection may have been used for write queries. More... | |
lastQuery () | |
Return the last query that went through IDatabase::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... | |
lockForUpdate ( $table, $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Lock all rows meeting the given conditions/options FOR UPDATE. More... | |
lockIsFree ( $lockName, $method) | |
Check to see if a named lock is not locked by any thread (non-blocking) More... | |
lockTables (array $read, array $write, $method) | |
Lock specific tables. More... | |
makeList ( $a, $mode=self::LIST_COMMA) | |
Makes an encoded list of strings from an array. 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 replica DB 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... | |
namedLocksEnqueue () | |
Check to see if a named lock used by lock() use blocking queues. More... | |
nextSequenceValue ( $seqName) | |
Deprecated method, calls should be removed. More... | |
onTransactionCommitOrIdle (callable $callback, $fname=__METHOD__) | |
Run a callback as soon as there is no transaction pending. More... | |
onTransactionIdle (callable $callback, $fname=__METHOD__) | |
Alias for onTransactionCommitOrIdle() for backwards-compatibility. More... | |
onTransactionPreCommitOrIdle (callable $callback, $fname=__METHOD__) | |
Run a callback before the current transaction commits or now if there is none. More... | |
onTransactionResolution (callable $callback, $fname=__METHOD__) | |
Run a callback as soon as the current transaction commits or rolls back. More... | |
pendingWriteAndCallbackCallers () | |
List the methods that have write queries or callbacks for the current transaction. More... | |
pendingWriteCallers () | |
Get the list of method names that did write queries for this transaction. More... | |
pendingWriteQueryDuration ( $type=self::ESTIMATE_TOTAL) | |
Get the time spend running write queries for this transaction. More... | |
pendingWriteRowsAffected () | |
Get the number of affected rows from pending write queries. More... | |
ping (&$rtt=null) | |
Ping the server and try to reconnect if it there is no connection. More... | |
preCommitCallbacksPending () | |
reportConnectionError ( $error='Unknown error') | |
reportQueryError ( $error, $errno, $sql, $fname, $ignoreErrors=false) | |
Report a query error. More... | |
restoreFlags ( $state=self::RESTORE_PRIOR) | |
Restore the flags to their prior state before the last setFlag/clearFlag call. More... | |
rollback ( $fname=__METHOD__, $flush='') | |
Rollback a transaction previously started using begin(). More... | |
runOnTransactionIdleCallbacks ( $trigger) | |
Actually consume and run any "on transaction idle/resolution" callbacks. More... | |
runOnTransactionPreCommitCallbacks () | |
Actually consume and run any "on transaction pre-commit" callbacks. More... | |
runTransactionListenerCallbacks ( $trigger) | |
Actually run any "transaction listener" callbacks. More... | |
select ( $table, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Execute a SELECT query constructed using the various parameters provided. More... | |
selectDB ( $db) | |
Change the current database. More... | |
selectDomain ( $domain) | |
Set the current domain (database, schema, and table prefix) More... | |
selectField ( $table, $var, $cond='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
A SELECT wrapper which returns a single field from a single result row. More... | |
selectFieldValues ( $table, $var, $cond='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
A SELECT wrapper which returns a list of single field values from result rows. More... | |
selectRow ( $table, $vars, $conds, $fname=__METHOD__, $options=[], $join_conds=[]) | |
Single row SELECT wrapper. More... | |
selectRowCount ( $tables, $var=' *', $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Get the number of rows in dataset. More... | |
selectSQLText ( $table, $vars, $conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
The equivalent of IDatabase::select() except that the constructed SQL is returned, instead of being immediately executed. More... | |
serverIsReadOnly () | |
setBigSelects ( $value=true) | |
Allow or deny "big selects" for this session only. More... | |
setFlag ( $flag, $remember=self::REMEMBER_NOTHING) | |
Set a flag for this connection. More... | |
setIndexAliases (array $aliases) | |
Convert certain index names to alternative names before querying the DB. More... | |
setLazyMasterHandle (IDatabase $conn) | |
Set a lazy-connecting DB handle to the master DB (for replication status purposes) More... | |
setLBInfo ( $name, $value=null) | |
Set the LB info array, or a member of it. More... | |
setLogger (LoggerInterface $logger) | |
Set the PSR-3 logger interface to use for query logging. 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... | |
setTransactionListener ( $name, callable $callback=null) | |
Run a callback after each time any transaction commits or rolls back. More... | |
setTrxEndCallbackSuppression ( $suppress) | |
Whether to disable running of post-COMMIT/ROLLBACK callbacks. More... | |
sourceFile ( $filename, callable $lineCallback=null, callable $resultCallback=null, $fname=false, callable $inputCallback=null) | |
Read and execute SQL commands from a file. More... | |
sourceStream ( $fp, callable $lineCallback=null, callable $resultCallback=null, $fname=__METHOD__, callable $inputCallback=null) | |
Read and execute commands from an open file handle. More... | |
startAtomic ( $fname=__METHOD__, $cancelable=self::ATOMIC_NOT_CANCELABLE) | |
Begin an atomic section of SQL statements. More... | |
streamStatementEnd (&$sql, &$newLine) | |
Called by sourceStream() to check if we've reached a statement end. More... | |
strreplace ( $orig, $old, $new) | |
Returns a command for str_replace function in SQL query. More... | |
tableLocksHaveTransactionScope () | |
Checks if table locks acquired by lockTables() are transaction-bound in their scope. 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... | |
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... | |
trxStatus () | |
trxTimestamp () | |
Get the UNIX timestamp of the time that the transaction was established. More... | |
unionConditionPermutations ( $table, $vars, array $permute_conds, $extra_conds='', $fname=__METHOD__, $options=[], $join_conds=[]) | |
Construct a UNION query for permutations of conditions. More... | |
unlockTables ( $method) | |
Unlock all tables locked via lockTables() More... | |
update ( $table, $values, $conds, $fname=__METHOD__, $options=[]) | |
UPDATE wrapper. More... | |
upsert ( $table, array $rows, $uniqueIndexes, array $set, $fname=__METHOD__) | |
INSERT ON DUPLICATE KEY UPDATE wrapper, upserts an array into a table. More... | |
useIndexClause ( $index) | |
USE INDEX clause. More... | |
wasConnectionLoss () | |
Determines if the last query error was due to a dropped connection. More... | |
wasErrorReissuable () | |
Determines if the last query error was due to something outside of the query itself. More... | |
wasLockTimeout () | |
Determines if the last failure was due to a lock timeout. More... | |
writesOrCallbacksPending () | |
Whether there is a transaction open with either possible write queries or unresolved pre-commit/commit/resolution callbacks pending. More... | |
writesPending () | |
Public Member Functions inherited from Wikimedia\Rdbms\IDatabase | |
buildSubString ( $input, $startPosition, $length=null) | |
Build a SUBSTRING function. More... | |
Static Public Member Functions | |
static | newInstance (array $p=[]) |
Static Public Member Functions inherited from Wikimedia\Rdbms\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 | newStandaloneInstance ( $filename, array $p=[]) |
Static Public Member Functions inherited from Wikimedia\Rdbms\Database | |
static | attributesFromType ( $dbType, $driver=null) |
static | factory ( $dbType, $p=[], $connect=self::NEW_CONNECTED) |
Construct a Database subclass instance given a database type and parameters. More... | |
static | getCacheSetOptions (IDatabase $db1, IDatabase $db2=null) |
Merge the result of getSessionLagStatus() for several DBs using the most pessimistic values to estimate the lag of any data derived from them in combination. More... | |
Additional Inherited Members | |
Public Attributes inherited from Wikimedia\Rdbms\Database | |
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... | |
const | PING_QUERY = 'SELECT 1 AS ping' |
const | PING_TTL = 1.0 |
How long before it is worth doing a dummy query to test the connection. More... | |
const | SLOW_WRITE_SEC = 0.500 |
const | SMALL_WRITE_ROWS = 100 |
const | TINY_WRITE_SEC = 0.010 |
Protected Member Functions inherited from Wikimedia\Rdbms\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... | |
doInitConnection () | |
Actually connect to the database over the wire (or to local files) More... | |
doQuery ( $sql) | |
SQLite doesn't allow buffered results or data seeking etc, so we'll use fetchAll as the result. More... | |
fetchAffectedRowCount () | |
getBindingHandle () | |
isTransactableQuery ( $sql) | |
Determine whether a SQL statement is sensitive to isolation level. More... | |
isWriteQuery ( $sql) | |
Determine whether a query writes to the DB. More... | |
makeUpdateOptionsArray ( $options) | |
open ( $server, $user, $pass, $dbName, $schema, $tablePrefix) | |
Open a new connection to the database (closing any existing one) More... | |
openFile ( $fileName, $dbName, $tablePrefix) | |
Opens a database file. More... | |
wasKnownStatementRollbackError () | |
Protected Member Functions inherited from Wikimedia\Rdbms\Database | |
assertBuildSubstringParams ( $startPosition, $length) | |
Check type and bounds for parameters to self::buildSubstring() More... | |
assertHasConnectionHandle () | |
Make sure there is an open connection handle (alive or not) as a sanity check. More... | |
assertIsWritableMaster () | |
Make sure that this server is not marked as a replica nor read-only as a sanity check. More... | |
doCommit ( $fname) | |
Issues the COMMIT command to the database server. More... | |
doLockTables (array $read, array $write, $method) | |
Helper function for lockTables() that handles the actual table locking. More... | |
doReleaseSavepoint ( $identifier, $fname) | |
Release a savepoint. More... | |
doRollback ( $fname) | |
Issues the ROLLBACK command to the database server. More... | |
doRollbackToSavepoint ( $identifier, $fname) | |
Rollback to a savepoint. More... | |
doSavepoint ( $identifier, $fname) | |
Create a savepoint. More... | |
doSelectDomain (DatabaseDomain $domain) | |
doUnlockTables ( $method) | |
Helper function for unlockTables() that handles the actual table unlocking. More... | |
escapeLikeInternal ( $s, $escapeChar='`') | |
extractSingleFieldFromList ( $var) | |
fieldNamesWithAlias ( $fields) | |
Gets an array of aliased field names. More... | |
fieldNameWithAlias ( $name, $alias=false) | |
Get an aliased field name e.g. More... | |
getApproximateLagStatus () | |
Get a replica DB lag estimate for this server. More... | |
getDefaultSchemaVars () | |
Get schema variables to use if none have been set via setSchemaVars(). More... | |
getLastPHPError () | |
getLazyMasterHandle () | |
getLogContext (array $extras=[]) | |
Create a log context to pass to PSR-3 logger functions. More... | |
getQueryVerb ( $sql) | |
getReadOnlyReason () | |
getRecordedTransactionLagStatus () | |
Get the replica DB lag when the current transaction started. More... | |
getSchemaVars () | |
Get schema variables. More... | |
getTransactionRoundId () | |
hasFlags ( $field, $flags) | |
indexName ( $index) | |
Allows for index remapping in queries where this is not consistent across DBMS. More... | |
installErrorHandler () | |
Set a custom error handler for logging errors during database connection. More... | |
isInsertSelectSafe (array $insertOptions, array $selectOptions) | |
makeGroupByWithHaving ( $options) | |
Returns an optional GROUP BY with an optional HAVING. More... | |
makeOrderBy ( $options) | |
Returns an optional ORDER BY. More... | |
makeUpdateOptions ( $options) | |
Make UPDATE options for the Database::update function. More... | |
nativeInsertSelect ( $destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[], $selectJoinConds=[]) | |
Native server-side implementation of insertSelect() for situations where we don't want to select everything into memory. More... | |
nativeReplace ( $table, $rows, $fname) | |
REPLACE query wrapper for MySQL and SQLite, which have a native REPLACE statement. More... | |
nonNativeInsertSelect ( $destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[], $selectJoinConds=[]) | |
Implementation of insertSelect() based on select() and insert() More... | |
normalizeConditions ( $conds, $fname) | |
qualifiedTableComponents ( $name) | |
Get the table components needed for a query given the currently selected database. More... | |
registerTempTableWrite ( $sql, $pseudoPermanent) | |
relationSchemaQualifier () | |
replaceLostConnection ( $fname) | |
Close any existing (dead) database connection and open a new connection. More... | |
restoreErrorHandler () | |
Restore the previous error handler and return the last PHP error for this DB. More... | |
resultObject ( $result) | |
Take the result from a query, and wrap it in a ResultWrapper if necessary. More... | |
tableNamesWithAlias ( $tables) | |
Gets an array of aliased table names. More... | |
tableNamesWithIndexClauseOrJOIN ( $tables, $use_index=[], $ignore_index=[], $join_conds=[]) | |
Get the aliased table name clause for a FROM clause which might have a JOIN and/or USE INDEX or IGNORE INDEX clause. More... | |
tableNameWithAlias ( $table, $alias=false) | |
Get an aliased table name. More... | |
wasQueryTimeout ( $error, $errno) | |
Checks whether the cause of the error is detected to be a timeout. More... | |
Static Protected Member Functions inherited from Wikimedia\Rdbms\DatabaseSqlite | |
static | getAttributes () |
Static Protected Member Functions inherited from Wikimedia\Rdbms\Database | |
static | generalizeSQL ( $sql) |
Removes most variables from an SQL query and replaces them with X or N for numbers. More... | |
Protected Attributes inherited from Wikimedia\Rdbms\DatabaseSqlite | |
PDO | $conn |
string | $dbDir |
Directory. More... | |
string | $dbPath |
File name for SQLite database file. More... | |
int | $lastAffectedRowCount |
The number of rows affected as an integer. More... | |
resource | $lastResultHandle |
FSLockManager | $lockMgr |
(hopefully on the same server as the DB) More... | |
string | $trxMode |
Transaction mode. More... | |
Protected Attributes inherited from Wikimedia\Rdbms\Database | |
integer null | $affectedRowCount |
Rows affected by the last query to query() or its CRUD wrappers. More... | |
string | $agent |
Agent name for query profiling. More... | |
bool | $cliMode |
Whether this PHP instance is for a CLI script. More... | |
object resource null | $conn = null |
Database connection. More... | |
array | $connectionParams = [] |
Parameters used by initConnection() to establish a connection. More... | |
LoggerInterface | $connLogger |
DatabaseDomain | $currentDomain |
string | $delimiter = ';' |
callable | $deprecationLogger |
Deprecation logging callback. More... | |
callable | $errorLogger |
Error logging callback. More... | |
int | $flags |
string bool null | $htmlErrors |
Stashed value of html_errors INI setting. More... | |
string[] | $indexAliases = [] |
Map of (index alias => index) More... | |
float | $lastPing = 0.0 |
UNIX timestamp. More... | |
string | $lastQuery = '' |
SQL query. More... | |
float bool | $lastWriteTime = false |
UNIX timestamp of last write query. More... | |
array | $lbInfo = [] |
int | $nonNativeInsertSelectBatchSize = 10000 |
bool | $opened = false |
string | $password |
Password used to establish the current connection. More... | |
string bool | $phpError = false |
array null | $preparedArgs |
callable null | $profiler |
LoggerInterface | $queryLogger |
array bool | $schemaVars = false |
string | $server |
Server that this instance is currently connected to. More... | |
array | $sessionTempTables = [] |
Map of (table name => 1) for TEMPORARY tables. More... | |
array | $sessionVars = [] |
BagOStuff | $srvCache |
APC cache. More... | |
array[] | $tableAliases = [] |
Map of (table => (dbname, schema, prefix) map) More... | |
array[] | $trxEndCallbacks = [] |
List of (callable, method name, atomic section id) More... | |
bool | $trxEndCallbacksSuppressed = false |
Whether to suppress triggering of transaction end callbacks. More... | |
array[] | $trxIdleCallbacks = [] |
List of (callable, method name, atomic section id) More... | |
int | $trxLevel = 0 |
Either 1 if a transaction is active or 0 otherwise. More... | |
array[] | $trxPreCommitCallbacks = [] |
List of (callable, method name, atomic section id) More... | |
TransactionProfiler | $trxProfiler |
callable[] | $trxRecurringCallbacks = [] |
Map of (name => callable) More... | |
string | $trxShortId = '' |
Either a short hexidecimal string if a transaction is active or "". More... | |
int | $trxStatus = self::STATUS_TRX_NONE |
Transaction status. More... | |
Exception null | $trxStatusCause |
The last error that caused the status to become STATUS_TRX_ERROR. More... | |
array null | $trxStatusIgnoredCause |
If wasKnownStatementRollbackError() prevented trxStatus from being set, the relevant details are stored here. More... | |
string | $user |
User that this instance is currently connected under the name of. More... | |
Definition at line 526 of file DatabaseSqliteTest.php.
|
static |
Definition at line 527 of file DatabaseSqliteTest.php.
Referenced by DatabaseSqliteTest\setUp().
DatabaseSqliteMock::query | ( | $sql, | |
$fname = '' , |
|||
$flags = 0 |
|||
) |
Run an SQL query and return the result.
Normally throws a DBQueryError on failure. If errors are ignored, returns false instead.
If a connection loss is detected, then an attempt to reconnect will be made. For queries that involve no larger transactions or locks, they will be re-issued for convenience, provided the connection was re-established.
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.
string | $sql | SQL query |
string | $fname | Name of the calling function, for profiling/SHOW PROCESSLIST comment (you can use METHOD or add some extra info) |
int | $flags | Bitfield of IDatabase::QUERY_* constants. Note that suppression of errors is best handled by try/catch rather than using one of these flags. |
DBError |
Reimplemented from Wikimedia\Rdbms\Database.
Definition at line 534 of file DatabaseSqliteTest.php.
Referenced by DatabaseSqliteTest\getColumns(), DatabaseSqliteTest\getIndexes(), DatabaseSqliteTest\testAddQuotes(), DatabaseSqliteTest\testCaseInsensitiveLike(), DatabaseSqliteTest\testDeleteJoin(), DatabaseSqliteTest\testDuplicateTableStructure(), DatabaseSqliteTest\testDuplicateTableStructureVirtual(), DatabaseSqliteTest\testInsertAffectedRows(), DatabaseSqliteTest\testInsertIdType(), and DatabaseSqliteTest\testNumFields().
DatabaseSqliteMock::replaceVars | ( | $s | ) |
Override parent visibility to public.
Reimplemented from Wikimedia\Rdbms\DatabaseSqlite.
Definition at line 541 of file DatabaseSqliteTest.php.
References $s.