vtkSQLiteQuery.h

Go to the documentation of this file.

/*=========================================================================
 
  Program:   Visualization Toolkit
  Module:    vtkSQLiteQuery.h
 
  Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
  All rights reserved.
  See Copyright.txt or http://www.kitware.com/Copyright.htm for details.
 
     This software is distributed WITHOUT ANY WARRANTY; without even
     the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
     PURPOSE.  See the above copyright notice for more information.
 
=========================================================================*/
/*-------------------------------------------------------------------------
  Copyright 2008 Sandia Corporation.
  Under the terms of Contract DE-AC04-94AL85000 with Sandia Corporation,
  the U.S. Government retains certain rights in this software.
-------------------------------------------------------------------------*/
#ifndef vtkSQLiteQuery_h
#define vtkSQLiteQuery_h
 
#include "vtkIOSQLModule.h" // For export macro
#include "vtkSQLQuery.h"
 
class vtkSQLiteDatabase;
class vtkVariant;
class vtkVariantArray;
struct sqlite3_stmt;
 
class VTKIOSQL_EXPORT vtkSQLiteQuery : public vtkSQLQuery
{
  //BTX
  friend class vtkSQLiteDatabase;
  //ETX
 
public:
  vtkTypeMacro(vtkSQLiteQuery, vtkSQLQuery);
  void PrintSelf(ostream& os, vtkIndent indent);
  static vtkSQLiteQuery *New();
 
  bool SetQuery(const char *query);
 
  bool Execute();
 
  int GetNumberOfFields();
 
  const char* GetFieldName(int i);
 
  int GetFieldType(int i);
 
  bool NextRow();
 
  bool HasError();
 
 
  bool BeginTransaction();
  bool RollbackTransaction();
  bool CommitTransaction();
 
  vtkVariant DataValue(vtkIdType c);
 
  const char* GetLastErrorText();
 
 
  using vtkSQLQuery::BindParameter;
  bool BindParameter(int index, unsigned char value);
  bool BindParameter(int index, signed char value);
  bool BindParameter(int index, unsigned short value);
  bool BindParameter(int index, short value);
  bool BindParameter(int index, unsigned int value);
//ETX
  bool BindParameter(int index, int value);
//BTX
  bool BindParameter(int index, unsigned long value);
  bool BindParameter(int index, long value);
  bool BindParameter(int index, vtkTypeUInt64 value);
  bool BindParameter(int index, vtkTypeInt64 value);
//ETX
  bool BindParameter(int index, float value);
  bool BindParameter(int index, double value);
 
  bool BindParameter(int index, const char *stringValue);
 
  bool BindParameter(int index, const char *stringValue, size_t length);
//BTX
  bool BindParameter(int index, const vtkStdString &string);
//ETX
  bool BindParameter(int index, vtkVariant value);
 
 
  bool BindParameter(int index, const void *data, size_t length);
  bool ClearParameterBindings();
 
protected:
  vtkSQLiteQuery();
  ~vtkSQLiteQuery();
 
  vtkSetStringMacro(LastErrorText);
 
private:
  vtkSQLiteQuery(const vtkSQLiteQuery &); // Not implemented.
  void operator=(const vtkSQLiteQuery &); // Not implemented.
 
  sqlite3_stmt *Statement;
  bool InitialFetch;
  int InitialFetchResult;
  char *LastErrorText;
  bool TransactionInProgress;
 
 
  bool BindIntegerParameter(int index, int value);
  bool BindDoubleParameter(int index, double value);
  bool BindInt64Parameter(int index, vtkTypeInt64 value);
  bool BindStringParameter(int index, const char *data, int length);
  bool BindBlobParameter(int index, const void *data, int length);
 
};
 
#endif // vtkSQLiteQuery_h