34 #ifndef __QueryDatabaseHelper_h
35 #define __QueryDatabaseHelper_h
43 #include "vtkMySQLDatabase.h"
45 #include "QGoIOConfigure.h"
49 std::string ServerName, std::string login,
50 std::string Password);
54 std::string ServerName, std::string login,
55 std::string Password, std::string DBName);
59 std::string ServerName, std::string login,
60 std::string Password, std::string DBName);
66 vtkMySQLDatabase *DatabaseConnector);
70 vtkMySQLDatabase *ServerConnector);
74 vtkMySQLDatabase *DatabaseConnector);
79 std::string TableName, std::string field, std::string newValue,
80 std::string ColumnName, std::string value);
86 std::string iTableName, std::string ifield,
87 std::string inewValue, std::vector< unsigned int > iVectIDs);
89 void UpdateValueInDB(vtkMySQLDatabase *DatabaseConnector,std::string iTableName,
90 std::string iColumnName, std::string iNewValue, std::string iField,
91 std::vector<unsigned int> iVectIDs);
95 vtkMySQLDatabase *ServerConnector,
100 vtkMySQLDatabase *DatabaseConnector,
101 std::string TableName);
106 vtkMySQLDatabase *DatabaseConnector,
107 std::string TableName, std::string field, std::string value);
113 vtkMySQLDatabase *DatabaseConnector,
114 std::string TableName, std::string field,
115 std::vector< std::string > VectorValues);
119 vtkMySQLDatabase *ServerConnector,
124 vtkMySQLDatabase *DatabaseConnector,
125 std::string TableName);
129 std::vector< std::string >
GetFieldNames(std::string TableName,
130 vtkMySQLDatabase *ServerConnector);
132 void ExecuteQuery(vtkMySQLDatabase * iDatabaseConnector, std::string iQuery);
bool CloseDatabaseConnection(vtkMySQLDatabase *DatabaseConnector)
return true if the connection has been closed, false if the connection was already closed ...
bool DoesDatabaseExist(vtkMySQLDatabase *ServerConnector, std::string DBName)
vtkMySQLDatabase * OpenDatabaseConnection(std::string ServerName, std::string login, std::string Password, std::string DBName)
std::vector< std::string > ListDatabases(vtkMySQLDatabase *ServerConnector)
void DropDatabase(vtkMySQLDatabase *ServerConnector, std::string DBName)
void UpdateValueInDB(vtkMySQLDatabase *DatabaseConnector, std::string iTableName, std::string iColumnName, std::string iNewValue, std::string iField, std::vector< unsigned int > iVectIDs)
std::vector< std::string > GetFieldNames(std::string TableName, vtkMySQLDatabase *DatabaseConnector)
void DeleteRows(vtkMySQLDatabase *DatabaseConnector, std::string TableName, std::string field, std::vector< std::string > VectorValues)
void ExecuteQuery(vtkMySQLDatabase *iDatabaseConnector, std::string iQuery)
void DropTable(vtkMySQLDatabase *DatabaseConnector, std::string TableName)
std::pair< bool, vtkMySQLDatabase * > ConnectToDatabase(std::string ServerName, std::string login, std::string Password, std::string DBName)
bool DoesTableExist(vtkMySQLDatabase *DatabaseConnector, std::string TableName)
std::pair< bool, vtkMySQLDatabase * > ConnectToServer(std::string ServerName, std::string login, std::string Password)
std::vector< std::string > ListTables(vtkMySQLDatabase *DatabaseConnector)
void DeleteRow(vtkMySQLDatabase *DatabaseConnector, std::string TableName, std::string field, std::string value)