msd_data.h

//-----------------------------------------------------
// msd_data.h
//
// Project: PDBe API Framework, EBI  
// Module:  DATA Layer Classes for PDBe API Framework 
//
// 
// Data Layer
// Last updated: 25 February 2004 10:17
// (C) Siamak Sobhany
//------------------------------------------------------



#ifndef __MSD_DATA_H__
#define __MSD_DATA_H__

#ifndef __MSD_DATATYPES_H__
#include "msd_datatypes.h"
#endif

//using namespace std;



//###class MSDColumn {
//### public:
//###  char strCVal[32];               
//###  double  dfCVal;                 
//###  float fCVal;                    
//###  int iCVal;                      
//###  unsigned int uiCVal;            
//###  short int shiCVal;              
//###  long int liCVal;                
//###  otl_datetime dtCVal;           
//###  otl_long_string lcCVal;  
//###  otl_long_string rlCVal;  
//###  otl_long_string clobCVal;
//###  otl_long_string blobCVal;
//###  //       otl_lob_stream blobCVal;
//###  int coltype;   // database dependent, column datatype code.
//###                 // for more detail, see the OCIx and the ODBC manuals.
//###  int otltype;   // OTL defined, column datatype code
//###  int colsize;   // column length
//###  int colscale;  // for numeric columns, column scale
//###  int colprec;   // for numeric columns, column precision
//###  int colnullok; // indicator whether column is nullable or not
//###  let colname; 
//###  let colvalue;
//###  MSDColumn(){};
//###  ~MSDColumn(){};
//###  void ValRead(msdbStream& os, int idx);
//###};


class MSDSelect {
 
 
 public:
 int buff;
 
 
 MSDSelect();
 void InitSql(msdbConnect& r_db, char* stm);
 //MSDColumn * cv;
 let collist;
 let colliststr;
 ~MSDSelect(){};
 void MakeRecord();
 void GetNext();
 int GetRowNum();
 void SetCriteria(char* strCVal);    
 void SetCriteria(double  dfCVal);      
 void SetCriteria(float fCVal);         
 void SetCriteria(int iCVal);           
 void SetCriteria(unsigned int uiCVal); 
 void SetCriteria(short int shiCVal);   
 void SetCriteria(long int liCVal); 
 int GetVal(int col, float& f);
 int GetVal(int col, int& i);
 int GetVal(int col, char*& val);
 int GetVal(int col, double& d);
 
 protected:
 int j;
 otl_column_desc * desc;
 int desc_len;
 msdbStream * pos;
 msd_array * p;
 }; 


class MSDHandle {
 public:
   const msdbConnect * vp_dbhandle[MAXCONN];
   const MSDSelect * vp_sql[MAXCONN][MAXSQL];
   MSDHandle();
   ~MSDHandle(){};
};




void new_exec_query (int bf, msdbConnect& r_db, char* stm, MSDDataSet& rs);
int msd_exec_query (int bf, msdbConnect& r_db, char* stm, MSDDataSet& rs, char* rs_table, const char* argtype ,...);

let  msd_make_rowlist(let se);

void genselect(msdbConnect& r_db, char* stm);

#endif //__MSD_DATA_H__

---