Function TestMySQLDatabase

IO/MySQL/Testing/Cxx/TestMySQLDatabase.cxx:37–546

#include <iostream>

int TestMySQLDatabase(int, char** const)
{
  vtkMySQLDatabase* db =
    vtkMySQLDatabase::SafeDownCast(vtkSQLDatabase::CreateFromURL(VTK_MYSQL_TEST_URL));

  // Temp code to for linkage ...
  vtkMySQLDatabase* tmp = vtkMySQLDatabase::New();

  bool status = db->Open("vtktest");

  if (!status)
  {
    std::cerr << "Couldn't open database.\n";
    return 1;
  }

  vtkSQLQuery* query = db->GetQueryInstance();
  std::string createQuery(
    "CREATE TABLE IF NOT EXISTS people (name TEXT, age INTEGER, weight FLOAT)");
  std::cout << createQuery << std::endl;
  query->SetQuery(createQuery.c_str());
  if (!query->Execute())
  {
    std::cerr << "Create query failed" << std::endl;
    return 1;
  }

  for (int i = 0; i < 40; ++i)
  {
    auto insertQuery =
      vtk::format("INSERT INTO people VALUES('John Doe {:d}', {:d}, {:d})", i, i, 10 * i);
    std::cout << insertQuery << std::endl;
    query->SetQuery(insertQuery);
    if (!query->Execute())
    {
      std::cerr << "Insert query " << i << " failed" << std::endl;
      return 1;
    }
  }

  const char* queryText = "SELECT name, age, weight FROM people WHERE age <= 20";
  query->SetQuery(queryText);
  std::cerr << std::endl << "Running query: " << query->GetQuery() << std::endl;

  std::cerr << std::endl << "Using vtkSQLQuery directly to execute query:" << std::endl;
  if (!query->Execute())
  {
    std::cerr << "Query failed" << std::endl;
    return 1;
  }

  for (int col = 0; col < query->GetNumberOfFields(); ++col)
  {
    if (col > 0)
    {
      std::cerr << ", ";
    }
    std::cerr << query->GetFieldName(col);