statement.h
Go to the documentation of this file.
1 /*
2  * Copyright (C) 2005 Tommi Maekitalo
3  *
4  * This library is free software; you can redistribute it and/or
5  * modify it under the terms of the GNU Lesser General Public
6  * License as published by the Free Software Foundation; either
7  * version 2.1 of the License, or (at your option) any later version.
8  *
9  * As a special exception, you may use this file as part of a free
10  * software library without restriction. Specifically, if other files
11  * instantiate templates or use macros or inline functions from this
12  * file, or you compile this file and link it with other files to
13  * produce an executable, this file does not by itself cause the
14  * resulting executable to be covered by the GNU General Public
15  * License. This exception does not however invalidate any other
16  * reasons why the executable file might be covered by the GNU Library
17  * General Public License.
18  *
19  * This library is distributed in the hope that it will be useful,
20  * but WITHOUT ANY WARRANTY; without even the implied warranty of
21  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
22  * Lesser General Public License for more details.
23  *
24  * You should have received a copy of the GNU Lesser General Public
25  * License along with this library; if not, write to the Free Software
26  * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
27  */
28 
29 #ifndef TNTDB_SQLITE_IMPL_SQLSTATEMENT_H
30 #define TNTDB_SQLITE_IMPL_SQLSTATEMENT_H
31 
32 #include <tntdb/iface/istatement.h>
33 #include <sqlite3.h>
34 
35 namespace tntdb
36 {
37  namespace sqlite
38  {
39  class Connection;
40 
41  class Statement : public IStatement
42  {
43  sqlite3_stmt* stmt;
44  sqlite3_stmt* stmtInUse;
45  Connection* conn;
46  const std::string query;
47 
48  sqlite3_stmt* getBindStmt();
49  int getBindIndex(const std::string& col);
50 
51  bool needReset;
52  void reset();
53 
54  public:
55  Statement(Connection* conn, const std::string& query);
56  ~Statement();
57 
58  // methods of IStatement
59 
60  virtual void clear();
61  virtual void setNull(const std::string& col);
62  virtual void setBool(const std::string& col, bool data);
63  virtual void setShort(const std::string& col, short data);
64  virtual void setInt(const std::string& col, int data);
65  virtual void setLong(const std::string& col, long data);
66  virtual void setUnsignedShort(const std::string& col, unsigned short data);
67  virtual void setUnsigned(const std::string& col, unsigned data);
68  virtual void setUnsignedLong(const std::string& col, unsigned long data);
69  virtual void setInt32(const std::string& col, int32_t data);
70  virtual void setUnsigned32(const std::string& col, uint32_t data);
71  virtual void setInt64(const std::string& col, int64_t data);
72  virtual void setUnsigned64(const std::string& col, uint64_t data);
73  virtual void setDecimal(const std::string& col, const Decimal& data);
74  virtual void setFloat(const std::string& col, float data);
75  virtual void setDouble(const std::string& col, double data);
76  virtual void setChar(const std::string& col, char data);
77  virtual void setString(const std::string& col, const std::string& data);
78  virtual void setBlob(const std::string& col, const Blob& data);
79  virtual void setDate(const std::string& col, const Date& data);
80  virtual void setTime(const std::string& col, const Time& data);
81  virtual void setDatetime(const std::string& col, const Datetime& data);
82 
83  virtual size_type execute();
84  virtual tntdb::Result select();
85  virtual tntdb::Row selectRow();
86  virtual tntdb::Value selectValue();
87  virtual ICursor* createCursor(unsigned fetchsize);
88 
89  // specific methods of sqlite-driver
90  sqlite3_stmt* getStmt() const { return stmt; }
91 
92  void putback(sqlite3_stmt* stmt);
93  };
94  }
95 }
96 
97 #endif // TNTDB_SQLITE_IMPL_SQLSTATEMENT_H
98