53#ifndef vtkSQLDatabase_h
54#define vtkSQLDatabase_h
56#include "vtkIOSQLModule.h"
69#define VTK_SQL_FEATURE_TRANSACTIONS 1000
70#define VTK_SQL_FEATURE_QUERY_SIZE 1001
71#define VTK_SQL_FEATURE_BLOB 1002
72#define VTK_SQL_FEATURE_UNICODE 1003
73#define VTK_SQL_FEATURE_PREPARED_QUERIES 1004
74#define VTK_SQL_FEATURE_NAMED_PLACEHOLDERS 1005
75#define VTK_SQL_FEATURE_POSITIONAL_PLACEHOLDERS 1006
76#define VTK_SQL_FEATURE_LAST_INSERT_ID 1007
77#define VTK_SQL_FEATURE_BATCH_OPERATIONS 1008
78#define VTK_SQL_FEATURE_TRIGGERS 1009
82#define VTK_SQL_DEFAULT_COLUMN_SIZE 32
96 virtual bool Open(
const char* password) = 0;
145 virtual bool IsSupported(
int vtkNotUsed(feature)) {
return false; }
263 class vtkCallbackVector;
264 static vtkCallbackVector* Callbacks;
a simple class to control print indentation
abstract base class for most VTK objects
represent an SQL database schema
maintain a connection to an sql database
virtual vtkSQLQuery * GetQueryInstance()=0
Return an empty query on this database.
static vtkInformationObjectBaseKey * DATABASE()
Stores the database class pointer as an information key.
virtual bool Open(const char *password)=0
Open a new connection to the database.
virtual vtkStdString GetTriggerSpecification(vtkSQLDatabaseSchema *schema, int tblHandle, int trgHandle)
Return the SQL string with the syntax to create a trigger using a "CREATE TRIGGER" SQL statement.
virtual vtkStringArray * GetRecord(const char *table)=0
Get the list of fields for a particular table.
virtual const char * GetDatabaseType()=0
Get the type of the database (e.g.
virtual vtkStdString GetTablePreamble(bool)
Return the SQL string with the syntax of the preamble following a "CREATE TABLE" SQL statement.
virtual vtkStdString GetURL()=0
Get the URL of the database.
virtual vtkStdString GetColumnSpecification(vtkSQLDatabaseSchema *schema, int tblHandle, int colHandle)
Return the SQL string with the syntax to create a column inside a "CREATE TABLE" SQL statement.
virtual bool ParseURL(const char *url)=0
Subclasses should override this method to determine connection parameters given the URL.
void PrintSelf(ostream &os, vtkIndent indent) override
Methods invoked by print to print information about the object including superclasses.
virtual vtkStdString GetIndexSpecification(vtkSQLDatabaseSchema *schema, int tblHandle, int idxHandle, bool &skipped)
Return the SQL string with the syntax to create an index inside a "CREATE TABLE" SQL statement.
~vtkSQLDatabase() override
static vtkSQLDatabase * CreateFromURL(const char *URL)
Create a the proper subclass given a URL.
static void UnRegisterCreateFromURLCallback(CreateFunction callback)
Provides mechanism to register/unregister additional callbacks to create concrete subclasses of vtkSQ...
virtual bool HasError()=0
Did the last operation generate an error.
virtual bool IsSupported(int vtkNotUsed(feature))
Return whether a feature is supported by the database.
virtual void Close()=0
Close the connection to the database.
static void RegisterCreateFromURLCallback(CreateFunction callback)
Provides mechanism to register/unregister additional callbacks to create concrete subclasses of vtkSQ...
virtual const char * GetLastErrorText()=0
Get the last error text from the database I'm using const so that people do NOT use the standard vtkG...
virtual vtkStringArray * GetTables()=0
Get the list of tables from the database.
virtual bool IsOpen()=0
Return whether the database has an open connection.
static void UnRegisterAllCreateFromURLCallbacks()
Provides mechanism to register/unregister additional callbacks to create concrete subclasses of vtkSQ...
virtual bool EffectSchema(vtkSQLDatabaseSchema *, bool dropIfExists=false)
Effect a database schema.
executes an sql query and retrieves results
Wrapper around std::string to keep symbols short.
a vtkAbstractArray subclass for strings