dbcon/inc/e3RunDbConn.h

#ifndef E3RUNDBCONN_H
#define E3RUNDBCONN_H

#include <string>
#include <cmath>
#include <iostream>
#include <fstream> 
#include <sstream> 
#include <cstdlib>
#include <ctime>
#include <cstring>
#include <climits> //for INT_MAX
#include <map>
#include <vector>

#include <my_global.h>
#include <mysql.h>

using namespace std;


class e3RunDbConn{

 private:

  int  _vLevel;                       

  string _hostName;            
  string _dbUser;                 
  string _dbPwd;                  
  string _dbName;               
  MYSQL *_mysqlCon;

  stringstream _queryStr;
  MYSQL_RES *_queryRes;
  MYSQL_FIELD *_dbFields;
  MYSQL_ROW _dbRow;

  struct tm _e3Start;
  time_t _e3StartTime;
  int _overtime;

  void finish_with_error();

 protected:

 public:


  e3RunDbConn(){ _vLevel=0; _mysqlCon = NULL; };


  e3RunDbConn(const string, const string, const string, const string);


  ~e3RunDbConn(){};


  void Init();


  void CloseConn();


  int GetTelescopeList(vector<string>&, const string);


  int GetRunList(vector<string>&, const string, const string, const string, const string, unsigned int);


  int GetDaqConf(vector<string>&, const string, const string, const string);


  int GetDaqConfList(vector<string>&, const string, const string, const string, const string);


  inline void SetOvertime(unsigned int overtime){ _overtime = overtime; _overtime*=(60*60); };      
  inline void SetVerbosity(unsigned int vLevel){ _vLevel = vLevel; };                

};

#endif

---