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

Timestamp:

07/05/06 11:41:13 (18 years ago)

Author:

tbretz

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/macros

Files:

• checkfileavail.C (modified) (2 diffs)
• checkstardone.C (modified) (2 diffs)
• doexclusions.C (modified) (6 diffs)
• filldotraw.C (modified) (2 diffs)
• fillganymed.C (modified) (1 diff)
• fillsignal.C (modified) (1 diff)
• fillstar.C (modified) (1 diff)
• setupdb.C (modified) (1 diff)

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

@@ -77 +77 @@
     }
 
-    TSQLRow *row=0;
-    while ((row = res->Next()))
-    {
-//        TString entry=(*row)[0];
-//        if (entry=="1970-01-01 00:00:00")
-//            return "";
-        return (*row)[0];
-    }
+    TString rc = (*row)[0];
 
-    return "";
+    delete res;
+
+    return rc;
 }
 
@@ -138 +133 @@
         cout << "run#: " << runno << endl;
         //if one value returns "" (i.e. column is NULL), 0 is returned
-        if (GetStatus(serv, rc, runno, "RunProcessStatus", "fCCFileAvail")==""
-            || GetStatus(serv, rc, runno, "RunProcessStatus", "fCaCoFileAvail")==""
-            || GetStatus(serv, rc, runno, "RunProcessStatus", "fCaCoFileFound")==""
-            || GetStatus(serv, rc, runno, "RunProcessStatus", "fTimingCorrection")==""
+        if (GetStatus(serv, rc, runno, "RunProcessStatus", "fCCFileAvail").IsNull()
+            || GetStatus(serv, rc, runno, "RunProcessStatus", "fCaCoFileAvail").IsNull()
+            || GetStatus(serv, rc, runno, "RunProcessStatus", "fCaCoFileFound").IsNull()
+            || GetStatus(serv, rc, runno, "RunProcessStatus", "fTimingCorrection").IsNull()
 //            || GetStatus(serv, rc, runno, "RunProcessStatus", "fTimingCorrection")=="1970-01-01 00:00:00"
-            || GetStatus(serv, rc, runno, "RunProcessStatus", "fRawFileAvail")=="")
+            || GetStatus(serv, rc, runno, "RunProcessStatus", "fRawFileAvail").IsNull())
             return 2;
     }

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

@@ -74 +74 @@
     }
 
-    TSQLRow *row=0;
-    while ((row = res->Next()))
-        return (*row)[0];
+    TString rc = (*row)[0];
 
-    return "";
+    delete res;
+
+    return rc;
 }
 
@@ -100 +100 @@
 
     //check if fStar not NULL for sequence 
-    if (GetStatus(serv, rc, datasetno, "SequenceProcessStatus", "fStar")=="")
+    if (GetStatus(serv, rc, datasetno, "SequenceProcessStatus", "fStar").IsNull())
         return 2;
 

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

@@ -174 +174 @@
         //get importance of exclusion-reason from database
         TString query(Form("SELECT fExcludedFDAImportance from ExcludedFDA where fExcludedFDAKEY=%s ", key.Data()));
-        TSQLResult *res = serv.Query(query);
-        if (!res)
+        TSQLResult *res2 = serv.Query(query);
+        if (!res2)
         {
             cout << "Error - could not get importance." << endl;
@@ -181 +181 @@
         }
 
-        TSQLRow *row2=res->Next();
+        TSQLRow *row2=res2->Next();
         Int_t newimp=atoi((*row2)[0]);
-        delete res;
+        delete res2;
 
         //get current importance from database
@@ -210 +210 @@
         cout << query << endl;
 
-        res = serv.Query(query);
-        if (!res)
+        res2 = serv.Query(query);
+        if (!res2)
         {
             cout << "Error - no runs to exclude" << endl;
@@ -219 +219 @@
         //compare new and old importance
         //change or keep the exclusion-reason accordingly
-        while ((row2 = res->Next()))
+        while ((row2 = res2->Next()))
         {
             if (TString((*row2)[1]).IsNull() || atoi((*row2)[1])>newimp)
@@ -227 +227 @@
                                    key.Data(), (*row2)[0]));
                 cout << "QU: " << query << endl;
-                TSQLResult *res = serv.Query(query);
-                if (!res)
+                TSQLResult *res3 = serv.Query(query);
+                if (!res3)
                 {
                     cout << "Error - could not insert exclusion" << endl;
                     return 2;
                 }
-                delete res;
+                delete res3;
                 continue;
             }
@@ -239 +239 @@
             cout << "run#: " << (*row2)[0] << " reason for exclusion is still the same" << endl;
         }
-        delete res;
+        delete res2;
     }
     delete res;

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

@@ -94 +94 @@
     }
 
-    return atoi((*row)[0]);
+    Int_t rc = atoi((*row)[0]);
+
+    delete res;
+
+    return rc;
 }
 
@@ -168 +172 @@
         return 2;
     }
-
+    delete res;
     return 1;
 }

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

@@ -212 +212 @@
         return 2;
     }
+    delete res;
     return 1;
 }

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

@@ -235 +235 @@
         return 2;
     }
-
+    delete res;
     return 1;
 }

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

@@ -337 +337 @@
         return 2;
     }
+    delete res;
 
     return 1;

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

@@ -140 +140 @@
             fields += ", ";
     }
+
+    delete res;
 
     return fields;