how to use QTreeView with Database model

[mikro]

i understand that i will have to structure my data in a way that it makes sense in a tree.
The data came in the form of
01|NULL|NULL|Text
01|01|NULL|Text
01|01|01|Text
01|01|02|Text

so it makes sense to show it in a Tree but i doubt that if i send a tablemodel with this data to the QTreeView Object it will be able to work with that.
Do i need to build a nested set or do i need to have a parent id in some column or how else do i need to prepare my data to give it to the tree?


btw: what i meant with the QDir was the QDirModel which is always used to explain the QTreeView, as in http://doc.trolltech.com/4.0/qtreeview.html
and no i don't want to use this i hope to be able to use a QSqlQueryModel or something like that.

[wysota]

You should be able to do this quickly using a two layered model. Lower layer should be QSqlTableModel or QSqlQueryModel and on top of that you'd have to implement a proxy model which will map indexes from the sql model to a tree structure (see docs for the proxy model for details).