Changeset 7112 for trunk/MagicSoft/Mars/datacenter/macros/doexclusions.C

Timestamp:

05/30/05 19:12:54 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/doexclusions.C (modified) (6 diffs)

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

@@ -45 +45 @@
 int GetRunNumber(MSQLServer &serv, TString date, TString value)
 {
-    TString query(Form("SELECT %s(fRunNumber) FROM MyMagic.RunData ", value.Data()));
+    TString query(Form("SELECT %s(fRunNumber) FROM RunData ", value.Data()));
 
     if (date!="NULL")
@@ -77 +77 @@
 TString GetJoin(TString table)
 {
-    TString query(Form("left join MyMagic.%s ON RunData.f%sKEY=%s.f%sKEY ",
+    TString query(Form("left join %s ON RunData.f%sKEY=%s.f%sKEY ",
                        table.Data(), table.Data(), table.Data(), table.Data()));
     return query;
@@ -114 +114 @@
     TString runcond(Form("AND fRunNumber BETWEEN %d AND %d ", startrun, stoprun));
 
-    TString query="SELECT fExcludedFDAKEY from MyMagic.ExcludedFDA where fExcludedFDAAutomatic='yes'";
+    TString query="SELECT fExcludedFDAKEY from ExcludedFDA where fExcludedFDAAutomatic='yes'";
     TSQLResult *res = serv.Query(query);
     if (!res)
@@ -131 +131 @@
         TString border=rc.GetValue("key"+key+".SpecialRunCond", "");
 
-        TString query(Form("SELECT fExcludedFDAImportance from MyMagic.ExcludedFDA where fExcludedFDAKEY=%s ", key.Data()));
+        TString query(Form("SELECT fExcludedFDAImportance from ExcludedFDA where fExcludedFDAKEY=%s ", key.Data()));
         TSQLResult *res = serv.Query(query);
         if (!res)
@@ -150 +150 @@
         if (!join2.IsNull())
             query+=Form(", f%sName", join2.Data());
-        query +=" FROM MyMagic.RunData ";
+        query +=" FROM RunData ";
         query +=GetJoin("ExcludedFDA");
         if (!join1.IsNull())
@@ -177 +177 @@
             if (TString((*row2)[1]).IsNull() || atoi((*row2)[1])>newimp)
             {
-                TString query(Form("UPDATE MyMagic.RunData SET fExcludedFDAKEY=%s WHERE fRunNumber=%s",
+                TString query(Form("UPDATE RunData SET fExcludedFDAKEY=%s WHERE fRunNumber=%s",
                                    key.Data(), (*row2)[0]));
                 cout << "QU: " << query << endl;