12 char *c_user = std::getenv(
"CSCMAP_AUTH_USER");
13 char *c_pass = std::getenv(
"CSCMAP_AUTH_PASSWORD");
19 std::cout <<
"Connection to mapping DB is done." << std::endl;
25 env->terminateConnection(
con);
26 oracle::occi::Environment::terminateEnvironment(
env);
34 int *first_strip_index,
35 int *strips_per_layer,
37 oracle::occi::Statement *stmt =
con->createStatement();
38 stmt->setSQL(
"begin cscmap.chamber0(:1, :2, :3, :4, :5, :6, :7, :8); end;");
40 stmt->setInt(1, crate0);
42 stmt->registerOutParam(3, oracle::occi::OCCISTRING, 10);
43 stmt->registerOutParam(4, oracle::occi::OCCIINT);
44 stmt->registerOutParam(5, oracle::occi::OCCIINT);
45 stmt->registerOutParam(6, oracle::occi::OCCIINT);
46 stmt->registerOutParam(7, oracle::occi::OCCIINT);
47 stmt->registerOutParam(8, oracle::occi::OCCIINT);
51 *chamber_id = stmt->getString(3);
52 *chamber_num = stmt->getInt(4);
53 *chamber_index = stmt->getInt(5);
54 *first_strip_index = stmt->getInt(6);
55 *strips_per_layer = stmt->getInt(7);
58 con->terminateStatement(stmt);
66 int *first_strip_index,
67 int *strips_per_layer,
69 oracle::occi::Statement *stmt =
con->createStatement();
70 stmt->setSQL(
"begin cscmap.chamber(:1, :2, :3, :4, :5, :6, :7, :8); end;");
72 stmt->setInt(1,
crate);
74 stmt->registerOutParam(3, oracle::occi::OCCISTRING, 10);
75 stmt->registerOutParam(4, oracle::occi::OCCIINT);
76 stmt->registerOutParam(5, oracle::occi::OCCIINT);
77 stmt->registerOutParam(6, oracle::occi::OCCIINT);
78 stmt->registerOutParam(7, oracle::occi::OCCIINT);
79 stmt->registerOutParam(8, oracle::occi::OCCIINT);
83 *chamber_id = stmt->getString(3);
84 *chamber_num = stmt->getInt(4);
85 *chamber_index = stmt->getInt(5);
86 *first_strip_index = stmt->getInt(6);
87 *strips_per_layer = stmt->getInt(7);
90 con->terminateStatement(stmt);
99 int *first_strip_index,
100 int *strips_per_layer,
101 int *chamber_index) {
102 oracle::occi::Statement *stmt =
con->createStatement();
103 stmt->setSQL(
"begin cscmap.crate0_proc(:1, :2, :3, :4, :5, :6, :7, :8, :9); end;");
105 stmt->setString(1, chamber_id);
106 stmt->registerOutParam(2, oracle::occi::OCCIINT);
107 stmt->registerOutParam(3, oracle::occi::OCCIINT);
108 stmt->registerOutParam(4, oracle::occi::OCCIINT);
109 stmt->registerOutParam(5, oracle::occi::OCCIINT);
110 stmt->registerOutParam(6, oracle::occi::OCCIINT);
111 stmt->registerOutParam(7, oracle::occi::OCCIINT);
112 stmt->registerOutParam(8, oracle::occi::OCCIINT);
113 stmt->registerOutParam(9, oracle::occi::OCCIINT);
117 *crate0 = stmt->getInt(2);
118 *
crate = stmt->getInt(3);
119 *dmb = stmt->getInt(4);
120 *
sector = stmt->getInt(5);
121 *chamber_num = stmt->getInt(6);
122 *chamber_index = stmt->getInt(7);
123 *first_strip_index = stmt->getInt(8);
124 *strips_per_layer = stmt->getInt(9);
126 con->terminateStatement(stmt);
oracle::occi::Environment * env
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)
oracle::occi::Connection * con
~cscmap() noexcept(false)
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)