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

Timestamp:

08/28/05 00:30:58 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/macros

Files:

• filldotraw.C (modified) (2 diffs)
• filldotrun.C (modified) (1 diff)
• setupdb.C (modified) (1 diff)

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

@@ -74 +74 @@
 Int_t MagicNumber(MSQLServer &serv, const MRawRunHeader &h)
 {
-    TString query(Form("SELECT fMagicNumberKEY FROM MyMagic.MagicNumber WHERE fMagicNumber=%d",
+    TString query(Form("SELECT fMagicNumberKEY FROM MagicNumber WHERE fMagicNumber=%d",
                        h.GetMagicNumber()));
 
@@ -152 +152 @@
         return 0;
 
-    TString query(Form("UPDATE MyMagic.RunData SET fMagicNumberKEY=%d, fFormatVersion=%d WHERE fRunNumber=%d",
+    TString query(Form("UPDATE RunData SET fMagicNumberKEY=%d, fFormatVersion=%d WHERE fRunNumber=%d",
                        key, h.GetFormatVersion(), h.GetRunNumber()));
 

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

@@ -577 +577 @@
         //create entry in table RunProcessStatus for this runnumber
         TString query2=Form("INSERT RunProcessStatus SET fRunNumber=%d, fTimingCorrection='1970-01-01 00:00:00'",
-                    runnumber);
+                            runnumber);
+        if (testflagkey==1)
+            query+=" , fDataCheckDone='1970-01-01 00:00:00'";
         res = serv.Query(query2);
         if (!res)

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

@@ -193 +193 @@
     list.Add(new TObjString(
         "INSERT MyMagic.MagicNumber (fMagicNumber, fMagicNumberName) VALUES "
-        "  (0x0000, 'Not available'),"
-        "  (0xc0c0, 'Ok'),"
-        "  (0xc0c1, 'Not closed'),"
-        "  (0xffff, 'Wrong')"));
+        "  (0x0001, 'Not available')," //1
+        "  (0xc0c0, 'Ok'),"            //45344
+        "  (0xc0c1, 'Not closed'),"    //45345
+        "  (0x0000, 'Wrong')"));       //0
 
     // Run type