All Questions
8 questions
5
votes
2
answers
99
views
Add as newest ID to SQLite Database
At our company we use an SQLite Database to manage our Drawing IDs (CAD Drawings). The code is written in Python and I need to update it. I think the code I have has some problems, but I am quite ...
- 357
3
votes
1
answer
394
views
Reading Database, scraping Barchart and uploading prices to DB
This is my first real excursion into Python, coming from C#. I wanted to see if my code is well-formatted and efficient.
The following will read the needed codes from a Database Table, then submit ...
- 208
2
votes
0
answers
640
views
Create and email an Excel report of data retrieved from SQL
This is my first Python (3.6) script which I would appreciate some critique of.
I am generating a daily alarm report. The data is gathered from an SQL Server database, presented in an xlsx file ...
- 21
3
votes
1
answer
2k
views
Transforming stored procedures using Python regular expressions
I have to add some extra logic to about 80 similar stored procedures on my DWH server.
I thought that it would take pretty much the same time if I do it with Python and lots of googling (I have no ...
- 133
5
votes
1
answer
1k
views
SQL Query generator, the GUI
This is the third round of reviews. The second round can be found in this question. This question focuses on the PyQt5 GUI for this app.
This is a project I have been working on. This is one of my ...
- 2,949
7
votes
3
answers
353
views
SQL Query generator, round 2
This is the second round of reviews. The first round can be found in this question.
This is a project I have been working on. This is one of my first experiences with Python and OOP as a whole. I have ...
- 2,949
2
votes
1
answer
4k
views
SQL query generator
This question has a follow-up review posted here
This is a project I have been working on. This is one of my first experiences with Python and OOP as a whole. I have written a GUI that handles the ...
- 2,949
5
votes
2
answers
135
views
Replacing MySQL's AUTO_INCREMENT with Postgres' SERIAL
I am making changes to a Python script that converts MySQL scripts to PostgreSQL, and I want to replace strings such as id INTEGER NOT NULL AUTO_INCREMENT with <...
- 153