| 6 |
#include <TSQLServer.h> |
#include <TSQLServer.h> |
| 7 |
#include <TSQLRow.h> |
#include <TSQLRow.h> |
| 8 |
#include <TSQLResult.h> |
#include <TSQLResult.h> |
| 9 |
|
#include <TSystem.h> |
| 10 |
#include <GLTablesStruct.h> |
#include <GLTablesStruct.h> |
| 11 |
#include <EventHeader.h> |
#include <EventHeader.h> |
| 12 |
#include <PscuHeader.h> |
#include <PscuHeader.h> |
| 13 |
#include <RunHeaderEvent.h> |
#include <RunHeaderEvent.h> |
| 14 |
#include <RunTrailerEvent.h> |
#include <RunTrailerEvent.h> |
| 15 |
#include <sgp4.h> |
#include <sgp4.h> |
| 16 |
|
// |
| 17 |
|
|
| 18 |
using namespace pamela; |
using namespace pamela; |
| 19 |
|
// |
| 20 |
|
|
| 21 |
|
static const TString *fHost; |
| 22 |
|
static const TString *fUser; |
| 23 |
|
static const TString *fPsw; |
| 24 |
|
static UInt_t fNquery; |
| 25 |
|
static Bool_t fSet; |
| 26 |
|
|
| 27 |
// ================================================================== |
// ================================================================== |
| 28 |
/** |
/** |
| 29 |
* \brief Class to store GL_RUN data |
* \brief Class to store GL_RUN data |
| 30 |
*/ |
*/ |
| 31 |
class GL_RUN : public TObject { |
class GL_TABLES : public TObject { |
| 32 |
|
private: |
| 33 |
|
|
| 34 |
|
public: |
| 35 |
|
// |
| 36 |
|
GL_TABLES(); |
| 37 |
|
GL_TABLES(TString, TString, TString); |
| 38 |
|
// |
| 39 |
|
void Set(TString, TString, TString); |
| 40 |
|
// |
| 41 |
|
Bool_t IsConnected(TSQLServer *); |
| 42 |
|
// |
| 43 |
|
void ResetCounters(); |
| 44 |
|
void AddQ(); |
| 45 |
|
// |
| 46 |
|
const TString* GetHost(){return(fHost);}; |
| 47 |
|
const TString* GetUser(){return(fUser);}; |
| 48 |
|
const TString* GetPsw(){return(fPsw);}; |
| 49 |
|
UInt_t GetfNquery(){return(fNquery);}; |
| 50 |
|
UInt_t GetNqueries(); |
| 51 |
|
Bool_t IsSet(){return(fSet);}; |
| 52 |
|
// |
| 53 |
|
GL_TABLES *GetGLTABLES(){return this;}; |
| 54 |
|
// |
| 55 |
|
ClassDef(GL_TABLES,1); |
| 56 |
|
}; |
| 57 |
|
|
| 58 |
|
// ================================================================== |
| 59 |
|
/** |
| 60 |
|
* \brief Class to store GL_RUN data |
| 61 |
|
*/ |
| 62 |
|
//class GL_RUN : public TObject { |
| 63 |
|
class GL_RUN : public GL_TABLES { |
| 64 |
private: |
private: |
| 65 |
|
|
| 66 |
public: |
public: |
| 187 |
/** |
/** |
| 188 |
* \brief Class to store GL_ROOT |
* \brief Class to store GL_ROOT |
| 189 |
*/ |
*/ |
| 190 |
class GL_ROOT : public TObject{ |
class GL_ROOT : public GL_TABLES { |
| 191 |
|
//class GL_ROOT : public TObject{ |
| 192 |
private: |
private: |
| 193 |
|
|
| 194 |
public: |
public: |
| 209 |
/** |
/** |
| 210 |
* \brief Class to store GL_PARAM data |
* \brief Class to store GL_PARAM data |
| 211 |
*/ |
*/ |
| 212 |
class GL_PARAM : public TObject{ |
class GL_PARAM : public GL_TABLES { |
| 213 |
|
//class GL_PARAM : public TObject{ |
| 214 |
private: |
private: |
| 215 |
|
|
| 216 |
public: |
public: |
| 233 |
/** |
/** |
| 234 |
* \brief Class to store GL_TRK_CALIB data |
* \brief Class to store GL_TRK_CALIB data |
| 235 |
*/ |
*/ |
| 236 |
class GL_TRK_CALIB : public TObject{ |
//class GL_TRK_CALIB : public TObject{ |
| 237 |
|
class GL_TRK_CALIB : public GL_TABLES { |
| 238 |
private: |
private: |
| 239 |
|
|
| 240 |
public: |
public: |
| 263 |
/** |
/** |
| 264 |
* \brief Class to store GL_CALO_CALIB data |
* \brief Class to store GL_CALO_CALIB data |
| 265 |
*/ |
*/ |
| 266 |
class GL_CALO_CALIB : public TObject{ |
class GL_CALO_CALIB : public GL_TABLES { |
| 267 |
|
//class GL_CALO_CALIB : public TObject{ |
| 268 |
private: |
private: |
| 269 |
|
|
| 270 |
public: |
public: |
| 286 |
/** |
/** |
| 287 |
* \brief Class to store GL_S4_CALIB data |
* \brief Class to store GL_S4_CALIB data |
| 288 |
*/ |
*/ |
| 289 |
class GL_S4_CALIB : public TObject{ |
class GL_S4_CALIB : public GL_TABLES { |
| 290 |
|
//class GL_S4_CALIB : public TObject{ |
| 291 |
private: |
private: |
| 292 |
|
|
| 293 |
public: |
public: |
| 311 |
/** |
/** |
| 312 |
* \brief Class to store TIMESYNC data |
* \brief Class to store TIMESYNC data |
| 313 |
*/ |
*/ |
| 314 |
class GL_TIMESYNC : public TObject{ |
class GL_TIMESYNC : public GL_TABLES { |
| 315 |
|
//class GL_TIMESYNC : public TObject{ |
| 316 |
private: |
private: |
| 317 |
UInt_t obtfirst; |
UInt_t obtfirst; |
| 318 |
UInt_t pktfirst; |
UInt_t pktfirst; |
| 347 |
ClassDef(GL_TIMESYNC,2); |
ClassDef(GL_TIMESYNC,2); |
| 348 |
}; |
}; |
| 349 |
|
|
| 350 |
/* Class to query a TLE from the db. |
|
| 351 |
|
/* |
| 352 |
|
* Class to query a TLE from the db. |
| 353 |
* |
* |
| 354 |
* Two methods are implemented. |
* Two non default constructor are avaiable. It is the same to call |
| 355 |
|
* the Query method. |
| 356 |
|
* |
| 357 |
|
* The class looks for a TLE in the GL_TLE table using the connection |
| 358 |
|
* dbc. You need to pass an UTC date in SQL datetime format or in |
| 359 |
|
* unix time (UTC) and it will look for the tle with the nearest and |
| 360 |
|
* previous date. Then it initialize tle to a cTle object, |
| 361 |
|
* tleFromTime to the UTC unix time of the tle and tleToTime to the |
| 362 |
|
* UTC unix time of the next avaible tle. |
| 363 |
*/ |
*/ |
| 364 |
class GL_TLE : public TObject{ |
class GL_TLE : public GL_TABLES { |
| 365 |
|
//class GL_TLE : public TObject{ |
| 366 |
private: |
private: |
| 367 |
cTle *Query_GL_TLE_go(TString, TSQLServer *); |
Int_t DoQuery(TString query, TSQLServer *dbc); |
| 368 |
|
cTle* GiveTle(TSQLRow*); |
| 369 |
|
|
| 370 |
public: |
cTle *tle; // the requested tle |
| 371 |
GL_TLE(); |
UInt_t tleFromTime; // unix time (UTC) of the tle |
| 372 |
|
UInt_t tleToTime; // unix time (UTC) of the next tle |
| 373 |
|
|
| 374 |
cTle* Query_GL_TLE(UInt_t unixtime, TSQLServer *dbc); |
public: |
| 375 |
cTle* Query_GL_TLE(TString date, TSQLServer *dbc); |
GL_TLE(){ |
| 376 |
|
tle = NULL; |
| 377 |
|
tleFromTime = 0; |
| 378 |
|
tleToTime = 0; |
| 379 |
|
}; |
| 380 |
|
|
| 381 |
|
GL_TLE(UInt_t unixtime, TSQLServer *dbc) { |
| 382 |
|
Query(unixtime, dbc); |
| 383 |
|
}; |
| 384 |
|
|
| 385 |
|
GL_TLE(TString date, TSQLServer *dbc) { |
| 386 |
|
Query(date, dbc); |
| 387 |
|
}; |
| 388 |
|
|
| 389 |
|
Int_t Query(UInt_t unixtime, TSQLServer *dbc); |
| 390 |
|
Int_t Query(TString date, TSQLServer *dbc); |
| 391 |
|
|
| 392 |
|
cTle* GetTle() const { return tle; } |
| 393 |
|
UInt_t GetFromTime() const { return tleFromTime; } |
| 394 |
|
UInt_t GetToTime() const { return tleToTime; } |
| 395 |
|
|
| 396 |
ClassDef(GL_TLE,1); |
ClassDef(GL_TLE,1); |
| 397 |
}; |
}; |