Changeset 42452 for trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl

Timestamp:

Apr 21, 2023, 10:36:27 AM (3 years ago)

Author:

eugene

Message:

some improvements (make sure to examine md5s for chip-specific inst files, randomly draw the new nights)

File:

• trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl (modified) (1 diff)

trunk/tools/eam/rawfix.20230221/src/advance.rawfix.pl

@@ -77 +77 @@
 
     # select and advance nights not yet running
-    $sql_get_run = "SELECT dateobs from nights where state = 'new'";
+#   $sql_get_run = "SELECT dateobs from nights where state = 'new'";
+
+    $sql_get_run = "SELECT dateobs FROM (SELECT dateobs, rand() AS myrand FROM nights WHERE (state = 'new')) AS tmp ORDER BY myrand";
+
     $runref   = $raw_dbh->selectall_arrayref( $sql_get_run );
     @runarray = @$runref;