// TestRunDB
//
// 2-aug-2000  kh  Use pii3.brahms.bnl.gov
//
// Read BRAHMS Online Run database and get neat stuff from it.
//
// $Author: Kris Hagel (copied from TestDBRead.cxx by aholm $
// $Date: 2000/07/19 13:17:48 $
// $Copyright: BRAHMS collaboration
// $Id: TestDBRead.cxx,v 1.7 2000/07/19 13:17:48 aholm Exp $
//

{
  gROOT->Reset();

#define  MAIN_NAME  "BrahmsMain"
#define  MAIN_HOST  "pii3.brahms.bnl.gov"
#define  USER_NAME  "query"
#define  PASSWORD   "query-only"

    cout << "*************************************" << endl;
    cout << "**                                 **" << endl;
    cout << "** Test BrRunDB class              **" << endl;
    cout << "**                                 **" << endl;
    cout << "*************************************" << endl;

    cout << "Connecting to main database" << endl;
    BrMainDb* mainDb  = 
          new BrMainDb(USER_NAME, PASSWORD, MAIN_HOST, MAIN_NAME);

    cout << "Connecting to run database" << endl;
    BrRunsDb* runDb = mainDb->ConnectToRun("query","query-only");

    cout<<" Creating runInfoManager"<<endl;
    BrRunInfoManager *runInfoManager = BrRunInfoManager::Instance();
    runInfoManager->Init();

    cout<<"Trying to get run directly"<<endl;
    BrDbRun = runDb->GetRun("RunNo = 2482");

    cout<<"Doing runInfoManager->Update()"<<endl;
    runInfoManager->Update(2482);
    cout<<"Getting current run"<<endl;

    BrRunInfo *runInfo = runInfoManager->GetCurrentRun();
    if(runInfo) {
       cout<<*runInfo;
       }
    else {
      printf("runInfo == 0!!!\n");
       }

    /*
    cout<<"Selecting Runs"<<endl;

    TDatime time1(2000,6,27,0,0,0);
    TDatime time2(2000,6,28,0,0,0);

    Char_t query[64];
    sprintf(query,"StartTime > %d and EndTime < %d",time1.Convert(),time2.Convert());
    BrRun *run = runDb->GetRun("RunNo = 1554");
    if(run) cout<<*run;
    */

    /*
    TObjArray *runList = runDb->GetXRun(query);
    printf("run entries = %d\n",runList->GetEntries());
    for(Int_t ijkk = 0;ijkk<runList->GetEntries();ijkk++) {
       BrRun *run = (BrRun*)runList->At(ijkk);
       printf("Run number found = %d\n",run->GetRunNo());
       }
    */
}