|
| | __construct () |
| |
| | affectedRows () |
| | Get the number of rows affected by the last write query. More...
|
| |
| | getServerVersion () |
| | A string describing the current software version, like from mysql_get_server_info(). More...
|
| |
| | insertId () |
| | Get the inserted value of an auto-increment row. More...
|
| |
| | lastErrno () |
| | Get the last error number. More...
|
| |
| | __construct (array $params) |
| | Additional $params include: More...
|
| |
| | addIdentifierQuotes ($s) |
| | MySQL uses backticks for identifier quoting instead of the sql standard "double quotes". More...
|
| |
| | dataSeek ($res, $row) |
| |
| | deleteJoin ($delTable, $joinTable, $delVar, $joinVar, $conds, $fname=__METHOD__) |
| | DELETE where the condition is a join. More...
|
| |
| | dropTable ($tableName, $fName=__METHOD__) |
| |
| | duplicateTableStructure ($oldName, $newName, $temporary=false, $fname=__METHOD__) |
| |
| | estimateRowCount ($table, $vars= '*', $conds= '', $fname=__METHOD__, $options=[]) |
| | Estimate rows in dataset Returns estimated count, based on EXPLAIN output Takes same arguments as Database::select() More...
|
| |
| | fetchObject ($res) |
| |
| | fetchRow ($res) |
| |
| | fieldInfo ($table, $field) |
| |
| | fieldName ($res, $n) |
| |
| | fieldType ($res, $n) |
| | mysql_field_type() wrapper More...
|
| |
| | freeResult ($res) |
| |
| | getApproximateLagStatus () |
| |
| | getLag () |
| | Get slave lag. More...
|
| |
| | getMasterPos () |
| | Get the position of the master from SHOW MASTER STATUS. More...
|
| |
| | getMysqlStatus ($which="%") |
| | Get status information from SHOW STATUS in an associative array. More...
|
| |
| | getSearchEngine () |
| | Get search engine class. More...
|
| |
| | getServerUptime () |
| | Determines how long the server has been up. More...
|
| |
| | getServerVersion () |
| |
| | getSlavePos () |
| | Get the position of the master from SHOW SLAVE STATUS. More...
|
| |
| | getSoftwareLink () |
| |
| | getType () |
| |
| | indexInfo ($table, $index, $fname=__METHOD__) |
| | Get information about an index into an object Returns false if the index does not exist. More...
|
| |
| | isQuotedIdentifier ($name) |
| |
| | isView ($name, $prefix=null) |
| | Differentiates between a TABLE and a VIEW. More...
|
| |
| | lastError () |
| |
| | listTables ($prefix=null, $fname=__METHOD__) |
| | List all tables on the database. More...
|
| |
| | listViews ($prefix=null, $fname=__METHOD__) |
| | Lists VIEWs in the database. More...
|
| |
| | lock ($lockName, $method, $timeout=5) |
| |
| | lockIsFree ($lockName, $method) |
| | Check to see if a named lock is available. More...
|
| |
| | lockTables ($read, $write, $method, $lowPriority=true) |
| |
| | lowPriorityOption () |
| |
| | masterPosWait (DBMasterPos $pos, $timeout) |
| | Wait for the slave to catch up to a given master position. More...
|
| |
| | namedLocksEnqueue () |
| | Check to see if a named lock used by lock() use blocking queues. More...
|
| |
| | numFields ($res) |
| |
| | numRows ($res) |
| |
| | open ($server, $user, $password, $dbName) |
| |
| | ping () |
| |
| | replace ($table, $uniqueIndexes, $rows, $fname=__METHOD__) |
| |
| | setBigSelects ($value=true) |
| |
| | setSessionOptions (array $options) |
| |
| | streamStatementEnd (&$sql, &$newLine) |
| |
| | strencode ($s) |
| |
| | unlock ($lockName, $method) |
| | FROM MYSQL DOCS: http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_release-lock. More...
|
| |
| | unlockTables ($method) |
| |
| | upsert ($table, array $rows, array $uniqueIndexes, array $set, $fname=__METHOD__) |
| |
| | useIndexClause ($index) |
| |
| | wasConnectionError ($errno) |
| |
| | wasDeadlock () |
| | Determines if the last failure was due to a deadlock. More...
|
| |
| | wasErrorReissuable () |
| | Determines if the last query error was something that should be dealt with by pinging the connection and reissuing the query. More...
|
| |
| | wasLockTimeout () |
| | Determines if the last failure was due to a lock timeout. More...
|
| |
| | wasReadOnlyError () |
| | Determines if the last failure was due to the database being read-only. More...
|
| |
| | __construct (array $params) |
| | Constructor. More...
|
| |
| | __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...
|
| |
| | addQuotes ($s) |
| | Adds quotes and backslashes. 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...
|
| |
| | 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...
|
| |
| | 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...
|
| |
| | 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...
|
| |
| | deadlockLoop () |
| | Perform a deadlock-prone transaction. More...
|
| |
| | debug ($debug=null) |
| | Boolean, controls output of large amounts of debug information. More...
|
| |
| | decodeBlob ($b) |
| | Some DBMSs return a special placeholder object representing blob fields in result objects. 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, $callback) |
| | Run a callback to do an atomic set of updates for this database. More...
|
| |
| | doneWrites () |
| | Returns true if the connection may have been used for write queries. More...
|
| |
| | dropTable ($tableName, $fName=__METHOD__) |
| | Delete a table. More...
|
| |
| | duplicateTableStructure ($oldName, $newName, $temporary=false, $fname=__METHOD__) |
| | Creates a new table with structure copied from existing table Note that unlike most database abstraction functions, this function does not automatically append database prefix, because it works at a lower abstraction level. More...
|
| |
| | encodeBlob ($b) |
| | Some DBMSs have a special format for inserting into blob fields, they don't allow simple quoted strings to be inserted. 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, $vars= '*', $conds= '', $fname=__METHOD__, $options=[]) |
| | Estimate the number of 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...
|
| |
| | freeResult ($res) |
| | Free a result object returned by query() or select(). More...
|
| |
| | functionalIndexes () |
| | Returns true if this database can use functional indexes. More...
|
| |
| | getApproximateLagStatus () |
| | Get a slave lag estimate for this server. 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...
|
| |
| | getLazyMasterHandle () |
| |
| | 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...
|
| |
| | getScopedLockAndFlush ($lockKey, $fname, $timeout) |
| | Acquire a named lock, flush any transaction, and return an RAII style unlocker object. More...
|
| |
| | getSearchEngine () |
| | Get search engine class. 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 STUB. More...
|
| |
| | getSessionLagStatus () |
| | Get the slave lag when the current transaction started or a general lag estimate if not transaction is active. More...
|
| |
| | getSlavePos () |
| | Get the replication position of this slave. More...
|
| |
| | getTransactionLagStatus () |
| | Get the slave lag when the current transaction started. More...
|
| |
| | getUpdateKeysPath () |
| | Return a path to the DBMS-specific update key file, otherwise default to update-keys.sql. More...
|
| |
| | getWikiID () |
| |
| | implicitGroupby () |
| | Returns true if this database does an implicit sort when doing GROUP BY. 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...
|
| |
| | indexInfo ($table, $index, $fname=__METHOD__) |
| | Get information about an index into an object. More...
|
| |
| | indexUnique ($table, $index) |
| | Determines if a given index is unique. More...
|
| |
| | insert ($table, $a, $fname=__METHOD__, $options=[]) |
| | INSERT wrapper, inserts an array into a table. More...
|
| |
| | insertSelect ($destTable, $srcTable, $varMap, $conds, $fname=__METHOD__, $insertOptions=[], $selectOptions=[]) |
| | 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 () |
| |
| | isView ($name) |
| | Differentiates between a TABLE and a VIEW. More...
|
| |
| | 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...
|
| |
| | listTables ($prefix=null, $fname=__METHOD__) |
| | List all tables on the database. More...
|
| |
| | listViews ($prefix=null, $fname=__METHOD__) |
| | Lists all the VIEWs in the database. More...
|
| |
| | lock ($lockName, $method, $timeout=5) |
| | Acquire a named lock. More...
|
| |
| | lockIsFree ($lockName, $method) |
| | Check to see if a named lock is available (non-blocking) 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...
|
| |
| | makeSelectOptions ($options) |
| | Returns an optional USE INDEX clause to go after the table, and a string to go at the end of the query. 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...
|
| |
| | namedLocksEnqueue () |
| | Check to see if a named lock used by lock() use blocking queues. 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...
|
| |
| | pendingWriteCallers () |
| | Get the list of method names that did write queries for this transaction. More...
|
| |
| | pendingWriteQueryDuration () |
| | Get the time spend running write queries for this transaction. More...
|
| |
| | ping () |
| | Ping the server and try to reconnect if it there is no connection. More...
|
| |
| | query ($sql, $fname=__METHOD__, $tempIgnore=false) |
| | Run an SQL query and return the result. More...
|
| |
| | realTimestamps () |
| | Returns true if this database uses timestamps rather than integers. More...
|
| |
| | replace ($table, $uniqueIndexes, $rows, $fname=__METHOD__) |
| | REPLACE query wrapper. More...
|
| |
| | reportConnectionError ($error= 'Unknown error') |
| |
| | reportQueryError ($error, $errno, $sql, $fname, $tempIgnore=false) |
| | Report a query error. 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=[], $join_conds=[]) |
| | 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=[]) |
| | A SELECT wrapper which returns a single field from a single result row. More...
|
| |
| | selectFieldValues ($table, $var, $cond= '', $fname=__METHOD__, $options=[], $join_conds=[]) |
| |
| | selectRow ($table, $vars, $conds, $fname=__METHOD__, $options=[], $join_conds=[]) |
| | Single row SELECT wrapper. More...
|
| |
| | selectRowCount ($tables, $vars= '*', $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...
|
| |
| | setBigSelects ($value=true) |
| | Allow or deny "big selects" for this session only. More...
|
| |
| | setFileHandle ($fh) |
| | Set the filehandle to copy write statements to. More...
|
| |
| | setFlag ($flag) |
| | Set a flag for this connection. 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...
|
| |
| | 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...
|
| |
| | setTransactionProfiler (TransactionProfiler $profiler) |
| |
| | 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...
|
| |
| | strencode ($s) |
| | Wrapper for addslashes() 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...
|
| |
| | tableName ($name, $format= 'quoted') |
| | Format a table name ready for use in constructing an SQL query. 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...
|
| |
| | textFieldSize ($table, $field) |
| | Returns the size of a text field, or -1 for "unlimited". 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...
|
| |
| | trxTimestamp () |
| | Get the UNIX timestamp of the time that the transaction was established. More...
|
| |
| | unionQueries ($sqls, $all) |
| | Construct a UNION query This is used for providing overload point for other DB abstractions not compatible with the MySQL syntax. More...
|
| |
| | unionSupportsOrderAndLimit () |
| | Returns true if current database backend supports ORDER BY or LIMIT for separate subqueries within the UNION construct. More...
|
| |
| | unlock ($lockName, $method) |
| | Release a lock. More...
|
| |
| | unlockTables ($method) |
| | Unlock specific tables. More...
|
| |
| | update ($table, $values, $conds, $fname=__METHOD__, $options=[]) |
| | 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...
|
| |
| | wasConnectionError ($errno) |
| | Determines if the given query error was a connection drop STUB. More...
|
| |
| | wasDeadlock () |
| | Determines if the last failure was due to a deadlock STUB. More...
|
| |
| | wasErrorReissuable () |
| | Determines if the last query error was something that should be dealt with by pinging the connection and reissuing the query. More...
|
| |
| | wasLockTimeout () |
| | Determines if the last failure was due to a lock timeout STUB. More...
|
| |
| | wasReadOnlyError () |
| | Determines if the last failure was due to the database being read-only. 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...
|
| |
| | writesPending () |
| |
| | selectFieldValues ($table, $var, $cond= '', $fname=__METHOD__, $options=[]) |
| | A SELECT wrapper which returns a list of single field values from result rows. More...
|
| |
Public Member Functions inherited from DatabaseMysqlBase