vtkPostgreSQLDatabase.h

Go to the documentation of this file.

// SPDX-FileCopyrightText: Copyright (c) Ken Martin, Will Schroeder, Bill Lorensen
// SPDX-FileCopyrightText: Copyright 2008 Sandia Corporation
// SPDX-License-Identifier: LicenseRef-BSD-3-Clause-Sandia-USGov
#ifndef vtkPostgreSQLDatabase_h
#define vtkPostgreSQLDatabase_h

#include "vtkIOPostgreSQLModule.h" // For export macro
#include "vtkSQLDatabase.h"

VTK_ABI_NAMESPACE_BEGIN
class vtkPostgreSQLQuery;
class vtkStringArray;
class vtkPostgreSQLDatabasePrivate;
struct PQconn;

class VTKIOPOSTGRESQL_EXPORT vtkPostgreSQLDatabase : public vtkSQLDatabase
{

  friend class vtkPostgreSQLQuery;
  friend class vtkPostgreSQLQueryPrivate;

public:
  vtkTypeMacro(vtkPostgreSQLDatabase, vtkSQLDatabase);
  void PrintSelf(ostream& os, vtkIndent indent) override;
  static vtkPostgreSQLDatabase* New();

  bool Open(const char* password = nullptr) override;

  void Close() override;

  bool IsOpen() override;

  vtkSQLQuery* GetQueryInstance() override;

  bool HasError() override;

  const char* GetLastErrorText() override;


  const char* GetDatabaseType() override { return this->DatabaseType; }


  virtual void SetHostName(const char*);
  vtkGetStringMacro(HostName);


  virtual void SetUser(const char*);
  vtkGetStringMacro(User);

  virtual void SetPassword(const char*);


  virtual void SetDatabaseName(const char*);
  vtkGetStringMacro(DatabaseName);


  virtual void SetConnectOptions(const char*);
  vtkGetStringMacro(ConnectOptions);


  virtual void SetServerPort(int);
  virtual int GetServerPortMinValue() { return 0; }
  virtual int GetServerPortMaxValue() { return VTK_INT_MAX; }
  vtkGetMacro(ServerPort, int);

  vtkStdString GetURL() override;

  vtkStringArray* GetTables() override;

  vtkStringArray* GetRecord(const char* table) override;

  bool IsSupported(int feature) override;

  vtkStringArray* GetDatabases();

  bool CreateDatabase(const char* dbName, bool dropExisting = false);

  bool DropDatabase(const char* dbName);

  vtkStdString GetColumnSpecification(
    vtkSQLDatabaseSchema* schema, int tblHandle, int colHandle) override;

  bool ParseURL(const char* url) override;

protected:
  vtkPostgreSQLDatabase();
  ~vtkPostgreSQLDatabase() override;

  void UpdateDataTypeMap();

  vtkSetStringMacro(DatabaseType);
  vtkSetStringMacro(LastErrorText);
  void NullTrailingWhitespace(char* msg);
  bool OpenInternal(const char* connectionOptions);

  vtkTimeStamp URLMTime;
  vtkPostgreSQLDatabasePrivate* Connection;
  vtkTimeStamp ConnectionMTime;
  vtkStringArray* Tables;
  char* DatabaseType;
  char* HostName;
  char* User;
  char* Password;
  char* DatabaseName;
  int ServerPort;
  char* ConnectOptions;
  char* LastErrorText;

private:
  vtkPostgreSQLDatabase(const vtkPostgreSQLDatabase&) = delete;
  void operator=(const vtkPostgreSQLDatabase&) = delete;
};

// This is basically the body of the SetStringMacro but with a
// call to update an additional vtkTimeStamp. We inline the implementation
// so that wrapping will work.
#define vtkSetStringPlusMTimeMacro(className, name, timeStamp)                                     \
  inline void className::Set##name(const char* _arg)                                               \
  {                                                                                                \
    vtkDebugMacro(<< this->GetClassName() << " (" << this << "): setting " << #name " to "         \
                  << (_arg ? _arg : "(null)"));                                                    \
    if (this->name == nullptr && _arg == nullptr)                                                  \
    {                                                                                              \
      return;                                                                                      \
    }                                                                                              \
    if (this->name && _arg && (!strcmp(this->name, _arg)))                                         \
    {                                                                                              \
      return;                                                                                      \
    }                                                                                              \
    delete[] this->name;                                                                           \
    if (_arg)                                                                                      \
    {                                                                                              \
      size_t n = strlen(_arg) + 1;                                                                 \
      char* cp1 = new char[n];                                                                     \
      const char* cp2 = (_arg);                                                                    \
      this->name = cp1;                                                                            \
      do                                                                                           \
      {                                                                                            \
        *cp1++ = *cp2++;                                                                           \
      } while (--n);                                                                               \
    }                                                                                              \
    else                                                                                           \
    {                                                                                              \
      this->name = nullptr;                                                                        \
    }                                                                                              \
    this->Modified();                                                                              \
    this->timeStamp.Modified();                                                                    \
    this->Close(); /* Force a re-open on next query */                                             \
  }

vtkSetStringPlusMTimeMacro(vtkPostgreSQLDatabase, HostName, URLMTime);
vtkSetStringPlusMTimeMacro(vtkPostgreSQLDatabase, User, URLMTime);
vtkSetStringPlusMTimeMacro(vtkPostgreSQLDatabase, Password, URLMTime);
vtkSetStringPlusMTimeMacro(vtkPostgreSQLDatabase, DatabaseName, URLMTime);
vtkSetStringPlusMTimeMacro(vtkPostgreSQLDatabase, ConnectOptions, URLMTime);

inline void vtkPostgreSQLDatabase::SetServerPort(int _arg)
{
  vtkDebugMacro(<< this->GetClassName() << " (" << this << "): setting ServerPort to " << _arg);
  _arg = std::min(std::max(_arg, 0), VTK_INT_MAX);
  if (this->ServerPort != _arg)
  {
    this->ServerPort = _arg;
    this->Modified();
    this->URLMTime.Modified();
    this->Close(); // Force a re-open on next query
  }
}

VTK_ABI_NAMESPACE_END
#endif // vtkPostgreSQLDatabase_h