RTSQLSelect.hh

//********************************************************************
//*** ResourcePool/SQL/RTSQLSelect.hh
//*** Copyright (c) 2003-2009 by Markus Winand <mws@fatalmind.com>
//*** $Id: RTSQLSelect.hh,v 1.29 2009-05-02 22:17:15 mws Exp $
//********************************************************************
/*
This file is part of ResourcePool.

ResourcePool is free software; you can redistribute it
and/or modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either version 2 of
the License, or (at your option) any later version.

ResourcePool is distributed in the hope that it will be
useful, but WITHOUT ANY WARRANTY; without even the implied warranty
of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with ResourcePool; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307  USA */

#ifndef RESOURCEPOOL_SQL_RTSQLSELECT_HH
#define RESOURCEPOOL_SQL_RTSQLSELECT_HH

#include "mm/gc_ptr.hh"
#include "ResourcePool/SQL/RTSQLCommand.hh"
#include "ResourcePool/SQL/Resource.hh"
#include "ResourcePool/SQL/BindInterface.hh"
#include "ResourcePool/SQL/BindOutInterface.hh"
#include "ResourcePool/SQL/RTCommandParameters.hh"
#include "ResourcePool/SQL/RTSQLSelectRow.hh"
#include "ResourcePool/SQL/SQLFetcher.hh"
#include "ResourcePool/SQL/SQLStatement.hh"

namespace fatalmind {
namespace SQL {

template<class TM> class RTSQLSelectRow_Impl;

template<class TM>
class RTSQLSelect
: public RTSQLCommand<TM>
, public BindInterface
, public BindOutInterface
{
    public:
        RTSQLSelect(const ResourcePool<ResourceType<TM> >& p, const SQLStatement& sql, SQL::SQLFetcher& fetcher);
        RTSQLSelect(const RTSQLSelect<TM>& rho);
        virtual ~RTSQLSelect();
        
        virtual void bind(const unsigned int pos, const char& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const signed char& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const unsigned char& val, bool isnull = false);

        virtual void bind(const unsigned int pos, const short int& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const unsigned short int& val, bool isnull = false);

        virtual void bind(const unsigned int pos, const int& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const unsigned int& val, bool isnull = false);

        virtual void bind(const unsigned int pos, const long int& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const unsigned long int& val, bool isnull = false);

        virtual void bind(const unsigned int pos, const float& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const double& val, bool isnull = false);
        virtual void bind(const unsigned int pos, const long double& val, bool isnull = false);

        virtual void bind(const unsigned int pos, const std::string& val, bool isnull = false);

        virtual void bindout(const unsigned int pos, char& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, signed char& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, unsigned char& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void bindout(const unsigned int pos, short int& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, unsigned short int& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void bindout(const unsigned int pos, int& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, unsigned int& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void bindout(const unsigned int pos, long int& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, unsigned long int& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void bindout(const unsigned int pos, float& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, double& val, bool& isnull = BindOutInterface::notnullconstant);
        virtual void bindout(const unsigned int pos, long double& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void bindout(const unsigned int pos, std::string& val, bool& isnull = BindOutInterface::notnullconstant);

        virtual void clearParameters();

        void execute(typename ResourceType<TM>::resource_t& hand);
        virtual void outputoperator(std::ostream&) const;

        virtual const Clone* getPlainSpecializedCommand() const;

    protected:
        virtual Clone* DoClone() const {
            return new RTSQLSelect<TM>(*this);
        }
    private:
        gc_ptr<RTSQLSelectRow_Impl<TM> > _realSQLExecute;   

        typedef typename SQLFactory<TM>::databaseType_t databaseType_t;
};


} // namespace SQL
} // namespace fatalmind
#endif

---