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.