Standard interface with SQL database. More...
#include </dev/shm/kenichi/update-github-e1039-doc/e1039-core/packages/db_svc/DbSvc.h>
Classes | |
| class | VarList |
Public Types | |
| enum | SvrId_t { AutoSvr , DB1 , DB2 , DB3 , DB4 , LITE , LOCAL } |
| enum | UsrId_t { AutoUsr , Guest , Prod } |
Public Member Functions | |
| DbSvc (const SvrId_t svr_id=AutoSvr, const UsrId_t usr_id=AutoUsr, const std::string my_cnf="") | |
| DbSvc (const SvrId_t svr_id, std::string dbfile) | |
| ~DbSvc () | |
| void | UseSchema (const char *name, const bool do_create=false, const bool do_drop=false) |
| void | UseSchema (const std::string name, const bool do_create=false, const bool do_drop=false) |
| void | DropTable (const char *name) |
| void | DropTable (const std::string name) |
| bool | HasTable (const char *name, const bool exit_on_false=false) |
| bool | HasTable (const std::string name, const bool exit_on_false=false) |
| void | CreateTable (const std::string name, const std::vector< std::string > list_var, const std::vector< std::string > list_type, const std::vector< std::string > list_key) |
| void | CreateTable (const std::string name, const int n_var, const char **list_var, const char **list_type, const int n_key=0, const char **list_key=0) |
| void | CreateTable (const std::string name, const VarList list) |
| TSQLServer * | Con () |
| TSQLStatement * | Process (const char *query) |
| TSQLStatement * | Process (const std::string query) |
Detailed Description
Standard interface with SQL database.
A server and a user can be selected via "DB_SERVER" and "DB_USER" in recoConsts. But they can be specified if needed, when each DbSvc object is created.
Member Enumeration Documentation
◆ SvrId_t
| enum DbSvc::SvrId_t |
◆ UsrId_t
| enum DbSvc::UsrId_t |
Constructor & Destructor Documentation
◆ DbSvc() [1/2]
◆ DbSvc() [2/2]
|
explicit |
◆ ~DbSvc()
Member Function Documentation
◆ Con()
|
inline |
Definition at line 44 of file DbSvc.h.
Referenced by Fun4AllSpillSRawEventOutputManager::CloseFile(), Fun4AllSpillDstOutputManager::DstFinished(), Fun4AllSpillDstOutputManager::DstStarted(), Fun4AllSpillSRawEventOutputManager::OpenFile(), DecoStatusDb::RunFinished(), DecoStatusDb::RunStarted(), DecoStatusDb::RunUpdated(), Fun4AllSpillSRawEventOutputManager::UpdateDBStatus(), CalibParamInTimeTaiwan::WriteDbTable(), CalibParamInTimeV1495::WriteDbTable(), CalibParamXT::WriteDbTable(), ChanMapScaler::WriteDbTable(), ChanMapTaiwan::WriteDbTable(), ChanMapV1495::WriteDbTable(), GeomParamPlane::WriteDbTable(), and ParamRunRange::WriteToDB().
Here is the caller graph for this function:◆ CreateTable() [1/3]
| void DbSvc::CreateTable | ( | const std::string | name, |
| const int | n_var, | ||
| const char ** | list_var, | ||
| const char ** | list_type, | ||
| const int | n_key = 0, |
||
| const char ** | list_key = 0 |
||
| ) |
Definition at line 135 of file DbSvc.cc.
References CreateTable().
Here is the call graph for this function:◆ CreateTable() [2/3]
| void DbSvc::CreateTable | ( | const std::string | name, |
| const std::vector< std::string > | list_var, | ||
| const std::vector< std::string > | list_type, | ||
| const std::vector< std::string > | list_key | ||
| ) |
Definition at line 102 of file DbSvc.cc.
References HasTable().
Referenced by CreateTable(), Fun4AllSpillDstOutputManager::EnableDB(), Fun4AllSpillSRawEventOutputManager::EnableDB(), DecoStatusDb::InitTable(), CalibParamInTimeTaiwan::WriteDbTable(), CalibParamInTimeV1495::WriteDbTable(), CalibParamXT::WriteDbTable(), ChanMapScaler::WriteDbTable(), ChanMapTaiwan::WriteDbTable(), ChanMapV1495::WriteDbTable(), GeomParamPlane::WriteDbTable(), and ParamRunRange::WriteToDB().
Here is the call graph for this function: Here is the caller graph for this function:◆ CreateTable() [3/3]
| void DbSvc::CreateTable | ( | const std::string | name, |
| const VarList | list | ||
| ) |
Definition at line 150 of file DbSvc.cc.
References CreateTable(), DbSvc::VarList::Get(), and DbSvc::VarList::Size().
Here is the call graph for this function:◆ DropTable() [1/2]
| void DbSvc::DropTable | ( | const char * | name | ) |
Definition at line 82 of file DbSvc.cc.
Referenced by Fun4AllSpillDstOutputManager::EnableDB(), Fun4AllSpillSRawEventOutputManager::EnableDB(), DecoStatusDb::InitTable(), RunParamBase::WriteToDB(), and ParamRunRange::WriteToDB().
Here is the caller graph for this function:◆ DropTable() [2/2]
|
inline |
Definition at line 37 of file DbSvc.h.
References DropTable().
Referenced by DropTable().
Here is the call graph for this function: Here is the caller graph for this function:◆ HasTable() [1/2]
| bool DbSvc::HasTable | ( | const char * | name, |
| const bool | exit_on_false = false |
||
| ) |
Definition at line 92 of file DbSvc.cc.
Referenced by CreateTable(), Fun4AllSpillDstOutputManager::EnableDB(), Fun4AllSpillSRawEventOutputManager::EnableDB(), DecoStatusDb::InitTable(), RunParamBase::ReadFromDB(), and ParamRunRange::ReadFromDB().
Here is the caller graph for this function:◆ HasTable() [2/2]
|
inline |
Definition at line 39 of file DbSvc.h.
References HasTable().
Referenced by HasTable().
Here is the call graph for this function: Here is the caller graph for this function:◆ Process() [1/2]
| TSQLStatement * DbSvc::Process | ( | const char * | query | ) |
This function runs Statement(), Process() and StoreResult() with error check. The return object (TSQLStatement*) must be deleted by user. Example: TSQLStatement* stmt = db_svc->Process(query); while (stmt->NextResultRow()) { int id = stmt->GetInt(0); int event = stmt->GetInt(1); } delete stmt;
Definition at line 176 of file DbSvc.cc.
References LITE.
Referenced by SQG4DipoleMagnetDetector::Construct(), CalibParamInTimeTaiwan::ReadDbTable(), CalibParamInTimeV1495::ReadDbTable(), CalibParamXT::ReadDbTable(), ChanMapScaler::ReadDbTable(), ChanMapTaiwan::ReadDbTable(), ChanMapV1495::ReadDbTable(), GeomParamPlane::ReadDbTable(), and ParamRunRange::ReadFromDB().
Here is the caller graph for this function:◆ Process() [2/2]
|
inline |
◆ UseSchema() [1/2]
| void DbSvc::UseSchema | ( | const char * | name, |
| const bool | do_create = false, |
||
| const bool | do_drop = false |
||
| ) |
Definition at line 52 of file DbSvc.cc.
Referenced by DecoError::AggregateData(), DecoStatusDb::DecoStatusDb(), Fun4AllSpillDstOutputManager::EnableDB(), Fun4AllSpillSRawEventOutputManager::EnableDB(), RunParamBase::ReadFromDB(), ParamRunRange::ReadFromDB(), RunParamBase::WriteToDB(), and ParamRunRange::WriteToDB().
Here is the caller graph for this function:◆ UseSchema() [2/2]
|
inline |
Definition at line 34 of file DbSvc.h.
References UseSchema().
Referenced by UseSchema().
Here is the call graph for this function: Here is the caller graph for this function:The documentation for this class was generated from the following files:
