SQLQuery.h++

Go to the documentation of this file.

/* ---------------------------------------------------------------------------
   commonc++ - A C++ Common Class Library
   Copyright (C) 2005-2014  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();

  void reset();

  String toSQL();

  void bind(uint_t index);

  void bind(const String& name);

  void bind(uint_t index, int value);

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

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

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

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

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

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

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

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

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

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

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

  void clear();

  uint_t getParameterCount();

  void execute();

  bool next();

  uint_t getColumnCount();

  Variant getColumnValue(uint_t column);

  String getColumnName(uint_t column);

  String getAliasedColumnName(uint_t column);

  String getTableName(uint_t column);

  int getInt(uint_t column);

  int64_t getInt64(uint_t column);

  double getDouble(uint_t column);

  String getString(uint_t column);

  Blob getBlob(uint_t column);

 private:

  SQLQuery(const SQLPrivate& private_);

  void prime();
  void _next();

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

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

  CCXX_COPY_DECLS(SQLQuery);
};

} // namespace ccxx

#endif // __ccxx_SQLQuery_hxx