QSqlTableModel

JonB

QStyledItemDelegate::displayText does its own conversion off data(DisplayRole) it never cares about EditRole

That is very interesting. So when (for right or for wrong) I made my data(DisplayRole) of a floating produce the format I wanted (f format, 2 decimal places) as a string, displayText saw a string instead of a number and passed it through without its own formatting, that's why it came out as it did.

I know about the spreadsheet case. It is "unusual", compared to 99% of cases. I thought DisplayRole was supposed to return the desired string for the default way you wanted the data output, hence why I did it that way for the floating point numbers. I think it was the very first area I did with Qt/PyQt, and I didn't know what you are saying now.

Although I know this conversation has been long, I hope @Xilit, the OP, won't mind as it's actually useful for him to see this stuff.

So my last question to @VRonin is: why are there all the other "presentational" roles (FontRole, TextAlignmentRole, ForegroundRole etc.)? If you are so keen that "The model [...] never cares about how it is represented to the user", why do you let the model provide/handle those? Even worse, data() returns types like QFont and QBrush for these (not even just a "symbolic" indicator), which is all to do with the presentation to the user.

VRonin

Those roles are still pure data. It's the delegate responsibility to use them. The model suggest the delegate how to align stuff but it's still the delegate responsibility to do it and it can ignore them altogether.

Xilit

@JonB said in QSqlTableModel:

I hope @Xilit, the OP, won't mind as it's actually useful for him to see this stuff.

Nope! Of course I don't mind! Rather I vote for this disscusion! It is really useful information. I'll read all this stuff very carefully after I read all information about model by links above. Then I'll read this comments because I never understand DisplayRole properly.((

Xilit

There are really tons of information on tutorials.))) In order not to sink there I decided to start my project from scretch and make this tutorial step by step. But now I stand at a crossroads what project architecture should I choose. I prepare one picture for you to show you what I mean.

I want to choose scheme number 6 and implement it in my project. I need universal solution to show tables from DB and lists in future. Maybe list, I'm not sure, that's why I want to create universal model (if it's possible). But for now I want to show table to user with my data from database table.

If it's not to hard for you to say what scheme (1-6) is incorrect at all and what scheme is preferable to implement in my situation.

Thank you!

Xilit

Emmm... Guys? Are you here? Is this topic is overloaded? Should I opened new one?

SGaist

Follow the chain up, QSqlTableModel is already a subclass of QAbstractTableModel.

As for the delegate, it's a QStyledItemDelegate that is used by default by the view to render the table's content.

Xilit

@SGaist

"QStyledItemDelegate that is used by default by the view"

Yes I know that. Tutorial says that if I want to make my own view I need to reimplement QStyledItemDelegate by sybclassing it. If you see what @VRonin said me to do is:
"Just subclass QStyledItemDelegate and override displayText:". So does this scheme correct?

P.S. Sorry for my persistance but tommorow I start working with my project so I want to understand all the details. Thank you!

SGaist

No, QStyledItemDelegate is at the view level, or maybe between the view and the model since it uses it to render something from the data in the model.

Xilit

@SGaist

Yes it is clear. My main question is where should I connect (pass) my delegat? I created MyDelegate.cpp, describe what I want and then pass it / connect it in QSqlTableModel.cpp? That I discribed in scheme above. This is the simpliest case. Of course there is another possibility to create MyClass.cpp and pass to this class my model and delegate, but now I'm talking about simple one. If all my app is just show info from DB can I pass my delegate to QSqlTableModel.cpp?

SGaist

The delegate has nothing to do directly with the model. You set the delegate on the view with setItemDelegate or one of its more precise sibling.

Xilit

@SGaist

Ok, thank you!