Method GetRecord

IO/PostgreSQL/vtkPostgreSQLDatabase.cxx:430–467

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

//------------------------------------------------------------------------------
vtkStringArray* vtkPostgreSQLDatabase::GetRecord(const char* table)
{
  // NB: There are *too many* other column names to list. Even the ones
  // currently in the query below are probably over the top. But there's
  // just so much peanut-buttery goodness in the table, I couldn't resist.
  vtkSQLQuery* query = this->GetQueryInstance();
  std::string text("SELECT "
                   "column_name,column_default,data_type,is_nullable,character_maximum_length,"
                   "numeric_precision,datetime_precision"
                   "  FROM information_schema.columns"
                   "  WHERE table_name='");
  text += table;
  text += "' ORDER BY ordinal_position";

  query->SetQuery(text.c_str());
  bool status = query->Execute();
  if (!status)
  {
    vtkErrorMacro(<< "GetRecord(" << table
                  << "): Database returned error: " << query->GetLastErrorText());
    this->SetLastErrorText(query->GetLastErrorText());
    query->Delete();
    return nullptr;
  }

  // Each row in the results that come back from this query
  // describes a single column in the table.
  vtkStringArray* results = vtkStringArray::New();

  while (query->NextRow())
  {
    results->InsertNextValue(query->DataValue(0).ToString());
  }

  query->Delete();
  this->SetLastErrorText(nullptr);
  return results;
}

//------------------------------------------------------------------------------
bool vtkPostgreSQLDatabase::IsSupported(int feature)