QStandardItemModel to sqlite database table

[sattu]

hi everyone,
I am trying to insert the data present in a QStandardItemModel.I have to set that data into a table present in sqlite database.I tried like below

QSqlTableModel table(0,db_local);
table.setTable("menu_list");
table.setEditStrategy(QSqlTableModel::OnManualSubmit);
for(i=0;i<model->rowCount();i++)
{
        table.insertRow(i);
        for(j=0;j<model->columnCount();j++)
        ok=  table.setData(table.index(i,j),model->data(model->index(i,j)));
}

QSqlTableModel table(0,db_local);
table.setTable("menu_list");
table.setEditStrategy(QSqlTableModel::OnManualSubmit);
for(i=0;i<model->rowCount();i++)
{
        table.insertRow(i);
        for(j=0;j<model->columnCount();j++)
        ok=  table.setData(table.index(i,j),model->data(model->index(i,j)));
}

To copy to clipboard, switch view to plain text mode 

In QSqlTableModel the required value is present.
But in database nothing is there.
Is there any other statement required to update the table inside database?
plz help me.

thanks

[wysota]

Get rid of line #3 in the above snippet.

[sattu]

thanks for reply.
if i remove the line 3 then table.insertRow(i) returns false.
this things was working for QSqlQUeryModel.

[wysota]

If it returns false then there has to be a reason for it. What exactly are you trying to do?

[sattu]

I have a xml string whoch contain data of a table.I want to insert that data in a table.
so first i inserted all data into QStandardItemModel .Now i have to insert the data into table.
Is there any other way to do this?

[wysota]

So why did you insert it to QStandardItemModel in the first place? Also does your sql table have a primary key defined?

[sattu]

No there is no primary key.Is there any other way to extract data? this is the only way which i know.
If there is any other easy plz suggest me.

[wysota]

If there is no primary key defined then I don't see how you would want to insert rows into the database.

[sattu]

I did not get you.Actually here primary key is not necessary.Is primary key necessary?

[wysota]

If you wish to say "insert me a new row" and then "set data on row X" how should the database know which row is "X"?

[sattu]

ok then how i will do this.plz tel me.

now i tried like below.but same thing.(means not working).

for(i=0;i<model->rowCount();i++)
    {
        QSqlRecord rec;
        for(j=0;j<model->columnCount();j++)
        {
            QSqlField field;
            field.setValue(model->data(model->index(i,j)));
            field.setName(model->headerData(j,Qt::Horizontal).toString());;
            rec.append(field);
        }
        ok=table->insertRecord(i,rec);
    }

for(i=0;i<model->rowCount();i++)
    {
        QSqlRecord rec;
        for(j=0;j<model->columnCount();j++)
        {
            QSqlField field;
            field.setValue(model->data(model->index(i,j)));
            field.setName(model->headerData(j,Qt::Horizontal).toString());;
            rec.append(field);
        }
        ok=table->insertRecord(i,rec);
    }

To copy to clipboard, switch view to plain text mode