vtkSQLDatabase Class Reference

#include <vtkSQLDatabase.h>

Inheritance diagram for vtkSQLDatabase:

Inheritance graph
[legend]
Collaboration diagram for vtkSQLDatabase:

Collaboration graph
[legend]

List of all members.


Detailed Description

maintain a connection to an sql database

Abstract base class for all SQL database connection classes. Manages a connection to the database, and is responsible for creating instances of the associated vtkSQLQuery objects associated with this class in order to perform execute queries on the database. To allow connections to a new type of database, create both a subclass of this class and vtkSQLQuery, and implement the required functions:

Open() - open the database connection, if possible. Close() - close the connection. GetQueryInstance() - create and return an instance of the vtkSQLQuery subclass associated with the database type.

The subclass should also provide API to set connection parameters.

This class also provides the function EffectSchema to transform a database schema into a SQL database.

Thanks:
Thanks to Andrew Wilson from Sandia National Laboratories for his work on the database classes and for the SQLite example. Thanks to David Thompson and Philippe Pebay from Sandia National Laboratories for implementing this class.
See also:
vtkSQLQuery vtkSQLDatabaseSchema
Examples:
vtkSQLDatabase (Examples)
Tests:
vtkSQLDatabase (Tests)

Definition at line 87 of file vtkSQLDatabase.h.


Public Types

typedef vtkObject Superclass

Public Member Functions

virtual const char * GetClassName ()
virtual int IsA (const char *type)
void PrintSelf (ostream &os, vtkIndent indent)
virtual bool Open ()=0
virtual void Close ()=0
virtual bool IsOpen ()=0
virtual vtkSQLQueryGetQueryInstance ()=0
virtual bool HasError ()=0
virtual const char * GetLastErrorText ()=0
virtual char * GetDatabaseType ()=0
virtual vtkStringArrayGetTables ()=0
virtual vtkStringArrayGetRecord (const char *table)=0
virtual bool IsSupported (int vtkNotUsed(feature))
virtual vtkStdString GetURL ()=0
virtual vtkStdString GetTablePreamble (bool)
virtual bool EffectSchema (vtkSQLDatabaseSchema *, bool dropIfExists=false)
virtual vtkStdString GetColumnSpecification (vtkSQLDatabaseSchema *schema, int tblHandle, int colHandle)
virtual vtkStdString GetIndexSpecification (vtkSQLDatabaseSchema *schema, int tblHandle, int idxHandle, bool &skipped)
virtual vtkStdString GetTriggerSpecification (vtkSQLDatabaseSchema *schema, int tblHandle, int trgHandle)

Static Public Member Functions

static int IsTypeOf (const char *type)
static vtkSQLDatabaseSafeDownCast (vtkObject *o)
static vtkSQLDatabaseCreateFromURL (const char *URL)

Protected Member Functions

 vtkSQLDatabase ()
 ~vtkSQLDatabase ()

Member Typedef Documentation

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

Definition at line 90 of file vtkSQLDatabase.h.


Constructor & Destructor Documentation

vtkSQLDatabase::vtkSQLDatabase (  )  [protected]

vtkSQLDatabase::~vtkSQLDatabase (  )  [protected]


Member Function Documentation

virtual const char* vtkSQLDatabase::GetClassName (  )  [virtual]

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

static int vtkSQLDatabase::IsTypeOf ( const char *  name  )  [static]

Return 1 if this class type is the same type of (or a subclass of) the named class. Returns 0 otherwise. This method works in combination with vtkTypeRevisionMacro found in vtkSetGet.h.

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual int vtkSQLDatabase::IsA ( const char *  name  )  [virtual]

Return 1 if this class is the same type of (or a subclass of) the named class. Returns 0 otherwise. This method works in combination with vtkTypeRevisionMacro found in vtkSetGet.h.

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

static vtkSQLDatabase* vtkSQLDatabase::SafeDownCast ( vtkObject o  )  [static]

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

void vtkSQLDatabase::PrintSelf ( ostream &  os,
vtkIndent  indent 
) [virtual]

Methods invoked by print to print information about the object including superclasses. Typically not called by the user (use Print() instead) but used in the hierarchical print process to combine the output of several classes.

Reimplemented from vtkObject.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual bool vtkSQLDatabase::Open (  )  [pure virtual]

Open a new connection to the database. You need to set up any database parameters before calling this function. Returns true is the database was opened sucessfully, and false otherwise.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual void vtkSQLDatabase::Close (  )  [pure virtual]

Close the connection to the database.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual bool vtkSQLDatabase::IsOpen (  )  [pure virtual]

Return whether the database has an open connection.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual vtkSQLQuery* vtkSQLDatabase::GetQueryInstance (  )  [pure virtual]

Return an empty query on this database.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual bool vtkSQLDatabase::HasError (  )  [pure virtual]

Did the last operation generate an error

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual const char* vtkSQLDatabase::GetLastErrorText (  )  [pure virtual]

Get the last error text from the database I'm using const so that people do NOT use the standard vtkGetStringMacro in their implementation, because 99% of the time that will not be the correct thing to do...

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual char* vtkSQLDatabase::GetDatabaseType (  )  [pure virtual]

Get the type of the database (e.g. mysql, psql,..).

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual vtkStringArray* vtkSQLDatabase::GetTables (  )  [pure virtual]

Get the list of tables from the database.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual vtkStringArray* vtkSQLDatabase::GetRecord ( const char *  table  )  [pure virtual]

Get the list of fields for a particular table.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual bool vtkSQLDatabase::IsSupported ( int   vtkNotUsedfeature  )  [inline, virtual]

Return whether a feature is supported by the database.

Definition at line 126 of file vtkSQLDatabase.h.

virtual vtkStdString vtkSQLDatabase::GetURL (  )  [pure virtual]

Get the URL of the database.

Implemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual vtkStdString vtkSQLDatabase::GetTablePreamble ( bool   )  [inline, virtual]

Return the SQL string with the syntax of the preamble following a "CREATE TABLE" SQL statement. NB: by default, this method returns an empty string. It must be overwritten for those SQL backends which allow such preambles such as, e.g., MySQL.

Reimplemented in vtkMySQLDatabase.

Definition at line 135 of file vtkSQLDatabase.h.

virtual vtkStdString vtkSQLDatabase::GetColumnSpecification ( vtkSQLDatabaseSchema schema,
int  tblHandle,
int  colHandle 
) [virtual]

Return the SQL string with the syntax to create a column inside a "CREATE TABLE" SQL statement. NB: this method implements the following minimally-portable syntax: <column name>=""> <column type>=""> <column attributes>=""> It must be overwritten for those SQL backends which have a different syntax such as, e.g., MySQL.

Reimplemented in vtkMySQLDatabase, vtkPostgreSQLDatabase, and vtkSQLiteDatabase.

virtual vtkStdString vtkSQLDatabase::GetIndexSpecification ( vtkSQLDatabaseSchema schema,
int  tblHandle,
int  idxHandle,
bool &  skipped 
) [virtual]

Return the SQL string with the syntax to create an index inside a "CREATE TABLE" SQL statement. NB1: this method implements the following minimally-portable syntax: <index type>=""> [<index name>="">] (<column name 1>,... ) It must be overwritten for those SQL backends which have a different syntax such as, e.g., MySQL. NB2: this method does not assume that INDEX creation is supported within a CREATE TABLE statement. Therefore, should such an INDEX arise in the schema, a CREATE INDEX statement is returned and skipped is set to true. Otherwise, skipped will always be returned false.

Reimplemented in vtkMySQLDatabase.

virtual vtkStdString vtkSQLDatabase::GetTriggerSpecification ( vtkSQLDatabaseSchema schema,
int  tblHandle,
int  trgHandle 
) [virtual]

Return the SQL string with the syntax to create a trigger using a "CREATE TRIGGER" SQL statement. NB1: support is contingent on VTK_FEATURE_TRIGGERS being recognized as a supported feature. Not all backends (e.g., SQLite) support it. NB2: this method implements the following minimally-portable syntax: <trigger name>=""> {BEFORE | AFTER} <event> ON border="1" cellspacing="3" cellpadding="3">
EACH ROW <trigger action>=""> It must be overwritten for those SQL backends which have a different syntax such as, e.g., PostgreSQL.

static vtkSQLDatabase* vtkSQLDatabase::CreateFromURL ( const char *  URL  )  [static]

Create a the proper subclass given a URL. The URL format for SQL databases is a true URL of the form: 'protocol://'[[username[':'password]'@']hostname[':'port]]'/'[dbname]

virtual bool vtkSQLDatabase::EffectSchema ( vtkSQLDatabaseSchema ,
bool  dropIfExists = false 
) [virtual]

Effect a database schema.


The documentation for this class was generated from the following file:

Generated on Sat Dec 27 13:51:08 2008 for VTK by  doxygen 1.5.6