connection.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_BITS_CONNECTION_H
30 #define TNTDB_BITS_CONNECTION_H
31 
32 #include <string>
33 #include <cxxtools/smartptr.h>
35 #include <tntdb/bits/statement.h>
36 
37 namespace tntdb
38 {
39  class Result;
40  class Row;
41  class Value;
42  class Statement;
43 
66  class Connection
67  {
68  public:
69  typedef unsigned size_type;
70 
71  private:
73 
74  public:
76  Connection() { }
77 
80  : _conn(conn)
81  { }
82 
86  void close() { _conn = 0; }
87 
92  void beginTransaction();
93 
95  void commitTransaction();
96 
98  void rollbackTransaction();
99 
106  size_type execute(const std::string& query);
107 
112  Result select(const std::string& query);
113 
119  Row selectRow(const std::string& query);
120 
126  Value selectValue(const std::string& query);
127 
129  Statement prepare(const std::string& query);
130 
136  Statement prepareWithLimit(const std::string& query, const std::string& limit, const std::string& offset = std::string());
137 
142  Statement prepareCached(const std::string& query)
143  { return prepareCached(query, query); }
144 
153  Statement prepareCached(const std::string& query, const std::string& key);
154 
159  Statement prepareCachedWithLimit(const std::string& query, const std::string& limit, const std::string& offset = std::string())
160  { return prepareCachedWithLimit(query, limit, offset, query); }
161 
167  Statement prepareCachedWithLimit(const std::string& query, const
168  std::string& limit, const std::string& offset, const std::string& key);
169 
172  { _conn->clearStatementCache(); }
173 
178  bool clearStatementCache(const std::string& key)
179  { return _conn->clearStatementCache(key); }
180 
182  bool ping() { return _conn->ping(); }
183 
185  long lastInsertId(const std::string& name = std::string())
186  { return _conn->lastInsertId(name); }
187 
189  bool operator!() const { return !_conn; }
190 
193  const IConnection* getImpl() const { return &*_conn; }
194  IConnection* getImpl() { return &*_conn; }
196  };
197 }
198 
199 #endif // TNTDB_BITS_CONNECTION_H
200