ClanLib  2.3.7
db_command.h
Go to the documentation of this file.
1 /*
2 ** ClanLib SDK
3 ** Copyright (c) 1997-2011 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 
31 
32 #pragma once
33 
34 #include "api_database.h"
35 
36 class CL_DataBuffer;
37 class CL_DateTime;
38 class CL_DBConnection;
40 class CL_DBCommand_Impl;
41 
46 {
49 public:
50  enum Type
51  {
53  sql_statement
54  };
55 
57  CL_DBCommand();
58 
62  CL_DBCommand(const CL_SharedPtr<CL_DBCommand_Impl> &impl);
63 
64  ~CL_DBCommand();
66 
69 public:
71  int get_input_parameter_column(const CL_StringRef &name) const;
72 
74  int get_output_last_insert_rowid() const;
75 
77  CL_DBCommandProvider *get_provider();
79 
82 public:
84  void set_input_parameter_string(int index, const CL_StringRef &value);
85 
87  void set_input_parameter_bool(int index, bool value);
88 
90  void set_input_parameter_int(int index, int value);
91 
93  void set_input_parameter_double(int index, double value);
94 
96  void set_input_parameter_datetime(int index, const CL_DateTime &value);
97 
99  void set_input_parameter_binary(int index, const CL_DataBuffer &value);
100 
102  template<class ValueType>
103  void set_input_parameter(int index, ValueType value);
104 
106  template<class ValueType>
107  void set_input_parameter(const CL_StringRef &name, ValueType value);
108 
110 
113 private:
114  CL_SharedPtr<CL_DBCommand_Impl> impl;
115 
117 };
118