// -*- mode: c++ -*- 
// $Id: BrRootDb.h,v 1.1 2001/10/08 10:31:44 cholm Exp $
// $Author: cholm $
// $Date: 2001/10/08 10:31:44 $
// $Copyright: 2000 Brahms Collaboration 
//
#ifndef BRAT_BrRootDb
#define BRAT_BrRootDb
#ifndef ROOT_TSQLServer
#include "TSQLServer.h"
#endif
#ifndef ROOT_TSQLResult
#include "TSQLResult.h"
#endif
#ifndef ROOT_TSQLRow
#include "TSQLRow.h"
#endif
#ifndef ROOT_TFile
#include "TFile.h"
#endif
#ifndef BRAT_BrDb
#include "BrDb.h"
#endif
#ifndef BRAT_BrDbQuery
#include "BrDbQuery.h"
#endif

class BrRootDb : public BrVirtualDb
{
protected:
  TString  fFileName;     // Cachecd file name.  
  TFile*   fConnection;   //! The connection 
  TObject* fSequence;     //! Pointer to sequence in this DB. 

  TObject* GetConnection() { return fConnection; }
public:
  BrRootDb(const Char_t* name, const Char_t* title="");
  virtual ~BrRootDb();

  virtual Bool_t       Connect(Option_t* option="");
  virtual void         Close(Option_t* option="");

  virtual TSQLResult*  Query(BrDbQuery* query);
  virtual TSQLRow*     GetSingle(const Char_t* table, 
				 const Char_t* condition);   
  virtual TSQLResult*  GetMultiple(const Char_t* table, 
				   const Char_t* condition);

  virtual Bool_t       IsConnected() const { return fConnection ? kTRUE : kFALSE; }
  
  virtual void         LockTables(const Char_t* writetables,int i=0);
  virtual void         UnLockTables();
  virtual Int_t        Increment();
  virtual void         CreateSequence();

  ClassDef(BrRootDb,0) // Brahms Database class
}
;

#endif // _BrRootDb_HH