classVIBSQL.h

Go to the documentation of this file.

#ifndef CLASSVIBSQL_H__
#define CLASSVIBSQL_H__

#include "../vibsql.h"
#include "VIBProperties.h"

struct VIBDatabase;
struct VIBTransaction;

namespace VIB
{
   class Database;
   class Transaction;

   class SQL
   {
   protected:
      VIBSQL *vsql; 

   public:
      SQL(VIBSQL *pvsql = NULL);
      virtual ~SQL();

      int  Call(int ErrCode, bool RaiseError);
      void CheckClosed();
      void CheckOpen();
      void CheckValidStatement();
      void Close();
      void ExecQuery();
      void FreeHandle();
      void Prepare();
      int  FieldIndex(const std::string &FieldName);
      
      std::string GetUniqueRelationName();

      // Property classes

      class SQLClass
      {
      protected:
         SQL *parent; 
      public:
         SQLClass(SQL *pParent);

         Property<std::string> Text;
      };
      friend class SQLClass;

      // Class for individual properties
      class ParamsSetClass;

      class ParamClass
      {
      protected:
         friend ParamsSetClass;
         std::string name; 
         SQL *parent;      
      public:
         ParamClass(SQL *pParent);

         Property<std::string> AsString; 
         Property<bool>        IsNull;   
         Property<int>         SQLType;  
      };
      friend class ParamClass;

      class ParamsSetClass
      {
      protected:
         SQL *parent;   
         ParamClass pc; 
      public:
         ParamsSetClass(SQL *pParent) : parent(pParent), pc(pParent) {}

         ParamClass *ByName(const std::string &name);
      };

   protected:
      // Property instances
      SQLClass sc;        
      ParamsSetClass psc; 

   public:
      // Properties
      Property<bool>             Bof;
      Property<VIBDatabase *>    Database;
      Property<void ***>         DBHandle;
      Property<bool>             Eof;
      Property<bool>             GenerateParamNames;
      Property<bool>             GoToFirstRecordOnExecute;
      Property<void **>          Handle;
      Property<bool>             Open;
      Property<bool>             ParamCheck;
      Property<ParamsSetClass *> Params;
      Property<std::string>      Plan;
      Property<bool>             Prepared;
      Property<int>              RecordCount;
      Property<int>              RowsAffected;
      Property<SQLClass *>       _SQL;                      // NB: Not same name as in C++Builder!
      Property<VIBSQLTypes>      SQLType;
      Property<VIBTransaction *> Transaction;
      Property<void ***>         TRHandle;
      Property<std::string>      UniqueRelationName;
   };
}

#endif

// EOF