my_first_calculator.py VS pyodbc

Avkuka lenkje: https://github.com/AceLewis/my_first_calculator.py/blob/master/my_first_calculator.py

Твоя работа?

A lot of ppl were asking about this, so I decided to find that calculator. I did but it was actually generated. Idk, why we didn't see this last time but it's clear the code is generated. https://github.com/AceLewis/my_first_calculator.py Maybe we saw something else, that was years ago.

the calculator is actually autogenerated! https://github.com/AceLewis/my_first_calculator.py

Simplicity and ease of use make good code? And nothing else? Ok, here's a great calculator implementation then: https://github.com/AceLewis/my_first_calculator.py/blob/master/my_first_calculator.py

At least they didn't do this: https://github.com/AceLewis/my_first_calculator.py/blob/master/my_first_calculator.py

Python can script and view this via pyodbc... https://github.com/mkleehammer/pyodbc/wiki

I am not 100% sure you call stored procedure correctly. in the examples they declare @out parameter for the procedures with output.

pyodbc has the odb2 part figured out. This could be useful instead of reinventing the wheel. The rest I can't think of anything that has been done. Sounds like an interesting project.

From its documentation it looks like pyodbc conforms to the DB API, so you can probably use named parameters by passing a dictionary to execute(), as described here.

~ $ pip show pyodbc Name: pyodbc Version: 4.0.34 Summary: DB API Module for ODBC Home-page: https://github.com/mkleehammer/pyodbc Author: Author-email: License: MIT Location: /data/data/com.termux/files/usr/lib/python3.10/site-packages Requires: Required-by:

I am trying to migrate data from our Enterprise Data Warehouse to one of our own reporting databases via ODBC and Python scripts. The python scripts import pyodbc to handle the database connections and execute SQL queries. A system DSN is defined on our ETL server for each database involved in the process.

See the docs.