From f2f48103b1dbc77ecc0070bfd5c51350c6ebcf85 Mon Sep 17 00:00:00 2001
From: Aaron Schulz <aaron@users.mediawiki.org>
Date: Thu, 10 May 2007 22:10:25 +0000
Subject: [PATCH] *Add a script to delete archived images

---
 maintenance/deleteArchivedFiles.inc     | 61 +++++++++++++++++++++++++
 maintenance/deleteArchivedFiles.php     | 31 +++++++++++++
 maintenance/deleteArchivedRevisions.inc |  2 +-
 maintenance/deleteArchivedRevisions.php |  2 +-
 4 files changed, 94 insertions(+), 2 deletions(-)
 create mode 100644 maintenance/deleteArchivedFiles.inc
 create mode 100644 maintenance/deleteArchivedFiles.php

diff --git a/maintenance/deleteArchivedFiles.inc b/maintenance/deleteArchivedFiles.inc
new file mode 100644
index 0000000000..1880ed9c23
--- /dev/null
+++ b/maintenance/deleteArchivedFiles.inc
@@ -0,0 +1,61 @@
+<?php
+
+/**
+ * Support functions for the deleteArchivedFiles script
+ *
+ * @addtogroup Maintenance
+ * @author Aaron Schulz
+ */
+
+require_once( "$IP/includes/FileStore.php" );
+
+function DeleteArchivedFiles( $delete = false ) {
+
+	# Data should come off the master, wrapped in a transaction
+	$dbw = wfGetDB( DB_MASTER );
+	$dbw->begin();
+	
+	$transaction = new FSTransaction();
+	if( !FileStore::lock() ) {
+		wfDebug( __METHOD__.": failed to acquire file store lock, aborting\n" );
+		return false;
+	}
+	
+	$tbl_arch = $dbw->tableName( 'filearchive' );
+	
+	# Get "active" revisions from the filearchive table
+	echo( "Searching for and deleting archived files...\n" );
+	$res = $dbw->query( "SELECT fa_storage_group,fa_storage_key FROM $tbl_arch" );
+	while( $row = $dbw->fetchObject( $res ) ) {
+		$key = $row->fa_storage_key;
+		$group = $row->fa_storage_group;
+		
+		$store = FileStore::get( $group );
+		if ( $store ) {
+			$path = $store->filePath( $key );
+			if ( $path && file_exists($path) ) {
+				$transaction->addCommit( FSTransaction::DELETE_FILE, $path );
+			} else {
+				echo( "Notice - file '$key' not found in group '$group'\n" );
+			}
+		} else {
+			echo( "Notice - invalid file storage group '$group'\n" );
+		}
+	}
+	echo( "done.\n" );
+	
+	$transaction->commit();
+	
+	
+	# Delete as appropriate
+	echo( "Deleting filearchive rows..." );
+	$dbw->query( "TRUNCATE TABLE $tbl_arch" );
+	echo( "done.\n" );
+	
+	# This bit's done
+	# Purge redundant text records
+	$dbw->commit();
+
+}
+
+?>
\ No newline at end of file
diff --git a/maintenance/deleteArchivedFiles.php b/maintenance/deleteArchivedFiles.php
new file mode 100644
index 0000000000..7aee527e81
--- /dev/null
+++ b/maintenance/deleteArchivedFiles.php
@@ -0,0 +1,31 @@
+<?php
+
+/**
+ * Delete archived (non-current) files from the database
+ *
+ * @addtogroup Maintenance
+ * @author Aaron Schulz
+ * Based on deleteOldRevisions.php by Rob Church
+ */
+
+$options = array( 'delete', 'help' );
+require_once( 'commandLine.inc' );
+require_once( 'deleteArchivedFiles.inc' );
+
+echo( "Delete Archived Images\n\n" );
+
+if( @$options['help'] ) {
+	ShowUsage();
+} else {
+	DeleteArchivedFiles( @$options['delete'] );
+}
+
+function ShowUsage() {
+	echo( "Deletes all archived images.\n\n" );
+	echo( "These images will no longer be restorable.\n\n" );
+	echo( "Usage: php deleteArchivedRevisions.php [--delete|--help]\n\n" );
+	echo( "delete : Performs the deletion\n" );
+	echo( "  help : Show this usage information\n" );
+}
+
+?>
\ No newline at end of file
diff --git a/maintenance/deleteArchivedRevisions.inc b/maintenance/deleteArchivedRevisions.inc
index 0cb1e86aab..8d89badc79 100644
--- a/maintenance/deleteArchivedRevisions.inc
+++ b/maintenance/deleteArchivedRevisions.inc
@@ -1,7 +1,7 @@
 <?php
 
 /**
- * Support functions for the deleteOldRevisions script
+ * Support functions for the deleteArchivedRevisions script
  *
  * @addtogroup Maintenance
  * @author Aaron Schulz
diff --git a/maintenance/deleteArchivedRevisions.php b/maintenance/deleteArchivedRevisions.php
index 57a725f2a5..26cc5ca044 100644
--- a/maintenance/deleteArchivedRevisions.php
+++ b/maintenance/deleteArchivedRevisions.php
@@ -1,7 +1,7 @@
 <?php
 
 /**
- * Delete old (non-current) revisions from the database
+ * Delete arcived (deleted from public) revisions from the database
  *
  * @addtogroup Maintenance
  * @author Aaron Schulz
-- 
2.20.1