TOracleServerE2W.cxx File Reference

#include "TOracleServerE2W.h"
#include "EdbLog.h"
#include "TTree.h"
#include "EdbPattern.h"
#include "EdbAffine.h"
#include "EdbSegment.h"
#include "EdbRun.h"

Include dependency graph for TOracleServerE2W.cxx:

Functions
	ClassImp (TOracleServerE2W) Int_t TOracleServerE2W

Function Documentation

ClassImp()

ClassImp

(

TOracleServerE2W

)

{
  // Adds a process operation into the DB
  // Table involved: TB_PROC_OPERATIONS
  // Details: INSERT query and then a COMMIT query
 
  char query[2048];
  char commit[10]="commit";
 
  try{
    if (!fStmt)
      fStmt = fConn->createStatement();
    
    sprintf(query,"\
 INSERT INTO OPERA.TB_PROC_OPERATIONS (ID_MACHINE, ID_PROGRAMSETTINGS, ID_REQUESTER, ID_PARENT_OPERATION, ID_EVENTBRICK, ID_PLATE, DRIVERLEVEL, ID_CALIBRATION_OPERATION, STARTTIME, FINISHTIME, SUCCESS, NOTES) \
 VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, '%s')",
        id_machine, id_programsettings, id_requester, id_parent_operation, id_eventbrick, id_plate, driverlevel, id_calibration, starttime, finishtime, success, notes);
    
    fStmt->setSQL(query);
    Log(2,"AddProcessOperation","execute sql query: %s ...",query);
    fStmt->execute();
    Query(commit);
    Log(2,"AddProcessOperation","Process operation added");
    
  } catch (SQLException &oraex) {
    Error("TOracleServerE2W", "AddProcessOperation; failed: (error: %s)", (oraex.getMessage()).c_str());
  }
 
  return 0;
}