Function TestSQLiteDatabase

IO/SQL/Testing/Cxx/TestSQLiteDatabase.cxx:23–399

#include <iostream>

int TestSQLiteDatabase(int /*argc*/, char* /*argv*/[])
{
  bool status;

  std::cerr << ">>>>> Testing bad input." << std::endl;

  vtkSQLDatabase* db0 = vtkSQLDatabase::CreateFromURL(nullptr);
  if (db0)
  {
    std::cerr << "ERROR: Created a database from a nullptr URL! How?" << std::endl;
    db0->Delete();
    return 1;
  }

  std::cerr << ">>>>> Testing creation modes." << std::endl;

  vtkSmartPointer<vtkTest::ErrorObserver> errorObserver =
    vtkSmartPointer<vtkTest::ErrorObserver>::New();
  vtkSmartPointer<vtkTest::ErrorObserver> queryObserver =
    vtkSmartPointer<vtkTest::ErrorObserver>::New();

  vtkSQLiteDatabase* db1 =
    vtkSQLiteDatabase::SafeDownCast(vtkSQLDatabase::CreateFromURL("sqlite://local.db"));

  status = db1->Open("", vtkSQLiteDatabase::CREATE_OR_CLEAR);
  vtkSQLQuery* query1 = db1->GetQueryInstance();
  query1->SetQuery("CREATE TABLE test (id INTEGER)");
  if (!query1->Execute())
  {
    std::cerr << "Create query failed" << std::endl;
    return 1;
  }
  if (!status)
  {
    std::cerr << "Couldn't open database using CREATE_OR_CLEAR.\n";
    return 1;
  }
  db1->Delete();
  query1->Delete();

  vtkSQLiteDatabase* db2 =
    vtkSQLiteDatabase::SafeDownCast(vtkSQLDatabase::CreateFromURL("sqlite://local.db"));
  db2->AddObserver(vtkCommand::ErrorEvent, errorObserver);
  status = db2->Open("", vtkSQLiteDatabase::CREATE);
  if (status)
  {
    std::cerr << "Using CREATE on an existing file should have failed but did not.\n";
    return 1;
  }
  int status1 =
    errorObserver->CheckErrorMessage("You specified creating a database but the file exists");
  if (status1 != 0)
  {
    std::cerr << "Expected error message not found.\n";
    return 1;
  }
  db2->Delete();