SQLQuery.h++

Go to the documentation of this file.

/* ---------------------------------------------------------------------------
   commonc++ - A C++ Common Class Library
   Copyright (C) 2005-2012  Mark A Lindner

   This file is part of commonc++.

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

   This library 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
   Library General Public License for more details.

   You should have received a copy of the GNU Library General Public
   License along with this library; if not, write to the Free
   Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
   ---------------------------------------------------------------------------
*/

#ifndef __ccxx_SQLQuery_hxx
#define __ccxx_SQLQuery_hxx

#include <commonc++/Common.h++>
#include <commonc++/Blob.h++>
#include <commonc++/InterruptedException.h++>
#include <commonc++/SQLException.h++>
#include <commonc++/String.h++>
#include <commonc++/Variant.h++>

namespace ccxx {

class SQLDatabase; // fwd decl
class SQLPrivate; // fwd decl

class COMMONCPPDB_API SQLQuery
{
  friend class SQLDatabase;

  public:

  ~SQLQuery() throw();

  void reset() throw(SQLException);

  String toSQL() throw(SQLException);

  void bind(uint_t index) throw(SQLException);

  void bind(const String &name) throw(SQLException);

  void bind(uint_t index, int value) throw(SQLException);

  void bind(const String &name, int value) throw(SQLException);

  void bind(uint_t index, const int64_t &value) throw(SQLException);

  void bind(const String &name, const int64_t &value) throw(SQLException);

  void bind(uint_t index, const double &value) throw(SQLException);

  void bind(const String &name, const double &value) throw(SQLException);

  void bind(uint_t index, const String &value) throw(SQLException);

  void bind(const String &name, const String &value) throw(SQLException);

  void bind(uint_t index, const char *value) throw(SQLException);

  void bind(const String &name, const char *value) throw(SQLException);

  void bind(uint_t index, const Blob &value) throw(SQLException);

  void bind(const String &name, const Blob &value) throw(SQLException);

  void clear() throw(SQLException);

  uint_t getParameterCount() throw(SQLException);

  void execute() throw(SQLException, InterruptedException);

  bool next() throw(SQLException, InterruptedException, TimeoutException);

  uint_t getColumnCount() throw(SQLException);

  Variant getColumnValue(uint_t column) throw(SQLException);

  String getColumnName(uint_t column) throw(SQLException);

  String getAliasedColumnName(uint_t column) throw(SQLException);

  String getTableName(uint_t column) throw(SQLException);

  int getInt(uint_t column) throw(SQLException);

  int64_t getInt64(uint_t column) throw(SQLException);

  double getDouble(uint_t column) throw(SQLException);

  String getString(uint_t column) throw(SQLException);

  Blob getBlob(uint_t column) throw(SQLException);

  private:

  SQLQuery(const SQLPrivate &private_);

  void prime() throw(SQLException, InterruptedException);
  void _next() throw();

  String _getString(uint_t column) throw();
  Blob _getBlob(uint_t column) throw();

  SQLPrivate *_private;
  int _result;
  bool _primed;
  bool _hasData;

  CCXX_COPY_DECLS(SQLQuery);
};

} // namespace ccxx

#endif // __ccxx_SQLQuery_hxx