File:
0.02.58a/server/bin/cleanup.sh (
View as Code)
1: #!/usr/bin/php -q
2: 3: require("include.php");
4: $NATS->Start();
5:
6: $day=60*60*24;
7: $nowx=time();
8:
9: $ret_alert=$NATS->Cfg->Get("retain,alert",356);
10: $ret_testrun=$NATS->Cfg->Get("retain.testrun",30);
11: $ret_records=$NATS->Cfg->Get("retain.record",356);
12:
13: if ($ret_alert>0)
14: {
15: $q="SELECT alertid FROM fnalert WHERE closedx<".($nowx-($day*$ret_alert));
16: $r=$NATS->DB->Query($q);
17: $del_alert=0;
18: $del_aa=0;
19: while ($row=$NATS->DB->Fetch_Array($r))
20: {
21: $alid=$row['alertid'];
22: $q="DELETE FROM fnalertlog WHERE alertid=".$row['alertid'];
23: $NATS->DB->Query($q);
24: $del_aa+=$NATS->DB->Affected_Rows();
25: $q="DELETE FROM fnalert WHERE alertid=".$row['alertid'];
26: $NATS->DB->Query($q);
27: $del_alert++;
28: }
29: echo "Deleted ".$del_alert." Alerts\n";
30: echo "Deleted ".$del_aa." Alert Log Entries\n";
31: }
32:
33: if ($ret_testrun>0)
34: {
35: $q="DELETE FROM fntestrun WHERE startx<".($nowx-($day*$ret_testrun));
36: $NATS->DB->Query($q);
37: $del_testrun=$NATS->DB->Affected_Rows();
38: echo "Deleted ".$del_testrun." Test Runs\n";
39: }
40:
41: if ($ret_records>0)
42: {
43: $q="DELETE FROM fnrecord WHERE recordx<".($nowx-($day*$ret_records));
44: $NATS->DB->Query($q);
45: $del_records=$NATS->DB->Affected_Rows();
46: echo "Deleted ".$del_records." Result Records\n";
47: }
48:
49: $q="DELETE FROM fnsession WHERE updatex<".($nowx-$day); // live unaffected
50: $NATS->DB->Query($q);
51: $del_sessions=$NATS->DB->Affected_Rows();
52: echo "Deleted ".$del_sessions." Stale Sessions\n";
53:
54: $NATS->Stop();
55:
56: ?>
57:
58: