Differential D14219 Diff 34352 src/applications/people/garbagecollector/PeopleUserLogGarbageCollector.php

Changeset View

Standalone View

	<?php			<?php

	final class PeopleUserLogGarbageCollector			final class PeopleUserLogGarbageCollector
	extends PhabricatorGarbageCollector {			extends PhabricatorGarbageCollector {

	const COLLECTORCONST = 'user.logs';			const COLLECTORCONST = 'user.logs';

	public function getCollectorName() {			public function getCollectorName() {
	return pht('User Activity Logs');			return pht('User Activity Logs');
	}			}

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

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

	$table = new PhabricatorUserLog();			$table = new PhabricatorUserLog();
	$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);
	}			}

	}			}