projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
14362a2
)
Prune.php
author
Alan Knowles
<alan@roojs.com>
Thu, 4 Oct 2018 04:29:41 +0000
(12:29 +0800)
committer
Alan Knowles
<alan@roojs.com>
Thu, 4 Oct 2018 04:29:41 +0000
(12:29 +0800)
Prune.php
patch
|
blob
|
history
diff --git
a/Prune.php
b/Prune.php
index
5b49bd9
..
633f571
100644
(file)
--- a/
Prune.php
+++ b/
Prune.php
@@
-76,7
+76,7
@@
class Pman_Core_Prune extends Pman
WHERE action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK GROUP BY on_id, on_table HAVING mm > 2 ORDER BY mm desc;
*/
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);
+ 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");
$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");
@@
-85,6
+85,7
@@
class Pman_Core_Prune extends Pman
$f->having("mm > 2");
$f->orderBy('mm desc') ;
$f->limit(10000);
$f->having("mm > 2");
$f->orderBy('mm desc') ;
$f->limit(10000);
+ exit;
$ar = $f->fetchAll();
foreach($ar as $f) {
$q = DB_DataObject::Factory('Events');
$ar = $f->fetchAll();
foreach($ar as $f) {
$q = DB_DataObject::Factory('Events');