X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FDatabaseFunctions.php;h=ad6e7f6c2221a48a8c1da508e7fa51dd23633296;hb=21e108b5fff02d1c38f1d7b047ec974799a43a3d;hp=37059696e445db194ab3bf3c1af5eaad45773219;hpb=b0c41ad13b4919a2b5fd2c3ba269ef399d183e64;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/DatabaseFunctions.php b/includes/DatabaseFunctions.php index 37059696e4..ad6e7f6c22 100644 --- a/includes/DatabaseFunctions.php +++ b/includes/DatabaseFunctions.php @@ -1,42 +1,40 @@ fatalError( wfMsgNoDB( 'wrong_wfQuery_params', $db, $sql ) ); + throw new FatalError( wfMsgNoDB( 'wrong_wfQuery_params', $db, $sql ) ); } - $c =& wfGetDB( $db ); + $c = wfGetDB( $db ); if ( $c !== false ) { return $c->query( $sql, $fname ); - } else { + } else { return false; } } /** * - * @param string $sql SQL query + * @param $sql String: SQL query * @param $dbi - * @param string $fname name of the php function calling - * @return array first row from the database + * @param $fname String: name of the php function calling + * @return Array: first row from the database */ function wfSingleQuery( $sql, $dbi, $fname = '' ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); $res = $db->query($sql, $fname ); $row = $db->fetchRow( $res ); $ret = $row[0]; @@ -44,15 +42,6 @@ function wfSingleQuery( $sql, $dbi, $fname = '' ) { return $ret; } -/* - * @todo document function - */ -function &wfGetDB( $db = DB_LAST, $groups = array() ) { - global $wgLoadBalancer; - $ret =& $wgLoadBalancer->getConnection( $db, true, $groups ); - return $ret; -} - /** * 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 @@ -65,7 +54,7 @@ function &wfGetDB( $db = DB_LAST, $groups = array() ) { * @return Returns the previous state. */ function wfIgnoreSQLErrors( $newstate, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->ignoreErrors( $newstate ); } else { @@ -74,21 +63,21 @@ function wfIgnoreSQLErrors( $newstate, $dbi = DB_LAST ) { } /**#@+ - * @param $res database result handler + * @param $res Database result handler * @param $dbi */ /** * Free a database result - * @return bool whether result is sucessful or not + * @return Bool: whether result is sucessful or not. */ -function wfFreeResult( $res, $dbi = DB_LAST ) -{ - $db =& wfGetDB( $dbi ); +function wfFreeResult( $res, $dbi = DB_LAST ) +{ + $db = wfGetDB( $dbi ); if ( $db !== false ) { - $db->freeResult( $res ); + $db->freeResult( $res ); return true; - } else { + } else { return false; } } @@ -97,11 +86,11 @@ function wfFreeResult( $res, $dbi = DB_LAST ) * Get an object from a database result * @return object|false object we requested */ -function wfFetchObject( $res, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfFetchObject( $res, $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->fetchObject( $res, $dbi = DB_LAST ); - } else { + return $db->fetchObject( $res, $dbi = DB_LAST ); + } else { return false; } } @@ -111,10 +100,10 @@ function wfFetchObject( $res, $dbi = DB_LAST ) { * @return object|false row we requested */ function wfFetchRow( $res, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->fetchRow ( $res, $dbi = DB_LAST ); - } else { + } else { return false; } } @@ -123,11 +112,11 @@ function wfFetchRow( $res, $dbi = DB_LAST ) { * Get a number of rows from a database result * @return integer|false number of rows */ -function wfNumRows( $res, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfNumRows( $res, $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->numRows( $res, $dbi = DB_LAST ); - } else { + return $db->numRows( $res, $dbi = DB_LAST ); + } else { return false; } } @@ -136,26 +125,28 @@ function wfNumRows( $res, $dbi = DB_LAST ) { * Get the number of fields from a database result * @return integer|false number of fields */ -function wfNumFields( $res, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfNumFields( $res, $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->numFields( $res ); - } else { + return $db->numFields( $res ); + } else { return false; } } /** * Return name of a field in a result - * @param integer $n id of the field + * @param $res Mixed: Ressource link see Database::fieldName() + * @param $n Integer: id of the field + * @param $dbi Default DB_LAST * @return string|false name of field */ -function wfFieldName( $res, $n, $dbi = DB_LAST ) -{ - $db =& wfGetDB( $dbi ); +function wfFieldName( $res, $n, $dbi = DB_LAST ) +{ + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->fieldName( $res, $n, $dbi = DB_LAST ); - } else { + return $db->fieldName( $res, $n, $dbi = DB_LAST ); + } else { return false; } } @@ -164,11 +155,11 @@ function wfFieldName( $res, $n, $dbi = DB_LAST ) /** * @todo document function */ -function wfInsertId( $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfInsertId( $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->insertId(); - } else { + return $db->insertId(); + } else { return false; } } @@ -176,11 +167,11 @@ function wfInsertId( $dbi = DB_LAST ) { /** * @todo document function */ -function wfDataSeek( $res, $row, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfDataSeek( $res, $row, $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->dataSeek( $res, $row ); - } else { + return $db->dataSeek( $res, $row ); + } else { return false; } } @@ -188,11 +179,11 @@ function wfDataSeek( $res, $row, $dbi = DB_LAST ) { /** * @todo document function */ -function wfLastErrno( $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfLastErrno( $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->lastErrno(); - } else { + return $db->lastErrno(); + } else { return false; } } @@ -200,11 +191,11 @@ function wfLastErrno( $dbi = DB_LAST ) { /** * @todo document function */ -function wfLastError( $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfLastError( $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->lastError(); - } else { + return $db->lastError(); + } else { return false; } } @@ -212,11 +203,11 @@ function wfLastError( $dbi = DB_LAST ) { /** * @todo document function */ -function wfAffectedRows( $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); +function wfAffectedRows( $dbi = DB_LAST ) { + $db = wfGetDB( $dbi ); if ( $db !== false ) { - return $db->affectedRows(); - } else { + return $db->affectedRows(); + } else { return false; } } @@ -225,94 +216,135 @@ function wfAffectedRows( $dbi = DB_LAST ) { * @todo document function */ function wfLastDBquery( $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->lastQuery(); - } else { + } else { return false; } } /** + * @see Database::Set() * @todo document function + * @param $table + * @param $var + * @param $value + * @param $cond + * @param $dbi Default DB_MASTER */ function wfSetSQL( $table, $var, $value, $cond, $dbi = DB_MASTER ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->set( $table, $var, $value, $cond ); - } else { + } else { return false; } } /** + * @see Database::selectField() * @todo document function + * @param $table + * @param $var + * @param $cond Default '' + * @param $dbi Default DB_LAST */ function wfGetSQL( $table, $var, $cond='', $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->selectField( $table, $var, $cond ); - } else { + } else { return false; } } /** + * @see Database::fieldExists() * @todo document function + * @param $table + * @param $field + * @param $dbi Default DB_LAST + * @return Result of Database::fieldExists() or false. */ function wfFieldExists( $table, $field, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->fieldExists( $table, $field ); - } else { + } else { return false; } } /** + * @see Database::indexExists() * @todo document function + * @param $table String + * @param $index + * @param $dbi Default DB_LAST + * @return Result of Database::indexExists() or false. */ function wfIndexExists( $table, $index, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->indexExists( $table, $index ); - } else { + } else { return false; } } /** + * @see Database::insert() * @todo document function + * @param $table String + * @param $array Array + * @param $fname String, default 'wfInsertArray'. + * @param $dbi Default DB_MASTER + * @return result of Database::insert() or false. */ function wfInsertArray( $table, $array, $fname = 'wfInsertArray', $dbi = DB_MASTER ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->insert( $table, $array, $fname ); - } else { + } else { return false; } } /** + * @see Database::getArray() * @todo document function + * @param $table String + * @param $vars + * @param $conds + * @param $fname String, default 'wfGetArray'. + * @param $dbi Default DB_LAST + * @return result of Database::getArray() or false. */ function wfGetArray( $table, $vars, $conds, $fname = 'wfGetArray', $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->getArray( $table, $vars, $conds, $fname ); - } else { + } else { return false; } } /** + * @see Database::update() + * @param $table String + * @param $values + * @param $conds + * @param $fname String, default 'wfUpdateArray' + * @param $dbi Default DB_MASTER + * @return Result of Database::update()) or false; * @todo document function */ function wfUpdateArray( $table, $values, $conds, $fname = 'wfUpdateArray', $dbi = DB_MASTER ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { $db->update( $table, $values, $conds, $fname ); return true; @@ -325,7 +357,7 @@ function wfUpdateArray( $table, $values, $conds, $fname = 'wfUpdateArray', $dbi * @todo document function */ function wfTableName( $name, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->tableName( $name ); } else { @@ -337,7 +369,7 @@ function wfTableName( $name, $dbi = DB_LAST ) { * @todo document function */ function wfStrencode( $s, $dbi = DB_LAST ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->strencode( $s ); } else { @@ -349,7 +381,7 @@ function wfStrencode( $s, $dbi = DB_LAST ) { * @todo document function */ function wfNextSequenceValue( $seqName, $dbi = DB_MASTER ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->nextSequenceValue( $seqName ); } else { @@ -361,11 +393,10 @@ function wfNextSequenceValue( $seqName, $dbi = DB_MASTER ) { * @todo document function */ function wfUseIndexClause( $index, $dbi = DB_SLAVE ) { - $db =& wfGetDB( $dbi ); + $db = wfGetDB( $dbi ); if ( $db !== false ) { return $db->useIndexClause( $index ); } else { return false; } } -?>