Changeset 27044 for trunk/tools/delete_convolved_diff.pl

Timestamp:

Feb 23, 2010, 4:23:05 PM (16 years ago)

Author:

Paul Price

Message:

Remove limit.

File:

• trunk/tools/delete_convolved_diff.pl (modified) (1 diff)

trunk/tools/delete_convolved_diff.pl

@@ -42 +42 @@
 my @files;                      # Files to clean up
 {
-    my $sql = "SELECT path_base FROM diffSkyfile JOIN diffRun USING(diff_id) JOIN magicRun USING(diff_id) WHERE diffRun.state IN ('full', 'drop') AND magicRun.state IN ('full', 'drop', 'censored') LIMIT 5";
+    my $sql = "SELECT path_base FROM diffSkyfile JOIN diffRun USING(diff_id) JOIN magicRun USING(diff_id) WHERE diffRun.state IN ('full', 'drop') AND magicRun.state IN ('full', 'drop', 'censored')";
     my $results = $db->selectall_arrayref( $sql ) or die "Unable to execute SQL: $DBI::errstr";
     foreach my $result ( @$results ) {