src/applications/conduit/garbagecollector/ConduitLogGarbageCollector.php

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