Changeset 7482 for trunk/MagicSoft/Mars/datacenter/macros/setstatus.C
- Timestamp:
- 02/07/06 10:53:42 (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/MagicSoft/Mars/datacenter/macros/setstatus.C
r7480 r7482 116 116 } 117 117 118 Int_t SetInfluences(MSQLServer &serv, TEnv &rc, TString primary, TString table, TString column, TString statustime, TString failedcode, TString failedcomment, TString starttime, TString failedtime, Bool_t resetall)118 Int_t SetInfluences(MSQLServer &serv, TEnv &rc, TString primary, TString table, TString column, TString statustime, TString returncode, TString failedcode, TString failedcodeadd, TString starttime, TString failedtime, Bool_t resetall) 119 119 { 120 cout << "set influen es for " << table << "." << column << endl;120 cout << "set influences for " << table << "." << column << endl; 121 121 122 122 //build query and set step and influences for the step 123 123 TString influences = rc.GetValue(table+"."+column+".Influences", ""); 124 124 125 TString query(Form("UPDATE %s SET %s=%s, f FailedCode=%s, fFailedComment=%s, fFailedTime=%s ",126 table.Data(), column.Data(), statustime.Data(), failedcode.Data(),127 failedco mment.Data(), failedtime.Data()));125 TString query(Form("UPDATE %s SET %s=%s, fReturnCode=%s, fFailedCode=%s, fFailedCodeAdd=%s, fFailedTime=%s ", 126 table.Data(), column.Data(), statustime.Data(), returncode.Data(), failedcode.Data(), 127 failedcodeadd.Data(), failedtime.Data())); 128 128 if (starttime.CompareTo("noreset")) 129 129 query += Form(", fStartTime=%s", starttime.Data()); … … 163 163 } 164 164 165 int setstatus(TString primary, TString table, TString column, TString statustime, TString failedcode, TString failedcomment, TString starttime, TString failedtime, Bool_t resetall=kTRUE)165 int setstatus(TString primary, TString table, TString column, TString statustime, TString returncode, TString failedcode, TString failedcodeadd, TString starttime, TString failedtime, Bool_t resetall=kTRUE) 166 166 { 167 167 TEnv env("sql.rc"); … … 182 182 183 183 //if reset is needed and/or can be done, set new values 184 return !CheckReset(rc, table, column, statustime) ? 0 : SetInfluences(serv, rc, primary, table, column, statustime, failedcode, failedcomment, starttime, failedtime, resetall);184 return !CheckReset(rc, table, column, statustime) ? 0 : SetInfluences(serv, rc, primary, table, column, statustime, returncode, failedcode, failedcodeadd, starttime, failedtime, resetall); 185 185 186 186 }
Note:
See TracChangeset
for help on using the changeset viewer.