36 const TRIGGER_IDLE = 1;
38 const TRIGGER_COMMIT = 2;
40 const TRIGGER_ROLLBACK = 3;
43 const TRANSACTION_EXPLICIT =
'';
45 const TRANSACTION_INTERNAL =
'implicit';
48 const FLUSHING_ALL_PEERS =
'flush';
50 const FLUSHING_INTERNAL =
'flush';
53 const REMEMBER_NOTHING =
'';
55 const REMEMBER_PRIOR =
'remember';
57 const RESTORE_PRIOR =
'prior';
59 const RESTORE_INITIAL =
'initial';
62 const ESTIMATE_TOTAL =
'total';
64 const ESTIMATE_DB_APPLY =
'apply';
168 public function dbSchema( $schema = null );
289 public function setFlag( $flag, $remember = self::REMEMBER_NOTHING );
303 public function clearFlag( $flag, $remember = self::REMEMBER_NOTHING );
311 public function restoreFlags( $state = self::RESTORE_PRIOR );
323 public function getFlag( $flag );
354 public function open( $server,
$user, $password, $dbName );
454 public function fieldInfo( $table, $field );
489 public function close();
519 public function query( $sql,
$fname = __METHOD__, $tempIgnore =
false );
967 public function aggregateValue( $valuedata, $valuename =
'value' );
973 public function bitNot( $field );
980 public function bitAnd( $fieldLeft, $fieldRight );
987 public function bitOr( $fieldLeft, $fieldRight );
1014 $delim, $table, $field, $conds =
'', $join_conds = []
1119 public function replace( $table, $uniqueIndexes, $rows,
$fname = __METHOD__ );
1179 public function deleteJoin( $delTable, $joinTable, $delVar, $joinVar, $conds,
1193 public function delete( $table, $conds,
$fname = __METHOD__ );
1221 public function insertSelect( $destTable, $srcTable, $varMap, $conds,
1222 $fname = __METHOD__,
1223 $insertOptions = [], $selectOptions = []
1252 public function conditional( $cond, $trueVal, $falseVal );
1264 public function strreplace( $orig, $old, $new );
1428 public function startAtomic( $fname = __METHOD__ );
1441 public function endAtomic( $fname = __METHOD__ );
1492 public function begin( $fname = __METHOD__, $mode = self::TRANSACTION_EXPLICIT );
1514 public function commit( $fname = __METHOD__, $flush =
'' );
1534 public function rollback( $fname = __METHOD__, $flush =
'' );
1558 public function listTables( $prefix = null, $fname = __METHOD__ );
1594 public function ping( &$rtt = null );
1605 public function getLag();
1679 public function lockIsFree( $lockName, $method );
1691 public function lock( $lockName, $method, $timeout = 5 );
1705 public function unlock( $lockName, $method );
lastDoneWrites()
Returns the last time the connection may have been used for write queries.
setSchemaVars($vars)
Set variables to be used in sourceFile/sourceStream, in preference to the ones in $GLOBALS...
anyString()
Returns a token for buildLike() that denotes a '' to be used in a LIKE query.
insert($table, $a, $fname=__METHOD__, $options=[])
INSERT wrapper, inserts an array into a table.
selectRow($table, $vars, $conds, $fname=__METHOD__, $options=[], $join_conds=[])
Single row SELECT wrapper.
the array() calling protocol came about after MediaWiki 1.4rc1.
aggregateValue($valuedata, $valuename= 'value')
Return aggregated value alias.
wasErrorReissuable()
Determines if the last query error was due to a dropped connection and should be dealt with by pingin...
dbSchema($schema=null)
Get/set the db schema.
onTransactionResolution(callable $callback, $fname=__METHOD__)
Run a callback as soon as the current transaction commits or rolls back.
Apache License January AND DISTRIBUTION Definitions License shall mean the terms and conditions for use
getDBname()
Get the current DB name.
lastQuery()
Return the last query that went through IDatabase::query()
indexExists($table, $index, $fname=__METHOD__)
Determines whether an index exists Usually throws a DBQueryError on failure If errors are explicitly ...
close()
Closes a database connection.
open($server, $user, $password, $dbName)
Open a connection to the database.
isOpen()
Is a connection to the database open?
query($sql, $fname=__METHOD__, $tempIgnore=false)
Run an SQL query and return the result.
getMasterPos()
Get the position of this master.
unionQueries($sqls, $all)
Construct a UNION query This is used for providing overload point for other DB abstractions not compa...
getServerInfo()
A string describing the current software version, and possibly other details in a user-friendly way...
lock($lockName, $method, $timeout=5)
Acquire a named lock.
getServerVersion()
A string describing the current software version, like from mysql_get_server_info().
fieldName($res, $n)
Get a field name in a result object.
bitAnd($fieldLeft, $fieldRight)
trxTimestamp()
Get the UNIX timestamp of the time that the transaction was established.
tableExists($table, $fname=__METHOD__)
Query whether a given table exists.
onTransactionIdle(callable $callback, $fname=__METHOD__)
Run a callback as soon as there is no transaction pending.
lastError()
Get a description of the last error.
selectDB($db)
Change the current database.
An object representing a master or replica DB position in a replicated setup.
upsert($table, array $rows, array $uniqueIndexes, array $set, $fname=__METHOD__)
INSERT ON DUPLICATE KEY UPDATE wrapper, upserts an array into a table.
fieldInfo($table, $field)
mysql_fetch_field() wrapper Returns false if the field doesn't exist
timestamp($ts=0)
Convert a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting ...
getType()
Get the type of the DBMS, as it appears in $wgDBtype.
lastErrno()
Get the last error number.
getInfinity()
Find out when 'infinity' is.
masterPosWait(DBMasterPos $pos, $timeout)
Wait for the replica DB to catch up to a given master position.
this hook is for auditing only RecentChangesLinked and Watchlist RecentChangesLinked and Watchlist e g Watchlist & $tables
setTableAliases(array $aliases)
Make certain table names use their own database, schema, and table prefix when passed into SQL querie...
trxLevel()
Gets the current transaction level.
estimateRowCount($table, $vars= '*', $conds= '', $fname=__METHOD__, $options=[])
Estimate the number of rows in dataset.
maxListLen()
Return the maximum number of items allowed in a list, or 0 for unlimited.
affectedRows()
Get the number of rows affected by the last write query.
setLBInfo($name, $value=null)
Set the LB info array, or a member of it.
makeList($a, $mode=self::LIST_COMMA)
Makes an encoded list of strings from an array.
dataSeek($res, $row)
Change the position of the cursor in a result object.
lockIsFree($lockName, $method)
Check to see if a named lock is available (non-blocking)
makeWhereFrom2d($data, $baseKey, $subKey)
Build a partial where clause from a 2-d array such as used for LinkBatch.
reportConnectionError($error= 'Unknown error')
wasLockTimeout()
Determines if the last failure was due to a lock timeout.
getSessionLagStatus()
Get the replica DB lag when the current transaction started or a general lag estimate if not transact...
listTables($prefix=null, $fname=__METHOD__)
List all tables on the database.
setFlag($flag, $remember=self::REMEMBER_NOTHING)
Set a flag for this connection.
getLag()
Get replica DB lag.
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.
timestampOrNull($ts=null)
Convert a timestamp in one of the formats accepted by wfTimestamp() to the format used for inserting ...
this hook is for auditing only RecentChangesLinked and Watchlist RecentChangesLinked and Watchlist e g Watchlist removed from all revisions and log entries to which it was applied This gives extensions a chance to take it off their books as the deletion has already been partly carried out by this point or something similar the user will be unable to create the tag set and then return false from the hook function Ensure you consume the ChangeTagAfterDelete hook to carry out custom deletion actions as context called by AbstractContent::getParserOutput May be used to override the normal model specific rendering of page content as context as context $options
selectFieldValues($table, $var, $cond= '', $fname=__METHOD__, $options=[])
A SELECT wrapper which returns a list of single field values from result rows.
fetchObject($res)
Fetch the next row from the given result object, in object form.
freeResult($res)
Free a result object returned by query() or select().
unlock($lockName, $method)
Release a lock.
setLazyMasterHandle(IDatabase $conn)
Set a lazy-connecting DB handle to the master DB (for replication status purposes) ...
namedLocksEnqueue()
Check to see if a named lock used by lock() use blocking queues.
buildGroupConcatField($delim, $table, $field, $conds= '', $join_conds=[])
Build a GROUP_CONCAT or equivalent statement for a query.
bufferResults($buffer=null)
Turns buffering of SQL result sets on (true) or off (false).
writesOrCallbacksPending()
Returns true if there is a transaction open with possible write queries or transaction pre-commit/idl...
const TS_MW
MediaWiki concatenated string timestamp (YYYYMMDDHHMMSS)
selectField($table, $var, $cond= '', $fname=__METHOD__, $options=[])
A SELECT wrapper which returns a single field from a single result row.
selectRowCount($tables, $vars= '*', $conds= '', $fname=__METHOD__, $options=[], $join_conds=[])
Get the number of rows in dataset.
endAtomic($fname=__METHOD__)
Ends an atomic section of SQL statements.
onTransactionPreCommitOrIdle(callable $callback, $fname=__METHOD__)
Run a callback before the current transaction commits or now if there is none.
bitOr($fieldLeft, $fieldRight)
getFlag($flag)
Returns a boolean whether the flag $flag is set for this connection.
deleteJoin($delTable, $joinTable, $delVar, $joinVar, $conds, $fname=__METHOD__)
DELETE where the condition is a join.
wasDeadlock()
Determines if the last failure was due to a deadlock.
fieldExists($table, $field, $fname=__METHOD__)
Determines whether a field exists in a table.
decodeExpiry($expiry, $format=TS_MW)
Decode an expiry time into a DBMS independent format.
buildConcat($stringList)
Build a concatenation list to feed into a SQL query.
replace($table, $uniqueIndexes, $rows, $fname=__METHOD__)
REPLACE query wrapper.
startAtomic($fname=__METHOD__)
Begin an atomic section of statements.
fetchRow($res)
Fetch the next row from the given result object, in associative array form.
please add to it if you re going to add events to the MediaWiki code where normally authentication against an external auth plugin would be creating a local account $user
pendingWriteQueryDuration($type=self::ESTIMATE_TOTAL)
Get the time spend running write queries for this transaction.
begin($fname=__METHOD__, $mode=self::TRANSACTION_EXPLICIT)
Begin a transaction.
numRows($res)
Get the number of rows in a result object.
getServerUptime()
Determines how long the server has been up.
commit($fname=__METHOD__, $flush= '')
Commits a transaction previously started using begin().
getReplicaPos()
Get the replication position of this replica DB.
strreplace($orig, $old, $new)
Returns a comand for str_replace function in SQL query.
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
anyChar()
Returns a token for buildLike() that denotes a '_' to be used in a LIKE query.
buildLike()
LIKE statement wrapper, receives a variable-length argument list with parts of pattern to match conta...
clearFlag($flag, $remember=self::REMEMBER_NOTHING)
Clear a flag for this connection.
restoreFlags($state=self::RESTORE_PRIOR)
Restore the flags to their prior state before the last setFlag/clearFlag call.
doneWrites()
Returns true if the connection may have been used for write queries.
getWikiID()
Alias for getDomainID()
implicitOrderby()
Returns true if this database does an implicit order by when the column has an index For example: SEL...
if(!defined( 'MEDIAWIKI')) $fname
This file is not a valid entry point, perform no further processing unless MEDIAWIKI is defined...
nextSequenceValue($seqName)
Returns an appropriately quoted sequence value for inserting a new row.
getSoftwareLink()
Returns a wikitext link to the DB's website, e.g., return "[http://www.mysql.com/ MySQL]"; Should at ...
pendingWriteCallers()
Get the list of method names that did write queries for this transaction.
insertId()
Get the inserted value of an auto-increment row.
doAtomicSection($fname, callable $callback)
Run a callback to do an atomic set of updates for this database.
insertSelect($destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[])
INSERT SELECT wrapper.
getServer()
Get the server hostname or IP address.
unionSupportsOrderAndLimit()
Returns true if current database backend supports ORDER BY or LIMIT for separate subqueries within th...
encodeExpiry($expiry)
Encode an expiry time into the DBMS dependent format.
tablePrefix($prefix=null)
Get/set the table prefix.
getLBInfo($name=null)
Get properties passed down from the server info array of the load balancer.
encodeBlob($b)
Some DBMSs have a special format for inserting into blob fields, they don't allow simple quoted strin...
addQuotes($s)
Adds quotes and backslashes.
rollback($fname=__METHOD__, $flush= '')
Rollback a transaction previously started using begin().
decodeBlob($b)
Some DBMSs return a special placeholder object representing blob fields in result objects...
setBigSelects($value=true)
Allow or deny "big selects" for this session only.
ping(&$rtt=null)
Ping the server and try to reconnect if it there is no connection.
select($table, $vars, $conds= '', $fname=__METHOD__, $options=[], $join_conds=[])
Execute a SELECT query constructed using the various parameters provided.
indexUnique($table, $index)
Determines if a given index is unique.
reportQueryError($error, $errno, $sql, $fname, $tempIgnore=false)
Report a query error.
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
conditional($cond, $trueVal, $falseVal)
Returns an SQL expression for a simple conditional.
setTransactionListener($name, callable $callback=null)
Run a callback each time any transaction commits or rolls back.
do that in ParserLimitReportFormat instead use this to modify the parameters of the image and a DIV can begin in one section and end in another Make sure your code can handle that case gracefully See the EditSectionClearerLink extension for an example zero but section is usually empty its values are the globals values before the output is cached one of or reset my talk my contributions etc etc otherwise the built in rate limiting checks are if enabled allows for interception of redirect as a string mapping parameter names to values & $type
numFields($res)
Get the number of fields in a result object.
implicitGroupby()
Returns true if this database does an implicit sort when doing GROUP BY.
getScopedLockAndFlush($lockKey, $fname, $timeout)
Acquire a named lock, flush any transaction, and return an RAII style unlocker object.
update($table, $values, $conds, $fname=__METHOD__, $options=[])
UPDATE wrapper.
wasReadOnlyError()
Determines if the last failure was due to the database being read-only.
Basic database interface for live and lazy-loaded relation database handles.
flushSnapshot($fname=__METHOD__)
Commit any transaction but error out if writes or callbacks are pending.
Allows to change the fields on the form that will be generated $name
setSessionOptions(array $options)
Override database's default behavior.