VTK/Examples/Cxx/Databases/SQL/MySQL/CreateDatabase

From KitwarePublic

Jump to: navigation, search

CreateDatabase.cxx

#include <vtkSmartPointer.h>
#include <vtkMySQLDatabase.h>
#include <vtkSQLQuery.h>
#include <vtkVariant.h>
 
int main(int, char *[])
{
  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)
    {
    //create database
    std::cout << "Database does not exist, create it!" << std::endl;
    db->CreateDatabase("TestDatabase", false);
    }
  else
    {
    std::cout << "Database already exists!" << std::endl;
    }
 
  return EXIT_SUCCESS;
}

CMakeLists.txt

cmake_minimum_required(VERSION 2.6)
 
PROJECT(CreateDatabase)
 
FIND_PACKAGE(VTK REQUIRED)
INCLUDE(${VTK_USE_FILE})
 
ADD_EXECUTABLE(CreateDatabase CreateDatabase.cxx)
TARGET_LINK_LIBRARIES(CreateDatabase vtkHybrid)
Personal tools