pyodbc-extras
Extra Methods for Working with ODBC Connections in Python
install
pip install pyodbc-extras
usage
from pyodbc import connect
from pyodbc_extras import dump_sql_to_rows, dump_table
cnxn = pyodbc.connect(CONNECTION_STRING)
cursor = cnxn.cursor()
# dump custom sql
dump_sql_to_rows(cursor, "SELECT * FROM cars WHERE year < 2015")
{ "column_names": ["year", "make", "model", ...], "rows": [{"year": 2005, "make": "Audi", "model": "A3"}, ...] }
# same as dump_sql_to_rows(cursor, "SELECT * FROM cars")
rows = dump_table(cursor, "cars")
1 maintainer
Metadata
1 maintainer
Release files for pyodbc-extras 0.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pyodbc_extras-0.0.0.tar.gz | 5.1 kB | Details |
Release files / pyodbc_extras-0.0.0.tar.gz
| Download URL | pyodbc_extras-0.0.0.tar.gz |
|---|---|
| Size | 5.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
adef92a45362efb85443b4a726390a1331ee3861ee41550e1dd2e5bb69351245
|
|
BLAKE2b-256 checksum How to use checksums |
cb4b6eb70f20bf5b5d129bc5c0dc1b7fd557fbfb016b8f2ee3a35dc82746d215
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.6
|
