sqlbuilder.h
Go to the documentation of this file.
1 /*
2  * Copyright (C) 2011 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_SQLBUILDER_H
30 #define TNTDB_SQLBUILDER_H
31 
32 #include <string>
33 
34 namespace tntdb
35 {
57  class SqlBuilder
58  {
59  public:
62  { }
63 
65  SqlBuilder(const std::string& sql_)
66  : sql(sql_)
67  { }
68 
96  SqlBuilder& extendParam(const std::string& varname, unsigned count);
97 
117  SqlBuilder& replace(const std::string& varname, const std::string& value);
118 
144  SqlBuilder& replaceIf(bool condition, const std::string& varname, const std::string& value,
145  const std::string& elsevalue = std::string())
146  {
147  replace(varname, condition ? value : elsevalue);
148  return *this;
149  }
150 
152  void str(const std::string& s) { sql = s; }
153 
155  const std::string& str() const { return sql; }
156 
158  operator const std::string&() const { return sql; }
159 
160  private:
161  std::string sql;
162  };
163 }
164 
165 #endif // TNTDB_SQLBUILDER_H
166