How to create a db and display it into a treeview? (Advice)

[MikhailG]

Hello!
I can not decide or convince myself which approach I should learn or inspect.
In genereal I have an app which has a settings page with a strcuture of a tree.
Like:
It is rough example of what I would like to implement.

• car
  • speed - 20
  • weight - 100
• bycicle
  • grils bike
    • color - red
    • color - pink
  • boys bike
    • color - black
    • color - green

All that data I want to put into a db. Than display it and edit.

What I have for now are TreeModel derived from QAbstractItemModel and TreeNode. Data for my TreeModel I populate manually
like: TreeModel.nodesList.append("bike", "red") etc.
But I would like to load the data from the db and put it into a TreeNode.
Please put me in a right direction. Advice on how to make it would be great!
Thank you.

[SGaist]

Hi,

A QSqlTableModel with a QAbstractProxyModel comes to mind. The former to get the data from your database, the later to turn in into a tree structure.

Otherwise, you can use QSqlQuery to extract the data from your database and put it in your TreeModel which is the fast and easy way.