How to display data returned from Oracle procedure in a different order in QTableWidget?

[Goldglv]

I have some data returned from an Oracle stored proc in this order:

Col1, Col2, Col3, Col4, Col5

But I want to display it in my QTableWidget like this:

Col2, Col5, Col3, Col4

Col1 is a primary key so I don't want it displayed in the table.

Now this is a very simple example and I know I can use setColumnHidden and moveSection but in my app there are screens that have 50+ columns, this would obviously take forever,

Is there a more efficient way to do this? I have many stored procs that return data in a certain order but I don't want to display it in that order to the user in my QTableWidget. Using PYQT5, displaying data in a QTableWidget. I will have some comboBoxes, Date fields, strings, integers....

Any type of sample code would be great but anything to get me pointed in the right direction would be helpful....

l_query = cursor.callproc('MYPROC_PD', (l_cur,))
l_results = l_query[0]
allSQLRows = l_results.fetchall()

[SGaist]

Hi,

A proxy model comes to mind for that see QAbstractProxyModel and the classes related.

Hope it helps

[Goldglv]

Currently I'm using:
Import cx_oracle
Connection = cx_oracle.connect()
Cursor = connection.cursor()
ProcResults =cursor.callproc()

I'm assuming I can't use this now and need to use something from QsqlQuery? Can I pass that a stored procedure?

[SGaist]

Sorry, I've read QTableView rather than Widget.

If you populate a QTableWidget with the result of your query you don't need any special stuff, just put the data where you want them directly.

If you take the QTableView + QSqlQueryModel then you should take a look at the SQL driver chapter of Qt's documentation where the support for stored procedure is discussed.

[Goldglv]

I just thought it wouldn't be very clean to just say:

Query result(3) put into 6th column in table widget and so on.....

Thought there may be a cleaner way to link result set and column positions.

Is there an advantage of using qtTableView in your 2nd example over what I'm currently doing?

[SGaist]

You avoid having to create and/or update and/or re-create items for your QTableWidget when you call the stored procedure again.