35 if (runtype != m_runType) {
58 this->checkConnection();
61 Statement* stmt = m_conn->createStatement();
62 stmt->setSQL(
"SELECT def_id FROM run_type_def WHERE " 65 stmt->setString(1, m_runType);
67 ResultSet* rset = stmt->executeQuery();
70 m_ID = rset->getInt(1);
74 m_conn->terminateStatement(stmt);
75 }
catch (SQLException &
e) {
76 throw(std::runtime_error(
"RunTypeDef::fetchID: "+e.getMessage()));
87 this->checkConnection();
90 Statement* stmt = m_conn->createStatement();
92 stmt->setSQL(
"SELECT run_type, description FROM run_type_def WHERE def_id = :1");
95 ResultSet* rset = stmt->executeQuery();
97 m_runType = rset->getString(1);
98 m_desc = rset->getString(2);
100 throw(std::runtime_error(
"RunTypeDef::setByID: Given def_id is not in the database"));
103 m_conn->terminateStatement(stmt);
104 }
catch (SQLException &
e) {
105 throw(std::runtime_error(
"RunTypeDef::setByID: "+e.getMessage()));
114 this->checkConnection();
116 Statement* stmt = m_conn->createStatement();
117 stmt->setSQL(
"SELECT def_id FROM run_type_def ORDER BY def_id");
118 ResultSet* rset = stmt->executeQuery();
123 while(rset->next()) {
124 runTypeDef.
setByID( rset->getInt(1) );
125 fillVec->push_back( runTypeDef );
127 }
catch (SQLException &
e) {
128 throw(std::runtime_error(
"RunTypeDef::fetchAllDefs: "+e.getMessage()));
std::string getDescription() const
std::string getRunType() const
int fetchID() noexcept(false) override
void setByID(int id) noexcept(false) override
void setRunType(std::string runtype)
void fetchAllDefs(std::vector< RunTypeDef > *fillVec) noexcept(false)
void setConnection(oracle::occi::Environment *env, oracle::occi::Connection *conn)