Differential D14219 Diff 34352 src/applications/metamta/garbagecollector/MetaMTAMailReceivedGarbageCollector.php

Changeset View

Standalone View

	<?php			<?php

	final class MetaMTAMailReceivedGarbageCollector			final class MetaMTAMailReceivedGarbageCollector
	extends PhabricatorGarbageCollector {			extends PhabricatorGarbageCollector {

	const COLLECTORCONST = 'metamta.received';			const COLLECTORCONST = 'metamta.received';

	public function getCollectorName() {			public function getCollectorName() {
	return pht('Mail (Received)');			return pht('Mail (Received)');
	}			}

	public function getDefaultRetentionPolicy() {			public function getDefaultRetentionPolicy() {
	return phutil_units('90 days in seconds');			return phutil_units('90 days in seconds');
	}			}

	public function collectGarbage() {			protected function collectGarbage() {
	$ttl = phutil_units('90 days in seconds');

	$table = new PhabricatorMetaMTAReceivedMail();			$table = new PhabricatorMetaMTAReceivedMail();
	$conn_w = $table->establishConnection('w');			$conn_w = $table->establishConnection('w');

	queryfx(			queryfx(
	$conn_w,			$conn_w,
	'DELETE FROM %T WHERE dateCreated < %d LIMIT 100',			'DELETE FROM %T WHERE dateCreated < %d LIMIT 100',
	$table->getTableName(),			$table->getTableName(),
	time() - $ttl);			$this->getGarbageEpoch());

	return ($conn_w->getAffectedRows() == 100);			return ($conn_w->getAffectedRows() == 100);
	}			}

	}			}