75 #ifndef vtkODBCDatabase_h 76 #define vtkODBCDatabase_h 78 #include "vtkIOODBCModule.h" 101 bool Open(
const char* password)
override;
106 void Close()
override;
144 vtkSetStringMacro(DataSourceName);
145 vtkGetStringMacro(DataSourceName);
148 vtkSetMacro(ServerPort,
int);
149 vtkSetStringMacro(HostName);
150 vtkSetStringMacro(UserName);
151 vtkSetStringMacro(DatabaseName);
152 vtkGetStringMacro(DatabaseName);
153 vtkSetStringMacro(Password);
163 return this->DatabaseType;
178 int colHandle )
override;
187 bool& skipped )
override;
193 bool CreateDatabase(
const char* dbName,
bool dropExisting );
199 bool DropDatabase(
const char* dbName );
212 vtkSetStringMacro(LastErrorText);
223 char *DataSourceName;
231 vtkSetStringMacro(DatabaseType);
239 #endif // vtkODBCDatabase_h Wrapper around std::string to keep symbols short.
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 IsSupported(int vtkNotUsed(feature))
Return whether a feature is supported by the database.
virtual bool Open(const char *password)=0
Open a new connection to the database.
virtual bool ParseURL(const char *url)=0
Subclasses should override this method to determine connection parameters given the URL...
virtual bool HasError()=0
Did the last operation generate an error.
a vtkAbstractArray subclass for strings
virtual vtkStdString GetURL()=0
Get the URL of the database.
represent an SQL database schema
virtual vtkStringArray * GetRecord(const char *table)=0
Get the list of fields for a particular table.
void PrintSelf(ostream &os, vtkIndent indent) override
Methods invoked by print to print information about the object including superclasses.
maintain a connection to an sql database
const char * GetDatabaseType() override
String representing database type (e.g.
virtual void Close()=0
Close the connection to the database.
Simple class to hide ODBC structures.
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...
a simple class to control print indentation
friend class vtkODBCDatabase
maintain an ODBC connection to a SQL database
virtual vtkSQLQuery * GetQueryInstance()=0
Return an empty query on this database.
virtual bool IsOpen()=0
Return whether the database has an open connection.
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...
executes an sql query and retrieves results
static vtkObject * New()
Create an object with Debug turned off, modified time initialized to zero, and reference counting on...
virtual vtkStringArray * GetTables()=0
Get the list of tables from the database.
vtkSQLQuery implementation for ODBC connections to databases