src/applications/people/garbagecollector/PeopleUserLogGarbageCollector.php

   1 <?php
   2
   3 final class PeopleUserLogGarbageCollector
   4   extends PhabricatorGarbageCollector {
   5
   6   const COLLECTORCONST = 'user.logs';
   7
   8   public function getCollectorName() {
   9     return pht('User Activity Logs');
  10   }
  11
  12   public function getDefaultRetentionPolicy() {
  13     return phutil_units('180 days in seconds');
  14   }
  15
  16   protected function collectGarbage() {
  17     $table = new PhabricatorUserLog();
  18     $conn_w = $table->establishConnection('w');
  19
  20     queryfx(
  21       $conn_w,
  22       'DELETE FROM %T WHERE dateCreated < %d LIMIT 100',
  23       $table->getTableName(),
  24       $this->getGarbageEpoch());
  25
  26     return ($conn_w->getAffectedRows() == 100);
  27   }
  28
  29 }