VTK
vtkODBCQuery.h
Go to the documentation of this file.
1 /* -*- Mode: C++; -*- */
2 /*=========================================================================
3 
4  Program: Visualization Toolkit
5  Module: vtkODBCQuery.h
6 
7  Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
8  All rights reserved.
9  See Copyright.txt or http://www.kitware.com/Copyright.htm for details.
10 
11  This software is distributed WITHOUT ANY WARRANTY; without even
12  the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
13  PURPOSE. See the above copyright notice for more information.
14 
15 =========================================================================*/
16 /*-------------------------------------------------------------------------
17  Copyright 2008 Sandia Corporation.
18  Under the terms of Contract DE-AC04-94AL85000 with Sandia Corporation,
19  the U.S. Government retains certain rights in this software.
20 -------------------------------------------------------------------------*/
21 
36 #ifndef vtkODBCQuery_h
37 #define vtkODBCQuery_h
38 
39 #include "vtkIOODBCModule.h" // For export macro
40 #include "vtkSQLQuery.h"
41 
42 class vtkODBCDatabase;
43 class vtkVariant;
44 class vtkVariantArray;
45 class vtkODBCInternals;
46 class vtkODBCQueryInternals;
47 
48 class VTKIOODBC_EXPORT vtkODBCQuery : public vtkSQLQuery
49 {
50 
51  friend class vtkODBCDatabase;
52 
53 public:
54  vtkTypeMacro(vtkODBCQuery, vtkSQLQuery);
55  void PrintSelf(ostream& os, vtkIndent indent);
56  static vtkODBCQuery *New();
57 
63  bool Execute();
64 
69 
73  const char* GetFieldName(int i);
74 
78  int GetFieldType(int i);
79 
83  bool NextRow();
84 
88  bool HasError();
89 
94 
98  const char* GetLastErrorText();
99 
101 
108 
110 
115  bool SetQuery(const char *queryString);
116  const char *GetQuery();
118 
128  bool BindParameter(int index, unsigned char value);
129  bool BindParameter(int index, signed char value);
130  bool BindParameter(int index, unsigned short value);
131  bool BindParameter(int index, signed short value);
132  bool BindParameter(int index, unsigned int value);
133 
134  bool BindParameter(int index, int value);
135 
136  bool BindParameter(int index, unsigned long value);
137  bool BindParameter(int index, signed long value);
138  bool BindParameter(int index, unsigned long long value);
139  bool BindParameter(int index, long long value);
140 
141  bool BindParameter(int index, float value);
142  bool BindParameter(int index, double value);
146  bool BindParameter(int index, const char *stringValue);
148 
151  bool BindParameter(int index, const char *stringValue, size_t length);
152  bool BindParameter(int index, const vtkStdString &string);
154 
155 
160  bool BindParameter(int index, const void *data, size_t length);
163 
164 protected:
167 
168  vtkSetStringMacro(LastErrorText);
169  vtkSetStringMacro(QueryText);
170  vtkGetStringMacro(QueryText);
171 
172  char *QueryText;
173 
174 private:
175  vtkODBCQuery(const vtkODBCQuery &) VTK_DELETE_FUNCTION;
176  void operator=(const vtkODBCQuery &) VTK_DELETE_FUNCTION;
177 
178  void ClearCurrentRow();
179  bool CacheCurrentRow();
180 
181  bool CacheTimeColumn(int column);
182  bool CacheIntervalColumn(int column);
183  bool CacheCharColumn(int column);
184  bool CacheLongLongColumn(int column);
185  bool CacheBinaryColumn(int column);
186  bool CacheBooleanColumn(int column);
187  bool CacheStringColumn(int column);
188  bool CacheWideStringColumn(int column);
189  bool CacheDecimalColumn(int column);
190  bool CacheNumericColumn(int column);
191  bool CacheIntColumn(int column);
192  bool CacheFloatColumn(int column);
193  bool CacheDoubleColumn(int column);
194 
195  vtkODBCQueryInternals *Internals;
196  bool InitialFetch;
197  char *LastErrorText;
198 };
199 
200 #endif // vtkODBCQuery_h
201 
vtkODBCQuery::BindParameter
bool BindParameter(int index, long long value)
vtkODBCDatabase::vtkODBCQuery
friend class vtkODBCQuery
Definition: vtkODBCDatabase.h:89
vtkODBCQuery
vtkSQLQuery implementation for ODBC connections to databases
Definition: vtkODBCQuery.h:49
vtkODBCQuery::BindParameter
bool BindParameter(int index, signed char value)
vtkODBCQuery::RollbackTransaction
bool RollbackTransaction()
vtkODBCQuery::GetFieldName
const char * GetFieldName(int i)
Return the name of the specified query field.
vtkX3D::value
@ value
Definition: vtkX3D.h:220
vtkIdType
int vtkIdType
Definition: vtkType.h:287
vtkX3D::data
@ data
Definition: vtkX3D.h:315
vtkODBCQuery::ClearParameterBindings
bool ClearParameterBindings()
Reset all parameter bindings to NULL.
vtkODBCInternals
Simple class to hide ODBC structures.
Definition: vtkODBCInternals.h:36
vtkODBCQuery::BindParameter
bool BindParameter(int index, const vtkStdString &string)
vtkODBCQuery::BindParameter
bool BindParameter(int index, const char *stringValue, size_t length)
Bind a string value by specifying an array and a size.
vtkX3D::length
@ length
Definition: vtkX3D.h:393
vtkVariantArray
An array holding vtkVariants.
Definition: vtkVariantArray.h:47
vtkODBCQuery::BindParameter
bool BindParameter(int index, unsigned long long value)
vtkODBCQuery::SetQuery
bool SetQuery(const char *queryString)
Set the query string to be used.
vtkODBCQuery::BindParameter
bool BindParameter(int index, int value)
vtkSQLQuery::BindParameter
virtual bool BindParameter(int index, unsigned char value)
Bind a parameter to a placeholder in a query.
vtkODBCQuery::QueryText
char * QueryText
Definition: vtkODBCQuery.h:170
vtkODBCDatabase
maintain an ODBC connection to a SQL database
Definition: vtkODBCDatabase.h:87
vtkODBCQuery::BindParameter
bool BindParameter(int index, unsigned int value)
vtkODBCQuery::GetLastErrorText
const char * GetLastErrorText()
Get the last error text from the query.
vtkODBCQuery::BindParameter
bool BindParameter(int index, signed long value)
vtkODBCQuery::BindParameter
bool BindParameter(int index, unsigned long value)
vtkODBCQuery::BindParameter
bool BindParameter(int index, const void *data, size_t length)
Bind a blob value.
vtkIndent
a simple class to control print indentation
Definition: vtkIndent.h:40
vtkODBCQuery::HasError
bool HasError()
Return true if there is an error on the current query.
vtkVariant
A atomic type representing the union of many types.
Definition: vtkVariant.h:76
vtkODBCQuery::GetNumberOfFields
int GetNumberOfFields()
The number of fields in the query result.
vtkODBCQuery::GetQuery
const char * GetQuery()
vtkGetStringMacro
vtkGetStringMacro(ExtensionsString)
Returns a string listing all available extensions.
vtkODBCQuery::~vtkODBCQuery
~vtkODBCQuery()
vtkODBCQuery::BindParameter
bool BindParameter(int index, float value)
vtkODBCQuery::Execute
bool Execute()
Execute the query.
vtkODBCQuery::DataValue
vtkVariant DataValue(vtkIdType c)
Return data in current row, field c.
vtkSQLQuery.h
vtkODBCQuery::BindParameter
bool BindParameter(int index, unsigned char value)
Bind a parameter to a placeholder in a query.
vtkODBCQuery::BindParameter
bool BindParameter(int index, const char *stringValue)
Bind a string value – string must be null-terminated.
vtkODBCQuery::vtkODBCQuery
vtkODBCQuery()
vtkODBCQuery::CommitTransaction
bool CommitTransaction()
vtkODBCQuery::BindParameter
bool BindParameter(int index, unsigned short value)
vtkODBCQuery::BeginTransaction
bool BeginTransaction()
Begin, commit, or roll back a transaction.
vtkODBCQuery::BindParameter
bool BindParameter(int index, signed short value)
vtkStdString
Wrapper around std::string to keep symbols short.
Definition: vtkStdString.h:49
vtkODBCQuery::NextRow
bool NextRow()
Advance row, return false if past end.
vtkODBCQuery::PrintSelf
void PrintSelf(ostream &os, vtkIndent indent)
Methods invoked by print to print information about the object including superclasses.
vtkODBCQuery::GetFieldType
int GetFieldType(int i)
Return the type of the field, using the constants defined in vtkType.h.
vtkSQLQuery
executes an sql query and retrieves results
Definition: vtkSQLQuery.h:75
vtkX3D::index
@ index
Definition: vtkX3D.h:246
vtkODBCQuery::BindParameter
bool BindParameter(int index, double value)
vtkODBCQuery::New
static vtkODBCQuery * New()