GOFIGURE2  0.9.0
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Groups Pages
Functions
QueryDataBaseHelper.cxx File Reference
#include "QueryDataBaseHelper.h"
#include "vtkMySQLDatabase.h"
#include "vtkSQLQuery.h"
#include "vtkStdString.h"
#include "vtkVariant.h"
#include "QueryBuilderHelper.h"
#include <sstream>
#include <string>
Include dependency graph for QueryDataBaseHelper.cxx:

Go to the source code of this file.

Functions

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

Function Documentation

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.

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.

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

Definition at line 46 of file QueryDataBaseHelper.cxx.

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

Definition at line 258 of file QueryDataBaseHelper.cxx.

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

Definition at line 277 of file QueryDataBaseHelper.cxx.

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

Definition at line 304 of file QueryDataBaseHelper.cxx.

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

Definition at line 325 of file QueryDataBaseHelper.cxx.

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

Definition at line 216 of file QueryDataBaseHelper.cxx.

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.

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

Definition at line 424 of file QueryDataBaseHelper.cxx.

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

Definition at line 154 of file QueryDataBaseHelper.cxx.

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

Definition at line 184 of file QueryDataBaseHelper.cxx.

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

Definition at line 100 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.

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.

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.