tabularview_models

Spine Toolbox grid view

author:

16. Vennström (VTT)

date:

1.11.2018

Module Contents

class tabularview_models.PivotModel

rows

columns

clear_track_data(self)

clears data that is tracked

set_new_data(self, data, index_names, index_type, rows=(), columns=(), frozen=(), frozen_value=(), index_entries=None, valid_index_values=None, tuple_index_entries=None, used_index_values=None, index_real_names=None)

set the data of the model, index names and any additional indexes that don’t have data, valid index values.

static _is_invalid_pivot(rows, columns, frozen, frozen_value, index_names)

checks if given pivot is valid for index_names, returns str with error message if invalid else None

_change_index_frozen(self)

Filters out data with index values in index_frozen

_index_key_getter(self, names_of_index)

creates a itemgetter that always returns tuples from list of index names

_get_unique_index_values(self, index, filter_index, filter_value)

Finds unique index values for index names in index filtered by index names in filter_index with values in filter_value

set_pivot(self, rows, columns, frozen, frozen_value)

Sets pivot for current data

set_frozen_value(self, value)

Sets the value of the frozen indexes

static _index_entries_without_data(pivot_index, pivot_set, filter_index, filter_value, tuple_index_entries)

find values in tuple_index_entries that are not present in pivot_set for index in pivot index filtered by filter_index and filter_value

get_pivoted_data(self, row_mask, col_mask)

gets data from current pivot with indexes in row_mask and col_mask

set_pivoted_data(self, data, row_mask, col_mask)

paste list of lists into current pivot, no change of indexes, row_mask list of indexes where to paste data rows in current pivot col_mask list of indexes where to paste data columns in current pivot

_add_index_value(self, value, name)

_delete_data(self, key)

_add_data(self, key, value)

_restore_data(self, key)

row(self, row)

column(self, col)

restore_pivoted_values(self, indexes)

Restores all values for given indexes

delete_pivoted_values(self, indexes)

Deletes values for given indexes

delete_tuple_index_values(self, delete_tuples)

deletes values from keys with combination of indexes given that match tuple_index_entries

delete_index_values(self, delete_indexes)

delete one ore more index value from data

_data_to_header(self, data, start_index, index_values, index_names, mask, direction)

paste_data(self, row_start=0, row_header_data=None, col_start=0, col_header_data=None, data=None, row_mask=None, col_mask=None)

Paste a list of list into current view of AbstractTable

edit_index(self, new_index, index_mask, direction)

Edits the index of either row or column

is_valid_index(self, index, index_name)

checks if if given index value is a valid value for given index

is_valid_key(self, key, existing_keys, key_names)

Checks if given key (combination of indexes) is valid

class tabularview_models.PivotTableModel(parent=None)

Bases: PySide2.QtCore.QAbstractTableModel

index_entries_changed

plot_x_column

Returns the index of the column designated as Y values for plotting or None.

set_data(self, data, index_names, index_type, rows=(), columns=(), frozen=(), frozen_value=(), index_entries=None, valid_index_values=None, tuple_index_entries=None, used_index_values=None, index_real_names=None)

set_pivot(self, rows, columns, frozen, frozen_value)

set_frozen_value(self, frozen_value)

delete_values(self, indexes)

delete_index_values(self, keys_dict)

delete_tuple_index_values(self, tuple_key_dict)

restore_values(self, indexes)

get_key(self, index)

get_col_key(self, column)

paste_data(self, index, data, row_mask, col_mask)

paste data into pivot model

_indexes_to_pivot_index(self, indexes)

_update_header_data(self)

updates the top left corner ‘header’ data

first_data_row(self)

Returns the row index to the first data row.

dataRowCount(self)

number of rows that contains actual data

dataColumnCount(self)

number of columns that contains actual data

rowCount(self, parent=QModelIndex())

Number of rows in table, number of header rows + datarows + 1 empty row

columnCount(self, parent=QModelIndex())

Number of columns in table, number of header columns + datacolumns + 1 empty columns

flags(self, index)

Roles for data

index_in_top_left(self, index)

check if index is in top left corner, where pivot names are displayed

index_in_data(self, index)

check if index is in data area

index_in_column_headers(self, index)

check if index is in column headers (horizontal) area

index_in_row_headers(self, index)

check if index is in row headers (vertical) area

set_plot_x_column(self, column, is_x)

Sets or clears the Y flag on a column

set_index_key(self, index, value, direction)

edits/sets a index value in a index in row/column

setData(self, index, value, role=Qt.EditRole)

data(self, index, role=Qt.DisplayRole)

headerData(self, section, orientation, role=Qt.DisplayRole)

data_color(self, index)

class tabularview_models.PivotTableSortFilterProxy(parent=None)

Bases: PySide2.QtCore.QSortFilterProxyModel

set_filter(self, index_name, filter_value)

clear_filter(self)

accept_index(self, index, index_names)

delete_values(self, delete_indexes)

restore_values(self, indexes)

paste_data(self, index, data)

filterAcceptsRow(self, source_row, source_parent)

Returns true if the item in the row indicated by the given source_row and source_parent should be included in the model; otherwise returns false. All the rules and subrules need to pass.

filterAcceptsColumn(self, source_column, source_parent)

Returns true if the item in the column indicated by the given source_column and source_parent should be included in the model; otherwise returns false.

class tabularview_models.FilterCheckboxListModel(parent=None, show_empty=True)

Bases: PySide2.QtCore.QAbstractListModel

reset_selection(self)

_select_all_clicked(self)

_is_all_selected(self)

rowCount(self, parent=QModelIndex())

data(self, index, role=Qt.DisplayRole)

click_index(self, index)

set_list(self, data, all_selected=True)

add_item(self, items, selected=True)

set_selected(self, selected, select_empty=None)

get_selected(self)

get_not_selected(self)

set_filter(self, search_for)

apply_filter(self)

_remove_and_add_filtered(self)

_remove_and_replace_filtered(self)

remove_filter(self)

remove_items(self, items)