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

Timestamp:

08/05/05 18:33:55 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/macros

Files:

• filldotraw.C (modified) (3 diffs)
• fillsinope.C (modified) (4 diffs)
• getdolist.C (modified) (1 diff)
• setupdb.C (modified) (1 diff)

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

@@ -133 +133 @@
 }
 
-Int_t Process(MSQLServer &serv, TString fname, Bool_t dummy)
+int Process(MSQLServer &serv, TString fname, Bool_t dummy)
 {
     MRawRunHeader h;
@@ -165 +165 @@
 }
 
-Int_t filldotraw(TString fname, Bool_t dummy=kTRUE)
+int filldotraw(TString fname, Bool_t dummy=kTRUE)
 {
     TEnv env("sql.rc");
@@ -186 +186 @@
 }
 
-Int_t filldotraw(Int_t runno, Bool_t dummy=kTRUE)
+int filldotraw(Int_t runno, Bool_t dummy=kTRUE)
 {
     TEnv env("sql.rc");

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

@@ -94 +94 @@
     for (Int_t i=0 ; i<9 ; i++)
     {
-        cout << "value: " << values[i] << endl;
+//        cout << "value: " << values[i] << endl;
+//        cout << "str: " << str << endl;
         str = env.GetValue(values[i], "");
         if (str.IsNull())
@@ -174 +175 @@
     }
 
-    TString fname(Form("%s/sinope/%s/sinope%08d.txt",
+    TString fname(Form("%s/sinope/%s/sinope-dat%08d.txt",
                        datapath.Data(), date.Data(), runno));
     cout << "file: " << fname << endl;
@@ -180 +181 @@
                         datapath.Data(), date.Data(), runno));
     cout << "file-cal: " << fnamecal << endl;
-
-    fname="/home/bla/Mars.cvs/bla.txt";
-    fnamecal="/home/bla/Mars.cvs/blacal.txt";
 
     Int_t rc=0;
@@ -190 +188 @@
 
     rc=Process(serv, fnamecal, runno, kTRUE, dummy);
-
     return rc;
-
 }

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

@@ -112 +112 @@
     query+=Form(" ORDER BY %s.%s DESC ", table.Data(), rc.GetValue(table+".Primary", ""));
 
+    if (table="RunProcessStatus")
+        query+="LIMIT 0, 500";
+
     cout << "query: " << query << endl;
 
     TSQLResult *res = serv.Query(query);
     if (!res)
+    {
+        cout << "ERROR - Query failed: " << query << endl;
         return 0;
+    }
 
 

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

@@ -595 +595 @@
          "  fCaCoFileFound         INT       UNSIGNED   NULL,"
          "  fRawFileAvail          DATETIME             NULL,"
-         "  fFillDotRaw            DATETIME             NULL,"
+         "  fDataCheckDone         DATETIME             NULL,"
          "  fTimingCorrection      DATETIME             NULL,"
          "  fMerpp                 DATETIME             NULL,"