File: 0.01.2a/bin/clearbigrecords.sh (View as Code)

1: #!/usr/bin/php -q 2: 3: require("include.php"); 4: $NATS->Start(); 5: 6: $q="SELECT testid,AVG(testvalue) FROM fnrecord GROUP BY testid"; 7: $r=$NATS->DB->Query($q); 8: 9: echo $q."\n"; 10: 11: while ($row=$NATS->DB->Fetch_Array($r)) 12: { 13: $limit=100*$row['AVG(testvalue)']; 14: if ($limit>1) 15: { 16: $q="DELETE FROM fnrecord WHERE testid=\"".$row['testid']."\" AND testvalue>".$limit; 17: $NATS->DB->Query($q); 18: echo $row['testid']." - deleted ".$NATS->DB->Affected_Rows()."\n"; 19: } 20: } 21: 22: $NATS->Stop(); 23: 24: ?> 25: 26: