VTK/Examples/Cxx/Databases/SQL/MySQL/WriteToDatabase

WriteToDatabase.cxx

#include <vtkSmartPointer.h>
#include <vtkMySQLDatabase.h>
#include <vtkSQLQuery.h>
#include <vtkVariant.h>

int main(int, char *[])
{
  // url syntax:
  // mysql://'[[username[':'password]'@']hostname[':'port]]'/'[dbname]

  vtkSmartPointer<vtkMySQLDatabase> db =
    vtkSmartPointer<vtkMySQLDatabase>::Take(vtkMySQLDatabase::SafeDownCast(
            vtkSQLDatabase::CreateFromURL( "mysql://root@localhost/TestDatabase" ) ));

  bool status = db->Open();
  
  std::cout << "Database open? " << status << std::endl;

  if(!status)
    {
    return EXIT_FAILURE;
    }
    
  vtkSmartPointer<vtkSQLQuery> query =
    vtkSmartPointer<vtkSQLQuery>::Take(db->GetQueryInstance());
  
  std::string createQuery( "INSERT INTO TestTable (PointId) VALUES(8)");
  std::cout << createQuery << std::endl;
  query->SetQuery( createQuery.c_str() );
  query->Execute();

  return EXIT_SUCCESS;
}

Please try the new VTKExamples website.

CMakeLists.txt

cmake_minimum_required(VERSION 2.8)

PROJECT(WriteToDatabase)

find_package(VTK REQUIRED)
include(${VTK_USE_FILE})

add_executable(WriteToDatabase MACOSX_BUNDLE WriteToDatabase.cxx)

if(VTK_LIBRARIES)
  target_link_libraries(WriteToDatabase ${VTK_LIBRARIES})
else()
  target_link_libraries(WriteToDatabase vtkHybrid vtkWidgets)
endif()

Download and Build WriteToDatabase

Click here to download WriteToDatabase. and its CMakeLists.txt file.

Once the tarball WriteToDatabase.tar has been downloaded and extracted,

cd WriteToDatabase/build 

• If VTK is installed:

cmake ..

• If VTK is not installed but compiled on your system, you will need to specify the path to your VTK build:

cmake -DVTK_DIR:PATH=/home/me/vtk_build ..

Build the project:

make

and run it:

./WriteToDatabase

WINDOWS USERS PLEASE NOTE: Be sure to add the VTK bin directory to your path. This will resolve the VTK dll's at run time.