23 #ifndef vtkMySQLDatabase_h
24 #define vtkMySQLDatabase_h
26 #include "vtkIOMySQLModule.h"
29 VTK_ABI_NAMESPACE_BEGIN
50 bool Open(
const char* password =
nullptr)
override;
55 void Close()
override;
103 vtkSetStringMacro(HostName);
104 vtkGetStringMacro(HostName);
111 vtkSetStringMacro(User);
112 vtkGetStringMacro(User);
119 vtkSetStringMacro(Password);
126 vtkSetStringMacro(DatabaseName);
127 vtkGetStringMacro(DatabaseName);
136 vtkSetMacro(Reconnect,
int);
137 vtkGetMacro(Reconnect,
int);
138 vtkBooleanMacro(Reconnect,
int);
146 vtkGetMacro(ServerPort,
int);
193 bool CreateDatabase(
const char* dbName,
bool dropExisting);
199 bool DropDatabase(
const char* dbName);
215 vtkSetStringMacro(DatabaseType);
234 VTK_ABI_NAMESPACE_END
235 #endif // vtkMySQLDatabase_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 a MySQL database
maintain a connection to an sql database
friend class vtkMySQLDatabase
virtual void Close()=0
Close the connection to the database.
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
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...
vtkStdString GetTablePreamble(bool b) override
Return the SQL string with the syntax of the preamble following a "CREATE TABLE" SQL statement...
executes an sql query and retrieves results
const char * GetDatabaseType() override
String representing database type (e.g.
vtkSQLQuery implementation for MySQL databases
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.