I did the migration with mysqldump then I edited the dump file. Then I have the resulting file into sqlite and saved it as database. The date columns are now stored in sqlite as TEXT fields. All done on a linux machine.

Thank you VRonin for your suggestion. That sounds like a great idea. Can I do this in pyQt5 or do I need to go to C++? I think QSQLiteDriver is a plugin i.e. a shared library. That means I have to do this in C++. Is that right? I wanted to avoid C++ so that my application is more portable. But anyway this solution sounds great.

Thanks for you answers guys.

Hi
I have not seen steam on linux , however they might have use
https://en.wikipedia.org/wiki/Client-side_decoration
or something similar.
or have hand made it.
While this works ok for win
https://github.com/dfct/TrueFramelessWindow
I have not seen one for linux. Maybe due to all the different managers.

Short story is. Qt do not draw the title bar so one can either totally fake it and draw all - and handle all min/max resize etc by
manual code or if the Desktop/Manager supports it, use direct api extensions.

@Dexter99 said in How to make a resizable gui?:

How can I solve this

See https://doc.qt.io/qt-5/layout.html

@SGaist
Ah, yes, I do mean adding to already visible widget parent/layout, so that's why I don't need to.

So, I'm not criticising @jsulm's code, but where he has added new QLabel(this, "Some text"); the this is the QMainWindow, which will be shown, so he didn't need to put in the label->show();, right?

Thanks for the feedback and happy hacking !

Hi and welcome to devnet,

Isn't that a system notification ?

@anp405, my first guess would be that by setting PYTHONPATH you are losing the location of PyQt5 package. This depends on your Python and environment setup, but if there is some PYTHONPATH existing, you are overriding it completely instead of complementing. You can verify this by opening a new command line session, setting PYTHONPATH to wherever your code sets it, then running Python interpreter and trying to import PyQt5.

Another guess would be that your child process uses different Python environment (e.g. built-in system Python 2), which does not have PyQt5 installed in its site-packages.

@mrjj Thank you very much! Problem solved.

@badr
You have one table widget (or similar, actually presumably QTableView rather than QTableWidget since you have your own model) holding rows & columns from a SQL query. You say you want another table widget to show a column "computed" (at client side) from columns in the first one.

So why not create a second model whose data() method is overridden to perform the necessary computation and return the desired final string for Qt::DisplayRole using the index.row/column() (not just the index) as indexers into the SQL model's rows/columns?

Or, if you want to stick with your current usage of QTableWidget (not ideal that you use Python SQL calls and copy result set into that, but up to you), you could make your second one a QTableWidget too and use setData() to populate its rows/columns with the actual corresponding strings whenever the first one changes (more work depending on how often your data changes, but in your case it might only be during loaddata() when you populate if it does not change thereafter).

Hi,

You can put your QStackedLayout and buttons in a QVBoxLayout so you can re-use the buttons. Put that layout in a QWidget and set that widget as the central widget of your QMainWindow.

Hi and welcome to devnet,

How are you building your executable ?
What version of PyQt5 and Qt are you using ?

Since you are using PyQt, you might want to consider contacting its authors.

@raven-worx you sir saved my life! I cant believe i was stuck at this for 2 days, when it was simply just about using the right object in qml. thanks!