Generic class to cleanup a database table. More...

Inheritance diagram for TableCleanup:

[legend]

Collaboration diagram for TableCleanup:

[legend]

Public Member Functions
	__construct ()
	Default constructor.

	execute ()
	Do the actual work.

	runTable ( $params)

Public Member Functions inherited from Maintenance
function	__construct ()

	checkRequiredExtensions ()
	Verify that the required extensions are installed.

	cleanupChanneled ()
	Clean up channeled output.

	clearParamsAndArgs ()
	Clear all params and arguments.

function	execute ()

	finalSetup ()
	Handle some last-minute setup here.

	getConfig ()

	getDbType ()
	Does the script need different DB access? By default, we give Maintenance scripts normal rights to the DB.

	getName ()
	Get the script's name.

	globals ()
	Potentially debug globals.

	isQuiet ()

	loadParamsAndArgs ( $self=null, $opts=null, $args=null)
	Process command line arguments $mOptions becomes an array with keys set to the option names $mArgs becomes a zero-based array containing the non-option arguments.

	loadSettings ()
	Generic setup for most installs.

	loadWithArgv ( $argv)
	Load params and arguments from a given array of command-line arguments.

	memoryLimit ()
	Normally we disable the memory_limit when running admin scripts.

	outputChanneled ( $msg, $channel=null)
	Message outputter with channeled message support.

	purgeRedundantText ( $delete=true)
	Support function for cleaning up redundant text records.

	runChild ( $maintClass, $classFile=null)
	Run a child maintenance script.

	setAgentAndTriggers ()
	Set triggers like when to try to run deferred updates.

	setConfig (Config $config)

	setDB (IDatabase $db)
	Sets database object to be returned by getDB().

	setup ()
	Do some sanity checking and basic setup.

	updateSearchIndex ( $maxLockTime, $callback, $dbw, $results)
	Perform a search index update with locking.

	updateSearchIndexForPage ( $dbw, $pageId)
	Update the searchindex table for a given pageid.

Public Attributes
	$batchSize = 100

	$reportInterval = 100

Public Attributes inherited from Maintenance
resource	$fileHandle
	Used when creating separate schema files.

array	$orderedOptions = []
	Used to read the options in the order they were passed.

const	DB_ADMIN = 2

const	DB_NONE = 0
	Constants for DB access type.

const	DB_STD = 1

const	STDIN_ALL = 'all'

Protected Member Functions
	hexChar ( $matches)

	init ( $count, $table)

	progress ( $updated)

Protected Member Functions inherited from Maintenance
	activateProfiler ()
	Activate the profiler (assuming $wgProfiler is set)

	addArg ( $arg, $description, $required=true)
	Add some args that are needed.

	addDefaultParams ()
	Add the default parameters to the scripts.

	addDescription ( $text)
	Set the description text.

	addOption ( $name, $description, $required=false, $withArg=false, $shortName=false, $multiOccurrence=false)
	Add a parameter to the script.

	adjustMemoryLimit ()
	Adjusts PHP's memory limit to better suit our needs, if needed.

	afterFinalSetup ()
	Execute a callback function at the end of initialisation.

	beginTransaction (IDatabase $dbw, $fname)
	Begin a transcation on a DB.

	commitTransaction (IDatabase $dbw, $fname)
	Commit the transcation on a DB handle and wait for replica DBs to catch up.

	deleteOption ( $name)
	Remove an option.

	error ( $err, $die=0)
	Throw an error to the user.

	getArg ( $argId=0, $default=null)
	Get an argument.

	getDB ( $db, $groups=[], $wiki=false)
	Returns a database to be used by current maintenance script.

	getDir ()
	Get the maintenance directory.

	getOption ( $name, $default=null)
	Get an option, or return the default.

	getStdin ( $len=null)
	Return input from stdin.

	hasArg ( $argId=0)
	Does a given argument exist?

	hasOption ( $name)
	Checks to see if a particular param exists.

	loadSpecialVars ()
	Handle the special variables that are global to all scripts.

	maybeHelp ( $force=false)
	Maybe show the help.

	output ( $out, $channel=null)
	Throw some output to the user.

	requireExtension ( $name)
	Indicate that the specified extension must be loaded before the script can run.

	rollbackTransaction (IDatabase $dbw, $fname)
	Rollback the transcation on a DB handle.

	setBatchSize ( $s=0)
	Set the batch size.

	validateParamsAndArgs ()
	Run some validation checks on the params, etc.

Protected Attributes
	$count

	$defaultParams

	$dryrun = false

	$processed

	$startTime

	$table

	$updated

Protected Attributes inherited from Maintenance
	$mArgList = []

	$mArgs = []

int	$mBatchSize = null
	Batch size.

	$mDbPass

	$mDbUser

	$mDescription = ''

	$mInputLoaded = false

	$mOptions = []

	$mParams = []

	$mQuiet = false

	$mSelf

	$mShortParamsMap = []

Additional Inherited Members
Static Public Member Functions inherited from Maintenance
static	posix_isatty ( $fd)
	Wrapper for posix_isatty() We default as considering stdin a tty (for nice readline methods) but treating stout as not a tty to avoid color codes.

static	readconsole ( $prompt='> ')
	Prompt the console for input.

static	requireTestsAutoloader ()
	Call this to set up the autoloader to allow classes to be used from the tests directory.

static	setLBFactoryTriggers (LBFactory $LBFactory)

static	shouldExecute ()
	Should we execute the maintenance script, or just allow it to be included as a standalone class? It checks that the call stack only includes this function and "requires" (meaning was called from the file scope)

Detailed Description

Generic class to cleanup a database table.

Already subclasses Maintenance.

Definition at line 31 of file cleanupTable.inc.

Constructor & Destructor Documentation

◆ __construct()

TableCleanup::__construct ( )

Default constructor.

Children should call this first if implementing their own constructors

Reimplemented from Maintenance.

Reimplemented in CapsCleanup, ImageCleanup, TitleCleanup, and WatchlistCleanup.

Definition at line 45 of file cleanupTable.inc.

References Maintenance\addOption().

Member Function Documentation

◆ execute()

TableCleanup::execute ( )

Do the actual work.

All child classes will need to implement this

Reimplemented from Maintenance.

Reimplemented in CapsCleanup, and WatchlistCleanup.

Definition at line 50 of file cleanupTable.inc.

References $wgUser, global, Maintenance\hasOption(), output(), and runTable().

◆ hexChar()

TableCleanup::hexChar ( $matches )

protected

Parameters

array $matches

Returns: string

Definition at line 171 of file cleanupTable.inc.

References $matches.

◆ init()

TableCleanup::init	(	$count,
		$table
	)

protected

Definition at line 63 of file cleanupTable.inc.

References $count, $table, and table.

Referenced by runTable().

◆ progress()

TableCleanup::progress ( $updated )

protected

Parameters

int $updated

Definition at line 74 of file cleanupTable.inc.

References $count, $processed, $startTime, $updated, output(), table, TS_DB, wfTimestamp(), and wfWikiID().

Referenced by ImageCleanup\processRow(), TitleCleanup\processRow(), WatchlistCleanup\processRow(), CapsCleanup\processRowToLowercase(), and CapsCleanup\processRowToUppercase().

◆ runTable()

TableCleanup::runTable ( $params )

Parameters

array $params

Exceptions

MWException

Definition at line 108 of file cleanupTable.inc.

References $batchSize, $count, $dbr, $options, $params, $res, $table, array(), as, DB_REPLICA, Maintenance\getDB(), init(), and output().

Referenced by CapsCleanup\execute(), and execute().

Member Data Documentation

◆ $batchSize

TableCleanup::$batchSize = 100

Definition at line 40 of file cleanupTable.inc.

Referenced by runTable().

◆ $count

TableCleanup::$count

protected

Definition at line 43 of file cleanupTable.inc.

Referenced by init(), progress(), and runTable().

◆ $defaultParams

TableCleanup::$defaultParams

protected

Initial value:

= [
        'table' => 'page',
        'conds' => [],
        'index' => 'page_id',
        'callback' => 'processRow',
    ]

Definition at line 32 of file cleanupTable.inc.

◆ $dryrun

TableCleanup::$dryrun = false

protected

Definition at line 39 of file cleanupTable.inc.

◆ $processed

TableCleanup::$processed

protected

Definition at line 43 of file cleanupTable.inc.

Referenced by progress().

◆ $reportInterval

TableCleanup::$reportInterval = 100

Definition at line 41 of file cleanupTable.inc.

◆ $startTime

TableCleanup::$startTime

protected

Definition at line 43 of file cleanupTable.inc.

Referenced by progress().

◆ $table

TableCleanup::$table

protected

Definition at line 43 of file cleanupTable.inc.

Referenced by init(), and runTable().

◆ $updated

TableCleanup::$updated

protected

Definition at line 43 of file cleanupTable.inc.

Referenced by WatchlistCleanup\processRow(), and progress().

The documentation for this class was generated from the following file:

maintenance/cleanupTable.inc

Public Member Functions

Public Attributes

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ execute()

◆ hexChar()

◆ init()

◆ progress()

◆ runTable()

Member Data Documentation

◆ $batchSize

◆ $count

◆ $defaultParams

◆ $dryrun

◆ $processed

◆ $reportInterval

◆ $startTime

◆ $table

◆ $updated