db_command.h
1 /*
2 ** ClanLib SDK
3 ** Copyright (c) 1997-2013 The ClanLib Team
4 **
5 ** This software is provided 'as-is', without any express or implied
6 ** warranty. In no event will the authors be held liable for any damages
7 ** arising from the use of this software.
8 **
9 ** Permission is granted to anyone to use this software for any purpose,
10 ** including commercial applications, and to alter it and redistribute it
11 ** freely, subject to the following restrictions:
12 **
13 ** 1. The origin of this software must not be misrepresented; you must not
14 ** claim that you wrote the original software. If you use this software
15 ** in a product, an acknowledgment in the product documentation would be
16 ** appreciated but is not required.
17 ** 2. Altered source versions must be plainly marked as such, and must not be
18 ** misrepresented as being the original software.
19 ** 3. This notice may not be removed or altered from any source distribution.
20 **
21 ** Note: Some of the libraries ClanLib may link to may have additional
22 ** requirements or restrictions.
23 **
24 ** File Author(s):
25 **
26 ** Magnus Norddahl
27 */
28 
29 
30 #pragma once
31 
32 #include "api_database.h"
33 
34 namespace clan
35 {
38 
39 class DataBuffer;
40 class DateTime;
41 class DBConnection;
42 class DBCommandProvider;
43 class DBCommand_Impl;
44 
46 class CL_API_DATABASE DBCommand
47 {
50 public:
51  enum Type
52  {
54  sql_statement
55  };
56 
58  DBCommand();
59 
63  DBCommand(const std::shared_ptr<DBCommand_Impl> &impl);
64 
65  ~DBCommand();
67 
70 public:
72  int get_input_parameter_column(const std::string &name) const;
73 
75  int get_output_last_insert_rowid() const;
76 
78  DBCommandProvider *get_provider();
80 
83 public:
85  void set_input_parameter_string(int index, const std::string &value);
86 
88  void set_input_parameter_bool(int index, bool value);
89 
91  void set_input_parameter_int(int index, int value);
92 
94  void set_input_parameter_double(int index, double value);
95 
97  void set_input_parameter_datetime(int index, const DateTime &value);
98 
100  void set_input_parameter_binary(int index, const DataBuffer &value);
101 
103  template<class ValueType>
104  void set_input_parameter(int index, ValueType value);
105 
107  template<class ValueType>
108  void set_input_parameter(const std::string &name, ValueType value);
109 
111 
114 private:
115  std::shared_ptr<DBCommand_Impl> impl;
116 
118 };
119 
120 }
121 
Database command.
Definition: db_command.h:46
Date/Time class.
Definition: datetime.h:44
Database command provider.
Definition: db_command_provider.h:43
Definition: db_command.h:53
Type
Definition: db_command.h:51
General purpose data buffer.
Definition: databuffer.h:43