function DeleteOldSubmissionRecords($projectid) { global $CDASH_ASYNC_EXPIRATION_TIME; $delete_time = gmdate(FMT_DATETIMESTD, time() - $CDASH_ASYNC_EXPIRATION_TIME); $ids = pdo_all_rows_query("SELECT id FROM submission WHERE " . "(status=2 OR status=3 OR status=4 OR status=5) AND " . "projectid='{$projectid}' AND finished<'{$delete_time}' AND " . "finished!='1980-01-01 00:00:00'"); $count = count($ids); if (0 == $count) { // Nothing to delete! return; } $idset = "("; foreach ($ids as $id_row) { $id = $id_row["id"]; $idset .= "'{$id}', "; } // Avoid conditional ", " emission in the loop. OK to repeat an // element in this DELETE IN type of query: $idset .= "'" . $ids[0]["id"] . "')"; pdo_delete_query("DELETE FROM submission WHERE id IN " . $idset); pdo_delete_query("DELETE FROM client_jobschedule2submission WHERE submissionid IN " . $idset); pdo_delete_query("DELETE FROM submission2ip WHERE submissionid IN " . $idset); }
/** Delete the old feeds */ public function DeleteOld($projectid, $days) { $secondsinday = 86400; // == 3600*24; $olddate_utc = gmdate(FMT_DATETIMESTD, time() - $days * $secondsinday); pdo_delete_query("DELETE FROM feed WHERE projectid='{$projectid}' AND date<'{$olddate_utc}'"); }