---

FBwQuery.h

Go to the documentation of this file.

//---------------------------------------------------------------------------

#ifndef FBwH
#define FBwH
#include <FBwConfig.h>
#include <FBwError.h>
#include <FBwConect.h>
#include <FBwDPB.h>
#include <FBwTransac.h>
#include <FBwDB.h>
#include <FBwField.h>
#include <FBwStringField.h>
#include <FBwDateField.h>
#include <FBwTimeField.h>
#include <FBwDateTimeField.h>
#include <FBwNumField.h>
#include <FBwBlobField.h>
#include <FBwFieldList.h>
#include <iostream>
//---------------------------------------------------------------------------

namespace fbwrap
{

// What are we using from standard libraries
using std::string;


class FBwBQuery
{
    XSQLDA *xsqlda;
    XSQLDA *inxsqlda;
    string sql;
    FBwDb *mdb;
    isc_stmt_handle stmt;
    FBwTransaction *mtr;
    ISC_STATUS *status;
    struct 
    {
        bool prepared:1;
        bool opened:1;
        bool eof:1;
        bool bof:1;
        bool error:1;
    } errst;
    struct 
    {
        bool checkparams:1;
        bool outparams:1;
        bool buffered:1;
        bool autocommit:1;
    } options;
    string cursor_name;
protected:
    void ClearStatus()
    {
        errst.prepared=false;
        errst.opened=false;
        errst.bof=false;
        errst.eof=false;
        errst.error=false;
    }

    virtual char *GetSqlText()
    {
        return const_cast<char *>(sql.c_str());
    }
    int Fetch();                        
    XSQLDA *CreateSqlda();              
    void CreateParams();                
    bool XSQLDAResize(XSQLDA **qx);     

    bool Execute();                     
    void SqlStmtInfo();
    void VCommit();
    XSQLDA *GetXSQLDA()
    {
        return xsqlda;
    }
    void GenCursorName();
public:

    FBwBQuery(FBwDb *pMdb):
            Fields(pMdb),Params(pMdb)
    {
        mdb=pMdb;
        ClearStatus();
        xsqlda=0;
        inxsqlda=0;
        stmt=0;
        options.buffered=false;
        options.autocommit=true;
        status = mdb->GetStatus();      // Use db status vector
        GenCursorName();
    }
    void Prepare();
    void UnPrepare();
    void SetSql(string sqltext);
    string GetSql() const
    {
        return sql;
    }
    void Open();
    void Close()
    {
        if( errst.prepared )
        {
            VCommit();
            Fields.DestroyFields();
            UnPrepare();
        }
    }
    void First();
    void Next();
    bool IsOpen() const
    {
        return errst.opened;
    }
    bool IsPrepared()
    {
        return errst.prepared;
    }
    bool Eof()
    {
        return errst.eof;
    }
    bool Bof()
    {
        return errst.bof;
    }
    bool Error()
    {
        return errst.error;
    }
    FieldList Fields;
    FieldList Params;
    string Text()
    {
        return sql;
    }
    void Debug();
    void GetLastError(BasicFBwErrorMgr *err)
    {
        err->Assign(status);
    }
    virtual ~FBwBQuery()
    {
        Close();
        if( xsqlda )
            delete xsqlda;
        if( inxsqlda )
            delete inxsqlda;
    }
    void DumpFields(std::ostream &o) const;
    void SetAutoCommit(bool how)
    {
        options.autocommit=how;
    }
    void ExecSQL()
    {
        Execute();
    }
};
std::ostream& operator<<(std::ostream &o, const FBwBQuery &q);
//-------------------------------------------------------------------------
}
#endif

---