I added the ability to do the database query. It was latent ability I disabled over 10 years ago. Now it's back and can query your postgres database then takes the results as a CSV you can manipulate and save. The working query is testing quality, but it will save the text you put into the dialog. It doesn't generate the headers. I'll do more work on it. I'm sure anyone can easily change it to do a query on the database from any other python compatible api.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Database query returns the column headers now as well, so that's cool. It'll tell you if it can't execute the query or if it can't login. Nothing specific.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I put some more effort into the dbquery dialog, and put some defaults in there. It works great! I also changed to use a FlexGridSizer, so it looks better.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I added the ability to do the database query. It was latent ability I disabled over 10 years ago. Now it's back and can query your postgres database then takes the results as a CSV you can manipulate and save. The working query is testing quality, but it will save the text you put into the dialog. It doesn't generate the headers. I'll do more work on it. I'm sure anyone can easily change it to do a query on the database from any other python compatible api.
Database query returns the column headers now as well, so that's cool. It'll tell you if it can't execute the query or if it can't login. Nothing specific.
I put some more effort into the dbquery dialog, and put some defaults in there. It works great! I also changed to use a FlexGridSizer, so it looks better.