cscmap Class Reference

#include <CSCMap.h>

Public Member Functions
void	chamber_crate (std::string chamber_id, int *crate, int *dmb, int *sector, int *chamber_num, int *crate0, int *first_strip_index, int *strips_per_layer, int *chamber_index)
void	crate0_chamber (int crate0, int dmb, std::string *chamber_id, int *chamber_num, int *sector, int *first_strip_index, int *strips_per_layer, int *chamber_index)
void	crate_chamber (int crate, int dmb, std::string *chamber_id, int *chamber_num, int *sector, int *first_strip_index, int *strips_per_layer, int *chamber_index)
	cscmap () noexcept(false)
	~cscmap () noexcept(false)

Private Attributes
oracle::occi::Connection *	con
oracle::occi::Environment *	env

Detailed Description

Definition at line 8 of file CSCMap.h.

Constructor & Destructor Documentation

cscmap()

cscmap::cscmap ( )

noexcept

Constructor for cscmap

Definition at line 8 of file CSCMap.cc.

References cms::cuda::assert(), con, gather_cfg::cout, copyBadStrip_cfg::db_user, SiStripPI::DEFAULT, env, and AlCaHLTBitMon_QueryRunRegistry::string.

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

~cscmap()

cscmap::~cscmap ( )

noexcept

Destructor for cscmap

Destructor for cscmap.

Definition at line 24 of file CSCMap.cc.

References con, and env.

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

Member Function Documentation

chamber_crate()

void cscmap::chamber_crate	(	std::string	chamber_id,
		int *	crate,
		int *	dmb,
		int *	sector,
		int *	chamber_num,
		int *	crate0,
		int *	first_strip_index,
		int *	strips_per_layer,
		int *	chamber_index
	)

Definition at line 93 of file CSCMap.cc.

References con, FCDTask_cfi::crate, and nano_mu_digi_cff::sector.

                                               {
  oracle::occi::Statement *stmt = con->createStatement();
  stmt->setSQL("begin cscmap.crate0_proc(:1, :2, :3, :4, :5, :6, :7, :8, :9); end;");

  stmt->setString(1, chamber_id);
  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::OCCIINT);
  stmt->registerOutParam(7, oracle::occi::OCCIINT);
  stmt->registerOutParam(8, oracle::occi::OCCIINT);
  stmt->registerOutParam(9, oracle::occi::OCCIINT);

  stmt->execute();  //execute procedure

  *crate0 = stmt->getInt(2);
  *crate = stmt->getInt(3);
  *dmb = stmt->getInt(4);
  *sector = stmt->getInt(5);
  *chamber_num = stmt->getInt(6);
  *chamber_index = stmt->getInt(7);
  *first_strip_index = stmt->getInt(8);
  *strips_per_layer = stmt->getInt(9);

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

crate0_chamber()

void cscmap::crate0_chamber	(	int	crate0,
		int	dmb,
		std::string *	chamber_id,
		int *	chamber_num,
		int *	sector,
		int *	first_strip_index,
		int *	strips_per_layer,
		int *	chamber_index
	)

Definition at line 29 of file CSCMap.cc.

References con, and nano_mu_digi_cff::sector.

                                                {
  oracle::occi::Statement *stmt = con->createStatement();
  stmt->setSQL("begin cscmap.chamber0(:1, :2, :3, :4, :5, :6, :7, :8); end;");

  stmt->setInt(1, crate0);
  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->execute();  //execute procedure

  *chamber_id = stmt->getString(3);
  *chamber_num = stmt->getInt(4);
  *chamber_index = stmt->getInt(5);
  *first_strip_index = stmt->getInt(6);
  *strips_per_layer = stmt->getInt(7);
  *sector = stmt->getInt(8);

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

crate_chamber()

void cscmap::crate_chamber	(	int	crate,
		int	dmb,
		std::string *	chamber_id,
		int *	chamber_num,
		int *	sector,
		int *	first_strip_index,
		int *	strips_per_layer,
		int *	chamber_index
	)

Definition at line 61 of file CSCMap.cc.

References con, FCDTask_cfi::crate, and nano_mu_digi_cff::sector.

                                               {
  oracle::occi::Statement *stmt = con->createStatement();
  stmt->setSQL("begin cscmap.chamber(:1, :2, :3, :4, :5, :6, :7, :8); 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->execute();  //execute procedure

  *chamber_id = stmt->getString(3);
  *chamber_num = stmt->getInt(4);
  *chamber_index = stmt->getInt(5);
  *first_strip_index = stmt->getInt(6);
  *strips_per_layer = stmt->getInt(7);
  *sector = stmt->getInt(8);

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

Member Data Documentation

con

oracle::occi::Connection* cscmap::con

private

Definition at line 11 of file CSCMap.h.

Referenced by chamber_crate(), crate0_chamber(), crate_chamber(), cscmap(), and ~cscmap().

env

oracle::occi::Environment* cscmap::env

private

Definition at line 10 of file CSCMap.h.

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