---

FBwSql.h

Go to the documentation of this file.

//---------------------------------------------------------------------------
#ifndef FBwSql_HH
#define FBwSql_HH
#include <FBwLst.h>

//---------------------------------------------------------------------------
namespace fbwrap
{

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

typedef SimList<int>    SList;


class sqParam 
{
    string p;
public:
    sqParam(const string &s)
    {
        p=s;
    }
    string GetText() const
    {
        return p;
    }
};

class sqAggregate
{
protected:
    string exp;
    string alias;
public:
    sqAggregate(const string &s, const string &palias)
    {
        exp=s;
        alias=palias;
    }
    virtual string GetText() const = 0;
    string GetAlias() const;
    void SetAlias(const string &s)
    {
        alias=s;
    }
};

class SqlTextHelper
{
    SList *curList;
public:
    enum clauseType { sq_select,sq_from,sq_where,sq_orderby,sq_groupby,sq_txtvars,sq_having};
    enum objectType { literal,aggregatefn,variable,parameter};
    SqlTextHelper()
    {
        curList=NULL;
    }
    void SetCurList(SList *s)
    {
        curList=s;
    }
    string ComaList(const SList &lst) const;
    string WhereList(const SList &lst) const;
    void Append(const string &var)
    {
        curList->Append(var,SqlTextHelper::literal);
    }
    void Append(const sqAggregate &var)
    {
        curList->Append(var.GetText(),SqlTextHelper::aggregatefn);
    }
    void Append(const sqParam &var)
    {
        curList->Append(var.GetText(),SqlTextHelper::parameter);
    }
    void Clear()
    {
        if( curList )
            curList->Destroy();
    }
    void Copy(const SList &s)
    {
        curList->Copy(s);
    }
};


class sqSUM : public sqAggregate
{
public:
    sqSUM(const string &s, const string &p)
            : sqAggregate(s,p)
    {
    }
    virtual string GetText() const;
};

class sqCOUNT : public sqAggregate
{
public:
    sqCOUNT(const string &s, const string &p)
            : sqAggregate(s,p)
    {
        exp=s;
    }
    virtual string GetText() const;
};

class sqMAX : public sqAggregate
{
public:
    sqMAX(const string &s, const string &p)
            : sqAggregate(s,p)
    {
        exp=s;
    }
    virtual string GetText() const;
};

class sqMIN : public sqAggregate
{
public:
    sqMIN(const string s, const string &p)
            : sqAggregate(s,p)
    {
        exp=s;
    }
    virtual string GetText() const;
};





class FBwSelectSql : public SqlTextHelper
{
    SList sselect;
    SList sfrom;
    SList swhere;
    SList sorderby;
    SList sgroupby;
    SList txtvars;
    SList shaving;
    clauseType state;
protected:
public:
    enum objectType { literal,aggregatefn };
    FBwSelectSql()
    {
        state=sq_select;
    }
    virtual string GetSqlText() const;
    void select()
    {
        state=sq_select;
        SetCurList(&sselect);
    }
    void from()
    {
        state=sq_from;
        SetCurList(&sfrom);
    }
    void where()
    {
        state=sq_where;
        SetCurList(&swhere);
    }
    void orderby()
    {
        state=sq_orderby;
        SetCurList(&sorderby);
    }
    void groupby()
    {
        state=sq_groupby;
        SetCurList(&sgroupby);
    }
    void having()
    {
        state=sq_having;
        SetCurList(&shaving);
    }
    void vars()
    {
        state=sq_txtvars;
        SetCurList(&txtvars);
    }
    void ClearAll();
    friend FBwSelectSql &operator<<(FBwSelectSql &s, const string var);
    friend FBwSelectSql &operator<<(FBwSelectSql &s, const sqAggregate &var);
    friend FBwSelectSql &operator<<(FBwSelectSql &s, const sqParam &var);
};


class FBwInsertSql : public SqlTextHelper
{
    string Into;
    SList sfields;
    SList svalues;
public:
    FBwInsertSql()
    {
    }
    FBwInsertSql(const string &table)
    {
        Into=table;
    }
    virtual string GetSqlText() const;
    void fields()
    {
        SetCurList(&sfields);
    }
    void values()
    {
        SetCurList(&svalues);
    }
    void SetTable(const string &tbl)
    {
        Into=tbl;
    }
    string GetTable() const
    {
        return Into;
    }
    void ClearAll();
    friend FBwInsertSql &operator<<(FBwInsertSql &s, const string var);
    friend FBwInsertSql &operator<<(FBwInsertSql &s, const sqAggregate &var);
    friend FBwInsertSql &operator<<(FBwInsertSql &s, const sqParam &var);
};


class FBwUpdateSql : public SqlTextHelper
{
    SList sfields;
    SList svalues;
    SList swhere;
    SList txtvars;
    string table;
public:
    FBwUpdateSql()
            : SqlTextHelper()
    {
    }
    FBwUpdateSql(const string &tbl)
            : SqlTextHelper()
    {
        table=tbl;
    }
    virtual string GetSqlText() const;
    void fields()
    {
        SetCurList(&sfields);
    }
    void values()
    {
        SetCurList(&svalues);
    }
    void where()
    {
        SetCurList(&swhere);
    }
    void SetTable(const string &tbl)
    {
        table=tbl;
    }
    void ClearAll();
    friend FBwUpdateSql &operator<<(FBwUpdateSql &s, const string var);
    friend FBwUpdateSql &operator<<(FBwUpdateSql &s, const sqAggregate &var);
};

class FBwDeleteSql : public SqlTextHelper
{
    string from;
    SList swhere;
public:
    FBwDeleteSql()
    {
        SetCurList(&swhere);
    };
    FBwDeleteSql(const string &tbl)
    {
        from=tbl;
    }
    void SetTable(const string &tbl)
    {
        from=tbl;
    }
    string GetTable() const
    {
        return from;
    }
    void where()
    {
        SetCurList(&swhere);
    }
    virtual string GetSqlText() const;
    void ClearAll();
    friend FBwDeleteSql &operator<<(FBwDeleteSql &s, const string var);
    friend FBwDeleteSql &operator<<(FBwDeleteSql &s, const sqAggregate &var);
    friend FBwDeleteSql &operator<<(FBwDeleteSql &s, const sqParam &var);
};

//-------------------------------------------------------------------------
};
#endif

---