Method BeginTransaction

IO/PostgreSQL/vtkPostgreSQLQuery.cxx:440–480

------------------------------------------------------------------------------

//------------------------------------------------------------------------------
bool vtkPostgreSQLQuery::BeginTransaction()
{
  if (this->TransactionInProgress)
  {
    vtkErrorMacro(<< "Cannot start a transaction.  One is already in progress.");
    return false;
  }

  vtkPostgreSQLDatabase* db = vtkPostgreSQLDatabase::SafeDownCast(this->Database);
  assert(db);
  bool status;
  PGresult* result = PQexec(db->Connection->Connection, BEGIN_TRANSACTION);
  switch (PQresultStatus(result))
  {
    case PGRES_COMMAND_OK:
    {
      this->SetLastErrorText(nullptr);
      this->TransactionInProgress = true;
      status = true;
    };
    break;
    case PGRES_FATAL_ERROR:
    {
      this->SetLastErrorText(PQresultErrorMessage(result));
      vtkErrorMacro(<< "Error in BeginTransaction: " << this->GetLastErrorText());
      status = false;
    };
    break;
    default:
    {
      this->SetLastErrorText(PQresultErrorMessage(result));
      vtkWarningMacro(<< "Unexpected return code " << PQresultStatus(result) << " ("
                      << PQresStatus(PQresultStatus(result)) << ") with error message "
                      << (this->LastErrorText ? this->LastErrorText : "(null)"));
      status = false;
    };
    break;
  }
  PQclear(result);
  return status;
}

//------------------------------------------------------------------------------
bool vtkPostgreSQLQuery::CommitTransaction()