Python: QSqlTableModel works on Windows but not on macOS
-
Certainly, you are right.
This is the MySQL server that I am pointing to:
It is reacheable using Terminal from macOS. There are no other databases call "test". As you can see, it contains 3 tables. Specifically, "canzoni" has 3 fields (canzoni_id, titolo, album_id).
I'm going to show you the best proof I can provide to ensure that I am operating on the correct server.
As you can see, the table "canzoni" contains the following 7 rows:
Now, if I try to execute an INSERT INTO statement via my script, using these lines
query_to_execute = "INSERT INTO canzoni (titolo, album_id) VALUES ('Test1', '1')" query = QtSql.QSqlQuery(query_to_execute, db=db)the application correctly insert the new data into "canzoni".
So I can suppose that ODBC driver works correctly, my application is able to point the correct server and also to query it.
The problem using macOS is only to retrieve data from it.
If I try
SELECT COUNT(*) FROM canzoni;the result is
-
@DrTiaZ
Any reason you chose not to try theSELECT 1, 2, 3I suggested? That's why I typed it in.... -
@DrTiaZ
That implies to me that it is succeeding in retrieving the result set (rows) from the query from the database --- as opposed to never retrieving data. Don't know where that leaves you for your case though. Nor why Number of rows keeps being reported as -1. -
But also SELECT 1, 2, 3 fails to retrieve the queryset, in facts it retrieve only columns name and 0 row(s), like the queries before.
Documentation relative to QtSql.QSqlQuery.size() says "Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes. Note that for non-SELECT statements ( isSelect() returns false ), will return -1. If the query is not active ( isActive() returns false ), -1 is returned."
I really don't understand why this happens.
-
But also SELECT 1, 2, 3 fails to retrieve the queryset, in facts it retrieve only columns name and 0 row(s), like the queries before.
Documentation relative to QtSql.QSqlQuery.size() says "Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes. Note that for non-SELECT statements ( isSelect() returns false ), will return -1. If the query is not active ( isActive() returns false ), -1 is returned."
I really don't understand why this happens.
@DrTiaZ said in Python: QSqlTableModel works on Windows but not on macOS:
I really don't understand why this happens.
I would blame the ODBC driver then.
-
But also SELECT 1, 2, 3 fails to retrieve the queryset, in facts it retrieve only columns name and 0 row(s), like the queries before.
Documentation relative to QtSql.QSqlQuery.size() says "Returns the size of the result (number of rows returned), or -1 if the size cannot be determined or if the database does not support reporting information about query sizes. Note that for non-SELECT statements ( isSelect() returns false ), will return -1. If the query is not active ( isActive() returns false ), -1 is returned."
I really don't understand why this happens.
@DrTiaZ said in Python: QSqlTableModel works on Windows but not on macOS:
But also SELECT 1, 2, 3 fails to retrieve the queryset, in facts it retrieve only columns name and 0 row(s), like the queries before.
Ah, yes. I was expecting "No column name" as the titles for each column and thought the row shown was the single data row, but I think you're right.
I don't know where you go next, or what help you will get here. Does MacOS supply an ODBC tool to allow you to query/view the data?
-
@Christian-Ehrlicher said in Python: QSqlTableModel works on Windows but not on macOS:
@DrTiaZ said in Python: QSqlTableModel works on Windows but not on macOS:
I really don't understand why this happens.
I would blame the ODBC driver then.
I thought the same, but as @JonB suggested before, using iODBC tool and connecting to MySQL server via ODBC 8.0 Unicode Driver (same driver used in my Py script) I can view the data.
-
I'm not aware of any such problems in the ODBC driver since ages so I doubt it's a Qt problem.
-
@Christian-Ehrlicher said in Python: QSqlTableModel works on Windows but not on macOS:
@DrTiaZ said in Python: QSqlTableModel works on Windows but not on macOS:
I really don't understand why this happens.
I would blame the ODBC driver then.
I thought the same, but as @JonB suggested before, using iODBC tool and connecting to MySQL server via ODBC 8.0 Unicode Driver (same driver used in my Py script) I can view the data.
@DrTiaZ
I'm with @Christian-Ehrlicher on this, though we can't say 100%. If you are able, you might try PyQt5 or 6, or even C++ if you can, to rule out PySide. Otherwise reinstall Qt and/or the ODBC driver/Python interface to that. Or even try a different version of Qt. And search to verify no known MacOS Qt/Py/ODBC issues. Or even a different MacOS machine if available! Other than that I'm not sure how much more help you can get here.
