#ifndef __DataFromSpryWare_h_
#define __DataFromSpryWare_h_


#include <string>
#include <MisApi.h>
#include <MISDirectory.h>
#include <MisTypes.h>
#include <Database/ITable.h>
#include "DataFormats.h"

class DataFromSpryWare
{
private:
  MisDirectory *pDirectory;
  
  Database::ITable *pTableHistory;;
  Database::Key *keyHistory;
  Database::Record *recordHistory;
  
  Database::ITable *pTable1Min;
  Database::Key *key1Min;
  Database::Record *record1Min;
  
  Database::ITable *pTableCorporateActions;
  Database::Key *keyCorporateActions;
  Database::Record *recordCorporateActions;
  
  Database::ITable *pTableFundamentalPrice;
  Database::Key *keyFundamentalPrice;
  Database::Record *recordFundamentalPrice;
  
  
/*  Database::ITable *pTableFundamental;
  Database::Key *keyFundamental;
  Database::Record *recordFundamental;
  
  Database::ITable *pTableEquityFundamental;
  Database::Key *keyEquityFundamental;
  Database::Record *recordEquityFundamental;
  
  Database::ITable *pTableIndexFundamental;
  Database::Key *keyIndexFundamental;
  Database::Record *recordIndexFundamental;*/

  void connectTable(Database::ITable * &, Database::Key * &,Database::Record * &, const std::string &, const int & = 0);
  
public:
  void connect();
  void disconnect();
  void getDailyBars(const std::string &symbol, BarList &data1Day);
  void get1MinBars(const std::string &symbol, BarList &data1Min);
  void getFundamentalData(const std::string &symbol, FundamentalData &fundamentalData);
  void getCorporateActions(const std::string &symbol, CorporateActions &corporateActions);
  
};

#endif