1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
/*=========================================================================
Program: Visualization Toolkit
Module: DatabaseSchemaWith2Tables.cxx
Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
All rights reserved.
See Copyright.txt or http://www.kitware.com/Copyright.htm for details.
This software is distributed WITHOUT ANY WARRANTY; without even
the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
PURPOSE. See the above copyright notice for more information.
=========================================================================*/
/*----------------------------------------------------------------------------
Copyright (c) Sandia Corporation
See Copyright.txt or http://www.paraview.org/HTML/Copyright.html for details.
----------------------------------------------------------------------------*/
// .SECTION Thanks
// Thanks to Philippe Pebay from Sandia National Laboratories for implementing
// this example of a database schema.
cerr << "@@ Creating a schema...";
vtkSQLDatabaseSchema* schema = vtkSQLDatabaseSchema::New();
schema->SetName( "TestSchema" );
// Create PostgreSQL-specific preambles to load the PL/PGSQL language and create a function
// with this language. These will be ignored by other backends.
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 );
// Insert in alphabetical order so that SHOW TABLES does not mix handles
int tblHandle = schema->AddTableMultipleArguments( "atable",
vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::SERIAL, "tablekey", 0, "",
vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::VARCHAR, "somename", 64, "NOT NULL",
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
);
tblHandle = schema->AddTableMultipleArguments( "btable",
vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::SERIAL, "tablekey", 0, "",
vtkSQLDatabaseSchema::COLUMN_TOKEN, vtkSQLDatabaseSchema::BIGINT, "somevalue", 12, "DEFAULT 0",
vtkSQLDatabaseSchema::INDEX_TOKEN, vtkSQLDatabaseSchema::PRIMARY_KEY, "",
vtkSQLDatabaseSchema::INDEX_COLUMN_TOKEN, "tablekey",
vtkSQLDatabaseSchema::END_INDEX_TOKEN,
vtkSQLDatabaseSchema::END_TABLE_TOKEN
);
if ( tblHandle < 0 )
{
cerr << "Could not create test schema.\n";
schema->Delete();
return 1;
}
cerr << " done." << endl;
|
