GOFIGURE2
0.9.0
|
#include "QueryDataBaseHelper.h"
#include "vtkMySQLDatabase.h"
#include "vtkSQLQuery.h"
#include "vtkStdString.h"
#include "vtkVariant.h"
#include "QueryBuilderHelper.h"
#include <sstream>
#include <string>
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) |
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.