Changeset 7183 for trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C

Timestamp:

07/13/05 13:54:05 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C (modified) (7 diffs)

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

@@ -335 +335 @@
 Bool_t NewSequence(MSQLServer &serv, Int_t from, Int_t to, Int_t src, Bool_t dummy)
 {
-    cout << "Found Sequence (" << from << ", " << to << ") ... checking..." << flush;
+    cout << "Found Sequence (" << from << ", " << to << ") ... checking runs..." << flush;
 
     if (!CheckSequence(serv, from, to, src, 2))
@@ -442 +442 @@
                     MTime *tm = new MTime;
                     tm->SetSqlDateTime((*row)[2]);
-                    map.Add((ULong_t)map.GetSize(), (Long_t)nblocks, (Long_t)tm);
+                    map.Add((ULong_t)map.GetSize(), (Long_t)tm, (Long_t)nblocks);
                 }
             }
@@ -451 +451 @@
             {
                 MTime *tm = new MTime(lasttime);
-                map.Add((ULong_t)map.GetSize(), (Long_t)nblocks, (Long_t)tm);
+                map.Add((ULong_t)map.GetSize(), (Long_t)tm, (Long_t)nblocks);
 
                 stop = last;
@@ -505 +505 @@
         while (nmap.Next(key, val))
         {
-            MTime *t = (MTime*)val;
+            MTime *t = (MTime*)key;
 
             if (nmin==-1)
             {
-                nmin = key;
-                min  = *(MTime*)val;
+                nmin = val;
+                min  = *(MTime*)key;
                 dmin = fabs((Double_t)*t-(Double_t)tstart);
             }
@@ -516 +516 @@
             if (fabs((Double_t)*t-(Double_t)tstart) < dmin)
             {
-                nmin = key;
+                nmin = val;
                 dmin = fabs((Double_t)*t-(Double_t)tstart);
                 min = *t;
@@ -522 +522 @@
             if (fabs((Double_t)*t-(Double_t)tstop) < dmin)
             {
-                nmin = key;
+                nmin = val;
                 dmin = fabs((Double_t)*t-(Double_t)tstop);
                 min = *t;
@@ -596 +596 @@
     return rc ? 1 : 0;
 }
+
+int buildsequenceentries()
+{
+    TEnv env("sql.rc");
+
+    MSQLServer serv(env);
+    if (!serv.IsConnected())
+    {
+        cout << "ERROR - Connection to database failed." << endl;
+        return 0;
+    }
+
+    TString query="SELECT fDate FROM SequenceBuildStatus";
+
+    cout << "Q: " << query << endl;
+
+    TSQLResult *res = serv.Query(query);
+    if (!res)
+        return 0;
+
+    TSQLRow *row=0;
+    while ((row=res->Next()))
+    {
+        cout << "date: " << (*row)[0] << endl;
+        buildsequenceentries((*row)[0]);
+    }
+
+    return 1;
+}