Page Menu
Home
WickedGov Phorge
Search
Configure Global Search
Log In
Files
F5943686
deleteArchivedFiles.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Flag For Later
Award Token
Size
4 KB
Referenced Files
None
Subscribers
None
deleteArchivedFiles.php
View Options
<?php
/**
* Delete archived (non-current) files from the database
*
* Based on deleteOldRevisions.php by Rob Church.
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License along
* with this program; if not, write to the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
* http://www.gnu.org/copyleft/gpl.html
*
* @file
* @ingroup Maintenance
*/
// @codeCoverageIgnoreStart
require_once
__DIR__
.
'/Maintenance.php'
;
// @codeCoverageIgnoreEnd
/**
* Maintenance script to delete archived (non-current) files from the database.
*
* @ingroup Maintenance
*/
class
DeleteArchivedFiles
extends
Maintenance
{
public
function
__construct
()
{
parent
::
__construct
();
$this
->
addDescription
(
'Deletes all archived images.'
);
$this
->
addOption
(
'delete'
,
'Perform the deletion'
);
$this
->
addOption
(
'force'
,
'Force deletion of rows from filearchive'
);
}
public
function
execute
()
{
if
(
!
$this
->
hasOption
(
'delete'
)
)
{
$this
->
output
(
"Use --delete to actually confirm this script
\n
"
);
return
;
}
# Data should come off the master, wrapped in a transaction
$dbw
=
$this
->
getPrimaryDB
();
$this
->
beginTransaction
(
$dbw
,
__METHOD__
);
$repo
=
$this
->
getServiceContainer
()->
getRepoGroup
()->
getLocalRepo
();
# Get "active" revisions from the filearchive table
$this
->
output
(
"Searching for and deleting archived files...
\n
"
);
$res
=
$dbw
->
newSelectQueryBuilder
()
->
select
(
[
'fa_id'
,
'fa_storage_group'
,
'fa_storage_key'
,
'fa_sha1'
,
'fa_name'
]
)
->
from
(
'filearchive'
)
->
caller
(
__METHOD__
)
->
fetchResultSet
();
$count
=
0
;
foreach
(
$res
as
$row
)
{
$key
=
$row
->
fa_storage_key
;
if
(
!
strlen
(
$key
)
)
{
$this
->
output
(
"Entry with ID {$row->fa_id} has empty key, skipping
\n
"
);
continue
;
}
$file
=
$repo
->
newFile
(
$row
->
fa_name
);
$status
=
$file
->
acquireFileLock
(
10
);
if
(
!
$status
->
isOK
()
)
{
$this
->
error
(
"Could not acquire lock on '{$row->fa_name}', skipping
\n
"
);
continue
;
}
$group
=
$row
->
fa_storage_group
;
$id
=
$row
->
fa_id
;
$path
=
$repo
->
getZonePath
(
'deleted'
)
.
'/'
.
$repo
->
getDeletedHashPath
(
$key
)
.
$key
;
if
(
isset
(
$row
->
fa_sha1
)
)
{
$sha1
=
$row
->
fa_sha1
;
}
else
{
// old row, populate from key
$sha1
=
LocalRepo
::
getHashFromKey
(
$key
);
}
// Check if the file is used anywhere...
$inuse
=
(
bool
)
$dbw
->
newSelectQueryBuilder
()
->
select
(
'1'
)
->
from
(
'oldimage'
)
->
where
(
[
'oi_sha1'
=>
$sha1
,
$dbw
->
bitAnd
(
'oi_deleted'
,
File
::
DELETED_FILE
)
=>
File
::
DELETED_FILE
]
)
->
caller
(
__METHOD__
)
->
forUpdate
()
->
fetchField
();
$needForce
=
true
;
if
(
!
$repo
->
fileExists
(
$path
)
)
{
$this
->
output
(
"Notice - file '$key' not found in group '$group'
\n
"
);
}
elseif
(
$inuse
)
{
$this
->
output
(
"Notice - file '$key' is still in use
\n
"
);
}
elseif
(
!
$repo
->
quickPurge
(
$path
)
)
{
$this
->
output
(
"Unable to remove file $path, skipping
\n
"
);
$file
->
releaseFileLock
();
// don't delete even with --force
continue
;
}
else
{
$needForce
=
false
;
}
if
(
$needForce
)
{
if
(
$this
->
hasOption
(
'force'
)
)
{
$this
->
output
(
"Got --force, deleting DB entry
\n
"
);
}
else
{
$file
->
releaseFileLock
();
continue
;
}
}
$count
++;
$dbw
->
newDeleteQueryBuilder
()
->
deleteFrom
(
'filearchive'
)
->
where
(
[
'fa_id'
=>
$id
]
)
->
caller
(
__METHOD__
)->
execute
();
$file
->
releaseFileLock
();
}
$this
->
commitTransaction
(
$dbw
,
__METHOD__
);
$this
->
output
(
"Done! [$count file(s)]
\n
"
);
}
}
// @codeCoverageIgnoreStart
$maintClass
=
DeleteArchivedFiles
::
class
;
require_once
RUN_MAINTENANCE_IF_MAIN
;
// @codeCoverageIgnoreEnd
File Metadata
Details
Attached
Mime Type
text/x-php
Expires
Oct 2 2026, 18:10 (6 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
ce/3c/a9c3c6b2414724054e9b41056295
Default Alt Text
deleteArchivedFiles.php (4 KB)
Attached To
Mode
rMWPROD MediaWiki Production
Attached
Detach File
Event Timeline
Log In to Comment