TTkTableModelSQLite3

class TTkTableModelSQLite3(*, fileName: str, table: str)

Bases: TTkAbstractTableModel

TTkTableModelSQLite3 extends TTkAbstractTableModel, allowing to map an sqlite3 table to this table model

Quickstart:

In This example i assume i have a database named sqlite.database.db which contain a table users

Please refer to test.ui.032.table.10.sqlite.py for working eample.

import TermTk as ttk

filename='sqlite.database.db'
tablename='users'

root = ttk.TTk(mouseTrack=True, layout=ttk.TTkGridLayout())

basicTableModel = ttk.TTkTableModelSQLite3(fileName=filename, table=tablename)
table = ttk.TTkTable(parent=root, tableModel=basicTableModel, sortingEnabled=True)
table.resizeColumnsToContents()

root.mainloop()

Parameters:

• fileName (str) – the sqlite3 file database

• table (str) – the name of the sqlite3 table to be mapped

Signals

dataChanged

This signal is emitted whenever the data in an existing item changes.

Members

dataChanged: pyTTkSignal

This signal is emitted whenever the data in an existing item changes.

If more items are affected, the pos/size definne the minimum area including all of those changes.

When reimplementing the setData() function, this signal must be emitted explicitly.

Parameters:

• pos (tuple(int,int)) – the topLeft margin of the modified area

• size (tuple(int,int)) – the size of the modified area

Methods

columnCount() → int

Returns the number of columns of the current moodel.

Returns:

int

data(row: int, col: int) → None

Returns the data stored for the item referred to by the row/column.

Note: If you do not have a value to return, return None instead of returning 0.

Parameters:

• row (int) – the row position of the data

• col (int) – the column position of the data

Returns:

object

flags(row: int, col: int) → ItemFlag

Returns the item flags for the given row,column.

The base class implementation returns a combination of flags that enables the item (ItemIsEnabled) and allows it to be selected (ItemIsSelectable).

Parameters:

• row (int) – the row position od the data

• col (int) – the column position of the data

Returns:

TTkConstant.ItemFlag

headerData(num: int, orientation: int)

Returns the data for the given role and section in the header with the specified orientation.

For horizontal headers, the section number corresponds to the column number. Similarly, for vertical headers, the section number corresponds to the row number.

Parameters:

• pos (int) – the position (col or row) of the header

• orientation (TTkConstant.Direction) – the orienttin of the header to be retrieved

Returns:

TTkString

index(row: int, col: int) → TTkModelIndex

Returns the index of the item in the model specified by the given row, column.

Parameters:

• row (int) – the row position of the index

• col (int) – the column position of the index

Returns:

TTkModelIndex

rowCount() → int

Returns the number of rows of the current model.

Returns:

int

setData(row: int, col: int, data: object) → None

Returns true if successful; otherwise returns false.

The dataChanged() signal should be emitted if the data was successfully set.

The base class implementation returns false. This function and data() must be reimplemented for editable models.

Parameters:

• row (int) – the row position of the data

• col (int) – the column position of the data

• data (object) – the data to be set in the (row,col) position of the table

Returns:

bool

sort(column: int, order: SortOrder) → None

Sorts the model by column in the given order.

Parameters:

• column (int) – The column index to be sorted, if -1 is provided the original unsorted order is used.

• order (TTkConstant.SortOrder) – the sorting order