Page MenuHomeWickedGov Phorge
Files F1430918

ThanksQueryHelper.php
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

ThanksQueryHelper.php
View Options

<?php
namespace MediaWiki\Extension\Thanks;
use MediaWiki\Title\TitleFactory;
use MediaWiki\User\UserIdentity;
use Wikimedia\Rdbms\DBAccessObjectUtils;
use Wikimedia\Rdbms\IConnectionProvider;
use Wikimedia\Rdbms\IDBAccessObject;
/**
* Query module
*/
class ThanksQueryHelper {
private TitleFactory $titleFactory;
private IConnectionProvider $dbProvider;
public function __construct( TitleFactory $titleFactory, IConnectionProvider $dbProvider ) {
$this->titleFactory = $titleFactory;
$this->dbProvider = $dbProvider;
}
/**
* Counts number of thanks a user has received. The query is not cached.
*
* @param UserIdentity $userIdentity
* @param int $limit cap the value of counts queried for performance
* @param int $flags database options. If calling in a POST context where a user is being thanked, the
* return value will be incorrect if returned from replica. This allows you to query primary if the
* exact number is important.
* @return int Number of thanks received for the user ID
*/
public function getThanksReceivedCount(
UserIdentity $userIdentity,
int $limit = 1000,
int $flags = IDBAccessObject::READ_NORMAL
): int {
$db = DBAccessObjectUtils::getDBFromRecency( $this->dbProvider, $flags );
$userPage = $this->titleFactory->newFromText( $userIdentity->getName(), NS_USER );
$logTitle = $userPage->getDBkey();
return $db->newSelectQueryBuilder()
->table( 'logging' )
->field( '1' )
// There is no type + target index, but there's a target index (log_page_time)
// and it's unlikely the user's page has many other log events than thanks,
// so the query should be okay.
->conds( [
'log_type' => 'thanks',
'log_action' => 'thank',
'log_namespace' => NS_USER,
'log_title' => $logTitle,
] )
->limit( $limit )
->caller( __METHOD__ )
->fetchRowCount();
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, May 16, 19:46 (3 h, 13 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
fd/9c/da3d922772a891f281aa6a94e425
Default Alt Text
ThanksQueryHelper.php (1 KB)

Event Timeline