<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"> <title>VTK: vtkSQLDatabaseSchema Class Reference</title> <link href="doxygen.css" rel="stylesheet" type="text/css"> <link href="tabs.css" rel="stylesheet" type="text/css"> </head><body> <!-- Generated by Doxygen 1.5.6 --> <div class="navigation" id="top"> <div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li class="current"><a href="classes.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> </ul> </div> <div class="tabs"> <ul> <li><a href="classes.html"><span>Alphabetical List</span></a></li> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="hierarchy.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> </div> <div class="contents"> <h1>vtkSQLDatabaseSchema Class Reference</h1><!-- doxytag: class="vtkSQLDatabaseSchema" --><!-- doxytag: inherits="vtkObject" --><code>#include <<a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>></code> <p> <div class="dynheader"> Inheritance diagram for vtkSQLDatabaseSchema:</div> <div class="dynsection"> <p><center><img src="a14678.png" border="0" usemap="#a14679" alt="Inheritance graph"></center> <map name="a14679"> <area shape="rect" href="a01084.html" title="abstract base class for most VTK objects" alt="" coords="52,80,132,107"><area shape="rect" href="a01085.html" title="abstract base class for most VTK objects" alt="" coords="37,6,147,32"></map> <center><font size="2">[<a href="graph_legend.html">legend</a>]</font></center></div> <div class="dynheader"> Collaboration diagram for vtkSQLDatabaseSchema:</div> <div class="dynsection"> <p><center><img src="a14680.png" border="0" usemap="#a14681" alt="Collaboration graph"></center> <map name="a14681"> <area shape="rect" href="a01084.html" title="abstract base class for most VTK objects" alt="" coords="87,96,167,123"><area shape="rect" href="a01085.html" title="abstract base class for most VTK objects" alt="" coords="5,5,115,32"><area shape="rect" href="a01719.html" title="record modification and/or execution time" alt="" coords="139,5,248,32"></map> <center><font size="2">[<a href="graph_legend.html">legend</a>]</font></center></div> <p> <a href="a14682.html">List of all members.</a><hr><a name="_details"></a><h2>Detailed Description</h2> create a SQL database schema <p> A class to create a SQL database schema<p> <dl class="user" compact><dt><b>Thanks:</b></dt><dd>Thanks to Philippe Pebay and David Thompson from Sandia National Laboratories for implementing this class.</dd></dl> <dl class="see" compact><dt><b>See also:</b></dt><dd>vtkSQLSQLDatabase</dd></dl> <dl class="user" compact><dt><b>Tests:</b></dt><dd><a class="el" href="c2_vtk_t_15.html#c2_vtk_t_vtkSQLDatabaseSchema">vtkSQLDatabaseSchema (Tests)</a> </dd></dl> <p>Definition at line <a class="el" href="a04985.html#l00054">54</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> <table border="0" cellpadding="0" cellspacing="0"> <tr><td></td></tr> <tr><td colspan="2"><br><h2>Public Types</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">enum </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c">VarargTokens</a> { <br> <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9">COLUMN_TOKEN</a> = 58, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288cea11c9743712e469a7c05a36118ca0a3">INDEX_TOKEN</a> = 63, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62">INDEX_COLUMN_TOKEN</a> = 65, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c0169ea381fbeb08f96432a9c47083c97">END_INDEX_TOKEN</a> = 75, <br> <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d">TRIGGER_TOKEN</a> = 81, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c7f7c9dbb5d0e2e501ab740b7ee150d92">END_TABLE_TOKEN</a> = 99 <br> }</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">typedef <a class="el" href="a01084.html">vtkObject</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#252b671542549ca8ae8df7ec6f0ef588">Superclass</a></td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">enum </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4">DatabaseColumnType</a> { <br> <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a41e6e3fff159856d240d8f6ca23f15908">SERIAL</a> = 0, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a425df9ef60e6338c1ba73d5dab7945f02">SMALLINT</a> = 1, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4a12f2be77e31d136b6cbb6067307f990">INTEGER</a> = 2, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a42415955434b81e14fa3ba58b433d1d40">BIGINT</a> = 3, <br> <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a41fbcd08f887d7cda74eade0291088984">VARCHAR</a> = 4, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4262d7be274f4d60dfc533e41a92bea2c">TEXT</a> = 5, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4137c659c186000bb2154415b10bf3715">REAL</a> = 6, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4d08297a7c72a67ee66889adc7d253509">DOUBLE</a> = 7, <br> <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4b25b73a9ae7b76f47a2c992db90743f1">BLOB</a> = 8, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4076e4998bd8c46e3a8d52268a4de9c67">TIME</a> = 9, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a49a786401af764632e54e495e5d839e26">DATE</a> = 10, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4a4bfd1b0a607ea79d2ed48ce5eb5bf65">TIMESTAMP</a> = 11 <br> }</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">enum </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#dc4546884c25550da09ab17f02246033">DatabaseIndexType</a> { <a class="el" href="a01595.html#dc4546884c25550da09ab17f0224603330cf0fecca1909158a4a83d2e28bafc1">INDEX</a> = 0, <a class="el" href="a01595.html#dc4546884c25550da09ab17f022460338973ff0e38aab19fb1cae87f313ceda6">UNIQUE</a> = 1, <a class="el" href="a01595.html#dc4546884c25550da09ab17f02246033923d89643977442392fa331249feb12e">PRIMARY_KEY</a> = 2 }</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">enum </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344">DatabaseTriggerType</a> { <br> <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344cd26e7f2a69debfa766947c87414a963">BEFORE_INSERT</a> = 0, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c">AFTER_INSERT</a> = 1, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd134424c155daede3fa2e6902860a3dcc5c57">BEFORE_UPDATE</a> = 2, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd134435cb4c26062b01838919c0e04aded6b1">AFTER_UPDATE</a> = 3, <br> <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344aa44fd9b05e7c7173126cccd39f609ae">BEFORE_DELETE</a> = 4, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344558f6aa090a7156d3e16a6d1e6f57ec6">AFTER_DELETE</a> = 5 <br> }</td></tr> <tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#3586c7951a513a7f33c074518787651e">GetClassName</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#700c3c1cd40104be5f5b169a83c704ec">IsA</a> (const char *type)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#405f285b7eb369cd97902462e59e5ce5">PrintSelf</a> (ostream &os, <a class="el" href="a00869.html">vtkIndent</a> indent)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#97cc210215073cc0ae96901020d99fe9">AddPreamble</a> (const char *preName, const char *preAction, const char *preBackend=VTK_SQL_ALLBACKENDS)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#2ef99216256d1954fb942b98de25f97e">AddTable</a> (const char *tblName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#0facb0a5464913deb63bc12c294c5329">AddColumnToTable</a> (int tblHandle, int colType, const char *colName, int colSize, const char *colAttribs)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#1042693d7ae50f615b2e3304b7a3183c">AddColumnToTable</a> (const char *tblName, int colType, const char *colName, int colSize, const char *colAttribs)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#4c032fe2c389321630599b8b0316fd40">AddIndexToTable</a> (int tblHandle, int idxType, const char *idxName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#2da716dee57be3dbef9c7d564e867535">AddIndexToTable</a> (const char *tblName, int idxType, const char *idxName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#b737d7366e4f0aa798f8fa53eef3e850">AddColumnToIndex</a> (int tblHandle, int idxHandle, int colHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#26362766dba0f823918ccdaf44aa3470">AddColumnToIndex</a> (const char *tblName, const char *idxName, const char *colName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#339e3d7948f759c214cad00609aa4ba6">AddTriggerToTable</a> (int tblHandle, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#c1dc9051c7aeb28a16b621de87f462f1">AddTriggerToTable</a> (const char *tblName, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#e63e59eb47f6470225d862ae167f2c3b">GetPreambleHandleFromName</a> (const char *preName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#f06cd043610b6f786746fa765966e4c3">GetPreambleNameFromHandle</a> (int preHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#9b0da21b3a32e3bb5b378851ba89b22e">GetPreambleActionFromHandle</a> (int preHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#d0e64694674d1d0994b4b83f4d2d392f">GetPreambleBackendFromHandle</a> (int preHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#36c4e04dc4f6841b959ecdcd68afeee1">GetTableHandleFromName</a> (const char *tblName)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#785e15fb1596274795412da2b91842de">GetTableNameFromHandle</a> (int tblHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#952a92428b195e0ce7b53d41ccd7a0ff">Reset</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#f0a1bbe5c093292862eb8f3c886e9476">GetNumberOfPreambles</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#257dc1f0f324078b89a8bd568d180712">GetNumberOfTables</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#abeb94ec9d2e3938a5b57e78de16fbe8">GetNumberOfColumnsInTable</a> (int tblHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#3d0bb2cf35a704831999cd831f3a2682">GetNumberOfIndicesInTable</a> (int tblHandle)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#b069bca649419c2b40856525864277a2">GetNumberOfTriggersInTable</a> (int tblHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#e8c5147a20b5c26238565153e8093395">GetIndexHandleFromName</a> (const char *tblName, const char *idxName)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#0226ef4d1f04b5bef27f7f6669e76055">GetIndexNameFromHandle</a> (int tblHandle, int idxHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#4965841ab409c52bb4cd13fb9860ab9a">GetIndexTypeFromHandle</a> (int tblHandle, int idxHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#eb1ba000b813de479a83433a02dde00b">GetIndexColumnNameFromHandle</a> (int tblHandle, int idxHandle, int cnmHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#4c98dc17198e64b227e71ebba0ea1c97">GetColumnHandleFromName</a> (const char *tblName, const char *colName)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#a6c2d8aaeb1a1c461065a5de204667d3">GetColumnNameFromHandle</a> (int tblHandle, int colHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#c2f15e9124b6a3269163d0afa7b3f57b">GetColumnTypeFromHandle</a> (int tblHandle, int colHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#ece4b9fe6759c5566e4b0aec9c998396">GetColumnSizeFromHandle</a> (int tblHandle, int colHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#d60950525292694d0e60eb72d3e2fe55">GetColumnAttributesFromHandle</a> (int tblHandle, int colHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#8f5487cc9fc76776f99f65cdbecfdaaf">GetTriggerHandleFromName</a> (const char *tblName, const char *trgName)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#9dabb630781be029e6b53dae34b25d4e">GetTriggerNameFromHandle</a> (int tblHandle, int trgHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#6a8bdbc5c60d72abe35a73683dd25435">GetTriggerTypeFromHandle</a> (int tblHandle, int trgHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#aba4d31d92fcafca47edc6ec2231255b">GetTriggerActionFromHandle</a> (int tblHandle, int trgHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#b38e4a37c7346844ae090cca7f9551db">GetTriggerBackendFromHandle</a> (int tblHandle, int trgHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#2097d38fa78eba02813fecf72a2e0790">GetNumberOfColumnNamesInIndex</a> (int tblHandle, int idxHandle)</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#5e087257716c939e42387e352a788ed5">SetName</a> (const char *)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">virtual char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#857cb5c613c27f3446ace215d404a280">GetName</a> ()</td></tr> <tr><td colspan="2"><div class="groupHeader"></div></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#10b903c61d65207eb91700538c99c2e2">AddTableMultipleArguments</a> (const char *tblName,...)</td></tr> <tr><td colspan="2"><br><h2>Static Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">static int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#1f48c5141f4b3e78a17c3ee7e0298d00">IsTypeOf</a> (const char *type)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">static <a class="el" href="a01595.html">vtkSQLDatabaseSchema</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#2c5bd8219bffe52b888fb0a8815099ed">SafeDownCast</a> (<a class="el" href="a01084.html">vtkObject</a> *o)</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">static <a class="el" href="a01595.html">vtkSQLDatabaseSchema</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#88a97504b27568c8deb6cacaea82ca5c">New</a> ()</td></tr> <tr><td colspan="2"><br><h2>Protected Member Functions</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#2debad65ce3c6687978ce734deb8e95f">vtkSQLDatabaseSchema</a> ()</td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#3188b3e31a301de9c807faa6e7bdef6c">~vtkSQLDatabaseSchema</a> ()</td></tr> <tr><td colspan="2"><br><h2>Protected Attributes</h2></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#4643ba40182bf6664ff2bd4df070e0ba">Name</a></td></tr> <tr><td class="memItemLeft" nowrap align="right" valign="top">class <br> vtkSQLDatabaseSchemaInternals * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01595.html#210f757d3eec8064ad53d347852da9a7">Internals</a></td></tr> </table> <hr><h2>Member Typedef Documentation</h2> <a class="anchor" name="252b671542549ca8ae8df7ec6f0ef588"></a><!-- doxytag: member="vtkSQLDatabaseSchema::Superclass" ref="252b671542549ca8ae8df7ec6f0ef588" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">typedef <a class="el" href="a01084.html">vtkObject</a> <a class="el" href="a01084.html">vtkSQLDatabaseSchema::Superclass</a> </td> </tr> </table> </div> <div class="memdoc"> <p> <p>Reimplemented from <a class="el" href="a01084.html#11429dee69f4b562e03e07b453dae9b5">vtkObject</a>.</p> <p>Definition at line <a class="el" href="a04985.html#l00057">57</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <hr><h2>Member Enumeration Documentation</h2> <a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4"></a><!-- doxytag: member="vtkSQLDatabaseSchema::DatabaseColumnType" ref="3f2977f44ac8ff1d98a3a868735ed6a4" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">enum <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4">vtkSQLDatabaseSchema::DatabaseColumnType</a> </td> </tr> </table> </div> <div class="memdoc"> <p> Basic data types for database columns <dl compact><dt><b>Enumerator: </b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a41e6e3fff159856d240d8f6ca23f15908"></a><!-- doxytag: member="SERIAL" ref="3f2977f44ac8ff1d98a3a868735ed6a41e6e3fff159856d240d8f6ca23f15908" args="" -->SERIAL</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a425df9ef60e6338c1ba73d5dab7945f02"></a><!-- doxytag: member="SMALLINT" ref="3f2977f44ac8ff1d98a3a868735ed6a425df9ef60e6338c1ba73d5dab7945f02" args="" -->SMALLINT</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4a12f2be77e31d136b6cbb6067307f990"></a><!-- doxytag: member="INTEGER" ref="3f2977f44ac8ff1d98a3a868735ed6a4a12f2be77e31d136b6cbb6067307f990" args="" -->INTEGER</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a42415955434b81e14fa3ba58b433d1d40"></a><!-- doxytag: member="BIGINT" ref="3f2977f44ac8ff1d98a3a868735ed6a42415955434b81e14fa3ba58b433d1d40" args="" -->BIGINT</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a41fbcd08f887d7cda74eade0291088984"></a><!-- doxytag: member="VARCHAR" ref="3f2977f44ac8ff1d98a3a868735ed6a41fbcd08f887d7cda74eade0291088984" args="" -->VARCHAR</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4262d7be274f4d60dfc533e41a92bea2c"></a><!-- doxytag: member="TEXT" ref="3f2977f44ac8ff1d98a3a868735ed6a4262d7be274f4d60dfc533e41a92bea2c" args="" -->TEXT</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4137c659c186000bb2154415b10bf3715"></a><!-- doxytag: member="REAL" ref="3f2977f44ac8ff1d98a3a868735ed6a4137c659c186000bb2154415b10bf3715" args="" -->REAL</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4d08297a7c72a67ee66889adc7d253509"></a><!-- doxytag: member="DOUBLE" ref="3f2977f44ac8ff1d98a3a868735ed6a4d08297a7c72a67ee66889adc7d253509" args="" -->DOUBLE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4b25b73a9ae7b76f47a2c992db90743f1"></a><!-- doxytag: member="BLOB" ref="3f2977f44ac8ff1d98a3a868735ed6a4b25b73a9ae7b76f47a2c992db90743f1" args="" -->BLOB</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4076e4998bd8c46e3a8d52268a4de9c67"></a><!-- doxytag: member="TIME" ref="3f2977f44ac8ff1d98a3a868735ed6a4076e4998bd8c46e3a8d52268a4de9c67" args="" -->TIME</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a49a786401af764632e54e495e5d839e26"></a><!-- doxytag: member="DATE" ref="3f2977f44ac8ff1d98a3a868735ed6a49a786401af764632e54e495e5d839e26" args="" -->DATE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="3f2977f44ac8ff1d98a3a868735ed6a4a4bfd1b0a607ea79d2ed48ce5eb5bf65"></a><!-- doxytag: member="TIMESTAMP" ref="3f2977f44ac8ff1d98a3a868735ed6a4a4bfd1b0a607ea79d2ed48ce5eb5bf65" args="" -->TIMESTAMP</em> </td><td> </td></tr> </table> </dl> <p>Definition at line <a class="el" href="a04985.html#l00064">64</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="dc4546884c25550da09ab17f02246033"></a><!-- doxytag: member="vtkSQLDatabaseSchema::DatabaseIndexType" ref="dc4546884c25550da09ab17f02246033" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">enum <a class="el" href="a01595.html#dc4546884c25550da09ab17f02246033">vtkSQLDatabaseSchema::DatabaseIndexType</a> </td> </tr> </table> </div> <div class="memdoc"> <p> Types of indices that can be generated for database tables <dl compact><dt><b>Enumerator: </b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"><em><a class="anchor" name="dc4546884c25550da09ab17f0224603330cf0fecca1909158a4a83d2e28bafc1"></a><!-- doxytag: member="INDEX" ref="dc4546884c25550da09ab17f0224603330cf0fecca1909158a4a83d2e28bafc1" args="" -->INDEX</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="dc4546884c25550da09ab17f022460338973ff0e38aab19fb1cae87f313ceda6"></a><!-- doxytag: member="UNIQUE" ref="dc4546884c25550da09ab17f022460338973ff0e38aab19fb1cae87f313ceda6" args="" -->UNIQUE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="dc4546884c25550da09ab17f02246033923d89643977442392fa331249feb12e"></a><!-- doxytag: member="PRIMARY_KEY" ref="dc4546884c25550da09ab17f02246033923d89643977442392fa331249feb12e" args="" -->PRIMARY_KEY</em> </td><td> </td></tr> </table> </dl> <p>Definition at line <a class="el" href="a04985.html#l00083">83</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="fe1e52a59359e010c4306dbd8ebd1344"></a><!-- doxytag: member="vtkSQLDatabaseSchema::DatabaseTriggerType" ref="fe1e52a59359e010c4306dbd8ebd1344" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">enum <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344">vtkSQLDatabaseSchema::DatabaseTriggerType</a> </td> </tr> </table> </div> <div class="memdoc"> <p> Events where database triggers can be registered. <dl compact><dt><b>Enumerator: </b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd1344cd26e7f2a69debfa766947c87414a963"></a><!-- doxytag: member="BEFORE_INSERT" ref="fe1e52a59359e010c4306dbd8ebd1344cd26e7f2a69debfa766947c87414a963" args="" -->BEFORE_INSERT</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c"></a><!-- doxytag: member="AFTER_INSERT" ref="fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c" args="" -->AFTER_INSERT</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd134424c155daede3fa2e6902860a3dcc5c57"></a><!-- doxytag: member="BEFORE_UPDATE" ref="fe1e52a59359e010c4306dbd8ebd134424c155daede3fa2e6902860a3dcc5c57" args="" -->BEFORE_UPDATE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd134435cb4c26062b01838919c0e04aded6b1"></a><!-- doxytag: member="AFTER_UPDATE" ref="fe1e52a59359e010c4306dbd8ebd134435cb4c26062b01838919c0e04aded6b1" args="" -->AFTER_UPDATE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd1344aa44fd9b05e7c7173126cccd39f609ae"></a><!-- doxytag: member="BEFORE_DELETE" ref="fe1e52a59359e010c4306dbd8ebd1344aa44fd9b05e7c7173126cccd39f609ae" args="" -->BEFORE_DELETE</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="fe1e52a59359e010c4306dbd8ebd1344558f6aa090a7156d3e16a6d1e6f57ec6"></a><!-- doxytag: member="AFTER_DELETE" ref="fe1e52a59359e010c4306dbd8ebd1344558f6aa090a7156d3e16a6d1e6f57ec6" args="" -->AFTER_DELETE</em> </td><td> </td></tr> </table> </dl> <p>Definition at line <a class="el" href="a04985.html#l00093">93</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="d79bbabb492b86c252c57f11f255288c"></a><!-- doxytag: member="vtkSQLDatabaseSchema::VarargTokens" ref="d79bbabb492b86c252c57f11f255288c" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">enum <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c">vtkSQLDatabaseSchema::VarargTokens</a> </td> </tr> </table> </div> <div class="memdoc"> <p> <dl compact><dt><b>Enumerator: </b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9"></a><!-- doxytag: member="COLUMN_TOKEN" ref="d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9" args="" -->COLUMN_TOKEN</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288cea11c9743712e469a7c05a36118ca0a3"></a><!-- doxytag: member="INDEX_TOKEN" ref="d79bbabb492b86c252c57f11f255288cea11c9743712e469a7c05a36118ca0a3" args="" -->INDEX_TOKEN</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62"></a><!-- doxytag: member="INDEX_COLUMN_TOKEN" ref="d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62" args="" -->INDEX_COLUMN_TOKEN</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288c0169ea381fbeb08f96432a9c47083c97"></a><!-- doxytag: member="END_INDEX_TOKEN" ref="d79bbabb492b86c252c57f11f255288c0169ea381fbeb08f96432a9c47083c97" args="" -->END_INDEX_TOKEN</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d"></a><!-- doxytag: member="TRIGGER_TOKEN" ref="d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d" args="" -->TRIGGER_TOKEN</em> </td><td> </td></tr> <tr><td valign="top"><em><a class="anchor" name="d79bbabb492b86c252c57f11f255288c7f7c9dbb5d0e2e501ab740b7ee150d92"></a><!-- doxytag: member="END_TABLE_TOKEN" ref="d79bbabb492b86c252c57f11f255288c7f7c9dbb5d0e2e501ab740b7ee150d92" args="" -->END_TABLE_TOKEN</em> </td><td> </td></tr> </table> </dl> <p>Definition at line <a class="el" href="a04985.html#l00337">337</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <hr><h2>Constructor & Destructor Documentation</h2> <a class="anchor" name="2debad65ce3c6687978ce734deb8e95f"></a><!-- doxytag: member="vtkSQLDatabaseSchema::vtkSQLDatabaseSchema" ref="2debad65ce3c6687978ce734deb8e95f" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">vtkSQLDatabaseSchema::vtkSQLDatabaseSchema </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td><code> [protected]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <a class="anchor" name="3188b3e31a301de9c807faa6e7bdef6c"></a><!-- doxytag: member="vtkSQLDatabaseSchema::~vtkSQLDatabaseSchema" ref="3188b3e31a301de9c807faa6e7bdef6c" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">vtkSQLDatabaseSchema::~vtkSQLDatabaseSchema </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td><code> [protected]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <hr><h2>Member Function Documentation</h2> <a class="anchor" name="3586c7951a513a7f33c074518787651e"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetClassName" ref="3586c7951a513a7f33c074518787651e" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual const char* vtkSQLDatabaseSchema::GetClassName </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Reimplemented from <a class="el" href="a01084.html#d95975c85c2896ea32ff4cf1f8de0886">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="1f48c5141f4b3e78a17c3ee7e0298d00"></a><!-- doxytag: member="vtkSQLDatabaseSchema::IsTypeOf" ref="1f48c5141f4b3e78a17c3ee7e0298d00" args="(const char *type)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">static int vtkSQLDatabaseSchema::IsTypeOf </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>name</em> </td> <td> ) </td> <td><code> [static]</code></td> </tr> </table> </div> <div class="memdoc"> <p> 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. <p>Reimplemented from <a class="el" href="a01084.html#e9548a248bce0f02f73bbcccd0a9489e">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="700c3c1cd40104be5f5b169a83c704ec"></a><!-- doxytag: member="vtkSQLDatabaseSchema::IsA" ref="700c3c1cd40104be5f5b169a83c704ec" args="(const char *type)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::IsA </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>name</em> </td> <td> ) </td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> 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. <p>Reimplemented from <a class="el" href="a01084.html#831e57b04e46827a7098aa81abadee69">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="2c5bd8219bffe52b888fb0a8815099ed"></a><!-- doxytag: member="vtkSQLDatabaseSchema::SafeDownCast" ref="2c5bd8219bffe52b888fb0a8815099ed" args="(vtkObject *o)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">static <a class="el" href="a01595.html">vtkSQLDatabaseSchema</a>* vtkSQLDatabaseSchema::SafeDownCast </td> <td>(</td> <td class="paramtype"><a class="el" href="a01084.html">vtkObject</a> * </td> <td class="paramname"> <em>o</em> </td> <td> ) </td> <td><code> [static]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Reimplemented from <a class="el" href="a01084.html#bb9351f076544c427ee91229dce83abe">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="405f285b7eb369cd97902462e59e5ce5"></a><!-- doxytag: member="vtkSQLDatabaseSchema::PrintSelf" ref="405f285b7eb369cd97902462e59e5ce5" args="(ostream &os, vtkIndent indent)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void vtkSQLDatabaseSchema::PrintSelf </td> <td>(</td> <td class="paramtype">ostream & </td> <td class="paramname"> <em>os</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="a00869.html">vtkIndent</a> </td> <td class="paramname"> <em>indent</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> Methods invoked by print to print information about the object including superclasses. Typically not called by the user (use <a class="el" href="a01085.html#edadf6378465fd81c2592ef64262e2a5">Print()</a> instead) but used in the hierarchical print process to combine the output of several classes. <p>Reimplemented from <a class="el" href="a01084.html#bf3dbb4154289b56a12483eee3866263">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="88a97504b27568c8deb6cacaea82ca5c"></a><!-- doxytag: member="vtkSQLDatabaseSchema::New" ref="88a97504b27568c8deb6cacaea82ca5c" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">static <a class="el" href="a01595.html">vtkSQLDatabaseSchema</a>* vtkSQLDatabaseSchema::New </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td><code> [static]</code></td> </tr> </table> </div> <div class="memdoc"> <p> Create an object with Debug turned off, modified time initialized to zero, and reference counting on. <p>Reimplemented from <a class="el" href="a01084.html#4d5b227267c076d6f9e38483370b6612">vtkObject</a>.</p> </div> </div><p> <a class="anchor" name="97cc210215073cc0ae96901020d99fe9"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddPreamble" ref="97cc210215073cc0ae96901020d99fe9" args="(const char *preName, const char *preAction, const char *preBackend=VTK_SQL_ALLBACKENDS)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddPreamble </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>preName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>preAction</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>preBackend</em> = <code>VTK_SQL_ALLBACKENDS</code></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> 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 = <a class="el" href="a01595.html#88a97504b27568c8deb6cacaea82ca5c">vtkSQLDatabaseSchema::New()</a>; 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 ); </div> </div><p> <a class="anchor" name="2ef99216256d1954fb942b98de25f97e"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddTable" ref="2ef99216256d1954fb942b98de25f97e" args="(const char *tblName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddTable </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em> </td> <td> ) </td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> Add a table to the schema </div> </div><p> <a class="anchor" name="0facb0a5464913deb63bc12c294c5329"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddColumnToTable" ref="0facb0a5464913deb63bc12c294c5329" args="(int tblHandle, int colType, const char *colName, int colSize, const char *colAttribs)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddColumnToTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colSize</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colAttribs</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <a class="anchor" name="1042693d7ae50f615b2e3304b7a3183c"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddColumnToTable" ref="1042693d7ae50f615b2e3304b7a3183c" args="(const char *tblName, int colType, const char *colName, int colSize, const char *colAttribs)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddColumnToTable </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colSize</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colAttribs</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [inline, virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00130">130</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="4c032fe2c389321630599b8b0316fd40"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddIndexToTable" ref="4c032fe2c389321630599b8b0316fd40" args="(int tblHandle, int idxType, const char *idxName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddIndexToTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>idxName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <a class="anchor" name="2da716dee57be3dbef9c7d564e867535"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddIndexToTable" ref="2da716dee57be3dbef9c7d564e867535" args="(const char *tblName, int idxType, const char *idxName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddIndexToTable </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>idxName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [inline, virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00147">147</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="b737d7366e4f0aa798f8fa53eef3e850"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddColumnToIndex" ref="b737d7366e4f0aa798f8fa53eef3e850" args="(int tblHandle, int idxHandle, int colHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddColumnToIndex </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <a class="anchor" name="26362766dba0f823918ccdaf44aa3470"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddColumnToIndex" ref="26362766dba0f823918ccdaf44aa3470" args="(const char *tblName, const char *idxName, const char *colName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddColumnToIndex </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>idxName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [inline, virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00160">160</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="339e3d7948f759c214cad00609aa4ba6"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddTriggerToTable" ref="339e3d7948f759c214cad00609aa4ba6" args="(int tblHandle, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddTriggerToTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgAction</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgBackend</em> = <code>VTK_SQL_ALLBACKENDS</code></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> </div> </div><p> <a class="anchor" name="c1dc9051c7aeb28a16b621de87f462f1"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddTriggerToTable" ref="c1dc9051c7aeb28a16b621de87f462f1" args="(const char *tblName, int trgType, const char *trgName, const char *trgAction, const char *trgBackend=VTK_SQL_ALLBACKENDS)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual int vtkSQLDatabaseSchema::AddTriggerToTable </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgType</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgAction</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgBackend</em> = <code>VTK_SQL_ALLBACKENDS</code></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td><code> [inline, virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00176">176</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="e63e59eb47f6470225d862ae167f2c3b"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetPreambleHandleFromName" ref="e63e59eb47f6470225d862ae167f2c3b" args="(const char *preName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetPreambleHandleFromName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>preName</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a preamble name, get its handle. </div> </div><p> <a class="anchor" name="f06cd043610b6f786746fa765966e4c3"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetPreambleNameFromHandle" ref="f06cd043610b6f786746fa765966e4c3" args="(int preHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetPreambleNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>preHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a preamble handle, get its name. </div> </div><p> <a class="anchor" name="9b0da21b3a32e3bb5b378851ba89b22e"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetPreambleActionFromHandle" ref="9b0da21b3a32e3bb5b378851ba89b22e" args="(int preHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetPreambleActionFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>preHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a preamble handle, get its action. </div> </div><p> <a class="anchor" name="d0e64694674d1d0994b4b83f4d2d392f"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetPreambleBackendFromHandle" ref="d0e64694674d1d0994b4b83f4d2d392f" args="(int preHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetPreambleBackendFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>preHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a preamble handle, get its backend. </div> </div><p> <a class="anchor" name="36c4e04dc4f6841b959ecdcd68afeee1"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTableHandleFromName" ref="36c4e04dc4f6841b959ecdcd68afeee1" args="(const char *tblName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetTableHandleFromName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a table name, get its handle. </div> </div><p> <a class="anchor" name="785e15fb1596274795412da2b91842de"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTableNameFromHandle" ref="785e15fb1596274795412da2b91842de" args="(int tblHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetTableNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Given a table hanlde, get its name. </div> </div><p> <a class="anchor" name="e8c5147a20b5c26238565153e8093395"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetIndexHandleFromName" ref="e8c5147a20b5c26238565153e8093395" args="(const char *tblName, const char *idxName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetIndexHandleFromName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>idxName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the names of a table and an index, get the handle of the index in this table. </div> </div><p> <a class="anchor" name="0226ef4d1f04b5bef27f7f6669e76055"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetIndexNameFromHandle" ref="0226ef4d1f04b5bef27f7f6669e76055" args="(int tblHandle, int idxHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetIndexNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and an index, get the name of the index. </div> </div><p> <a class="anchor" name="4965841ab409c52bb4cd13fb9860ab9a"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetIndexTypeFromHandle" ref="4965841ab409c52bb4cd13fb9860ab9a" args="(int tblHandle, int idxHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetIndexTypeFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and an index, get the type of the index. </div> </div><p> <a class="anchor" name="eb1ba000b813de479a83433a02dde00b"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetIndexColumnNameFromHandle" ref="eb1ba000b813de479a83433a02dde00b" args="(int tblHandle, int idxHandle, int cnmHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetIndexColumnNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>cnmHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table, an index, and a column name, get the column name. </div> </div><p> <a class="anchor" name="4c98dc17198e64b227e71ebba0ea1c97"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetColumnHandleFromName" ref="4c98dc17198e64b227e71ebba0ea1c97" args="(const char *tblName, const char *colName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetColumnHandleFromName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>colName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the names of a table and a column, get the handle of the column in this table. </div> </div><p> <a class="anchor" name="a6c2d8aaeb1a1c461065a5de204667d3"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetColumnNameFromHandle" ref="a6c2d8aaeb1a1c461065a5de204667d3" args="(int tblHandle, int colHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetColumnNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a column, get the name of the column. </div> </div><p> <a class="anchor" name="c2f15e9124b6a3269163d0afa7b3f57b"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetColumnTypeFromHandle" ref="c2f15e9124b6a3269163d0afa7b3f57b" args="(int tblHandle, int colHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetColumnTypeFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a column, get the type of the column. </div> </div><p> <a class="anchor" name="ece4b9fe6759c5566e4b0aec9c998396"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetColumnSizeFromHandle" ref="ece4b9fe6759c5566e4b0aec9c998396" args="(int tblHandle, int colHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetColumnSizeFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a column, get the size of the column. </div> </div><p> <a class="anchor" name="d60950525292694d0e60eb72d3e2fe55"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetColumnAttributesFromHandle" ref="d60950525292694d0e60eb72d3e2fe55" args="(int tblHandle, int colHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetColumnAttributesFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>colHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a column, get the attributes of the column. </div> </div><p> <a class="anchor" name="8f5487cc9fc76776f99f65cdbecfdaaf"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTriggerHandleFromName" ref="8f5487cc9fc76776f99f65cdbecfdaaf" args="(const char *tblName, const char *trgName)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetTriggerHandleFromName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const char * </td> <td class="paramname"> <em>trgName</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the names of a trigger and a table, get the handle of the trigger in this table. </div> </div><p> <a class="anchor" name="9dabb630781be029e6b53dae34b25d4e"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTriggerNameFromHandle" ref="9dabb630781be029e6b53dae34b25d4e" args="(int tblHandle, int trgHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetTriggerNameFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a trigger, get the name of the trigger. </div> </div><p> <a class="anchor" name="6a8bdbc5c60d72abe35a73683dd25435"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTriggerTypeFromHandle" ref="6a8bdbc5c60d72abe35a73683dd25435" args="(int tblHandle, int trgHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetTriggerTypeFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a trigger, get the type of the trigger. </div> </div><p> <a class="anchor" name="aba4d31d92fcafca47edc6ec2231255b"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTriggerActionFromHandle" ref="aba4d31d92fcafca47edc6ec2231255b" args="(int tblHandle, int trgHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetTriggerActionFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a trigger, get the action of the trigger. </div> </div><p> <a class="anchor" name="b38e4a37c7346844ae090cca7f9551db"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetTriggerBackendFromHandle" ref="b38e4a37c7346844ae090cca7f9551db" args="(int tblHandle, int trgHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char* vtkSQLDatabaseSchema::GetTriggerBackendFromHandle </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>trgHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Given the handles of a table and a trigger, get the backend of the trigger. </div> </div><p> <a class="anchor" name="952a92428b195e0ce7b53d41ccd7a0ff"></a><!-- doxytag: member="vtkSQLDatabaseSchema::Reset" ref="952a92428b195e0ce7b53d41ccd7a0ff" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void vtkSQLDatabaseSchema::Reset </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Reset the schema to its initial, empty state. </div> </div><p> <a class="anchor" name="f0a1bbe5c093292862eb8f3c886e9476"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfPreambles" ref="f0a1bbe5c093292862eb8f3c886e9476" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfPreambles </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of preambles. </div> </div><p> <a class="anchor" name="257dc1f0f324078b89a8bd568d180712"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfTables" ref="257dc1f0f324078b89a8bd568d180712" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfTables </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of tables. </div> </div><p> <a class="anchor" name="abeb94ec9d2e3938a5b57e78de16fbe8"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfColumnsInTable" ref="abeb94ec9d2e3938a5b57e78de16fbe8" args="(int tblHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfColumnsInTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of columns in a particular table . </div> </div><p> <a class="anchor" name="3d0bb2cf35a704831999cd831f3a2682"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfIndicesInTable" ref="3d0bb2cf35a704831999cd831f3a2682" args="(int tblHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfIndicesInTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of indices in a particular table . </div> </div><p> <a class="anchor" name="2097d38fa78eba02813fecf72a2e0790"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfColumnNamesInIndex" ref="2097d38fa78eba02813fecf72a2e0790" args="(int tblHandle, int idxHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfColumnNamesInIndex </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"> <em>idxHandle</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of column names associated to a particular index in a particular table . </div> </div><p> <a class="anchor" name="b069bca649419c2b40856525864277a2"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetNumberOfTriggersInTable" ref="b069bca649419c2b40856525864277a2" args="(int tblHandle)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::GetNumberOfTriggersInTable </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"> <em>tblHandle</em> </td> <td> ) </td> <td></td> </tr> </table> </div> <div class="memdoc"> <p> Get the number of trigger in a particular table . </div> </div><p> <a class="anchor" name="5e087257716c939e42387e352a788ed5"></a><!-- doxytag: member="vtkSQLDatabaseSchema::SetName" ref="5e087257716c939e42387e352a788ed5" args="(const char *)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual void vtkSQLDatabaseSchema::SetName </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> </td> <td> ) </td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> Set/Get the name of the schema. </div> </div><p> <a class="anchor" name="857cb5c613c27f3446ace215d404a280"></a><!-- doxytag: member="vtkSQLDatabaseSchema::GetName" ref="857cb5c613c27f3446ace215d404a280" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual char* vtkSQLDatabaseSchema::GetName </td> <td>(</td> <td class="paramname"> </td> <td> ) </td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p> Set/Get the name of the schema. </div> </div><p> <a class="anchor" name="10b903c61d65207eb91700538c99c2e2"></a><!-- doxytag: member="vtkSQLDatabaseSchema::AddTableMultipleArguments" ref="10b903c61d65207eb91700538c99c2e2" args="(const char *tblName,...)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">int vtkSQLDatabaseSchema::AddTableMultipleArguments </td> <td>(</td> <td class="paramtype">const char * </td> <td class="paramname"> <em>tblName</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"> </td> <td class="paramname"> <em>...</em></td><td> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p> An unwrappable but useful routine to construct built-in schema. Example usage: int main() { vtkSQLDatabaseSchema* schema = <a class="el" href="a01595.html#88a97504b27568c8deb6cacaea82ca5c">vtkSQLDatabaseSchema::New()</a>; schema->SetName( "Example" ); schema->AddTableMultipleArguments( "atable", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9">vtkSQLDatabaseSchema::COLUMN_TOKEN</a>, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a4a12f2be77e31d136b6cbb6067307f990">vtkSQLDatabaseSchema::INTEGER</a>, "tablekey", 0, "", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9">vtkSQLDatabaseSchema::COLUMN_TOKEN</a>, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a41fbcd08f887d7cda74eade0291088984">vtkSQLDatabaseSchema::VARCHAR</a>, "somename", 11, "NOT NULL", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c8154741dfdf72645d685899dad8499e9">vtkSQLDatabaseSchema::COLUMN_TOKEN</a>, <a class="el" href="a01595.html#3f2977f44ac8ff1d98a3a868735ed6a42415955434b81e14fa3ba58b433d1d40">vtkSQLDatabaseSchema::BIGINT</a>, "somenmbr", 17, "DEFAULT 0", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288cea11c9743712e469a7c05a36118ca0a3">vtkSQLDatabaseSchema::INDEX_TOKEN</a>, <a class="el" href="a01595.html#dc4546884c25550da09ab17f02246033923d89643977442392fa331249feb12e">vtkSQLDatabaseSchema::PRIMARY_KEY</a>, "bigkey", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62">vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN</a>, "tablekey", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c0169ea381fbeb08f96432a9c47083c97">vtkSQLDatabaseSchema::END_INDEX_TOKEN</a>, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288cea11c9743712e469a7c05a36118ca0a3">vtkSQLDatabaseSchema::INDEX_TOKEN</a>, <a class="el" href="a01595.html#dc4546884c25550da09ab17f022460338973ff0e38aab19fb1cae87f313ceda6">vtkSQLDatabaseSchema::UNIQUE</a>, "reverselookup", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62">vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN</a>, "somename", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c25be362836c38181ba8ae011c5233b62">vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN</a>, "somenmbr", <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c0169ea381fbeb08f96432a9c47083c97">vtkSQLDatabaseSchema::END_INDEX_TOKEN</a>, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d">vtkSQLDatabaseSchema::TRIGGER_TOKEN</a>, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c">vtkSQLDatabaseSchema::AFTER_INSERT</a>, "InsertTrigger", "DO NOTHING", VTK_SQL_SQLITE, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d">vtkSQLDatabaseSchema::TRIGGER_TOKEN</a>, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c">vtkSQLDatabaseSchema::AFTER_INSERT</a>, "InsertTrigger", "FOR EACH ROW EXECUTE PROCEDURE somefunction ()", VTK_SQL_POSTGRESQL, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c947a3fcdadaaf6ad6492b9ce1697cd9d">vtkSQLDatabaseSchema::TRIGGER_TOKEN</a>, <a class="el" href="a01595.html#fe1e52a59359e010c4306dbd8ebd1344893f70e4a6087d688e89feb01829292c">vtkSQLDatabaseSchema::AFTER_INSERT</a>, "InsertTrigger", "FOR EACH ROW INSERT INTO btable SET SomeValue = NEW.SomeNmbr", VTK_SQL_MYSQL, <a class="el" href="a01595.html#d79bbabb492b86c252c57f11f255288c7f7c9dbb5d0e2e501ab740b7ee150d92">vtkSQLDatabaseSchema::END_TABLE_TOKEN</a> ); return 0; } </div> </div><p> <hr><h2>Member Data Documentation</h2> <a class="anchor" name="4643ba40182bf6664ff2bd4df070e0ba"></a><!-- doxytag: member="vtkSQLDatabaseSchema::Name" ref="4643ba40182bf6664ff2bd4df070e0ba" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">char* <a class="el" href="a01595.html#4643ba40182bf6664ff2bd4df070e0ba">vtkSQLDatabaseSchema::Name</a><code> [protected]</code> </td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00381">381</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <a class="anchor" name="210f757d3eec8064ad53d347852da9a7"></a><!-- doxytag: member="vtkSQLDatabaseSchema::Internals" ref="210f757d3eec8064ad53d347852da9a7" args="" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">class vtkSQLDatabaseSchemaInternals* <a class="el" href="a01595.html#210f757d3eec8064ad53d347852da9a7">vtkSQLDatabaseSchema::Internals</a><code> [protected]</code> </td> </tr> </table> </div> <div class="memdoc"> <p> <p>Definition at line <a class="el" href="a04985.html#l00383">383</a> of file <a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a>.</p> </div> </div><p> <hr>The documentation for this class was generated from the following file:<ul> <li>dox/IO/<a class="el" href="a04985.html">vtkSQLDatabaseSchema.h</a></ul> </div> <hr size="1"><address style="text-align: right;"><small>Generated on Wed Jun 3 19:36:07 2009 for VTK by <a href="http://www.doxygen.org/index.html"> <img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.6 </small></address> </body> </html>