VTK
9.1.0
|
represent an SQL database schema More...
#include <vtkSQLDatabaseSchema.h>
Public Types | |
enum | DatabaseColumnType { SERIAL = 0 , SMALLINT = 1 , INTEGER = 2 , BIGINT = 3 , VARCHAR = 4 , TEXT = 5 , REAL = 6 , DOUBLE = 7 , BLOB = 8 , TIME = 9 , DATE = 10 , TIMESTAMP = 11 } |
Basic data types for database columns. More... | |
enum | DatabaseIndexType { INDEX = 0 , UNIQUE = 1 , PRIMARY_KEY = 2 } |
Types of indices that can be generated for database tables. More... | |
enum | DatabaseTriggerType { BEFORE_INSERT = 0 , AFTER_INSERT = 1 , BEFORE_UPDATE = 2 , AFTER_UPDATE = 3 , BEFORE_DELETE = 4 , AFTER_DELETE = 5 } |
Events where database triggers can be registered. More... | |
enum | VarargTokens { COLUMN_TOKEN = 58 , INDEX_TOKEN = 63 , INDEX_COLUMN_TOKEN = 65 , END_INDEX_TOKEN = 75 , TRIGGER_TOKEN = 81 , OPTION_TOKEN = 86 , END_TABLE_TOKEN = 99 } |
typedef vtkObject | Superclass |
Public Member Functions | |
virtual vtkTypeBool | IsA (const char *type) |
Return 1 if this class is the same type of (or a subclass of) the named class. | |
vtkSQLDatabaseSchema * | NewInstance () const |
void | PrintSelf (ostream &os, vtkIndent indent) override |
Methods invoked by print to print information about the object including superclasses. | |
virtual int | AddPreamble (const char *preName, const char *preAction, const char *preBackend=VTK_SQL_ALLBACKENDS) |
Add a preamble to the schema This can be used, in particular, to create functions and/or load languages in a backend-specific manner. | |
virtual int | AddTable (const char *tblName) |
Add a table to the schema. | |
int | GetPreambleHandleFromName (const char *preName) |
Given a preamble name, get its handle. | |
const char * | GetPreambleNameFromHandle (int preHandle) |
Given a preamble handle, get its name. | |
const char * | GetPreambleActionFromHandle (int preHandle) |
Given a preamble handle, get its action. | |
const char * | GetPreambleBackendFromHandle (int preHandle) |
Given a preamble handle, get its backend. | |
int | GetTableHandleFromName (const char *tblName) |
Given a table name, get its handle. | |
const char * | GetTableNameFromHandle (int tblHandle) |
Given a table handle, get its name. | |
int | GetIndexHandleFromName (const char *tblName, const char *idxName) |
Given the names of a table and an index, get the handle of the index in this table. | |
const char * | GetIndexNameFromHandle (int tblHandle, int idxHandle) |
Given the handles of a table and an index, get the name of the index. | |
int | GetIndexTypeFromHandle (int tblHandle, int idxHandle) |
Given the handles of a table and an index, get the type of the index. | |
const char * | GetIndexColumnNameFromHandle (int tblHandle, int idxHandle, int cnmHandle) |
Given the handles of a table, an index, and a column name, get the column name. | |
int | GetColumnHandleFromName (const char *tblName, const char *colName) |
Given the names of a table and a column, get the handle of the column in this table. | |
const char * | GetColumnNameFromHandle (int tblHandle, int colHandle) |
Given the handles of a table and a column, get the name of the column. | |
int | GetColumnTypeFromHandle (int tblHandle, int colHandle) |
Given the handles of a table and a column, get the type of the column. | |
int | GetColumnSizeFromHandle (int tblHandle, int colHandle) |
Given the handles of a table and a column, get the size of the column. | |
const char * | GetColumnAttributesFromHandle (int tblHandle, int colHandle) |
Given the handles of a table and a column, get the attributes of the column. | |
int | GetTriggerHandleFromName (const char *tblName, const char *trgName) |
Given the names of a trigger and a table, get the handle of the trigger in this table. | |
const char * | GetTriggerNameFromHandle (int tblHandle, int trgHandle) |
Given the handles of a table and a trigger, get the name of the trigger. | |
int | GetTriggerTypeFromHandle (int tblHandle, int trgHandle) |
Given the handles of a table and a trigger, get the type of the trigger. | |
const char * | GetTriggerActionFromHandle (int tblHandle, int trgHandle) |
Given the handles of a table and a trigger, get the action of the trigger. | |
const char * | GetTriggerBackendFromHandle (int tblHandle, int trgHandle) |
Given the handles of a table and a trigger, get the backend of the trigger. | |
const char * | GetOptionTextFromHandle (int tblHandle, int optHandle) |
Given the handles of a table and one of its options, return the text of the option. | |
const char * | GetOptionBackendFromHandle (int tblHandle, int optHandle) |
Given the handles of a table and one of its options, get the backend of the option. | |
void | Reset () |
Reset the schema to its initial, empty state. | |
int | GetNumberOfPreambles () |
Get the number of preambles. | |
int | GetNumberOfTables () |
Get the number of tables. | |
int | GetNumberOfColumnsInTable (int tblHandle) |
Get the number of columns in a particular table . | |
int | GetNumberOfIndicesInTable (int tblHandle) |
Get the number of indices in a particular table . | |
int | GetNumberOfColumnNamesInIndex (int tblHandle, int idxHandle) |
Get the number of column names associated to a particular index in a particular table . | |
int | GetNumberOfTriggersInTable (int tblHandle) |
Get the number of triggers defined for a particular table. | |
int | GetNumberOfOptionsInTable (int tblHandle) |
Get the number of options associated with a particular table. | |
int | AddTableMultipleArguments (const char *tblName,...) |
An unwrappable but useful routine to construct built-in schema. | |
virtual int | AddColumnToTable (int tblHandle, int colType, const char *colName, int colSize, const char *colOpts) |
Add a column to table. | |
virtual int | AddColumnToTable (const char *tblName, int colType, const char *colName, int colSize, const char *colAttribs) |
Add a column to table. | |
virtual int | AddIndexToTable (int tblHandle, int idxType, const char *idxName) |
Add an index to table. | |
virtual int | AddIndexToTable (const char *tblName, int idxType, const char *idxName) |
Add an index to table. | |
virtual int | AddColumnToIndex (int tblHandle, int idxHandle, int colHandle) |
Add a column to a table index. | |
virtual int | AddColumnToIndex (const char *tblName, const char *idxName, const char *colName) |
Add a column to a table index. | |
virtual int | AddTriggerToTable (int tblHandle, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS) |
Add a (possibly backend-specific) trigger action to a table. | |
virtual int | AddTriggerToTable (const char *tblName, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS) |
Add a (possibly backend-specific) trigger action to a table. | |
virtual int | AddOptionToTable (int tblHandle, const char *optText, const char *optBackend=VTK_SQL_ALLBACKENDS) |
Add (possibly backend-specific) text to the end of a CREATE TABLE (...) statement. | |
virtual int | AddOptionToTable (const char *tblName, const char *optStr, const char *optBackend=VTK_SQL_ALLBACKENDS) |
Add (possibly backend-specific) text to the end of a CREATE TABLE (...) statement. | |
virtual void | SetName (const char *) |
Set/Get the name of the schema. | |
virtual char * | GetName () |
Set/Get the name of the schema. | |
Public Member Functions inherited from vtkObject | |
vtkBaseTypeMacro (vtkObject, vtkObjectBase) | |
virtual void | DebugOn () |
Turn debugging output on. | |
virtual void | DebugOff () |
Turn debugging output off. | |
bool | GetDebug () |
Get the value of the debug flag. | |
void | SetDebug (bool debugFlag) |
Set the value of the debug flag. | |
virtual void | Modified () |
Update the modification time for this object. | |
virtual vtkMTimeType | GetMTime () |
Return this object's modified time. | |
void | PrintSelf (ostream &os, vtkIndent indent) override |
Methods invoked by print to print information about the object including superclasses. | |
void | RemoveObserver (unsigned long tag) |
void | RemoveObservers (unsigned long event) |
void | RemoveObservers (const char *event) |
void | RemoveAllObservers () |
vtkTypeBool | HasObserver (unsigned long event) |
vtkTypeBool | HasObserver (const char *event) |
int | InvokeEvent (unsigned long event) |
int | InvokeEvent (const char *event) |
unsigned long | AddObserver (unsigned long event, vtkCommand *, float priority=0.0f) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
unsigned long | AddObserver (const char *event, vtkCommand *, float priority=0.0f) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
vtkCommand * | GetCommand (unsigned long tag) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
void | RemoveObserver (vtkCommand *) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
void | RemoveObservers (unsigned long event, vtkCommand *) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
void | RemoveObservers (const char *event, vtkCommand *) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
vtkTypeBool | HasObserver (unsigned long event, vtkCommand *) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
vtkTypeBool | HasObserver (const char *event, vtkCommand *) |
Allow people to add/remove/invoke observers (callbacks) to any VTK object. | |
template<class U , class T > | |
unsigned long | AddObserver (unsigned long event, U observer, void(T::*callback)(), float priority=0.0f) |
Overloads to AddObserver that allow developers to add class member functions as callbacks for events. | |
template<class U , class T > | |
unsigned long | AddObserver (unsigned long event, U observer, void(T::*callback)(vtkObject *, unsigned long, void *), float priority=0.0f) |
Overloads to AddObserver that allow developers to add class member functions as callbacks for events. | |
template<class U , class T > | |
unsigned long | AddObserver (unsigned long event, U observer, bool(T::*callback)(vtkObject *, unsigned long, void *), float priority=0.0f) |
Allow user to set the AbortFlagOn() with the return value of the callback method. | |
int | InvokeEvent (unsigned long event, void *callData) |
This method invokes an event and return whether the event was aborted or not. | |
int | InvokeEvent (const char *event, void *callData) |
This method invokes an event and return whether the event was aborted or not. | |
Public Member Functions inherited from vtkObjectBase | |
const char * | GetClassName () const |
Return the class name as a string. | |
virtual vtkTypeBool | IsA (const char *name) |
Return 1 if this class is the same type of (or a subclass of) the named class. | |
virtual vtkIdType | GetNumberOfGenerationsFromBase (const char *name) |
Given the name of a base class of this class type, return the distance of inheritance between this class type and the named class (how many generations of inheritance are there between this class and the named class). | |
virtual void | Delete () |
Delete a VTK object. | |
virtual void | FastDelete () |
Delete a reference to this object. | |
void | InitializeObjectBase () |
void | Print (ostream &os) |
Print an object to an ostream. | |
virtual void | Register (vtkObjectBase *o) |
Increase the reference count (mark as used by another object). | |
virtual void | UnRegister (vtkObjectBase *o) |
Decrease the reference count (release by another object). | |
int | GetReferenceCount () |
Return the current reference count of this object. | |
void | SetReferenceCount (int) |
Sets the reference count. | |
bool | GetIsInMemkind () const |
A local state flag that remembers whether this object lives in the normal or extended memory space. | |
virtual void | PrintHeader (ostream &os, vtkIndent indent) |
Methods invoked by print to print information about the object including superclasses. | |
virtual void | PrintTrailer (ostream &os, vtkIndent indent) |
Methods invoked by print to print information about the object including superclasses. | |
Static Public Member Functions | |
static vtkTypeBool | IsTypeOf (const char *type) |
static vtkSQLDatabaseSchema * | SafeDownCast (vtkObjectBase *o) |
static vtkSQLDatabaseSchema * | New () |
Static Public Member Functions inherited from vtkObject | |
static vtkObject * | New () |
Create an object with Debug turned off, modified time initialized to zero, and reference counting on. | |
static void | BreakOnError () |
This method is called when vtkErrorMacro executes. | |
static void | SetGlobalWarningDisplay (int val) |
This is a global flag that controls whether any debug, warning or error messages are displayed. | |
static void | GlobalWarningDisplayOn () |
This is a global flag that controls whether any debug, warning or error messages are displayed. | |
static void | GlobalWarningDisplayOff () |
This is a global flag that controls whether any debug, warning or error messages are displayed. | |
static int | GetGlobalWarningDisplay () |
This is a global flag that controls whether any debug, warning or error messages are displayed. | |
Static Public Member Functions inherited from vtkObjectBase | |
static vtkTypeBool | IsTypeOf (const char *name) |
Return 1 if this class type is the same type of (or a subclass of) the named class. | |
static vtkIdType | GetNumberOfGenerationsFromBaseType (const char *name) |
Given a the name of a base class of this class type, return the distance of inheritance between this class type and the named class (how many generations of inheritance are there between this class and the named class). | |
static vtkObjectBase * | New () |
Create an object with Debug turned off, modified time initialized to zero, and reference counting on. | |
static void | SetMemkindDirectory (const char *directoryname) |
The name of a directory, ideally mounted -o dax, to memory map an extended memory space within. | |
static bool | GetUsingMemkind () |
A global state flag that controls whether vtkObjects are constructed in the usual way (the default) or within the extended memory space. | |
Protected Member Functions | |
virtual vtkObjectBase * | NewInstanceInternal () const |
vtkSQLDatabaseSchema () | |
~vtkSQLDatabaseSchema () override | |
Protected Member Functions inherited from vtkObject | |
vtkObject () | |
~vtkObject () override | |
void | RegisterInternal (vtkObjectBase *, vtkTypeBool check) override |
void | UnRegisterInternal (vtkObjectBase *, vtkTypeBool check) override |
void | InternalGrabFocus (vtkCommand *mouseEvents, vtkCommand *keypressEvents=nullptr) |
These methods allow a command to exclusively grab all events. | |
void | InternalReleaseFocus () |
These methods allow a command to exclusively grab all events. | |
Protected Member Functions inherited from vtkObjectBase | |
vtkObjectBase () | |
virtual | ~vtkObjectBase () |
virtual void | RegisterInternal (vtkObjectBase *, vtkTypeBool check) |
virtual void | UnRegisterInternal (vtkObjectBase *, vtkTypeBool check) |
virtual void | ReportReferences (vtkGarbageCollector *) |
vtkObjectBase (const vtkObjectBase &) | |
void | operator= (const vtkObjectBase &) |
Protected Attributes | |
char * | Name |
class vtkSQLDatabaseSchemaInternals * | Internals |
Protected Attributes inherited from vtkObject | |
bool | Debug |
vtkTimeStamp | MTime |
vtkSubjectHelper * | SubjectHelper |
Protected Attributes inherited from vtkObjectBase | |
std::atomic< int32_t > | ReferenceCount |
vtkWeakPointerBase ** | WeakPointers |
Additional Inherited Members | |
Static Protected Member Functions inherited from vtkObjectBase | |
static vtkMallocingFunction | GetCurrentMallocFunction () |
static vtkReallocingFunction | GetCurrentReallocFunction () |
static vtkFreeingFunction | GetCurrentFreeFunction () |
static vtkFreeingFunction | GetAlternateFreeFunction () |
represent an SQL database schema
This class stores the information required to create an SQL database from scratch. Information on each table's columns, indices, and triggers is stored. You may also store an arbitrary number of preamble statements, intended to be executed before any tables are created; this provides a way to create procedures or functions that may be invoked as part of a trigger action. Triggers and table options may be specified differently for each backend database type you wish to support.
Definition at line 61 of file vtkSQLDatabaseSchema.h.
Definition at line 64 of file vtkSQLDatabaseSchema.h.
Basic data types for database columns.
Enumerator | |
---|---|
SERIAL | |
SMALLINT | |
INTEGER | |
BIGINT | |
VARCHAR | |
TEXT | |
REAL | |
DOUBLE | |
BLOB | |
TIME | |
DATE | |
TIMESTAMP |
Definition at line 71 of file vtkSQLDatabaseSchema.h.
Types of indices that can be generated for database tables.
Enumerator | |
---|---|
INDEX | |
UNIQUE | |
PRIMARY_KEY |
Definition at line 90 of file vtkSQLDatabaseSchema.h.
Events where database triggers can be registered.
Enumerator | |
---|---|
BEFORE_INSERT | |
AFTER_INSERT | |
BEFORE_UPDATE | |
AFTER_UPDATE | |
BEFORE_DELETE | |
AFTER_DELETE |
Definition at line 102 of file vtkSQLDatabaseSchema.h.
Enumerator | |
---|---|
COLUMN_TOKEN | |
INDEX_TOKEN | |
INDEX_COLUMN_TOKEN | |
END_INDEX_TOKEN | |
TRIGGER_TOKEN | |
OPTION_TOKEN | |
END_TABLE_TOKEN |
Definition at line 375 of file vtkSQLDatabaseSchema.h.
|
protected |
|
overrideprotected |
|
static |
|
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 vtkTypeMacro found in vtkSetGet.h.
Reimplemented from vtkObjectBase.
|
static |
|
protectedvirtual |
vtkSQLDatabaseSchema * vtkSQLDatabaseSchema::NewInstance | ( | ) | const |
|
overridevirtual |
|
static |
|
virtual |
Add a preamble to the schema This can be used, in particular, to create functions and/or load languages in a backend-specific manner.
Example usage: vtkSQLDatabaseSchema* schema = vtkSQLDatabaseSchema::New(); schema->SetName( "Example" ); schema->AddPreamble( "dropPLPGSQL", "DROP LANGUAGE IF EXISTS PLPGSQL CASCADE", VTK_SQL_POSTGRESQL ); schema->AddPreamble( "loadPLPGSQL", "CREATE LANGUAGE PLPGSQL", VTK_SQL_POSTGRESQL ); schema->AddPreamble( "createsomefunction", "CREATE OR REPLACE FUNCTION somefunction() RETURNS TRIGGER AS $btable$ " "BEGIN " "INSERT INTO btable (somevalue) VALUES (NEW.somenmbr); " "RETURN NEW; " "END; $btable$ LANGUAGE PLPGSQL", VTK_SQL_POSTGRESQL );
|
virtual |
Add a table to the schema.
|
virtual |
Add a column to table.
The returned value is a column handle or -1 if an error occurred.
|
inlinevirtual |
Add a column to table.
The returned value is a column handle or -1 if an error occurred.
Definition at line 141 of file vtkSQLDatabaseSchema.h.
|
virtual |
Add an index to table.
The returned value is an index handle or -1 if an error occurred.
|
inlinevirtual |
Add an index to table.
The returned value is an index handle or -1 if an error occurred.
Definition at line 156 of file vtkSQLDatabaseSchema.h.
|
virtual |
Add a column to a table index.
The returned value is an index-column handle or -1 if an error occurred.
|
inlinevirtual |
Add a column to a table index.
The returned value is an index-column handle or -1 if an error occurred.
Definition at line 169 of file vtkSQLDatabaseSchema.h.
|
virtual |
Add a (possibly backend-specific) trigger action to a table.
Triggers must be given unique, non-nullptr names as some database backends require them. The returned value is a trigger handle or -1 if an error occurred.
|
inlinevirtual |
Add a (possibly backend-specific) trigger action to a table.
Triggers must be given unique, non-nullptr names as some database backends require them. The returned value is a trigger handle or -1 if an error occurred.
Definition at line 186 of file vtkSQLDatabaseSchema.h.
|
virtual |
Add (possibly backend-specific) text to the end of a CREATE TABLE (...) statement.
This is most useful for specifying storage semantics of tables that are specific to the backend. For example, table options can be used to specify the TABLESPACE of a PostgreSQL table or the ENGINE of a MySQL table.
The returned value is an option handle or -1 if an error occurred.
|
inlinevirtual |
Add (possibly backend-specific) text to the end of a CREATE TABLE (...) statement.
This is most useful for specifying storage semantics of tables that are specific to the backend. For example, table options can be used to specify the TABLESPACE of a PostgreSQL table or the ENGINE of a MySQL table.
The returned value is an option handle or -1 if an error occurred.
Definition at line 208 of file vtkSQLDatabaseSchema.h.
int vtkSQLDatabaseSchema::GetPreambleHandleFromName | ( | const char * | preName | ) |
Given a preamble name, get its handle.
const char * vtkSQLDatabaseSchema::GetPreambleNameFromHandle | ( | int | preHandle | ) |
Given a preamble handle, get its name.
const char * vtkSQLDatabaseSchema::GetPreambleActionFromHandle | ( | int | preHandle | ) |
Given a preamble handle, get its action.
const char * vtkSQLDatabaseSchema::GetPreambleBackendFromHandle | ( | int | preHandle | ) |
Given a preamble handle, get its backend.
int vtkSQLDatabaseSchema::GetTableHandleFromName | ( | const char * | tblName | ) |
Given a table name, get its handle.
const char * vtkSQLDatabaseSchema::GetTableNameFromHandle | ( | int | tblHandle | ) |
Given a table handle, get its name.
int vtkSQLDatabaseSchema::GetIndexHandleFromName | ( | const char * | tblName, |
const char * | idxName | ||
) |
Given the names of a table and an index, get the handle of the index in this table.
const char * vtkSQLDatabaseSchema::GetIndexNameFromHandle | ( | int | tblHandle, |
int | idxHandle | ||
) |
Given the handles of a table and an index, get the name of the index.
int vtkSQLDatabaseSchema::GetIndexTypeFromHandle | ( | int | tblHandle, |
int | idxHandle | ||
) |
Given the handles of a table and an index, get the type of the index.
const char * vtkSQLDatabaseSchema::GetIndexColumnNameFromHandle | ( | int | tblHandle, |
int | idxHandle, | ||
int | cnmHandle | ||
) |
Given the handles of a table, an index, and a column name, get the column name.
int vtkSQLDatabaseSchema::GetColumnHandleFromName | ( | const char * | tblName, |
const char * | colName | ||
) |
Given the names of a table and a column, get the handle of the column in this table.
const char * vtkSQLDatabaseSchema::GetColumnNameFromHandle | ( | int | tblHandle, |
int | colHandle | ||
) |
Given the handles of a table and a column, get the name of the column.
int vtkSQLDatabaseSchema::GetColumnTypeFromHandle | ( | int | tblHandle, |
int | colHandle | ||
) |
Given the handles of a table and a column, get the type of the column.
int vtkSQLDatabaseSchema::GetColumnSizeFromHandle | ( | int | tblHandle, |
int | colHandle | ||
) |
Given the handles of a table and a column, get the size of the column.
const char * vtkSQLDatabaseSchema::GetColumnAttributesFromHandle | ( | int | tblHandle, |
int | colHandle | ||
) |
Given the handles of a table and a column, get the attributes of the column.
int vtkSQLDatabaseSchema::GetTriggerHandleFromName | ( | const char * | tblName, |
const char * | trgName | ||
) |
Given the names of a trigger and a table, get the handle of the trigger in this table.
const char * vtkSQLDatabaseSchema::GetTriggerNameFromHandle | ( | int | tblHandle, |
int | trgHandle | ||
) |
Given the handles of a table and a trigger, get the name of the trigger.
int vtkSQLDatabaseSchema::GetTriggerTypeFromHandle | ( | int | tblHandle, |
int | trgHandle | ||
) |
Given the handles of a table and a trigger, get the type of the trigger.
const char * vtkSQLDatabaseSchema::GetTriggerActionFromHandle | ( | int | tblHandle, |
int | trgHandle | ||
) |
Given the handles of a table and a trigger, get the action of the trigger.
const char * vtkSQLDatabaseSchema::GetTriggerBackendFromHandle | ( | int | tblHandle, |
int | trgHandle | ||
) |
Given the handles of a table and a trigger, get the backend of the trigger.
const char * vtkSQLDatabaseSchema::GetOptionTextFromHandle | ( | int | tblHandle, |
int | optHandle | ||
) |
Given the handles of a table and one of its options, return the text of the option.
const char * vtkSQLDatabaseSchema::GetOptionBackendFromHandle | ( | int | tblHandle, |
int | optHandle | ||
) |
Given the handles of a table and one of its options, get the backend of the option.
void vtkSQLDatabaseSchema::Reset | ( | ) |
Reset the schema to its initial, empty state.
int vtkSQLDatabaseSchema::GetNumberOfPreambles | ( | ) |
Get the number of preambles.
int vtkSQLDatabaseSchema::GetNumberOfTables | ( | ) |
Get the number of tables.
int vtkSQLDatabaseSchema::GetNumberOfColumnsInTable | ( | int | tblHandle | ) |
Get the number of columns in a particular table .
int vtkSQLDatabaseSchema::GetNumberOfIndicesInTable | ( | int | tblHandle | ) |
Get the number of indices in a particular table .
int vtkSQLDatabaseSchema::GetNumberOfColumnNamesInIndex | ( | int | tblHandle, |
int | idxHandle | ||
) |
Get the number of column names associated to a particular index in a particular table .
int vtkSQLDatabaseSchema::GetNumberOfTriggersInTable | ( | int | tblHandle | ) |
Get the number of triggers defined for a particular table.
int vtkSQLDatabaseSchema::GetNumberOfOptionsInTable | ( | int | tblHandle | ) |
Get the number of options associated with a particular table.
|
virtual |
Set/Get the name of the schema.
|
virtual |
Set/Get the name of the schema.
int vtkSQLDatabaseSchema::AddTableMultipleArguments | ( | const char * | tblName, |
... | |||
) |
An unwrappable but useful routine to construct built-in schema.
Example usage: int main() { vtkSQLDatabaseSchema* schema = vtkSQLDatabaseSchema::New(); schema->SetName( "Example" ); schema->AddTableMultipleArguments( "atable", vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::INTEGER, "tablekey", 0, "", vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::VARCHAR, "somename", 11, "NOT nullptr", vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::BIGINT, "somenmbr", 17, "DEFAULT 0", vtkSQLDatabaseSchema::INDEX_TOKEN, vtkSQLDatabaseSchema::PRIMARY_KEY, "bigkey", vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN, "tablekey", vtkSQLDatabaseSchema::END_INDEX_TOKEN, vtkSQLDatabaseSchema::INDEX_TOKEN, vtkSQLDatabaseSchema::UNIQUE, "reverselookup", vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN, "somename", vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN, "somenmbr", vtkSQLDatabaseSchema::END_INDEX_TOKEN, vtkSQLDatabaseSchema::TRIGGER_TOKEN, vtkSQLDatabaseSchema::AFTER_INSERT, "InsertTrigger", "DO NOTHING", VTK_SQL_SQLITE, vtkSQLDatabaseSchema::TRIGGER_TOKEN, vtkSQLDatabaseSchema::AFTER_INSERT, "InsertTrigger", "FOR EACH ROW EXECUTE PROCEDURE somefunction ()", VTK_SQL_POSTGRESQL, vtkSQLDatabaseSchema::TRIGGER_TOKEN, vtkSQLDatabaseSchema::AFTER_INSERT, "InsertTrigger", "FOR EACH ROW INSERT INTO btable SET SomeValue = NEW.SomeNmbr", VTK_SQL_MYSQL, vtkSQLDatabaseSchema::END_TABLE_TOKEN ); return 0; }
|
protected |
Definition at line 421 of file vtkSQLDatabaseSchema.h.
|
protected |
Definition at line 423 of file vtkSQLDatabaseSchema.h.