VTK  9.0.1
vtkPostgreSQLDatabase.h
Go to the documentation of this file.
1 /* -*- Mode: C++; -*- */
2 /*=========================================================================
3 
4  Program: Visualization Toolkit
5  Module: vtkPostgreSQLDatabase.h
6 
7  Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
8  All rights reserved.
9  See Copyright.txt or http://www.kitware.com/Copyright.htm for details.
10 
11  This software is distributed WITHOUT ANY WARRANTY; without even
12  the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
13  PURPOSE. See the above copyright notice for more information.
14 
15 =========================================================================*/
16 /*-------------------------------------------------------------------------
17  Copyright 2008 Sandia Corporation.
18  Under the terms of Contract DE-AC04-94AL85000 with Sandia Corporation,
19  the U.S. Government retains certain rights in this software.
20 -------------------------------------------------------------------------*/
46 #ifndef vtkPostgreSQLDatabase_h
47 #define vtkPostgreSQLDatabase_h
48 
49 #include "vtkIOPostgreSQLModule.h" // For export macro
50 #include "vtkSQLDatabase.h"
51 
52 class vtkPostgreSQLQuery;
53 class vtkStringArray;
55 struct PQconn;
56 
57 class VTKIOPOSTGRESQL_EXPORT vtkPostgreSQLDatabase : public vtkSQLDatabase
58 {
59 
60  friend class vtkPostgreSQLQuery;
61  friend class vtkPostgreSQLQueryPrivate;
62 
63 public:
65  void PrintSelf(ostream& os, vtkIndent indent) override;
67 
73  bool Open(const char* password = 0) override;
74 
78  void Close() override;
79 
83  bool IsOpen() override;
84 
89 
93  virtual bool HasError() override;
94 
98  const char* GetLastErrorText() override;
99 
101 
104  const char* GetDatabaseType() override { return this->DatabaseType; }
106 
108 
111  virtual void SetHostName(const char*);
112  vtkGetStringMacro(HostName);
114 
116 
119  virtual void SetUser(const char*);
120  vtkGetStringMacro(User);
122 
126  virtual void SetPassword(const char*);
127 
129 
132  virtual void SetDatabaseName(const char*);
133  vtkGetStringMacro(DatabaseName);
135 
137 
140  virtual void SetConnectOptions(const char*);
141  vtkGetStringMacro(ConnectOptions);
143 
145 
148  virtual void SetServerPort(int);
149  virtual int GetServerPortMinValue() { return 0; }
150  virtual int GetServerPortMaxValue() { return VTK_INT_MAX; }
151  vtkGetMacro(ServerPort, int);
153 
160  vtkStdString GetURL() override;
161 
166 
170  vtkStringArray* GetRecord(const char* table) override;
171 
175  bool IsSupported(int feature) override;
176 
181 
186  bool CreateDatabase(const char* dbName, bool dropExisting = false);
187 
192  bool DropDatabase(const char* dbName);
193 
201  vtkSQLDatabaseSchema* schema, int tblHandle, int colHandle) override;
202 
208  bool ParseURL(const char* url) override;
209 
210 protected:
213 
229 
230  vtkSetStringMacro(DatabaseType);
231  vtkSetStringMacro(LastErrorText);
232  void NullTrailingWhitespace(char* msg);
233  bool OpenInternal(const char* connectionOptions);
234 
240  char* HostName;
241  char* User;
242  char* Password;
247 
248 private:
250  void operator=(const vtkPostgreSQLDatabase&) = delete;
251 };
252 
253 // This is basically the body of the SetStringMacro but with a
254 // call to update an additional vtkTimeStamp. We inline the implementation
255 // so that wrapping will work.
256 #define vtkSetStringPlusMTimeMacro(className, name, timeStamp) \
257  inline void className::Set##name(const char* _arg) \
258  { \
259  vtkDebugMacro(<< this->GetClassName() << " (" << this << "): setting " << #name " to " \
260  << (_arg ? _arg : "(null)")); \
261  if (this->name == nullptr && _arg == nullptr) \
262  { \
263  return; \
264  } \
265  if (this->name && _arg && (!strcmp(this->name, _arg))) \
266  { \
267  return; \
268  } \
269  delete[] this->name; \
270  if (_arg) \
271  { \
272  size_t n = strlen(_arg) + 1; \
273  char* cp1 = new char[n]; \
274  const char* cp2 = (_arg); \
275  this->name = cp1; \
276  do \
277  { \
278  *cp1++ = *cp2++; \
279  } while (--n); \
280  } \
281  else \
282  { \
283  this->name = nullptr; \
284  } \
285  this->Modified(); \
286  this->timeStamp.Modified(); \
287  this->Close(); /* Force a re-open on next query */ \
288  }
289 
295 
297 {
298  vtkDebugMacro(<< this->GetClassName() << " (" << this << "): setting ServerPort to " << _arg);
299  if (this->ServerPort != (_arg < 0 ? 0 : (_arg > VTK_INT_MAX ? VTK_INT_MAX : _arg)))
300  {
301  this->ServerPort = (_arg < 0 ? 0 : (_arg > VTK_INT_MAX ? VTK_INT_MAX : _arg));
302  this->Modified();
303  this->URLMTime.Modified();
304  this->Close(); // Force a re-open on next query
305  }
306 }
307 
308 #endif // vtkPostgreSQLDatabase_h
vtkPostgreSQLDatabase::Password
char * Password
Definition: vtkPostgreSQLDatabase.h:242
vtkPostgreSQLDatabasePrivate
internal details of a connection to a PostgreSQL database
Definition: vtkPostgreSQLDatabasePrivate.h:47
vtkPostgreSQLDatabase::HasError
virtual bool HasError() override
Did the last operation generate an error.
vtkPostgreSQLDatabase::New
static vtkPostgreSQLDatabase * New()
VTK_INT_MAX
#define VTK_INT_MAX
Definition: vtkType.h:155
vtkPostgreSQLDatabase::HostName
char * HostName
Definition: vtkPostgreSQLDatabase.h:240
vtkPostgreSQLDatabase::ParseURL
bool ParseURL(const char *url) override
Overridden to determine connection parameters given the URL.
vtkPostgreSQLDatabase::GetQueryInstance
vtkSQLQuery * GetQueryInstance() override
Return an empty query on this database.
vtkPostgreSQLDatabase::SetPassword
virtual void SetPassword(const char *)
The user's password for connecting to the database server.
vtkPostgreSQLDatabase::GetServerPortMinValue
virtual int GetServerPortMinValue()
Definition: vtkPostgreSQLDatabase.h:149
vtkPostgreSQLDatabase::GetURL
vtkStdString GetURL() override
Get a URL referencing the current database connection.
vtkTimeStamp
record modification and/or execution time
Definition: vtkTimeStamp.h:33
vtkObject::Modified
virtual void Modified()
Update the modification time for this object.
vtkPostgreSQLDatabase
maintain a connection to a PostgreSQL database
Definition: vtkPostgreSQLDatabase.h:58
vtkPostgreSQLDatabase::PrintSelf
void PrintSelf(ostream &os, vtkIndent indent) override
Methods invoked by print to print information about the object including superclasses.
vtkPostgreSQLDatabase::DatabaseType
char * DatabaseType
Definition: vtkPostgreSQLDatabase.h:239
vtkPostgreSQLDatabase::URLMTime
vtkTimeStamp URLMTime
Definition: vtkPostgreSQLDatabase.h:235
vtkPostgreSQLDatabase::ServerPort
int ServerPort
Definition: vtkPostgreSQLDatabase.h:244
vtkPostgreSQLDatabase::OpenInternal
bool OpenInternal(const char *connectionOptions)
vtkPostgreSQLDatabase::GetLastErrorText
const char * GetLastErrorText() override
Get the last error text from the database.
vtkPostgreSQLDatabase::Connection
vtkPostgreSQLDatabasePrivate * Connection
Definition: vtkPostgreSQLDatabase.h:236
vtkSQLDatabase.h
vtkPostgreSQLDatabase::SetServerPort
virtual void SetServerPort(int)
The port used for connecting to the database.
Definition: vtkPostgreSQLDatabase.h:296
vtkPostgreSQLDatabase::User
char * User
Definition: vtkPostgreSQLDatabase.h:241
vtkPostgreSQLDatabase::Tables
vtkStringArray * Tables
Definition: vtkPostgreSQLDatabase.h:238
vtkPostgreSQLDatabase::ConnectOptions
char * ConnectOptions
Definition: vtkPostgreSQLDatabase.h:245
vtkPostgreSQLDatabase::Open
bool Open(const char *password=0) override
Open a new connection to the database.
vtkObjectBase::GetClassName
const char * GetClassName() const
Return the class name as a string.
vtkPostgreSQLDatabase::SetConnectOptions
virtual void SetConnectOptions(const char *)
Additional options for the database.
vtkTimeStamp::Modified
void Modified()
Set this objects time to the current time.
vtkPostgreSQLDatabase::vtkPostgreSQLDatabase
vtkPostgreSQLDatabase()
vtkPostgreSQLDatabase::ConnectionMTime
vtkTimeStamp ConnectionMTime
Definition: vtkPostgreSQLDatabase.h:237
vtkPostgreSQLDatabase::CreateDatabase
bool CreateDatabase(const char *dbName, bool dropExisting=false)
Create a new database, optionally dropping any existing database of the same name.
vtkIndent
a simple class to control print indentation
Definition: vtkIndent.h:34
vtkPostgreSQLQuery
vtkSQLQuery implementation for PostgreSQL databases
Definition: vtkPostgreSQLQuery.h:51
vtkPostgreSQLDatabase::Close
void Close() override
Close the connection to the database.
vtkPostgreSQLDatabase::GetDatabases
vtkStringArray * GetDatabases()
Return a list of databases on the server.
vtkPostgreSQLDatabase::GetServerPortMaxValue
virtual int GetServerPortMaxValue()
Definition: vtkPostgreSQLDatabase.h:150
vtkPostgreSQLDatabase::NullTrailingWhitespace
void NullTrailingWhitespace(char *msg)
vtkX3D::url
@ url
Definition: vtkX3D.h:239
vtkPostgreSQLDatabase::~vtkPostgreSQLDatabase
~vtkPostgreSQLDatabase() override
vtkPostgreSQLDatabase::IsOpen
bool IsOpen() override
Return whether the database has an open connection.
vtkSQLDatabaseSchema
represent an SQL database schema
Definition: vtkSQLDatabaseSchema.h:62
vtkPostgreSQLDatabase::IsSupported
bool IsSupported(int feature) override
Return whether a feature is supported by the database.
vtkPostgreSQLDatabase::UpdateDataTypeMap
void UpdateDataTypeMap()
Create or refresh the map from Postgres column types to VTK array types.
vtkPostgreSQLDatabase::LastErrorText
char * LastErrorText
Definition: vtkPostgreSQLDatabase.h:246
vtkPostgreSQLDatabase::GetRecord
vtkStringArray * GetRecord(const char *table) override
Get the list of fields for a particular table.
vtkStringArray
a vtkAbstractArray subclass for strings
Definition: vtkStringArray.h:37
vtkPostgreSQLDatabase::DropDatabase
bool DropDatabase(const char *dbName)
Drop a database if it exists.
vtkPostgreSQLDatabase::GetDatabaseType
const char * GetDatabaseType() override
String representing database type (e.g.
Definition: vtkPostgreSQLDatabase.h:104
vtkSetStringPlusMTimeMacro
#define vtkSetStringPlusMTimeMacro(className, name, timeStamp)
Definition: vtkPostgreSQLDatabase.h:256
vtkStdString
Wrapper around std::string to keep symbols short.
Definition: vtkStdString.h:35
vtkPostgreSQLDatabase::SetDatabaseName
virtual void SetDatabaseName(const char *)
The name of the database to connect to.
vtkPostgreSQLDatabase::SetUser
virtual void SetUser(const char *)
The user name for connecting to the database server.
vtkSQLQuery
executes an sql query and retrieves results
Definition: vtkSQLQuery.h:69
vtkPostgreSQLDatabase::GetTables
vtkStringArray * GetTables() override
Get the list of tables from the database.
vtkPostgreSQLDatabase::DatabaseName
char * DatabaseName
Definition: vtkPostgreSQLDatabase.h:243
vtkPostgreSQLDatabase::SetHostName
virtual void SetHostName(const char *)
The database server host name.
vtkPostgreSQLDatabase::GetColumnSpecification
vtkStdString GetColumnSpecification(vtkSQLDatabaseSchema *schema, int tblHandle, int colHandle) override
Return the SQL string with the syntax to create a column inside a "CREATE TABLE" SQL statement.
vtkSQLDatabase
maintain a connection to an sql database
Definition: vtkSQLDatabase.h:85