TableModel Class Reference

The TableModel class handles boolean and datetime columns in a custom way. More...

#include <TableModel.h>

Inheritance diagram for TableModel:

Public Member Functions
void	addBooleanColumn (int column)
void	addDateTimeColumn (int column)
QVariant	data (const QModelIndex &index, int role=Qt::DisplayRole) const override
Qt::ItemFlags	flags (const QModelIndex &index) const override
bool	setData (const QModelIndex &index, const QVariant &value, int role) override
	TableModel (QObject *parent=nullptr, QSqlDatabase db=QSqlDatabase())
	~TableModel () override

Private Attributes
QVector< int >	m_booleanColumns
QVector< int >	m_dateTimeColumns

Detailed Description

The TableModel class handles boolean and datetime columns in a custom way.

Definition at line 40 of file TableModel.h.

Constructor & Destructor Documentation

TableModel()

TableModel::TableModel	(	QObject *	parent = nullptr,
		QSqlDatabase	db = QSqlDatabase() )

Definition at line 91 of file TableModel.cpp.

    : QSqlRelationalTableModel(parent, db)
{
    this->setEditStrategy(QSqlTableModel::OnFieldChange);
}

~TableModel()

TableModel::~TableModel ( )

override

Definition at line 97 of file TableModel.cpp.

{
 
}

Member Function Documentation

addBooleanColumn()

void TableModel::addBooleanColumn

(

int

column

)

Definition at line 159 of file TableModel.cpp.

{
    m_booleanColumns << column;
}

References m_booleanColumns.

addDateTimeColumn()

void TableModel::addDateTimeColumn

(

int

column

)

Definition at line 154 of file TableModel.cpp.

{
    m_dateTimeColumns << column;
}

References m_dateTimeColumns.

data()

QVariant TableModel::data ( const QModelIndex & index, int role = Qt::DisplayRole ) const

override

Definition at line 102 of file TableModel.cpp.

{
    QVariant d = QSqlRelationalTableModel::data(index, role);
    if (role == Qt::DisplayRole) {
        if (m_dateTimeColumns.contains(index.column())) {
            return QDateTime::fromSecsSinceEpoch(d.toInt()).toString();
        } else if (m_booleanColumns.contains(index.column())) {
            return {};
        }
    }
    else if (role == Qt::CheckStateRole) {
        if (m_booleanColumns.contains(index.column())) {
            if (d.toInt() == 0) {
                return Qt::Unchecked;
            }
            else {
                return Qt::Checked;
            }
        }
        return {};
    }
    return d;
}

References m_booleanColumns, and m_dateTimeColumns.

flags()

Qt::ItemFlags TableModel::flags ( const QModelIndex & index ) const

override

Definition at line 144 of file TableModel.cpp.

{
    Qt::ItemFlags f = QSqlRelationalTableModel::flags((index));
    if (m_booleanColumns.contains(index.column())) {
        f |= Qt::ItemIsUserCheckable;
    }
    return f;
 
}

References m_booleanColumns.

setData()

bool TableModel::setData ( const QModelIndex & index, const QVariant & value, int role )

override

Definition at line 126 of file TableModel.cpp.

{
    if (m_booleanColumns.contains(index.column()) && role == Qt::CheckStateRole) {
        // Writing the data when the check box is set to checked.
        if (value == Qt::Checked) {
            // Let's write the new value
            return QSqlTableModel::setData(index, 1, Qt::EditRole);
            // Writing the data when the check box is set to unchecked
        } else if (value == Qt::Unchecked) {
            // Let's write the new value
            return QSqlTableModel::setData(index, 0, Qt::EditRole);
        }
    }
 
    bool response = QSqlTableModel::setData(index, value, role);
    return response;
}

References m_booleanColumns, and value().

Member Data Documentation

m_booleanColumns

QVector<int> TableModel::m_booleanColumns

private

Definition at line 56 of file TableModel.h.

m_dateTimeColumns

QVector<int> TableModel::m_dateTimeColumns

private

Definition at line 57 of file TableModel.h.

---

The documentation for this class was generated from the following files:

• plugins/extensions/dbexplorer/TableModel.h
• plugins/extensions/dbexplorer/TableModel.cpp