VTK
vtkMySQLQuery.h
Go to the documentation of this file.
1 /*=========================================================================
2 
3  Program: Visualization Toolkit
4  Module: vtkMySQLQuery.h
5 
6  Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
7  All rights reserved.
8  See Copyright.txt or http://www.kitware.com/Copyright.htm for details.
9 
10  This software is distributed WITHOUT ANY WARRANTY; without even
11  the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
12  PURPOSE. See the above copyright notice for more information.
13 
14 =========================================================================*/
35 #ifndef vtkMySQLQuery_h
36 #define vtkMySQLQuery_h
37 
38 #include "vtkIOMySQLModule.h" // For export macro
39 #include "vtkSQLQuery.h"
40 
41 class vtkMySQLDatabase;
42 class vtkVariant;
43 class vtkVariantArray;
44 class vtkMySQLQueryInternals;
45 
47 {
48 //BTX
49  friend class vtkMySQLDatabase;
50 //ETX
51 
52 public:
54  void PrintSelf(ostream& os, vtkIndent indent);
55  static vtkMySQLQuery *New();
56 
59  bool SetQuery(const char *query);
60 
63  bool Execute();
64 
66 
69  virtual bool BeginTransaction();
70  virtual bool CommitTransaction();
71  virtual bool RollbackTransaction();
73 
76 
78  const char* GetFieldName(int i);
79 
82  int GetFieldType(int i);
83 
85  bool NextRow();
86 
88  bool HasError();
89 
92 
94  const char* GetLastErrorText();
95 
97 
103  bool BindParameter(int index, unsigned char value);
104  bool BindParameter(int index, signed char value);
105  bool BindParameter(int index, unsigned short value);
106  bool BindParameter(int index, signed short value);
107  bool BindParameter(int index, unsigned int value);
108 //ETX
109  bool BindParameter(int index, int value);
110 //BTX
111  bool BindParameter(int index, unsigned long value);
112  bool BindParameter(int index, signed long value);
113  bool BindParameter(int index, vtkTypeUInt64 value);
114  bool BindParameter(int index, vtkTypeInt64 value);
115 //ETX
116  bool BindParameter(int index, float value);
117  bool BindParameter(int index, double value);
119 
120  bool BindParameter(int index, const char *stringValue);
122 
123  bool BindParameter(int index, const char *stringValue, size_t length);
124  bool BindParameter(int index, const vtkStdString &string);
126 
128 
130  bool BindParameter(int index, const void *data, size_t length);
133 
135  virtual vtkStdString EscapeString( vtkStdString src, bool addSurroundingQuotes = true );
136 
137 protected:
140 
141  vtkSetStringMacro(LastErrorText);
142 
143 private:
144  vtkMySQLQuery(const vtkMySQLQuery &); // Not implemented.
145  void operator=(const vtkMySQLQuery &); // Not implemented.
146 
147  vtkMySQLQueryInternals *Internals;
148  bool InitialFetch;
149  char *LastErrorText;
150 };
151 
152 #endif // vtkMySQLQuery_h
153 
vtkgl::data
GLsizei GLsizei GLenum GLenum const GLvoid * data
Definition: vtkgl.h:11339
vtkMySQLDatabase::vtkMySQLQuery
friend class vtkMySQLQuery
Definition: vtkMySQLDatabase.h:52
vtkMySQLQuery::BindParameter
bool BindParameter(int index, const void *data, size_t length)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, signed short value)
vtkMySQLQuery::vtkMySQLQuery
vtkMySQLQuery()
vtkgl::query
GLenum query
Definition: vtkgl.h:14432
vtkMySQLQuery::BindParameter
bool BindParameter(int index, int value)
vtkMySQLQuery::DataValue
vtkVariant DataValue(vtkIdType c)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, vtkTypeInt64 value)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, signed long value)
vtkMySQLQuery::ClearParameterBindings
bool ClearParameterBindings()
vtkIdType
int vtkIdType
Definition: vtkType.h:275
vtkMySQLQuery::BindParameter
bool BindParameter(int index, unsigned int value)
vtkTypeMacro
#define vtkTypeMacro(thisClass, superclass)
Definition: vtkSetGet.h:642
vtkMySQLQuery::BindParameter
bool BindParameter(int index, unsigned long value)
vtkVariantArray
An array holding vtkVariants.
Definition: vtkVariantArray.h:48
vtkMySQLQuery::HasError
bool HasError()
vtkMySQLQuery::GetNumberOfFields
int GetNumberOfFields()
vtkgl::length
GLuint GLsizei GLsizei * length
Definition: vtkgl.h:11992
vtkMySQLQuery::BeginTransaction
virtual bool BeginTransaction()
vtkMySQLDatabase
maintain a connection to a MySQL database
Definition: vtkMySQLDatabase.h:50
vtkSQLQuery::BindParameter
virtual bool BindParameter(int index, unsigned char value)
VTKIOMYSQL_EXPORT
#define VTKIOMYSQL_EXPORT
Definition: vtkIOMySQLModule.h:15
vtkgl::value
GLsizei const GLfloat * value
Definition: vtkgl.h:12021
vtkgl::c
const GLubyte * c
Definition: vtkgl.h:15720
vtkMySQLQuery::BindParameter
bool BindParameter(int index, const vtkStdString &string)
vtkgl::src
GLenum src
Definition: vtkgl.h:12525
vtkMySQLQuery::GetLastErrorText
const char * GetLastErrorText()
vtkIndent
a simple class to control print indentation
Definition: vtkIndent.h:39
vtkMySQLQuery::SetQuery
bool SetQuery(const char *query)
vtkSetStringMacro
#define vtkSetStringMacro(name)
Definition: vtkSetGet.h:104
vtkMySQLQuery::GetFieldType
int GetFieldType(int i)
vtkIOMySQLModule.h
vtkVariant
A atomic type representing the union of many types.
Definition: vtkVariant.h:79
vtkMySQLQuery::BindParameter
bool BindParameter(int index, unsigned char value)
vtkMySQLQuery::RollbackTransaction
virtual bool RollbackTransaction()
vtkMySQLQuery
vtkSQLQuery implementation for MySQL databases
Definition: vtkMySQLQuery.h:47
vtkMySQLQuery::BindParameter
bool BindParameter(int index, signed char value)
vtkMySQLQuery::PrintSelf
void PrintSelf(ostream &os, vtkIndent indent)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, vtkTypeUInt64 value)
vtkMySQLQuery::GetFieldName
const char * GetFieldName(int i)
vtkgl::index
GLuint index
Definition: vtkgl.h:11983
vtkMySQLQuery::BindParameter
bool BindParameter(int index, double value)
vtkSQLQuery.h
vtkMySQLQuery::NextRow
bool NextRow()
vtkMySQLQuery::~vtkMySQLQuery
~vtkMySQLQuery()
vtkMySQLQuery::BindParameter
bool BindParameter(int index, float value)
vtkMySQLQuery::EscapeString
virtual vtkStdString EscapeString(vtkStdString src, bool addSurroundingQuotes=true)
vtkMySQLQuery::CommitTransaction
virtual bool CommitTransaction()
vtkMySQLQuery::New
static vtkMySQLQuery * New()
vtkMySQLQuery::Execute
bool Execute()
vtkStdString
Wrapper around std::string to keep symbols short.
Definition: vtkStdString.h:48
vtkSQLQuery
executes an sql query and retrieves results
Definition: vtkSQLQuery.h:74
vtkMySQLQuery::BindParameter
bool BindParameter(int index, const char *stringValue, size_t length)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, unsigned short value)
vtkMySQLQuery::BindParameter
bool BindParameter(int index, const char *stringValue)