Changeset 6935 for trunk/MagicSoft/Mars/datacenter/macros/fillcalib.C

Timestamp:

04/13/05 09:29:47 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/fillcalib.C (modified) (4 diffs)

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

@@ -63 +63 @@
 #include <TFile.h>
 #include <TSQLResult.h>
+#include <TSQLRow.h>
 
 #include "MSQLServer.h"
@@ -70 +71 @@
 
 using namespace std;
+
+// --------------------------------------------------------------------------
+//
+// Checks whether an entry is already existing
+//
+Bool_t ExistStr(MSQLServer &serv, const char *column, const char *table, Int_t test)
+{
+    TString query(Form("SELECT %s FROM %s WHERE %s='%d'", column, table, column, test));
+    TSQLResult *res = serv.Query(query);
+    if (!res)
+        return kFALSE;
+
+    TSQLRow *row;
+
+    Bool_t rc = kFALSE;
+    while ((row=res->Next()))
+    {
+        if ((*row)[0])
+        {
+            rc = kTRUE;
+            break;
+        }
+    }
+
+    delete res;
+
+    return rc;
+}
+
 
 int Process(MSQLServer &serv, TString fname, Bool_t dummy)
@@ -125 +155 @@
     cout << "  Max.Cluster: (i/o)  " << Form("%3d", (int)clumax) << endl;                 // Max Cluster
 
+    TString query;
+    if (!ExistStr(serv, "fSequenceFirst", "MyMagic.Calibration", seq))
+    {
+
+        query = Form("INSERT MyMagic.Calibration SET"
+                     " fSequenceFirst=%d,"
+                     " fUnsuitableInner=%d, "
+                     " fUnsuitableOuter=%d, "
+                     " fUnreliableInner=%d, "
+                     " fUnreliableOuter=%d, "
+                     " fIsolatedInner=%d, "
+                     " fIsolatedOuter=%d, "
+                     " fIsolatedMaxCluster=%d",
+                     seq, (int)unsin, (int)unsout, (int)unrin,
+                     (int)unrout, (int)isoin, (int)isoout, (int)clumax);
+    }
+    else
+    {
+        query = Form("UPDATE MyMagic.Calibration SET"
+                     " fUnsuitableInner=%d, "
+                     " fUnsuitableOuter=%d, "
+                     " fUnreliableInner=%d, "
+                     " fUnreliableOuter=%d, "
+                     " fIsolatedInner=%d, "
+                     " fIsolatedOuter=%d, "
+                     " fIsolatedMaxCluster=%d"
+                     " WHERE fSequenceFirst=%d,",
+                     (int)unsin, (int)unsout, (int)unrin,(int)unrout,
+                     (int)isoin, (int)isoout, (int)clumax, seq);
+    }
+
     if (dummy)
         return 0;
-
-    TString query = Form("INSERT MyMagic.Calibration SET"
-                         " fSequenceFirst=%d,"
-                         " fUnsuitableInner=%d, "
-                         " fUnsuitableOuter=%d, "
-                         " fUnreliableInner=%d, "
-                         " fUnreliableOuter=%d, "
-                         " fIsolatedInner=%d, "
-                         " fIsolatedOuter=%d, "
-                         " fIsolatedMaxCluster=%d",
-                         seq, (int)unsin, (int)unsout, (int)unrin,
-                         (int)unrout, (int)isoin, (int)isoout, (int)clumax);
-
 
     TSQLResult *res = serv.Query(query);
@@ -147 +195 @@
         return 0;
     }
+    delete res;
 
     return 1;