Okay before we get started on deciphering what you got I want to state -- first you are hurting yourself by using Designer code for you Gui as a pure Python-Qt (aka PyQt5 or PySide2) version created as it was meant to be used is just as quick and simple once you have learned how it works and what you end up with is not only code you understand but a better understanding of how Qt works.
Next when it comes to your Database and your Gui -- I hope that you are using MVC methodology but I expecting that you are not and that is another major issue that will cause you much pain.
So let me know if you want to address both of these things and learn how to do it properly so that you pain is minimized -- coding always comes with a little pain but no pain no gain ;-)
Next when it comes to your Database and your Gui -- I hope that you are using MVC methodology but I expecting that you are not and that is another major issue that will cause you much pain.
So let me know if you want to address both of these things and learn how to do it properly so that you pain is minimized -- coding always comes with a little pain but no pain no gain ;-)