#include <ITTable.h>
Collaboration diagram for ITTable:
Public Types | |
enum | eOrientation { eCOLUMN_WISE = 0, eROW_WISE } |
enum | eSearchType { eEQUAL = 0, eLESS_THAN, eLESS_THAN_OR_EQUAL, eGREATER_THAN, eGREATER_THAN_OR_EQUAL } |
enum | eSearchDir { eFORWARD = 0, eBACKWARD } |
Public Member Functions | |
ITTable () | |
ITTable (eOrientation orient) | |
ITTable (const ITTable &inTable) | |
~ITTable () | |
ITTable & | operator= (const ITTable &inTable) |
unsigned int | GetNumColumns () const |
void | AddColumn (const string &colName, const vector< string > &col=vector< string >(0)) |
void | InsertColumn (const string &colName, const string &atColName, const vector< string > &col=vector< string >(0)) |
void | FillColumn (const string &colName, const vector< string > &col) |
void | AppendToColumn (const string &colName, const string &cell) |
void | AppendToColumn (const string &colName, const vector< string > &col) |
void | GetColumn (vector< string > &col, const string &colName) |
void | GetColumn (vector< string > &col, const string &colName, const unsigned int fromRowIndex, unsigned int toRowIndex) |
void | GetColumn (vector< string > &col, const string &colName, const vector< unsigned int > &rowIndex) |
void | ClearColumn (const string &colName) |
void | DeleteColumn (const string &colName) |
unsigned int | GetNumRows () const |
unsigned int | AddRow (const vector< string > &row=vector< string >(0)) |
unsigned int | InsertRow (const unsigned int atRowIndex, const vector< string > &row=vector< string >(0)) |
void | FillRow (const unsigned int rowIndex, const vector< string > &row) |
void | GetRow (vector< string > &row, const unsigned int rowIndex, const string &fromColName=String::Empty, const string &toColName=String::Empty) |
void | ClearRow (const unsigned int rowIndex) |
void | DeleteRow (const unsigned int rowIndex) |
void | DeleteRows (const vector< unsigned int > &rows) |
unsigned int | GetLastRowIndex () |
void | UpdateCell (const unsigned int rowIndex, const string &colName, const string &value) |
const string & | operator() (const unsigned int rowIndex, const string &colName) const |
void | SetFlags (const string &colName, const unsigned char flags) |
unsigned char | GetDataType (const string &colName) |
void | FindDuplicateRows (vector< pair< unsigned int, unsigned int > > &duplRows, const vector< string > &colNames, const bool keepDuplRows, const eSearchDir searchDir=eFORWARD) |
void | ValidateOptions (unsigned int colIndex) |
void | UpdateIndex (const unsigned int indexIndex, const unsigned int rowIndex) |
void | InsertIndexEntry (const unsigned int indexIndex, const unsigned int rowIndex) |
void | DeleteIndexEntry (const unsigned int indexIndex, const unsigned int rowIndex) |
void | VerifyColumnsIndices (const vector< unsigned int > &colIndices) |
int | FindIndex (const vector< unsigned int > &colIndices) |
int | SetFlags (const unsigned char newOpts, const unsigned int colIndex) |
unsigned int | FindFirst (const vector< string > &targets, const vector< unsigned int > &colIndices, const unsigned int indexIndex) |
void | Search (vector< unsigned int > &res, const vector< string > &targets, const vector< unsigned int > &colIndices, const unsigned int indexIndex, const eSearchType searchType=eEQUAL) |
void | DeleteIndex (const unsigned int indexIndex) |
void | Search (vector< unsigned int > &res, const string &target, const unsigned int colIndex, const eSearchType searchType=eEQUAL) |
void | FindDuplicateRows (const vector< unsigned int > &colIndices, vector< pair< unsigned int, unsigned int > > &duplRows, const bool keep, const eSearchDir searchDir=eFORWARD) |
void | RebuildIndex (const unsigned int indexIndex) |
void | InsertColumn (const unsigned int colIndex, const vector< string > &col=vector< string >(0)) |
void | InsertColumn (const unsigned int colIndex, vector< string >::const_iterator colBeg, vector< string >::const_iterator colEnd) |
void | Clear () |
const string & | operator() (const unsigned int rowIndex, const unsigned int colIndex) const |
int | UpdateCell (const string &cell, const unsigned int colIndex, const unsigned int rowIndex) |
void | FillColumn (const vector< string > &col, const unsigned int colIndex) |
void | FillColumn (const unsigned int colIndex, vector< string >::const_iterator colBeg, vector< string >::const_iterator colEnd) |
void | AppendToColumn (const unsigned int colIndex, const vector< string > &col) |
void | AppendToColumn (const unsigned int colIndex, const string &cell) |
void | CreateColumn (const unsigned int atColIndex, const vector< string > &col=vector< string >(0)) |
void | CreateColumn (const unsigned int atColIndex, vector< string >::const_iterator colBeg, vector< string >::const_iterator colEnd) |
void | GetColumn (vector< string > &col, const unsigned int colIndex, const unsigned int fromRowIndex, unsigned int toRowIndex) |
void | GetColumn (vector< string > &col, const unsigned int colIndex, const vector< unsigned int > &rowIndex) |
void | ClearColumn (const unsigned int colIndex) |
void | DeleteColumn (const unsigned int colIndex) |
void | GetColumn (vector< string > &col, const unsigned int colIndex) |
void | GetRow (vector< string > &row, const unsigned int rowIndex, const unsigned int fromColIndex, unsigned int toColIndex) |
const vector< string > & | GetRow (const unsigned int rowIndex) |
eOrientation | GetOrientation () |
void | CreateIndex (const vector< unsigned int > &colIndices, const unsigned int unique=0) |
void | SetSerializer (Serializer *ser) |
int | WriteObject (Serializer *ser, int &size) |
int | GetObject (UInt32 index, Serializer *ser) |
int | Read (unsigned int indexInFile, Serializer *ser) |
int | Write (Serializer *ser, int &size) |
void | RebuildIndices () |
void | InsertEntry (const unsigned int rowIndex) |
void | DeleteEntry (const unsigned int rowIndex) |
unsigned int | GetNumIndices () |
void | GetColumn (vector< string > &col, const unsigned int colIndex, const unsigned int indexIndex) |
Static Public Attributes | |
static const unsigned char | DT_STRING_VAL = 1 |
static const unsigned char | DT_INTEGER_VAL = 2 |
static const unsigned char | CASE_SENSE = 0x00 |
static const unsigned char | CASE_INSENSE = 0x01 |
static const unsigned char | W_SPACE_SENSE = 0x00 |
static const unsigned char | W_SPACE_INSENSE = 0x02 |
static const unsigned char | DT_STRING = DT_STRING_VAL << 4 |
static const unsigned char | DT_INTEGER = DT_INTEGER_VAL << 4 |
Private Member Functions | |
bool | AreListsOfColumnsValid (const vector< unsigned int > &colIndices) |
void | CreateKey (const vector< unsigned int > &colIndices) |
void | Init () |
StringCompare::eCompareType | GetCompareType (const vector< unsigned int > &colIndices) |
string | CellValue (const unsigned int colIndex, const unsigned int rowIndex) |
string | ConvertString (const string &value, const unsigned int colIndex) |
string | MultiStringsValue (const vector< string > &values, const vector< unsigned int > &colIndices) |
string | SubRowValue (const vector< unsigned int > &colIndices, const unsigned int rowIndex) |
string | AggregateRow (const vector< unsigned int > &colIndices, const unsigned int rowIndex) |
void | AppendToAndDelimit (string &to, const string &appending) |
string | CreateInternalIndexName (const unsigned int indexIndex) |
void | ClearIndex (const unsigned int indexIndex) |
void | UpdateIndices (const unsigned int rowIndex) |
void | ClearIndices () |
bool | IsColumnInIndex (const unsigned int indexIndex, const unsigned int colIndex) |
int | FindKeyIndex () |
void | UpdateColListOnColInsert (const unsigned int colIndex) |
void | UpdateColListOnColDelete (const unsigned int colIndex) |
void | UpdateIndicesOnCellUpdate (const unsigned int rowIndex, const unsigned int colIndex) |
void | ConvertToInt (const string &a, string &ret) |
void | ConvertDouble (const string &a, string &ret) |
void | ConvertToLowerNoWhiteSpace (const string &a, string &ret) |
void | Print (unsigned int indexIndex) |
Private Attributes | |
TTable | _ttable |
eOrientation | _orient |
Serializer * | _ser |
vector< unsigned char > | _compare_opts |
vector< vector< unsigned int > > | _listsOfColumns |
vector< unsigned int > | _unique |
vector< tIndex > | _indices |
Static Private Attributes | |
static const unsigned int | EXPONENT = 4 |
static const unsigned int | MAX_PRECISION = DBL_DIG |
static const unsigned int | MANTISSA = MAX_PRECISION + 2 |
static const unsigned int | INT_LIMIT = 11 |
static const unsigned char | DT_MASK = 15 << 4 |
static const unsigned char | SC_MASK = 0x01 |
static const unsigned char | WS_MASK = 0x02 |
static const unsigned char | LAST_DT_VALUE = 3 |
static const unsigned int | DEFAULT_PRECISION = MAX_PRECISION |
static const unsigned char | DEFAULT_OPTIONS |
This class represents a two-dimensional table of cells. Each cell holds a text string. The table is identified by its name. Rows are horizontal table entities identified by row indices, which are unsigned integers ranging from zero to the number of rows minus one. Columns are vertical table entities identified by (non-empty) column names. Column names can be case-sensitive (by default) or case-insensitive (customizable during construction). The class provides methods for table construction and destruction, assignment operator, equal operator, column and row based methods for addition, insertion, retrieval, update, deletion, cell based methods for update and retrieval, column search methods and table printing. Table cells are internally stored as vectors of text strings, where vectors can represent either columns (by default) or rows (customizable during construction).
enum ITTable::eSearchType |
enum ITTable::eSearchDir |
ITTable::ITTable | ( | ) |
Constructs a table.
Constructed table is nameless (its name is an empty string).
None |
ITTable::ITTable | ( | eOrientation | orient | ) |
Constructs a table.
[in] | orient | - table orientation. Possible values are row-wise orientation (vectors of strings represent table rows) and column-wise orientation (vectors of strings represent table columns) |
Constructed table is nameless (its name is an empty string).
None |
ITTable::ITTable | ( | const ITTable & | inTable | ) |
Constructs a table by copying from another table (copy constructor).
[in] | inTable | - reference to a table that will be copied to the newly constructed table |
None |
ITTable::~ITTable | ( | ) |
Destructs a table, by releasing all the used resources.
Not applicable |
None |
Copies a table to another table (assignment operator).
[in] | inTable | - reference to the source table |
None |
unsigned int ITTable::GetNumColumns | ( | ) | const [inline] |
Retrieves the number of columns in the table.
None |
None |
void ITTable::AddColumn | ( | const string & | colName, | |
const vector< string > & | col = vector< string >(0) | |||
) |
Adds a column to the end of the table.
[in] | colName | - the name of the column to be added |
[in] | col | - optional parameter that contains the values which are to be used to fill in the newly added column. If col is specified, filling starts at row index 0 and continues until size of col. If col is not specified, the newly added column is filled with empty values, where filling starts at row index 0 and ends at row index "number of rows - 1". |
Column with name colName must not be present
If col is specified, the size of col must be less than or equal to the number of rows.
EmptyValueException | - if colName is empty | |
AlreadyExistsException | - if column with name colName already exists | |
out_of_range | - if size of col is greater than the number of rows |
void ITTable::InsertColumn | ( | const string & | colName, | |
const string & | atColName, | |||
const vector< string > & | col = vector< string >(0) | |||
) |
Inserts a new column at the specified existing column and shifts, to the right by one, the specified existing column and all columns after it.
[in] | colName | - the name of the column to be inserted |
[in] | atColName | - the name of the column at which the new column is to be inserted |
[in] | col | - optional parameter that contains the values which are to be used to fill in the newly inserted column. If col is specified, filling starts at row index 0 and continues until size of col. If col is not specified, the newly inserted column is filled with empty values, where filling starts at row index 0 and ends at row index "number of rows - 1". |
Column with name colName must not be present
atColName must be non-empty
Column with name atColName must be present
If col is specified, the size of col must be less than or equal to the number of rows.
The column which comes, in order, before the column with name atColName, must be non-empty. This is to prevent creation of non-rectangular tables.
EmptyValueException | - if colName is empty | |
AlreadyExistsException | - if column with name colName already exists | |
EmptyValueException | - if atColName is empty | |
NotFoundException | - if column with name atColName does not exist | |
out_of_range | - if size of col is greater than the number of rows | |
out_of_range | - if column, which comes, in order, before the column with name atColName, is empty. |
void ITTable::FillColumn | ( | const string & | colName, | |
const vector< string > & | col | |||
) |
Fills a column with values.
[in] | colName | - the name of the column to be filled |
[in] | col | - contains the values which are to be used for filling. Filling starts at row index 0 and continues until size of col. |
Column with name colName must be present
The size of col must be less than or equal to the number of rows.
The column which comes, in order, before the column with name colName, must be non-empty. This is to prevent creation of non-rectangular tables.
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist | |
out_of_range | - if size of col is greater than the number of rows | |
out_of_range | - if column, which comes, in order, before the column with name colName, is empty. |
void ITTable::AppendToColumn | ( | const string & | colName, | |
const string & | cell | |||
) |
Appends one cell to the specified column.
[in] | colName | - the name of the column to which the cell is to be appended |
[in] | cell | - contains the value that is to be appended |
Column with name colName must be present
The column, which comes, in order, before the column with name colName, must be non-empty. This is to prevent creation of non-rectangular tables.
Cells in other columns of the, newly appended row, are set to empty values.
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist | |
out_of_range | - if column, which comes, in order, before the column with name colName, is empty. |
void ITTable::AppendToColumn | ( | const string & | colName, | |
const vector< string > & | col | |||
) |
Appends cells to the specified column.
[in] | colName | - the name of the column to which the cells are to be appended |
[in] | col | - contains the values which are to be appended. |
Column with name colName must be present
The column, which comes, in order, before the column with name colName, must be non-empty. This is to prevent creation of non-rectangular tables.
Cells in other columns of the, newly appended rows, are set to empty values.
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist | |
out_of_range | - if column, which comes, in order, before the column with name colName, is empty. |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const string & | colName | |||
) |
Retrieves column values.
[out] | col | - retrieved column values |
[in] | colName | - the name of the column which content is to be retrieved. |
Column with name colName must be present
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const string & | colName, | |||
const unsigned int | fromRowIndex, | |||
unsigned int | toRowIndex | |||
) |
Retrieves column values in the specified row range.
[out] | col | - retrieved values |
[in] | colName | - the name of the column which content is to be retrieved. |
[in] | fromRowIndex | - the row index of the first cell in the column to be retrieved. |
[in] | toRowIndex | - the row index of the last cell in the column to be retrieved. |
Column with name colName must be present
fromRowIndex must be less than or equal to the column length
toRowIndex must be less than or equal to the column length
fromRowIndex must be less than or equal to the toRowIndex
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist | |
out_of_range | - if fromRowIndex is greater than the column length | |
out_of_range | - if toRowIndex is greater than the column length | |
out_of_range | - if fromRowIndex is greater than toRowIndex |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const string & | colName, | |||
const vector< unsigned int > & | rowIndex | |||
) |
Retrieves column values in the specified rows.
[out] | col | - retrieved values |
[in] | colName | - the name of the column which content is to be retrieved |
[in] | rowIndices | - row indices of column cells to be retrieved |
Column with name colName must be present
Row indices in rowIndices must be less than or equal to the column length
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist | |
out_of_range | - if at least one row index in rowIndices is greater than the column length |
void ITTable::ClearColumn | ( | const string & | colName | ) |
Sets all cells in the column to empty string.
[in] | colName | - the name of the column |
Column with name colName must be present
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
void ITTable::DeleteColumn | ( | const string & | colName | ) |
Deletes a column from the table.
[in] | colName | - the name of the column |
Column with name colName must be present
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
unsigned int ITTable::GetNumRows | ( | ) | const [inline] |
Retrieves the number of rows in the table.
None |
None |
unsigned int ITTable::AddRow | ( | const vector< string > & | row = vector< string >(0) |
) |
Adds a row to the end of the table. For an empty table (0 rows), the number of inserted cells is equal to the number of table columns. For a non-empty table, the number of inserted cells is equal to the number of non-empty columns (this is in order to prevent creation of non-rectangular tables). The newly added row is, optionally, filled with values, starting at the first column.
[in] | row | - optional parameter that contains the values which are to be used to fill in the newly added row. If row is specified, filling starts at the first column and continues until size of row is reached. If row is not specified and table is empty, the newly inserted row is filled with empty values, where filling starts at the first column and continues until the number of columns is reached. If row is not specified and table is not empty, the newly inserted row is filled with empty values, where filling starts at the first column and continues until the number of non-empty columns is reached. |
If table is not empty and row is specified, the size of row must be less than or equal to the number of non-empty columns. This is in order to prevent creation of non-rectangular tables.
If table is empty and row is specified, the size of row must be less than or equal to the number of columns.
EmptyContainerException | - if table has no columns. | |
out_of_range | - if table is not empty and size of row is greater than the number of non-empty columns. | |
out_of_range | - if table is empty and size of row is greater than the number of columns. |
unsigned int ITTable::InsertRow | ( | const unsigned int | atRowIndex, | |
const vector< string > & | row = vector< string >(0) | |||
) |
Inserts a row at the specified row index and shifts, down by one, the old row and all other rows below it. For an empty table (0 rows), the number of inserted cells is equal to the number of table columns. For a non-empty table, the number of inserted cells is equal to the number of non-empty columns (this is in order to prevent creation of non-rectangular tables). The newly inserted row is optionally filled with values, starting at the first column.
[in] | atRowIndex | - index of the row at which the new row is to be inserted. Note: If atRowIndex is equal to the number of rows, the operation of this method is equivalent to AddRow(). |
[in] | row | - optional parameter that contains the values which are to be used to fill in the newly inserted row. If row is specified, filling starts at the first column and continues until size of row is reached. If row is not specified and table is empty, the newly inserted row is filled with empty values, where filling starts at the first column and continues until the number of columns is reached. If row is not specified and table is not empty, the newly inserted row is filled with empty values, where filling starts at the first column and continues until the number of non-empty columns is reached. |
atRowIndex must be greater than or equal to 0 and less than or equal to the number of table rows.
If table is not empty and row is specified, the size of row must be less than or equal to the number of non-empty columns. This is in order to prevent creation of non-rectangular tables.
If table is empty and row is specified, the size of row must be less than or equal to the number of columns.
Row indices, of the rows below the inserted row, are invalidated by being increased by one.
EmptyContainerException | - if table has no columns. | |
out_of_range | - if atRowIndex is greater than the number of table rows. | |
out_of_range | - if table is not empty and size of row is greater than the number of non-empty columns. | |
out_of_range | - if table is empty and size of row is greater than the number of columns. |
void ITTable::FillRow | ( | const unsigned int | rowIndex, | |
const vector< string > & | row | |||
) |
Fills, with values, a row at the specified row index, starting at the the first column.
[in] | rowIndex | - index of the row that is to be filled. |
[in] | row | - values which are to be used to fill in the row. Filling starts at the first column and continues until size of row is reached. |
The size of row must be less than or equal to the number of non-empty columns. This is in order to prevent creation of non-rectangular tables.
out_of_range | - if rowIndex is greater than or equal to the number of table rows. | |
out_of_range | - if size of row is greater than the number of non-empty columns. |
void ITTable::GetRow | ( | vector< string > & | row, | |
const unsigned int | rowIndex, | |||
const string & | fromColName = String::Empty , |
|||
const string & | toColName = String::Empty | |||
) |
Retrieves row values.
[out] | row | - retrieved row values |
[in] | rowIndex | - index of the row which values are to be retrieved. |
[in] | fromColName | - optional parameter which specifies the location of the first cell to be retrieved. If not specified the first column cell is used. |
[in] | toColName | - optional parameter which specifies the location of the last cell to be retrieved. If not specified the last non-empty-column cell is used. |
If fromColName is specified, the column with name fromColName must be present and must be non-empty
If toColName is specified, the column with name toColName must be present and must be non-empty
If fromColName is different than toColName, it must come prior to it in the column order.
out_of_range | - if rowIndex is greater than or equal to the number of table rows. | |
NotFoundException | - If fromColName is specified and column with name fromColName does not exist | |
NotFoundException | - If toColName is specified and column with name toColName does not exist | |
out_of_range | - If fromColName is specified and column with name fromColName exists but is empty | |
out_of_range | - If toColName is specified and column with name toColName exists but is empty | |
out_of_range | - if fromColName is different than toColName and it comes after it in the column order. |
void ITTable::ClearRow | ( | const unsigned int | rowIndex | ) |
Sets all cells in the row to empty string.
[in] | rowIndex | - index of the row that is to be cleared. |
out_of_range | - if rowIndex is greater than or equal to the number of table rows. |
void ITTable::DeleteRow | ( | const unsigned int | rowIndex | ) |
Deletes a row with the specified index and shifts, up by one, all other rows below it.
[in] | rowIndex | - index of the row that is to be deleted. |
Row indices of the rows which are below the deleted row are invalidated by being reduced by one.
out_of_range | - if rowIndex is greater than or equal to the number of table rows. |
void ITTable::DeleteRows | ( | const vector< unsigned int > & | rows | ) |
Deletes rows with specified indices.
[in] | rows | - indices of rows that are to be deleted. |
Row indices of the remaining rows are invalidated by being appropriatelly adjusted.
out_of_range | - if any row index in rows is greater than or equal to the number of table rows. |
unsigned int ITTable::GetLastRowIndex | ( | ) | [inline] |
Retrieves the row index of the last row in the table.
None |
None |
void ITTable::UpdateCell | ( | const unsigned int | rowIndex, | |
const string & | colName, | |||
const string & | value | |||
) |
Updates a cell in the table.
[in] | rowIndex | - row index of the cell that is to be updated |
[in] | colName | - the name of the column of the cell that is to be updated |
[in] | value | - the new value |
colName must be non-empty
Column with name colName must be present
out_of_range | - if rowIndex is greater than or equal to the number of table rows. | |
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
const string& ITTable::operator() | ( | const unsigned int | rowIndex, | |
const string & | colName | |||
) | const |
Retrieves a reference to the cell in the table.
[in] | rowIndex | - row index of the cell |
[in] | colName | - the name of the column of the cell |
colName must be non-empty
Column with name colName must be present
out_of_range | - if rowIndex is greater than or equal to the number of table rows. | |
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
void ITTable::SetFlags | ( | const string & | colName, | |
const unsigned char | flags | |||
) |
Sets column flags that are only used in column search. These flags control how cell values in a column are interpreted at the time of search. They can be interpreted as strings or integers, as case-sensitive or case-insensitive strings, as space-ignoring or space-non-ignoring strings. Multiple flags can be specified using "|" operator when invoking this method.
[in] | colName | - the name of the column |
[in] | flags | - column search flags. It can have any or multiple "or"-ed values of: DT_STRING, DT_INTEGER, CASE_SENSE, CASE_INSENSE, W_SPACE_SENSE, W_SPACE_INSENSE. |
Column with name colName must be present
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
unsigned char ITTable::GetDataType | ( | const string & | colName | ) |
Retrieves data type flag of a column.
[in] | colName | - the name of the column |
DT_INTEGER_VAL - if data type of a column is integer.
Column with name colName must be present
EmptyValueException | - if colName is empty | |
NotFoundException | - if column with name colName does not exist |
void ITTable::FindDuplicateRows | ( | vector< pair< unsigned int, unsigned int > > & | duplRows, | |
const vector< string > & | colNames, | |||
const bool | keepDuplRows, | |||
const eSearchDir | searchDir = eFORWARD | |||
) |
Finds duplicate rows and, optionally, deletes them.
[out] | duplRows | - vector of pairs of indices, where each pair indicates a row and its duplicate row |
[in] | colNames | - column names that are of inerest in determining duplicate rows. Note that determination of duplicate rows is not done based on all values in a row, but based on the cell values in the columns specified in this parameter. |
[in] | keepDuplRows | - indicates whether duplicate rows should be kept in the table (if true) or deleted (if false). |
[in] | searchDir | - optional parameter which specifies search direction. This parameter is only relevant when duplicate rows are deleted. If searchDir specifies forward search, the deleted duplicate rows will have bigger index than the original row. If searchDir specifies backward search, the deleted duplicate rows will have smaller index than the original row. |
Each column name in colNames must be present
EmptyValueException | - if one or more column names in colNames is empty | |
NotFoundException | - if one or more column names in colNames does not exist |
void ITTable::ValidateOptions | ( | unsigned int | colIndex | ) |
void ITTable::UpdateIndex | ( | const unsigned int | indexIndex, | |
const unsigned int | rowIndex | |||
) |
void ITTable::InsertIndexEntry | ( | const unsigned int | indexIndex, | |
const unsigned int | rowIndex | |||
) |
void ITTable::DeleteIndexEntry | ( | const unsigned int | indexIndex, | |
const unsigned int | rowIndex | |||
) |
void ITTable::VerifyColumnsIndices | ( | const vector< unsigned int > & | colIndices | ) |
int ITTable::FindIndex | ( | const vector< unsigned int > & | colIndices | ) |
int ITTable::SetFlags | ( | const unsigned char | newOpts, | |
const unsigned int | colIndex | |||
) |
unsigned int ITTable::FindFirst | ( | const vector< string > & | targets, | |
const vector< unsigned int > & | colIndices, | |||
const unsigned int | indexIndex | |||
) |
void ITTable::Search | ( | vector< unsigned int > & | res, | |
const vector< string > & | targets, | |||
const vector< unsigned int > & | colIndices, | |||
const unsigned int | indexIndex, | |||
const eSearchType | searchType = eEQUAL | |||
) |
void ITTable::DeleteIndex | ( | const unsigned int | indexIndex | ) |
void ITTable::Search | ( | vector< unsigned int > & | res, | |
const string & | target, | |||
const unsigned int | colIndex, | |||
const eSearchType | searchType = eEQUAL | |||
) |
void ITTable::FindDuplicateRows | ( | const vector< unsigned int > & | colIndices, | |
vector< pair< unsigned int, unsigned int > > & | duplRows, | |||
const bool | keep, | |||
const eSearchDir | searchDir = eFORWARD | |||
) |
void ITTable::RebuildIndex | ( | const unsigned int | indexIndex | ) |
void ITTable::InsertColumn | ( | const unsigned int | colIndex, | |
const vector< string > & | col = vector< string >(0) | |||
) |
void ITTable::InsertColumn | ( | const unsigned int | colIndex, | |
vector< string >::const_iterator | colBeg, | |||
vector< string >::const_iterator | colEnd | |||
) |
void ITTable::Clear | ( | ) |
const string & ITTable::operator() | ( | const unsigned int | rowIndex, | |
const unsigned int | colIndex | |||
) | const |
int ITTable::UpdateCell | ( | const string & | cell, | |
const unsigned int | colIndex, | |||
const unsigned int | rowIndex | |||
) |
void ITTable::FillColumn | ( | const vector< string > & | col, | |
const unsigned int | colIndex | |||
) |
void ITTable::FillColumn | ( | const unsigned int | colIndex, | |
vector< string >::const_iterator | colBeg, | |||
vector< string >::const_iterator | colEnd | |||
) |
void ITTable::AppendToColumn | ( | const unsigned int | colIndex, | |
const vector< string > & | col | |||
) |
void ITTable::AppendToColumn | ( | const unsigned int | colIndex, | |
const string & | cell | |||
) |
void ITTable::CreateColumn | ( | const unsigned int | atColIndex, | |
const vector< string > & | col = vector< string >(0) | |||
) |
void ITTable::CreateColumn | ( | const unsigned int | atColIndex, | |
vector< string >::const_iterator | colBeg, | |||
vector< string >::const_iterator | colEnd | |||
) |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const unsigned int | colIndex, | |||
const unsigned int | fromRowIndex, | |||
unsigned int | toRowIndex | |||
) |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const unsigned int | colIndex, | |||
const vector< unsigned int > & | rowIndex | |||
) |
void ITTable::ClearColumn | ( | const unsigned int | colIndex | ) |
void ITTable::DeleteColumn | ( | const unsigned int | colIndex | ) |
void ITTable::GetColumn | ( | vector< string > & | col, | |
const unsigned int | colIndex | |||
) |
void ITTable::GetRow | ( | vector< string > & | row, | |
const unsigned int | rowIndex, | |||
const unsigned int | fromColIndex, | |||
unsigned int | toColIndex | |||
) |
const vector< string > & ITTable::GetRow | ( | const unsigned int | rowIndex | ) |
ITTable::eOrientation ITTable::GetOrientation | ( | ) |
void ITTable::CreateIndex | ( | const vector< unsigned int > & | colIndices, | |
const unsigned int | unique = 0 | |||
) |
void ITTable::SetSerializer | ( | Serializer * | ser | ) |
Utility method, not part of users public API.
int ITTable::WriteObject | ( | Serializer * | ser, | |
int & | size | |||
) |
Utility method, not part of users public API.
int ITTable::GetObject | ( | UInt32 | index, | |
Serializer * | ser | |||
) |
Utility method, not part of users public API.
int ITTable::Read | ( | unsigned int | indexInFile, | |
Serializer * | ser | |||
) |
Utility method, not part of users public API.
int ITTable::Write | ( | Serializer * | ser, | |
int & | size | |||
) |
Utility method, not part of users public API.
void ITTable::RebuildIndices | ( | ) |
Utility method, not part of users public API.
void ITTable::InsertEntry | ( | const unsigned int | rowIndex | ) |
void ITTable::DeleteEntry | ( | const unsigned int | rowIndex | ) |
unsigned int ITTable::GetNumIndices | ( | ) | [inline] |
Utility method, not part of users public API.
void ITTable::GetColumn | ( | vector< string > & | col, | |
const unsigned int | colIndex, | |||
const unsigned int | indexIndex | |||
) |
Utility method, not part of users public API.
bool ITTable::AreListsOfColumnsValid | ( | const vector< unsigned int > & | colIndices | ) | [private] |
void ITTable::CreateKey | ( | const vector< unsigned int > & | colIndices | ) | [private] |
void ITTable::Init | ( | ) | [private] |
StringCompare::eCompareType ITTable::GetCompareType | ( | const vector< unsigned int > & | colIndices | ) | [private] |
string ITTable::CellValue | ( | const unsigned int | colIndex, | |
const unsigned int | rowIndex | |||
) | [private] |
string ITTable::ConvertString | ( | const string & | value, | |
const unsigned int | colIndex | |||
) | [private] |
string ITTable::MultiStringsValue | ( | const vector< string > & | values, | |
const vector< unsigned int > & | colIndices | |||
) | [private] |
string ITTable::SubRowValue | ( | const vector< unsigned int > & | colIndices, | |
const unsigned int | rowIndex | |||
) | [private] |
string ITTable::AggregateRow | ( | const vector< unsigned int > & | colIndices, | |
const unsigned int | rowIndex | |||
) | [private] |
void ITTable::AppendToAndDelimit | ( | string & | to, | |
const string & | appending | |||
) | [inline, private] |
string ITTable::CreateInternalIndexName | ( | const unsigned int | indexIndex | ) | [private] |
void ITTable::ClearIndex | ( | const unsigned int | indexIndex | ) | [private] |
void ITTable::UpdateIndices | ( | const unsigned int | rowIndex | ) | [private] |
void ITTable::ClearIndices | ( | ) | [private] |
bool ITTable::IsColumnInIndex | ( | const unsigned int | indexIndex, | |
const unsigned int | colIndex | |||
) | [private] |
int ITTable::FindKeyIndex | ( | ) | [private] |
void ITTable::UpdateColListOnColInsert | ( | const unsigned int | colIndex | ) | [private] |
void ITTable::UpdateColListOnColDelete | ( | const unsigned int | colIndex | ) | [private] |
void ITTable::UpdateIndicesOnCellUpdate | ( | const unsigned int | rowIndex, | |
const unsigned int | colIndex | |||
) | [private] |
void ITTable::ConvertToInt | ( | const string & | a, | |
string & | ret | |||
) | [private] |
void ITTable::ConvertDouble | ( | const string & | a, | |
string & | ret | |||
) | [private] |
void ITTable::ConvertToLowerNoWhiteSpace | ( | const string & | a, | |
string & | ret | |||
) | [private] |
void ITTable::Print | ( | unsigned int | indexIndex | ) | [private] |
const unsigned char ITTable::DT_STRING_VAL = 1 [static] |
const unsigned char ITTable::DT_INTEGER_VAL = 2 [static] |
const unsigned char ITTable::CASE_SENSE = 0x00 [static] |
const unsigned char ITTable::CASE_INSENSE = 0x01 [static] |
const unsigned char ITTable::W_SPACE_SENSE = 0x00 [static] |
const unsigned char ITTable::W_SPACE_INSENSE = 0x02 [static] |
const unsigned char ITTable::DT_STRING = DT_STRING_VAL << 4 [static] |
const unsigned char ITTable::DT_INTEGER = DT_INTEGER_VAL << 4 [static] |
const unsigned int ITTable::EXPONENT = 4 [static, private] |
const unsigned int ITTable::MAX_PRECISION = DBL_DIG [static, private] |
const unsigned int ITTable::MANTISSA = MAX_PRECISION + 2 [static, private] |
const unsigned int ITTable::INT_LIMIT = 11 [static, private] |
const unsigned char ITTable::DT_MASK = 15 << 4 [static, private] |
const unsigned char ITTable::SC_MASK = 0x01 [static, private] |
const unsigned char ITTable::WS_MASK = 0x02 [static, private] |
const unsigned char ITTable::LAST_DT_VALUE = 3 [static, private] |
const unsigned int ITTable::DEFAULT_PRECISION = MAX_PRECISION [static, private] |
const unsigned char ITTable::DEFAULT_OPTIONS [static, private] |
TTable ITTable::_ttable [private] |
eOrientation ITTable::_orient [private] |
Serializer* ITTable::_ser [private] |
vector<unsigned char> ITTable::_compare_opts [private] |
vector<vector<unsigned int> > ITTable::_listsOfColumns [private] |
vector<unsigned int> ITTable::_unique [private] |
vector<tIndex> ITTable::_indices [private] |