Prune.php

[Pman.Core] / Prune.php

diff --git a/Prune.php b/Prune.php
index d14bac7..07a28c6 100644 (file)
--- a/Prune.php
+++ b/Prune.php
@@ -25,6 +25,8 @@ class Pman_Core_Prune extends Pman
     var $cli = false;
     
     function getAuth() {
+        
+         
         $ff = HTML_FlexyFramework::get();
         if (!empty($ff->cli)) {
             $this->cli = true;
@@ -34,9 +36,9 @@ class Pman_Core_Prune extends Pman
         return false;
     }
     
-    function get($m="", $opts)
+    function get($m="", $opts=array())
     {
-        
+        echo "start?";
         // prune irrelivant stuff..
        
         
@@ -48,7 +50,8 @@ class Pman_Core_Prune extends Pman
     {
         // 40 seconds ? to delete 100K records..
        // DB_DataObject::debugLevel(1);
-        $f = DB_DataObject::Factory('reader_article');
+       /*
+        $f = DB_DataObject::Factory('Events');
         $f->query("
             DELETE FROM Events where 
                   event_when < NOW() - INTERVAL {$inM} MONTH
@@ -56,7 +59,7 @@ class Pman_Core_Prune extends Pman
                   action != 'NOTIFY'
                   LIMIT 100000
         ");
-        
+        */
         // notificication events occur alot - so we should trash them more frequently..
       /*  $f = DB_DataObject::Factory('reader_article');
         $f->query("
@@ -69,8 +72,13 @@ class Pman_Core_Prune extends Pman
         */
         // rather than deleting them all, it's probably best to just delete notify events that occured to often.
         // eg. when we tried to deliver multiple times without success...
+        /*
+         *
+         SELECT on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm FROM Events
+         WHERE action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK GROUP BY  on_id, on_table HAVING  mm > 2 ORDER BY mm desc;
+         */
         
-        
+        DB_DataObject::debugLevel(1);
         $f = DB_DataObject::Factory('Events');
         $f->selectAdd();
         $f->selectAdd("on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm");
@@ -78,7 +86,8 @@ class Pman_Core_Prune extends Pman
         $f->groupBy('on_id, on_table');
         $f->having("mm > 2");
         $f->orderBy('mm desc') ;
-        $f->limit(1000);
+        $f->limit(10000);
+        exit;
         $ar = $f->fetchAll();
         foreach($ar as $f) {
             $q = DB_DataObject::Factory('Events');