Get content of cell from QTableView

[Karoluss96]

It take only the first record from selected row, wheras I need all data from selected row, which later I want to put (separatly one-by-one) to a sql question

[JonB]

@Karoluss96 said in Get content of cell from QTableView:

It take only the first record from selected row

Careful with words, you mean column not record. So look at your 0 argument which only fetches the data for column 0, and write code to pick up all the columns in the row if that is what you want....

[Karoluss96]

Maybe some loop will be good?

[JonB]

@Karoluss96 I would think that would indeed be a good idea if you want to get the content of each column :)

[Karoluss96]

Now I have:

data= self.dlg.tableView_3.model().index(self.dlg.tableView_3.selectionModel().currentIndex().row(),0)
dane=data.data()
       for i in data:
           data=self.model4.selectIndex(i)
           print (data)

but it get error: 'QModelIndex' object is not iterable

[JonB]

@Karoluss96
This is wrong. Your data variable is a single data index item, you can't go for i in data. Please look at the documentation for correct usage of QVariant QAbstractItemModel::data(const QModelIndex &index, int role = Qt::DisplayRole) const or QVariant QModelIndex::data(int role = Qt::DisplayRole) const

[Karoluss96]

hmm, so maybe the the whole row at begin in loop?

[JonB]

@Karoluss96
I really should not have to tell you this! If you want to allow for picking all the columns in a row even if just one cell is selected (so you can't only look at selected cells) you will want something like:

row = self.dlg.tableView_3.selectionModel().currentIndex().row()
model = self.dlg.tableView_3.model()
for col in range(model.columnCount()):
    print(model.index(row, col).data())
# Or I think you can do this in Python:
rowData = [ model.index(row, col).data() for col in range(model.columnCount()) ]
print(rowData)

[Karoluss96]

@JonB said in Get content of cell from QTableView:

self.dlg.tableView_3.selectionModel().currentIndex().row()

Well, It works, but I need to separate it to put every attribute to INSER INTO sql query.

Thnaks for help!

[JonB]

@Karoluss96
I don't know why you quote the first line of this code, but anyway.

Well, It works, but I need to separate it to put every attribute to INSER INTO sql query.

And what is the problem with that? Assuming

rowData = [ model.index(row, col).data() for col in range(model.columnCount()) ]

works in Python you have rowData containing all the values you need for your SQL statement.

[Karoluss96]

I suppose true. I forgot to change the first word in my previous answer from nagative to positive :-)

[Karoluss96]

If can add something for it:
I need to change all empty (if is empty!) records in rowData from 'None' Type to 'Null' (for better recognising it in SQL Question).

It's obviosly rather a python than qt question, but I can't find good answer in a differnt forum.

[JonB]

@Karoluss96
Sorry but this question does not mean much. If you are, say, generating an INSERT statement from the column values in a row, and some of these are Python None, and you need to pass NULL for this to SQL in VALUES clause, then you must write code to do so at the appropriate point. If you use, say, QSqlQuery to generate the statement you may find that QSqlQuery::addBindValue() does this for you if the value is Python None, I don't know.

[Karoluss96]

@JonB said in Get content of cell from QTableView:

addBindValue()

well first I want to concatenate data from rowData into one 'train' of later sql Values like below:

dn2 = iden + ',\'' + teryt + '\',\'' +....+ DatMod
             

where iden is rowCount[0], teryt is rowCount[1] etc.

but it take erorr:

TypeError: can only concatenate str (not "NoneType") to str

[jsulm]

@Karoluss96 said in Get content of cell from QTableView:

TypeError: can only concatenate str (not "NoneType") to str

@JonB told you that you will have to write code for that. You need to check whether it is None, if it is add "NULL" instead of the value into the string.

But it would be way better to use QSqlQuery::addBindValue() anyway...

[JonB]

@Karoluss96
Both of what @jsulm said.

Since I already wrote

and some of these are Python None, and you need to pass NULL for this to SQL in VALUES clause, then you must write code to do so at the appropriate point.

I don't understand why you come back with TypeError: can only concatenate str (not "NoneType") to str error message when you haven't done anything about it. Please read the answers and act upon them, else it's pointless asking/responding.

[Karoluss96]

@jsulm I try inspiring from here: https://cpp.hotexamples.com/examples/-/QSqlQuery/addBindValue/cpp-qsqlquery-addbindvalue-method-examples.html but still I have only one

[jsulm]

@Karoluss96 said in Get content of cell from QTableView:

but still I have only one

Only one what? Can you please be more precise?

[Karoluss96]

@jsulm I mean if I try:

 a=query.addBindValue(rowData)
            print (a)

still have one 'None'

[jsulm]

This post is deleted!