|
| __toString () |
| Give an id for the connection. More...
|
|
| affectedRows () |
|
| getServerVersion () |
|
| insertId () |
|
| lastErrno () |
|
| selectDB ( $db) |
|
| 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=array()) |
| 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) |
|
| getLag () |
| Returns slave lag. More...
|
|
| getLagFromProcesslist () |
|
| getLagFromSlaveStatus () |
|
| 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...
|
|
| 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...
|
|
| numFields ( $res) |
|
| numRows ( $res) |
|
| open ( $server, $user, $password, $dbName) |
|
| ping () |
|
| replace ( $table, $uniqueIndexes, $rows, $fname=__METHOD__) |
|
| setBigSelects ( $value=true) |
|
| setFakeMaster ( $enabled=true) |
| Make this connection a fake master. More...
|
|
| setFakeSlaveLag ( $lag) |
| Set lag time in seconds for a fake slave. More...
|
|
| 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) |
|
| 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 ( $params=null) |
| Constructor. More...
|
|
| __destruct () |
| Run a few simple sanity checks. More...
|
|
| __sleep () |
| Called by serialize. 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=array()) |
| 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...
|
|
| doneWrites () |
| Returns true if the connection may have been used for write queries. 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...
|
|
| errorCount ( $count=null) |
| Get/set the number of errors logged. 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...
|
|
| getLBInfo ( $name=null) |
| Get properties passed down from the server info array of the load balancer. 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...
|
|
| getServerInfo () |
| A string describing the current software version, and possibly other details in a user-friendly way. 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...
|
|
| 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...
|
|
| indexUnique ( $table, $index) |
| Determines if a given index is unique. More...
|
|
| insert ( $table, $a, $fname=__METHOD__, $options=array()) |
| INSERT wrapper, inserts an array into a table. 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...
|
|
| isView ( $name) |
| Differentiates between a TABLE and a VIEW. More...
|
|
| isWriteQuery ( $sql) |
| Determine whether a query writes to the DB. 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| 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...
|
|
| update ( $table, $values, $conds, $fname=__METHOD__, $options=array()) |
| UPDATE wrapper. 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...
|
|