QSqlTableModel::setData() works but it does not do any change to the database

[oMerry]

My purpose ：
I have a table in my database with column 'gender'.
And I set the type int for column 'gender', so it can only store integer like 0, 1 in the database.
But I don't want to display gender with 0 or 1 in my application, or modify the gender with 0 or 1.

My solution:
I override the functions QSqlTableModel::setData() and QSqlTableModel::data(),
in my class class MyTableModel : public QSqlTableModel.

   QVariant data(const QModelIndex &idx,
                  int role = Qt::DisplayRole) const {

        if (idx.column() == 2) {
            QVariant var = QSqlTableModel::data(idx, role);
            qDebug() << "var : " << var.toString();
            if (var.toInt() == 0) {
                return QVariant("female");
            }
            else {
                return QVariant("male");
            }
        }
        return QSqlTableModel::data(idx, role);
    }

    bool setData(
            const QModelIndex &index,
            const QVariant &value,
            int role = Qt::EditRole){

       if (index.column() == 2) {
           int newValue = value.toString() == "female" ?
                       0 : 1;
           return QSqlTableModel::setData(index, newValue, role);
       }
       // column() != 2
       else {
            return QSqlTableModel::setData(index, value, role);
       }
    }

This code is wrong, but I have try my best.
I am to new to Qt, I just can't make it right.
I don't know how to override these functions or maybe there is another solution?

Can someone help me?

[SGaist]

Hi and welcome to devnet,

No need to alter the model. You should create a custom QStyledItemDelegate that will handle that part.