GOFIGURE2
0.9.0
|
#include "SelectQueryDatabaseHelper.h"
#include "vtkMySQLDatabase.h"
#include "vtkSQLQuery.h"
#include "vtkStdString.h"
#include "vtkSmartPointer.h"
#include "vtkVariant.h"
#include "vtkPolyDataMySQLContourReader.h"
#include "vtkPolyDataMySQLMeshReader.h"
#include "vtkPolyDataMySQLTrackReader.h"
#include <sstream>
#include <string>
#include <algorithm>
Go to the source code of this file.
Functions | |
int | FindOneID (vtkMySQLDatabase *DatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::string &value) |
SELECT ColumnName FROM TableName WHERE field = value. More... | |
int | FindOneID (vtkMySQLDatabase *DatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::vector< FieldWithValue > &iConditions) |
std::vector< std::string > | FindSeveralIDs (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::vector< FieldWithValue > &iConditions) |
"SELECT ColumnName FROM TableName WHERE (field1 = value1 AND field2 = value2...); More... | |
std::list< unsigned int > | GetAllSelectedValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::vector< FieldWithValue > &iFieldsWithValues, bool Distinct) |
std::vector< std::string > | GetAllSelectedValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::vector< std::string > &iSelectedFields, const FieldWithValue &iJoinCondition, const std::vector< FieldWithValue > &iFieldsWithValues, std::string iConditionConnector, std::string ColumnNameOrder) |
std::list< unsigned int > | GetAllSelectedValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::string &iField, const std::vector< std::string > &iVectorValues, bool Distinct, bool NonNULLRows) |
std::list< unsigned int > | GetAllSelectedValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::string &iField, const std::vector< std::string > &iVectorValues, const FieldWithValue &iAndCondition) |
std::list< unsigned int > | GetAllSelectedValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::vector< std::string > &iSelectedFields, const FieldWithValue &iJoinCondition, const std::string &iField, const std::string &iValue, bool NonNULLRows) |
std::list< double * > | GetCenterBoundingBoxes (vtkMySQLDatabase *DatabaseConnector, const std::string &iTableName, const std::string &iField, const std::string &iValue) |
std::list< unsigned int > | GetColumnForBoundedValue (const std::string &iColumnName, const std::string &iTableName, const std::string &iImgSessionID, const std::string &iCoordType, const std::string &iValue, vtkMySQLDatabase *DatabaseConnector) |
std::string | GetCoordinateValuesQueryString (const std::string &iTableName, const std::string &iField, const std::string &iValue, bool iMin) |
std::list< unsigned int > | GetDoublonValuesFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::string &iField, const std::vector< std::string > &iVectValues) |
std::list< unsigned int > | GetListValuesFromTwoTablesAndCondition (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::string &iField, const std::vector< std::string > &iVectorValues, const FieldWithValue &iAndCondition) |
int | GetMaxValueFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const FieldWithValue &iJoinCondition, const std::string &iField, const std::vector< std::string > &iVectorValues, const FieldWithValue &iAndCondition) |
std::vector< std::string > | GetOrderByWithLimit (vtkMySQLDatabase *iDatabaseConnector, const std::string &iColumnName, const std::string &iTableName, const std::string &iField, const std::string &iValue, bool ASC, const std::string &iNumberLimit) |
std::vector< std::string > | GetSamefieldFromTwoTables (vtkMySQLDatabase *DatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumn, const std::string &iField, const std::string &iValue, const std::string &iFieldTwo, const std::vector< std::string > &iListConditionsTwo) |
std::vector< std::string > | GetSameFieldsFromSeveralTables (vtkMySQLDatabase *DatabaseConnector, const std::vector< std::string > &iColumnNames, const std::vector< std::string > &iVectorTablesNames, const std::vector< std::string > &iVectorConditionFieldNames, const std::vector< std::vector< std::string > > &iVectorConditionsValues) |
std::vector< std::string > | GetSamefieldsFromTwoTables (vtkMySQLDatabase *DatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumnOne, const std::string &iColumnTwo, const std::string &iField, const std::string &iValue) |
std::vector< std::string > | GetSamefieldsFromTwoTables (vtkMySQLDatabase *DatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const std::string &iColumnOne, const std::string &iColumnTwo, const std::string &iField, const std::string &iValue, const std::string &iFieldTwo, const std::vector< std::string > &iListConditionsTwo) |
std::vector< std::string > | GetSpecificValueFromOneTableWithConditionsOnTwoColumns (vtkMySQLDatabase *DatabaseConnector, const std::string &iColumnName, const std::string &iTableName, const std::string &iFieldOne, const std::vector< std::string > &iVectorConditionFieldOne, const std::string &iFieldTwo, const std::vector< std::string > &iVectorConditionFieldTwo) |
std::list< unsigned int > | GetSpecificValuesEqualToZero (vtkMySQLDatabase *iDatabaseConnector, const std::string &iColumnName, const std::string &iTableName, const std::vector< std::string > &iVectorConditionFieldOne, const std::string &iFieldTwo) |
std::list< unsigned int > | GetTwoFieldsFromTwoTables (vtkMySQLDatabase *iDatabaseConnector, const std::string &iTableOne, const std::string &iTableTwo, const FieldWithValue &iOnCondition, const std::string &iColumnOne, const std::string &iColumnTwo, const std::string &iField, const std::vector< std::string > &iListValues, bool Distinct) |
std::vector< std::vector < std::string > > | GetValuesFromSeveralTables (vtkMySQLDatabase *DatabaseConnector, const std::string &MainTable, const std::vector< std::string > &SelectFields, const std::string &field, const std::string &value, const std::vector< std::string > &JoinTablesOnTraceTable, bool Distinct) |
std::vector< std::vector < std::string > > | GetValuesFromSeveralTables (vtkMySQLDatabase *DatabaseConnector, const std::string &MainTable, const std::vector< std::string > &SelectFields, const std::string &field, const std::string &value, const std::vector< std::string > &JoinTablesOnTraceTable, bool Distinct, const std::vector< FieldWithValue > &iWhereOrConditions) |
std::vector< std::vector < std::string > > | GetValuesFromSeveralTables (vtkMySQLDatabase *DatabaseConnector, const std::string &MainTable, const std::vector< std::string > &SelectFields, const std::vector< std::string > &WhereAndConditions, const std::vector< std::string > &JoinTablesOnTraceTable, bool Distinct) |
std::vector< std::string > | ListAllValuesForOneColumn (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnName, const std::string &TableName, std::string OrderByColumnName) |
SELECT ColumnName from TableName ORDER BY OrderbyColumnName. More... | |
std::vector< std::string > | ListSpecificValuesForOneColumn (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::string &value, bool ExcludeZero) |
SELECT ColumnName FROM TableName WHERE field = value and ColumnName <> 0 (if excludezero) More... | |
std::vector< std::string > | ListSpecificValuesForOneColumn (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::string &value, const std::string &ColumnNameOrder) |
SELECT ColumnName FROM TableName WHERE field = value ORDER BY ColumnNameOrder ASC This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
std::vector< std::string > | ListSpecificValuesForOneColumn (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::vector< std::string > &VectorValues, bool Distinct, bool ExcludeZero) |
SELECT ColumnName FROM TableName WHERE (field = value1 or field = value2 AND ColumnName <> 0 (if excludezero)) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
std::list< unsigned int > | ListSpecificValuesForOneColumn (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::list< unsigned int > &iListValues, bool Distinct, bool ExcludeZero) |
SELECT ColumnName FROM TableName WHERE (field = value1 or field = value2 AND ColumnName <> 0 (if excludezero)) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
std::list< unsigned int > | ListSpecificValuesForOneColumn (vtkMySQLDatabase *iDatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &fieldOne, const std::list< unsigned int > &ListValuesOne, const std::string &fieldTwo, const std::string &ValueFieldTwo) |
SELECT ColumnName FROM TableName WHERE (field1 = value1 or field = value2 AND fieldTwo = ValueFieldTwo ) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
std::vector< std::string > | ListSpecificValuesForRow (vtkMySQLDatabase *DatabaseConnector, const std::string &TableName, const std::string &field, const std::string &value) |
SELECT * FROM TableName WHERE field = value. More... | |
std::vector< std::pair < std::string, std::string > > | ListSpecificValuesForTwoColumns (vtkMySQLDatabase *DatabaseConnector, const std::string &TableName, const std::string &ColumnNameOne, const std::string &ColumnNameTwo, const std::string &field, const std::string &value, const std::string &ColumnNameOrder) |
SELECT ColumnNameOne,ColumnName2 FROM TableName WHERE field = value ORDER BY ColumnNameOrder ASC". More... | |
std::vector< std::pair< int, std::string > > | ListSpecificValuesForTwoColumnsAndTwoTables (vtkMySQLDatabase *DatabaseConnector, const std::string &TableOne, const std::string &ColumnOne, const std::string &TableTwo, const std::string &ColumnTwo, const std::string &ForeignKey, const std::string &PrimaryKey, const std::string &field, const std::string &value) |
boost::unordered_map < std::string, std::string > | MapTwoColumnsFromTable (vtkMySQLDatabase *DatabaseConnector, const std::vector< std::string > &iColumnNames, const std::string &iTableName, std::string iField, std::string iValue) |
query: "SELECT ColumnName1, ColumnName2 FROM TableName" More... | |
int | MaxValueForOneColumnInTable (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnName, const std::string &TableName) |
SELECT MAX(ColumnName) FROM TableName This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
int | MaxValueForOneColumnInTable (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnName, const std::string &TableName, const std::string &field, const std::string &value) |
SELECT MAX(ColumnName) FROM TableName WHERE field = value This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts. More... | |
int | MaxValueForOneColumnInTable (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnName, const std::string &TableName, const std::string &field, const std::vector< std::string > &VectorValues) |
SELECT MAX(ColumnName) FROM TableName WHERE (field = value1 or field = value2....". More... | |
int | MinValueForOneColumnInTable (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnName, const std::string &TableName, const std::string &field, const std::vector< std::string > &VectorValues) |
SELECT MIN(ColumnName) FROM TableName WHERE (field = value1 or field = value2....". More... | |
void | ModifyStructureWithSpecificities (ContourMeshStructure &ioStructure, unsigned int iTCoord, const std::string &iPoints, const std::string &iTraceName) |
fill the TCoord and the attributes of the structure obtained from Points More... | |
void | ModifyStructureWithSpecificities (TrackStructure &ioStructure, unsigned int iTCoord, const std::string &iPoints, const std::string &iTraceName) |
void | ModifyStructureWithSpecificities (LineageStructure &ioStructure, unsigned int iTrackRootID, const std::string &iPoints, const std::string &iTraceName) |
int | NumberOfElementForGivenImagingSessionAndTrace (vtkMySQLDatabase *DatabaseConnector, unsigned int iImagingSession, const std::string &iTrace) |
int | NumberOfElementForGivenImagingSessionAndTraceForGivenTimePoint (vtkMySQLDatabase *DatabaseConnector, unsigned int iImagingSession, const std::string &iTrace, int iTimePoint) |
std::string | ReturnOnlyOneValue (vtkMySQLDatabase *DatabaseConnector, const std::string &TableName, const std::string &ColumnName, const std::string &field, const std::string &value) |
SELECT ColunmName FROM TableName WHERE field=value limit 1. More... | |
std::vector< std::pair < std::string, std::string > > | VectorTwoColumnsFromTable (vtkMySQLDatabase *DatabaseConnector, const std::string &ColumnNameOne, const std::string &ColumnNameTwo, const std::string &TableName, const std::string &OrderByColumnName) |
SELECT ColumnNameOne,ColumnNameTwo FROM TableName ORDER BY ColumnName ASC. More... | |
int FindOneID | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::string & | value | ||
) |
SELECT ColumnName FROM TableName WHERE field = value.
[in] | DatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | field | field for the condition |
[in] | value | value of the condition |
Definition at line 170 of file SelectQueryDatabaseHelper.cxx.
int FindOneID | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::vector< FieldWithValue > & | iConditions | ||
) |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
[in] | iConditions | vector of fields = values |
Definition at line 200 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > FindSeveralIDs | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::vector< FieldWithValue > & | iConditions | ||
) |
"SELECT ColumnName FROM TableName WHERE (field1 = value1 AND field2 = value2...);
[in] | DatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | iConditions | vector of fields = values |
Definition at line 222 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetAllSelectedValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::vector< FieldWithValue > & | iFieldsWithValues, | ||
bool | Distinct | ||
) |
Definition at line 1262 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetAllSelectedValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::vector< std::string > & | iSelectedFields, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::vector< FieldWithValue > & | iFieldsWithValues, | ||
std::string | iConditionConnector, | ||
std::string | ColumnNameOrder | ||
) |
Definition at line 1282 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetAllSelectedValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iVectorValues, | ||
bool | Distinct, | ||
bool | NonNULLRows | ||
) |
Definition at line 1309 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetAllSelectedValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iVectorValues, | ||
const FieldWithValue & | iAndCondition | ||
) |
Definition at line 1329 of file SelectQueryDatabaseHelper.cxx.
std::list<unsigned int> GetAllSelectedValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::vector< std::string > & | iSelectedFields, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::string & | iValue, | ||
bool | NonNULLRows | ||
) |
Definition at line 1356 of file SelectQueryDatabaseHelper.cxx.
std::list< double * > GetCenterBoundingBoxes | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | iTableName, | ||
const std::string & | iField, | ||
const std::string & | iValue | ||
) |
Definition at line 1613 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetColumnForBoundedValue | ( | const std::string & | iColumnName, |
const std::string & | iTableName, | ||
const std::string & | iImgSessionID, | ||
const std::string & | iCoordType, | ||
const std::string & | iValue, | ||
vtkMySQLDatabase * | DatabaseConnector | ||
) |
Definition at line 1140 of file SelectQueryDatabaseHelper.cxx.
std::string GetCoordinateValuesQueryString | ( | const std::string & | iTableName, |
const std::string & | iField, | ||
const std::string & | iValue, | ||
bool | iMin | ||
) |
Definition at line 1481 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetDoublonValuesFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iVectValues | ||
) |
Definition at line 1430 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetListValuesFromTwoTablesAndCondition | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iVectorValues, | ||
const FieldWithValue & | iAndCondition | ||
) |
Definition at line 1403 of file SelectQueryDatabaseHelper.cxx.
int GetMaxValueFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const FieldWithValue & | iJoinCondition, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iVectorValues, | ||
const FieldWithValue & | iAndCondition | ||
) |
Definition at line 1374 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetOrderByWithLimit | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iColumnName, | ||
const std::string & | iTableName, | ||
const std::string & | iField, | ||
const std::string & | iValue, | ||
bool | ASC, | ||
const std::string & | iNumberLimit | ||
) |
Definition at line 1452 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetSamefieldFromTwoTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumn, | ||
const std::string & | iField, | ||
const std::string & | iValue, | ||
const std::string & | iFieldTwo, | ||
const std::vector< std::string > & | iListConditionsTwo | ||
) |
Definition at line 830 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetSameFieldsFromSeveralTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::vector< std::string > & | iColumnNames, | ||
const std::vector< std::string > & | iVectorTablesNames, | ||
const std::vector< std::string > & | iVectorConditionFieldNames, | ||
const std::vector< std::vector< std::string > > & | iVectorConditionsValues | ||
) |
Definition at line 995 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetSamefieldsFromTwoTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumnOne, | ||
const std::string & | iColumnTwo, | ||
const std::string & | iField, | ||
const std::string & | iValue | ||
) |
Definition at line 896 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetSamefieldsFromTwoTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const std::string & | iColumnOne, | ||
const std::string & | iColumnTwo, | ||
const std::string & | iField, | ||
const std::string & | iValue, | ||
const std::string & | iFieldTwo, | ||
const std::vector< std::string > & | iListConditionsTwo | ||
) |
Definition at line 944 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > GetSpecificValueFromOneTableWithConditionsOnTwoColumns | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | iColumnName, | ||
const std::string & | iTableName, | ||
const std::string & | iFieldOne, | ||
const std::vector< std::string > & | iVectorConditionFieldOne, | ||
const std::string & | iFieldTwo, | ||
const std::vector< std::string > & | iVectorConditionFieldTwo | ||
) |
Definition at line 1065 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetSpecificValuesEqualToZero | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iColumnName, | ||
const std::string & | iTableName, | ||
const std::vector< std::string > & | iVectorConditionFieldOne, | ||
const std::string & | iFieldTwo | ||
) |
Definition at line 1214 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > GetTwoFieldsFromTwoTables | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | iTableOne, | ||
const std::string & | iTableTwo, | ||
const FieldWithValue & | iOnCondition, | ||
const std::string & | iColumnOne, | ||
const std::string & | iColumnTwo, | ||
const std::string & | iField, | ||
const std::vector< std::string > & | iListValues, | ||
bool | Distinct | ||
) |
Definition at line 875 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::vector< std::string > > GetValuesFromSeveralTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | MainTable, | ||
const std::vector< std::string > & | SelectFields, | ||
const std::string & | field, | ||
const std::string & | value, | ||
const std::vector< std::string > & | JoinTablesOnTraceTable, | ||
bool | Distinct | ||
) |
Definition at line 583 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::vector< std::string > > GetValuesFromSeveralTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | MainTable, | ||
const std::vector< std::string > & | SelectFields, | ||
const std::string & | field, | ||
const std::string & | value, | ||
const std::vector< std::string > & | JoinTablesOnTraceTable, | ||
bool | Distinct, | ||
const std::vector< FieldWithValue > & | iWhereOrConditions | ||
) |
Definition at line 658 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::vector< std::string > > GetValuesFromSeveralTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | MainTable, | ||
const std::vector< std::string > & | SelectFields, | ||
const std::vector< std::string > & | WhereAndConditions, | ||
const std::vector< std::string > & | JoinTablesOnTraceTable, | ||
bool | Distinct | ||
) |
Definition at line 746 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > ListAllValuesForOneColumn | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnName, | ||
const std::string & | TableName, | ||
std::string | OrderByColumnName = "" |
||
) |
SELECT ColumnName from TableName ORDER BY OrderbyColumnName.
[in] | DatabaseConnector | connection to the database |
[in] | ColumnName | name of the field in the database |
[in] | TableName | name of the database table |
in] | OrderByColumnName sorting |
Definition at line 50 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > ListSpecificValuesForOneColumn | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::string & | value, | ||
bool | ExcludeZero = false |
||
) |
SELECT ColumnName FROM TableName WHERE field = value and ColumnName <> 0 (if excludezero)
[in] | iDatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | field | field for the condition |
[in] | value | value of the condition |
[in] | distinct | set to true if doublon are not allowed |
[in] | ExcludeZero | set to true if ColumnName has to be different than 0 |
Definition at line 236 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > ListSpecificValuesForOneColumn | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::string & | value, | ||
const std::string & | ColumnNameOrder | ||
) |
SELECT ColumnName FROM TableName WHERE field = value ORDER BY ColumnNameOrder ASC This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
[in] | ColumnNameOrder | name of the column for sorting |
Definition at line 261 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > ListSpecificValuesForOneColumn | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::vector< std::string > & | VectorValues, | ||
bool | Distinct, | ||
bool | ExcludeZero | ||
) |
SELECT ColumnName FROM TableName WHERE (field = value1 or field = value2 AND ColumnName <> 0 (if excludezero)) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 277 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > ListSpecificValuesForOneColumn | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::list< unsigned int > & | iListValues, | ||
bool | Distinct, | ||
bool | ExcludeZero | ||
) |
SELECT ColumnName FROM TableName WHERE (field = value1 or field = value2 AND ColumnName <> 0 (if excludezero)) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 311 of file SelectQueryDatabaseHelper.cxx.
std::list< unsigned int > ListSpecificValuesForOneColumn | ( | vtkMySQLDatabase * | iDatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | fieldOne, | ||
const std::list< unsigned int > & | ListValuesOne, | ||
const std::string & | fieldTwo, | ||
const std::string & | ValueFieldTwo | ||
) |
SELECT ColumnName FROM TableName WHERE (field1 = value1 or field = value2 AND fieldTwo = ValueFieldTwo ) This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 351 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::string > ListSpecificValuesForRow | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | field, | ||
const std::string & | value | ||
) |
SELECT * FROM TableName WHERE field = value.
Definition at line 157 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::pair< std::string, std::string > > ListSpecificValuesForTwoColumns | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnNameOne, | ||
const std::string & | ColumnNameTwo, | ||
const std::string & | field, | ||
const std::string & | value, | ||
const std::string & | ColumnNameOrder | ||
) |
SELECT ColumnNameOne,ColumnName2 FROM TableName WHERE field = value ORDER BY ColumnNameOrder ASC".
[in] | iDatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnNameOne | name of the first field in the database |
[in] | ColumnNameTwo | name of the second field in the database |
[in] | field | field for the condition |
[in] | value | value of the condition |
in] | OrderByColumnName sorting |
Definition at line 375 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::pair< int, std::string > > ListSpecificValuesForTwoColumnsAndTwoTables | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableOne, | ||
const std::string & | ColumnOne, | ||
const std::string & | TableTwo, | ||
const std::string & | ColumnTwo, | ||
const std::string & | ForeignKey, | ||
const std::string & | PrimaryKey, | ||
const std::string & | field, | ||
const std::string & | value | ||
) |
Definition at line 513 of file SelectQueryDatabaseHelper.cxx.
boost::unordered_map< std::string, std::string > MapTwoColumnsFromTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::vector< std::string > & | iColumnNames, | ||
const std::string & | iTableName, | ||
std::string | iField = "" , |
||
std::string | iValue = "" |
||
) |
query: "SELECT ColumnName1, ColumnName2 FROM TableName"
[in] | DatabaseConnector | connection to the database |
[in] | iColumnNames | vector[0] = ColumnName1, vector[1] = ColumnName2 |
[in] | iTableName | name of the database table |
[in] | iField | field for the condition if there is one |
[in] | iValue | value of the condition if there is one |
Definition at line 64 of file SelectQueryDatabaseHelper.cxx.
int MaxValueForOneColumnInTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnName, | ||
const std::string & | TableName | ||
) |
SELECT MAX(ColumnName) FROM TableName This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 439 of file SelectQueryDatabaseHelper.cxx.
int MaxValueForOneColumnInTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnName, | ||
const std::string & | TableName, | ||
const std::string & | field, | ||
const std::string & | value | ||
) |
SELECT MAX(ColumnName) FROM TableName WHERE field = value This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 455 of file SelectQueryDatabaseHelper.cxx.
int MaxValueForOneColumnInTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnName, | ||
const std::string & | TableName, | ||
const std::string & | field, | ||
const std::vector< std::string > & | VectorValues | ||
) |
SELECT MAX(ColumnName) FROM TableName WHERE (field = value1 or field = value2....".
[in] | DatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | field | field for the condition |
[in] | VectorValues | values of the condition |
Definition at line 473 of file SelectQueryDatabaseHelper.cxx.
int MinValueForOneColumnInTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnName, | ||
const std::string & | TableName, | ||
const std::string & | field, | ||
const std::vector< std::string > & | VectorValues | ||
) |
SELECT MIN(ColumnName) FROM TableName WHERE (field = value1 or field = value2....".
[in] | DatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | field | field for the condition |
[in] | VectorValues | values of the condition |
Definition at line 491 of file SelectQueryDatabaseHelper.cxx.
void ModifyStructureWithSpecificities | ( | ContourMeshStructure & | ioStructure, |
unsigned int | iTCoord, | ||
const std::string & | iPoints, | ||
const std::string & | iTraceName | ||
) |
fill the TCoord and the attributes of the structure obtained from Points
[in] | ioStructure | structure to be modified with TCoord and co. |
[in] | iTCoord | one to be filled with |
[in] | iPoints | points from which some attributes will be calculated |
[in] | iTraceName | name of the trace |
Definition at line 1514 of file SelectQueryDatabaseHelper.cxx.
void ModifyStructureWithSpecificities | ( | TrackStructure & | ioStructure, |
unsigned int | iTCoord, | ||
const std::string & | iPoints, | ||
const std::string & | iTraceName | ||
) |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 1556 of file SelectQueryDatabaseHelper.cxx.
void ModifyStructureWithSpecificities | ( | LineageStructure & | ioStructure, |
unsigned int | iTrackRootID, | ||
const std::string & | iPoints, | ||
const std::string & | iTraceName | ||
) |
This is an overloaded member function, provided for convenience. It differs from the above function only in what argument(s) it accepts.
Definition at line 1594 of file SelectQueryDatabaseHelper.cxx.
int NumberOfElementForGivenImagingSessionAndTrace | ( | vtkMySQLDatabase * | DatabaseConnector, |
unsigned int | iImagingSession, | ||
const std::string & | iTrace | ||
) |
Definition at line 1674 of file SelectQueryDatabaseHelper.cxx.
int NumberOfElementForGivenImagingSessionAndTraceForGivenTimePoint | ( | vtkMySQLDatabase * | DatabaseConnector, |
unsigned int | iImagingSession, | ||
const std::string & | iTrace, | ||
int | iTimePoint | ||
) |
Definition at line 1694 of file SelectQueryDatabaseHelper.cxx.
std::string ReturnOnlyOneValue | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | TableName, | ||
const std::string & | ColumnName, | ||
const std::string & | field, | ||
const std::string & | value | ||
) |
SELECT ColunmName FROM TableName WHERE field=value limit 1.
[in] | iDatabaseConnector | connection to the database |
[in] | TableName | name of the database table |
[in] | ColumnName | name of the field in the database |
[in] | field | field for the condition |
[in] | value | value of the condition |
Definition at line 421 of file SelectQueryDatabaseHelper.cxx.
std::vector< std::pair< std::string, std::string > > VectorTwoColumnsFromTable | ( | vtkMySQLDatabase * | DatabaseConnector, |
const std::string & | ColumnNameOne, | ||
const std::string & | ColumnNameTwo, | ||
const std::string & | TableName, | ||
const std::string & | OrderByColumnName | ||
) |
SELECT ColumnNameOne,ColumnNameTwo FROM TableName ORDER BY ColumnName ASC.
[in] | DatabaseConnector | connection to the database |
[in] | ColumnNameOne | first value of the pair |
[in] | ColumnNameTwo | second value of the pair |
[in] | TableName | name of the database table |
in] | OrderByColumnName sorting |
Definition at line 114 of file SelectQueryDatabaseHelper.cxx.