---

db.DbQuery_ODBC.h

/*----------------------------------------------------------------------------
  SWORD 2000 - Software With Objects for Rapid Development
  Copyright (C) 2003 Eric NICOLAS
  ----------------------------------------------------------------------------
  SWORD is free software; you can redistribute it and/or modify
  it under the terms of the GNU Lesser General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  SWORD 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 Lesser General Public License for more details.

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

// This is available only if you have enabled the "db.odbc" feature
#ifdef HAVE_DB_ODBC

#include "sword/db.DbQuery.h"
#include "sword/db.DbConnection_ODBC.h"
#include <map>

namespace sword {

  class SWORDDECL DbQuery_ODBC : public DbQuery {
  public:
    DbQuery_ODBC(DbConnection_ODBC* con, int timeout = 120);
    virtual ~DbQuery_ODBC();

    virtual bool exec(const std::string& sql, bool reportWarningsAsErrors = true);
    virtual bool nextRow();
    virtual bool nextSet();
    virtual int  columns();

    virtual Variant     get(word column);
    virtual Variant     get(const std::string& column);

  private:
    DbConnection_ODBC* con_;
    SQLHSTMT           dbs_;
    int                columns_;
    // columns type description
    typedef std::vector<Variant::Type> ColumnTypes;
    ColumnTypes        columnTypes_;
    bool               columnTypesReady_;
    // columns names
    typedef std::vector<std::string> ColumnNames;
    ColumnNames        columnNames_;
    typedef std::map<std::string, word> ColumnPositions;
    ColumnPositions    columnPositions_;
    // row data
    typedef std::vector<Variant> RowData;
    RowData            row_;
    bool               rowReady_;

    void reportError_(const std::string& message);
    bool firstRow_();
    bool nextSet_();

    void fetchRow_();
    void fetchColumnTypes_();

    word columnPosition_(const std::string& columnName);
  };

} // namespace sword

#endif // HAVE_DB_ODBC

#endif // _SWORD_DB_DBQUERY_ODBC_

---