A collection of helper for sql connections
Project description
connection-helper
usage
install / update package
pip install connection-helper -U
include in python
from connection_helper import sql, pgp, sec
why use connection-helper
connection-helper
bundles some packages for connecting to sql databases
-
sql
is added as convenience wrapper for retrieving data from sql databasesconnect_sql()
to get get data from['mssql', 'sqlite','postgres']
load_sql_to_sqlite
connect to a sql db and transfer a list of tables tosqlite
load_sqlite_to_parquet()
to get all tables from a sqlite file as parquetsunpack_files_to_duckdb()
return a tuple of all files of a dir (csv or parquet) into high performance duckdb objects ⚡print_meta()
print meta information of a certain database (niche case)load_from_mssql()
load data from an MSSQL database into a Pandas DataFramesave_to_mssql()
save data from a Pandas DataFrame to an MSSQL database- 🆕
load_file_to_duckdb()
load data from various sources into a duckdb database, using pandas read functions (experimental) - azure storage connector 🚧
-
pgp
cryptographic tools adapted from python-gnupg. this is a wrapper aroundgnupg
, but only offers some cenvenience or tailored options. feel free to use the original library or the GNU Privacy Guard.encrypt()
a message for one or more recipient(s) with a public keydecrypt()
a message with a private key. Passphrase must be provided via env variablefind_key()
in keyring- ...
💡 The pgp methods require a pgp public/private key in the keyring
sec
secrets module. ⚠️ this package is optional and must be extra installed withpip install 'connection-helper[sec]'
(enclose in '')- 🆕
get_infisical_secrets()
retrieve secrets from Infisical project (requires existing account and machine identities)
- 🆕
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
connection_helper-0.8.9.tar.gz
(13.9 kB
view hashes)
Built Distribution
Close
Hashes for connection_helper-0.8.9-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c32a8b23feee6d0961fb83cd178899e33994c462c20a8a7e53e0a72245409904 |
|
MD5 | cd318af784d3bc9fa98a11f4a00f34f9 |
|
BLAKE2b-256 | 26832813b1e6abb6ed4710af2bcbda5c2c0d458f87769d21bd83c8b1e1823bc4 |