cscmap1 Class Reference

#include <CSCMap1.h>

List of all members.

Public Member Functions
void	chamber (int chamberid, CSCMapItem::MapItem *item)
void	cratedmb (int crate, int dmb, CSCMapItem::MapItem *item)
	cscmap1 () throw (oracle::occi::SQLException)
void	ruiddu (int rui, int ddu_input, CSCMapItem::MapItem *item)
	~cscmap1 () throw (oracle::occi::SQLException)
Private Attributes
oracle::occi::Connection *	con
oracle::occi::Environment *	env

---

Detailed Description

Definition at line 9 of file CSCMap1.h.

---

Constructor & Destructor Documentation

cscmap1::cscmap1

(

)

throw (oracle::occi::SQLException)

Constructor for cscmap1

Definition at line 7 of file CSCMap1.cc.

References con, gather_cfg::cout, and env.

  {
    std::string db_user;
    std::string db_pass;
    env = oracle::occi::Environment::createEnvironment (oracle::occi::Environment::DEFAULT);
    char* c_user = ::getenv("CSCMAP_AUTH_USER");
    char* c_pass = ::getenv("CSCMAP_AUTH_PASSWORD");
    db_user=std::string(c_user);
    db_pass=std::string(c_pass);
    con = env->createConnection (db_user,db_pass,"cms_orcoff_prod");
     std::cout << "Connection to mapping DB is done." << std::endl;
  }// end of constructor cscmap1 ()

cscmap1::~cscmap1

(

)

throw (oracle::occi::SQLException)

Destructor for cscmap1

Destructor for cscmap1.

Definition at line 23 of file CSCMap1.cc.

References con, and env.

  {
    env->terminateConnection (con);
    oracle::occi::Environment::terminateEnvironment (env);
  }  // end of ~cscmap1 ()

---

Member Function Documentation

void cscmap1::chamber	(	int	chamberid,
		CSCMapItem::MapItem *	item
	)

Definition at line 29 of file CSCMap1.cc.

References CSCMapItem::MapItem::anodeIndex, CSCMapItem::MapItem::anodes, CSCMapItem::MapItem::chamber, CSCMapItem::MapItem::chamberId, CSCMapItem::MapItem::chamberLabel, con, CSCMapItem::MapItem::crateid, CSCMapItem::MapItem::crateLabel, CSCMapItem::MapItem::cscid, CSCMapItem::MapItem::cscIndex, CSCMapItem::MapItem::dcc_fifo, CSCMapItem::MapItem::ddu, CSCMapItem::MapItem::ddu_input, CSCMapItem::MapItem::ddu_slot, CSCMapItem::MapItem::dmb, CSCMapItem::MapItem::endcap, Reference_intrackfit_cff::endcap, CSCMapItem::MapItem::fed_crate, CSCMapItem::MapItem::fiber_crate, CSCMapItem::MapItem::fiber_pos, CSCMapItem::MapItem::fiber_socket, CSCMapItem::MapItem::layerIndex, CSCMapItem::MapItem::ring, relativeConstraints::ring, CSCMapItem::MapItem::sector, CSCMapItem::MapItem::slink, relativeConstraints::station, CSCMapItem::MapItem::station, CSCMapItem::MapItem::stripIndex, CSCMapItem::MapItem::strips, and CSCMapItem::MapItem::trig_sector.

Referenced by CSCMap1Read::analyze(), cratedmb(), CSCChamberIndexValues::fillChamberIndex(), CSCChamberMapValues::fillChamberMap(), CSCCrateMapValues::fillCrateMap(), CSCDDUMapValues::fillDDUMap(), and ruiddu().

  {
    oracle::occi::Statement *stmt = con->createStatement();

    stmt->setSQL("begin cms_emu_cern.cscmap.chamberid_crate(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); end;");

    stmt->setInt (1, chamberid);
    stmt->registerOutParam (2, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (3, oracle::occi::OCCIINT);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCIINT);
    stmt->registerOutParam (6, oracle::occi::OCCIINT);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCIINT);
    stmt->registerOutParam (10, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (11, oracle::occi::OCCIINT);
    stmt->registerOutParam (12, oracle::occi::OCCIINT);
    stmt->registerOutParam (13, oracle::occi::OCCIINT);
    stmt->registerOutParam (14, oracle::occi::OCCIINT);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);
    stmt->registerOutParam (18, oracle::occi::OCCIINT);
    stmt->registerOutParam (19, oracle::occi::OCCIINT);
    stmt->registerOutParam (20, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->chamberLabel = stmt->getString(10);
    item->chamberId = chamberid;
     int chamber = chamberid/10%100;
     int rest = (chamberid - chamber*10)/1000;
     int ring = rest%10;
     rest = (rest - ring)/10;
     int station = rest%10;
     int endcap = (rest - station)/10;
    item->endcap = endcap;
    item->station = station;
    item->ring = ring;
    item->chamber = chamber;
    item->cscIndex = stmt->getInt(13);
    item->layerIndex = stmt->getInt(14);
    item->stripIndex = stmt->getInt(15);
    item->anodeIndex = stmt->getInt(16);
    item->strips = stmt->getInt(11);
    item->anodes = stmt->getInt(12);
    item->crateLabel = stmt->getString(2);
    item->crateid  = stmt->getInt(3);
    item->sector = stmt->getInt(8);
    item->trig_sector = stmt->getInt(9);
    item->dmb = stmt->getInt(5);
    item->cscid = stmt->getInt(7);

    stmt->setSQL("begin cms_emu_cern.ddumap.chamberid_ddu(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19); end;");

    stmt->setInt (1, chamberid);
    stmt->registerOutParam (2, oracle::occi::OCCIINT);
    stmt->registerOutParam (3, oracle::occi::OCCIINT);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCIINT);
    stmt->registerOutParam (6, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCIINT);
    stmt->registerOutParam (10, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (11, oracle::occi::OCCIINT);
    stmt->registerOutParam (12, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (13, oracle::occi::OCCIINT);
    stmt->registerOutParam (14, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);
    stmt->registerOutParam (18, oracle::occi::OCCIINT);
    stmt->registerOutParam (19, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->ddu = stmt->getInt(2);
    item->ddu_input = stmt->getInt(5);
    item->slink = stmt->getInt(7);

    item->fed_crate = stmt->getInt(3);
    item->ddu_slot = stmt->getInt(4);
    item->dcc_fifo = stmt->getString(6);
    item->fiber_crate = stmt->getInt(8);
    item->fiber_pos = stmt->getInt(9);
    item->fiber_socket = stmt->getString(10);

    con->terminateStatement (stmt);
  } //end of chamber

void cscmap1::cratedmb	(	int	crate,
		int	dmb,
		CSCMapItem::MapItem *	item
	)

Definition at line 121 of file CSCMap1.cc.

References CSCMapItem::MapItem::anodeIndex, CSCMapItem::MapItem::anodes, chamber(), CSCMapItem::MapItem::chamber, CSCMapItem::MapItem::chamberId, CSCMapItem::MapItem::chamberLabel, con, CSCMapItem::MapItem::crateid, CSCMapItem::MapItem::crateLabel, CSCMapItem::MapItem::cscid, CSCMapItem::MapItem::cscIndex, CSCMapItem::MapItem::dcc_fifo, CSCMapItem::MapItem::ddu, CSCMapItem::MapItem::ddu_input, CSCMapItem::MapItem::ddu_slot, CSCMapItem::MapItem::dmb, CSCMapItem::MapItem::endcap, Reference_intrackfit_cff::endcap, CSCMapItem::MapItem::fed_crate, CSCMapItem::MapItem::fiber_crate, CSCMapItem::MapItem::fiber_pos, CSCMapItem::MapItem::fiber_socket, CSCMapItem::MapItem::layerIndex, CSCMapItem::MapItem::ring, relativeConstraints::ring, CSCMapItem::MapItem::sector, CSCMapItem::MapItem::slink, relativeConstraints::station, CSCMapItem::MapItem::station, CSCMapItem::MapItem::stripIndex, CSCMapItem::MapItem::strips, and CSCMapItem::MapItem::trig_sector.

Referenced by CSCMap1Read::analyze().

  {
    oracle::occi::Statement *stmt = con->createStatement();

    stmt->setSQL("begin cms_emu_cern.cscmap.crateid_chamber(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17); end;");

    stmt->setInt (1, crate);
    stmt->setInt (2, dmb);
    stmt->registerOutParam (3, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCIINT);
    stmt->registerOutParam (6, oracle::occi::OCCIINT);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCIINT);
    stmt->registerOutParam (10, oracle::occi::OCCIINT);
    stmt->registerOutParam (11, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (12, oracle::occi::OCCIINT);
    stmt->registerOutParam (13, oracle::occi::OCCIINT);
    stmt->registerOutParam (14, oracle::occi::OCCIINT);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->chamberLabel = stmt->getString(3);
    item->chamberId = stmt->getInt(4);
     int chamberid = item->chamberId;
     int chamber = chamberid/10%100;
     int rest = (chamberid - chamber*10)/1000;
     int ring = rest%10;
     rest = (rest - ring)/10;
     int station = rest%10;
     int endcap = (rest - station)/10;
    item->endcap = endcap;
    item->station = station;
    item->ring = ring;
    item->chamber = chamber;
    item->cscIndex = stmt->getInt(14);
    item->layerIndex = stmt->getInt(15);
    item->stripIndex = stmt->getInt(16);
    item->anodeIndex = stmt->getInt(17);
    item->strips = stmt->getInt(12);
    item->anodes = stmt->getInt(13);
    item->crateLabel = stmt->getString(11);
    item->crateid  = stmt->getInt(9);
    item->sector = stmt->getInt(7);
    item->trig_sector = stmt->getInt(8);
    item->dmb = dmb;
    item->cscid = stmt->getInt(5);

    stmt->setSQL("begin cms_emu_cern.ddumap.chamberid_ddu(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19); end;");

    stmt->setInt (1, chamberid);
    stmt->registerOutParam (2, oracle::occi::OCCIINT);
    stmt->registerOutParam (3, oracle::occi::OCCIINT);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCIINT);
    stmt->registerOutParam (6, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCIINT);
    stmt->registerOutParam (10, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (11, oracle::occi::OCCIINT);
    stmt->registerOutParam (12, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (13, oracle::occi::OCCIINT);
    stmt->registerOutParam (14, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);
    stmt->registerOutParam (18, oracle::occi::OCCIINT);
    stmt->registerOutParam (19, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->ddu = stmt->getInt(2);
    item->ddu_input = stmt->getInt(5);
    item->slink = stmt->getInt(7);

    item->fed_crate = stmt->getInt(3);
    item->ddu_slot = stmt->getInt(4);
    item->dcc_fifo = stmt->getString(6);
    item->fiber_crate = stmt->getInt(8);
    item->fiber_pos = stmt->getInt(9);
    item->fiber_socket = stmt->getString(10);

    con->terminateStatement (stmt);
  } //end of cratedmb

void cscmap1::ruiddu	(	int	rui,
		int	ddu_input,
		CSCMapItem::MapItem *	item
	)

Definition at line 211 of file CSCMap1.cc.

References CSCMapItem::MapItem::anodeIndex, CSCMapItem::MapItem::anodes, chamber(), CSCMapItem::MapItem::chamber, CSCMapItem::MapItem::chamberId, CSCMapItem::MapItem::chamberLabel, con, CSCMapItem::MapItem::crateid, CSCMapItem::MapItem::crateLabel, CSCMapItem::MapItem::cscid, CSCMapItem::MapItem::cscIndex, CSCMapItem::MapItem::dcc_fifo, CSCMapItem::MapItem::ddu, CSCMapItem::MapItem::ddu_input, CSCMapItem::MapItem::ddu_slot, CSCMapItem::MapItem::dmb, CSCMapItem::MapItem::endcap, Reference_intrackfit_cff::endcap, CSCMapItem::MapItem::fed_crate, CSCMapItem::MapItem::fiber_crate, CSCMapItem::MapItem::fiber_pos, CSCMapItem::MapItem::fiber_socket, CSCMapItem::MapItem::layerIndex, CSCMapItem::MapItem::ring, relativeConstraints::ring, CSCMapItem::MapItem::sector, CSCMapItem::MapItem::slink, relativeConstraints::station, CSCMapItem::MapItem::station, CSCMapItem::MapItem::stripIndex, CSCMapItem::MapItem::strips, and CSCMapItem::MapItem::trig_sector.

Referenced by CSCMap1Read::analyze().

  {
    oracle::occi::Statement *stmt = con->createStatement();

    stmt->setSQL("begin cms_emu_cern.ddumap.ddu_chamber(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19); end;");

    stmt->setInt (1, rui);
    stmt->setInt (2, ddu_input);
    stmt->registerOutParam (3, oracle::occi::OCCIINT);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (6, oracle::occi::OCCIINT);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (10, oracle::occi::OCCIINT);
    stmt->registerOutParam (11, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (12, oracle::occi::OCCIINT);
    stmt->registerOutParam (13, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (14, oracle::occi::OCCIINT);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);
    stmt->registerOutParam (18, oracle::occi::OCCIINT);
    stmt->registerOutParam (19, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->ddu = rui;
    item->ddu_input = ddu_input;
    item->slink = stmt->getInt(6);

    item->fed_crate = stmt->getInt(3);
    item->ddu_slot = stmt->getInt(4);
    item->dcc_fifo = stmt->getString(5);
    item->fiber_crate = stmt->getInt(7);
    item->fiber_pos = stmt->getInt(8);
    item->fiber_socket = stmt->getString(9);
    int chamberid = stmt->getInt(14);

    stmt->setSQL("begin cms_emu_cern.cscmap.chamberid_crate(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20); end;");

    stmt->setInt (1, chamberid);
    stmt->registerOutParam (2, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (3, oracle::occi::OCCIINT);
    stmt->registerOutParam (4, oracle::occi::OCCIINT);
    stmt->registerOutParam (5, oracle::occi::OCCIINT);
    stmt->registerOutParam (6, oracle::occi::OCCIINT);
    stmt->registerOutParam (7, oracle::occi::OCCIINT);
    stmt->registerOutParam (8, oracle::occi::OCCIINT);
    stmt->registerOutParam (9, oracle::occi::OCCIINT);
    stmt->registerOutParam (10, oracle::occi::OCCISTRING, 10);
    stmt->registerOutParam (11, oracle::occi::OCCIINT);
    stmt->registerOutParam (12, oracle::occi::OCCIINT);
    stmt->registerOutParam (13, oracle::occi::OCCIINT);
    stmt->registerOutParam (14, oracle::occi::OCCIINT);
    stmt->registerOutParam (15, oracle::occi::OCCIINT);
    stmt->registerOutParam (16, oracle::occi::OCCIINT);
    stmt->registerOutParam (17, oracle::occi::OCCIINT);
    stmt->registerOutParam (18, oracle::occi::OCCIINT);
    stmt->registerOutParam (19, oracle::occi::OCCIINT);
    stmt->registerOutParam (20, oracle::occi::OCCIINT);

    stmt->execute(); //execute procedure

    item->chamberLabel = stmt->getString(10);
    item->chamberId = chamberid;
     int chamber = chamberid/10%100;
     int rest = (chamberid - chamber*10)/1000;
     int ring = rest%10;
     rest = (rest - ring)/10;
     int station = rest%10;
     int endcap = (rest - station)/10;
    item->endcap = endcap;
    item->station = station;
    item->ring = ring;
    item->chamber = chamber;
    item->cscIndex = stmt->getInt(13);
    item->layerIndex = stmt->getInt(14);
    item->stripIndex = stmt->getInt(15);
    item->anodeIndex = stmt->getInt(16);
    item->strips = stmt->getInt(11);
    item->anodes = stmt->getInt(12);
    item->crateLabel = stmt->getString(2);
    item->crateid  = stmt->getInt(3);
    item->sector = stmt->getInt(8);
    item->trig_sector = stmt->getInt(9);
    item->dmb = stmt->getInt(5);
    item->cscid = stmt->getInt(7);

    stmt->execute(); //execute procedure

    con->terminateStatement (stmt);
  } //end of ruiddu

---

Member Data Documentation

oracle::occi::Connection* cscmap1::con [private]

Definition at line 14 of file CSCMap1.h.

Referenced by chamber(), cratedmb(), cscmap1(), ruiddu(), and ~cscmap1().

oracle::occi::Environment* cscmap1::env [private]

Definition at line 13 of file CSCMap1.h.

Referenced by cscmap1(), and ~cscmap1().