How to save the content from a QTreeWidget (tree structure, model) to database

[whitefurrows]

Hi

how can i save and load the items for a QTreeWidget(TreeModel) line by line. My current table looks like this(ListModel):

CREATE TABLE tree
(
	ID integer NOT NULL  PRIMARY KEY AUTOINCREMENT, 
	entries varchar (50) NOT NULL 
);

CREATE TABLE tree
(
	ID integer NOT NULL  PRIMARY KEY AUTOINCREMENT, 
	entries varchar (50) NOT NULL 
);

To copy to clipboard, switch view to plain text mode 

and i load it by

QTreeWidgetItem* item;
for (int i=0; i<allEntries.size(); i++)
{
 	item=new QTreeWidgetItem(ui.treeWidget);
	item->setText(0, allEntries.at(i).getName());
}

QTreeWidgetItem* item;
for (int i=0; i<allEntries.size(); i++)
{
 	item=new QTreeWidgetItem(ui.treeWidget);
	item->setText(0, allEntries.at(i).getName());
}

To copy to clipboard, switch view to plain text mode 

Now i want add a field (index) to my database, and store the the current TreeModel-Index within to add rows under a row. How can i do that?

[wysota]

Iterate over the tree and run an INSERT statement for each item you traverse.

[whitefurrows]

What is the value(index) for my INSERT statement if i iterate over the tree?

ui.treeWidget->selectionModel()->currentIndex().row()

ui.treeWidget->selectionModel()->currentIndex().row()

To copy to clipboard, switch view to plain text mode 

I think thats not the right value if my model looks like this:


Should i use nested sets-modell and is that easy to handle with a QTreeWidget?

[wysota]

You surely can't save a hierarchical model into a database that doesn't provide any means to store information about the relationship between items. Furthermore it seems your "tree" is "flat", based on the code snippet you provided. Anyway, the minimal sql table needed to store hierarchical data consists of three columns -- id of the element, data of the element and id of the parent of the element. Then it's just a matter of recursing into the tree and storing that information in the database.

[whitefurrows]

Shold i store the id of the element, data of the element and id of the parent of the element into one database field or into three?

What is the common way to load the tree?

[wysota]

Shold i store the id of the element, data of the element and id of the parent of the element into one database field or into three?

If you are asking this question then I suggest you get familiar with the concept or relational databases before trying to use one.

[whitefurrows]

Hi,

sorry for my bad english, but i have understand the concept of relational databases. I have start my first try to create a tree structure. It looks good but only one problem exist. The tree should look like this:


but that is the result



from this table



The tree was build with this function

addTree(0);
 
void MyWidget::addTree(const int id)
{
    QList<Entries*> folders = db->getEntries(id);
    MyTreeWidgetItem* item;
 
    foreach(Entries* obj, folders)
    {
        if(obj->getParentID())
        {
            item=new MyTreeWidgetItem(treeWidget->currentItem());
        }
        else
        {
            item=new MyTreeWidgetItem(treeWidget);
        }
 
        item->setEntries(obj);
        item->setText(0, obj->getName());
        item->setIcon(0, QIcon(":/folder.ico") );
        treeWidget->setCurrentItem(item);
 
        addNodes(obj->getID());
    }
}

addTree(0);

void MyWidget::addTree(const int id)
{
    QList<Entries*> folders = db->getEntries(id);
    MyTreeWidgetItem* item;

    foreach(Entries* obj, folders)
    {
        if(obj->getParentID())
        {
            item=new MyTreeWidgetItem(treeWidget->currentItem());
        }
        else
        {
            item=new MyTreeWidgetItem(treeWidget);
        }

        item->setEntries(obj);
        item->setText(0, obj->getName());
        item->setIcon(0, QIcon(":/folder.ico") );
        treeWidget->setCurrentItem(item);

        addNodes(obj->getID());
    }
}

To copy to clipboard, switch view to plain text mode 

I think the problem is i set every time the current item to the QTreeWidget. I don't known what the right criteria to do that. Can you help me please?