GOFIGURE2  0.9.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Groups Pages
Functions
QueryDataBaseHelper.h File Reference
#include <list>
#include <vector>
#include <string>
#include <map>
#include "itkMacro.h"
#include "vtkMySQLDatabase.h"
#include "QGoIOConfigure.h"
Include dependency graph for QueryDataBaseHelper.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Functions

QGOIO_EXPORT bool CloseDatabaseConnection (vtkMySQLDatabase *DatabaseConnector)
 return true if the connection has been closed, false if the connection was already closed More...
 
QGOIO_EXPORT std::pair< bool,
vtkMySQLDatabase * > 
ConnectToDatabase (std::string ServerName, std::string login, std::string Password, std::string DBName)
 
QGOIO_EXPORT std::pair< bool,
vtkMySQLDatabase * > 
ConnectToServer (std::string ServerName, std::string login, std::string Password)
 
QGOIO_EXPORT void DeleteRow (vtkMySQLDatabase *DatabaseConnector, std::string TableName, std::string field, std::string value)
 
QGOIO_EXPORT void DeleteRows (vtkMySQLDatabase *DatabaseConnector, std::string TableName, std::string field, std::vector< std::string > VectorValues)
 
QGOIO_EXPORT bool DoesDatabaseExist (vtkMySQLDatabase *ServerConnector, std::string DBName)
 
QGOIO_EXPORT bool DoesTableExist (vtkMySQLDatabase *DatabaseConnector, std::string TableName)
 
QGOIO_EXPORT void DropDatabase (vtkMySQLDatabase *ServerConnector, std::string DBName)
 
QGOIO_EXPORT void DropTable (vtkMySQLDatabase *DatabaseConnector, std::string TableName)
 
void ExecuteQuery (vtkMySQLDatabase *iDatabaseConnector, std::string iQuery)
 
QGOIO_EXPORT std::vector
< std::string > 
GetFieldNames (std::string TableName, vtkMySQLDatabase *ServerConnector)
 
QGOIO_EXPORT std::vector
< std::string > 
ListDatabases (vtkMySQLDatabase *ServerConnector)
 
QGOIO_EXPORT std::vector
< std::string > 
ListTables (vtkMySQLDatabase *DatabaseConnector)
 
QGOIO_EXPORT vtkMySQLDatabase * OpenDatabaseConnection (std::string ServerName, std::string login, std::string Password, std::string DBName)
 
QGOIO_EXPORT void UpdateValueInDB (vtkMySQLDatabase *DatabaseConnector, std::string TableName, std::string field, std::string newValue, std::string ColumnName, std::string value)
 
QGOIO_EXPORT void UpdateValueInDB (vtkMySQLDatabase *DatabaseConnector, std::string iTableName, std::string ifield, std::string inewValue, std::vector< unsigned int > iVectIDs)
 
void UpdateValueInDB (vtkMySQLDatabase *DatabaseConnector, std::string iTableName, std::string iColumnName, std::string iNewValue, std::string iField, std::vector< unsigned int > iVectIDs)
 

Function Documentation

QGOIO_EXPORT bool CloseDatabaseConnection ( vtkMySQLDatabase *  DatabaseConnector)

return true if the connection has been closed, false if the connection was already closed

Definition at line 120 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT std::pair< bool, vtkMySQLDatabase * > ConnectToDatabase ( std::string  ServerName,
std::string  login,
std::string  Password,
std::string  DBName 
)

Definition at line 71 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT std::pair< bool, vtkMySQLDatabase * > ConnectToServer ( std::string  ServerName,
std::string  login,
std::string  Password 
)

Definition at line 46 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void DeleteRow ( vtkMySQLDatabase *  DatabaseConnector,
std::string  TableName,
std::string  field,
std::string  value 
)

Definition at line 258 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void DeleteRows ( vtkMySQLDatabase *  DatabaseConnector,
std::string  TableName,
std::string  field,
std::vector< std::string >  VectorValues 
)

Definition at line 277 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT bool DoesDatabaseExist ( vtkMySQLDatabase *  ServerConnector,
std::string  DBName 
)

Definition at line 304 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT bool DoesTableExist ( vtkMySQLDatabase *  DatabaseConnector,
std::string  TableName 
)

Definition at line 325 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void DropDatabase ( vtkMySQLDatabase *  ServerConnector,
std::string  DBName 
)

Definition at line 216 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void DropTable ( vtkMySQLDatabase *  DatabaseConnector,
std::string  TableName 
)

Definition at line 237 of file QueryDataBaseHelper.cxx.

void ExecuteQuery ( vtkMySQLDatabase *  iDatabaseConnector,
std::string  iQuery 
)

Definition at line 135 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT std::vector< std::string > GetFieldNames ( std::string  TableName,
vtkMySQLDatabase *  ServerConnector 
)

Definition at line 424 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT std::vector< std::string > ListDatabases ( vtkMySQLDatabase *  ServerConnector)

Definition at line 154 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT std::vector< std::string > ListTables ( vtkMySQLDatabase *  DatabaseConnector)

Definition at line 184 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT vtkMySQLDatabase* OpenDatabaseConnection ( std::string  ServerName,
std::string  login,
std::string  Password,
std::string  DBName 
)

Definition at line 100 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void UpdateValueInDB ( vtkMySQLDatabase *  DatabaseConnector,
std::string  TableName,
std::string  field,
std::string  newValue,
std::string  ColumnName,
std::string  value 
)

Definition at line 367 of file QueryDataBaseHelper.cxx.

QGOIO_EXPORT void UpdateValueInDB ( vtkMySQLDatabase *  DatabaseConnector,
std::string  iTableName,
std::string  ifield,
std::string  inewValue,
std::vector< unsigned int >  iVectIDs 
)

Definition at line 392 of file QueryDataBaseHelper.cxx.

void UpdateValueInDB ( vtkMySQLDatabase *  DatabaseConnector,
std::string  iTableName,
std::string  iColumnName,
std::string  iNewValue,
std::string  iField,
std::vector< unsigned int >  iVectIDs 
)

Definition at line 347 of file QueryDataBaseHelper.cxx.