pyodbc VS pytermgui

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.

Several libraries, such as urwid or PyTermGUI, allow the development of TUI applications in Python. For enhancing the functionality and aesthetics of TUI apps, they offer some fundamental and more sophisticated utilities. But there is one package that is truly exceptional and might even be so amazing that it sparks a TUI renaissance (I really wanted to put "TUI renaissance" somewhere in this article).

There are plenty of terminal UI libraries that are actually nice to work with. For Python, there's Textual and PyTermGUI. For Rust, there's ratatui and Cursive (or, if you want something a bit lower level, crosster or termion). For Go, there's bubbletea.

Talking about resources, their docs are pretty good and contains some examples too. Documentation: https://ptg.bczsalba.com/pytermgui.html

Have you tried PyTermGUI? It looks promising, but I wonder if there are any pitfalls. I need to build a professional CLI for a robot, and half-baked packages just won't do.

While the community is relatively small right now, my TUI framework PyTermGUI has a lot of the attributes you're looking for! We don't currently have a section dedicated to this yet, but if you come to the discord I'm sure we can help you :)

Check out the changelog here.

I suspect that the reason you didn't find much is that usually people need a whole textual user interface (or TUI). And there's quite a few libraries for those, like pytermgui or textual, and some more low-level tools in that area like prompt-toolkit