PyQt5 database application: module contents

q&a
1

I use a postgresql database for tracking my business and now want to add a PyQt5 GUI to it. I run Slackware linux.

The application will use the ModelView and SQL capabilities of PyQt. As a new learner having read Martin’s PyQt5 book I did not see how to put SQL queries in models. For example, when I want to add new rows to a table do I write a separate .py module for each table or can I write a single file where I can put each table in a separate class in the same module? Same for updating table rows and deleting rows.

I’m sure that I’ll have many more questions whose answers I don’t find in the book.

TIA,

Rich

2

Of course I can. It’s been a long time since I last wrote python code so I apologize for posting this thread. It’s closed now.