Changeset 7426 for trunk/MagicSoft/Mars/datacenter/macros

Timestamp:

11/25/05 11:17:51 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/checkfileavail.C (modified) (2 diffs)

trunk/MagicSoft/Mars/datacenter/macros/checkfileavail.C

@@ -71 +71 @@
 }
 
-int checkfileavail(TString sequenceno)
+int checkfileavail(TString sequencefile)
 {
     TEnv env("sql.rc");
@@ -89 +89 @@
     TEnv rc("steps.rc");
 
-    cout << "sequ: " << sequenceno.Data() << endl;
-    TString query(Form("SELECT fRunNumber FROM RunData WHERE fSequenceFirst=%s",
-                       sequenceno.Data()));
+    TEnv sequ(sequencefile);
+
+    TString runs;
+    runs = sequ.GetValue("Runs", "");
+    runs.ReplaceAll(" ", ",");
+    if (runs.IsNull())
+    {
+        cout << "ERROR - No runs in file " << sequencefile << " found." << endl;
+        return 0;
+    }
+
+    cout << "sequ file: " << sequencefile.Data() << endl;
+    TString query(Form("SELECT fRunNumber FROM RunData WHERE fRunNumber in (%s)",
+                       sequencefile.Data()));
 
     TSQLResult *res = serv.Query(query);