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)- 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.2.tar.gz
(12.4 kB
view hashes)
Built Distribution
Close
Hashes for connection_helper-0.8.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1c3f33968bfbbc7a4284bda8411c025cb624ef33e23251b08f5bef6afbdbb951 |
|
MD5 | 2110efa696cf5613ff7bb94264f885d6 |
|
BLAKE2b-256 | 301bb62d8b605860f32f46b152b17ad9385b1b01e77ad03498237ff0cd4155d0 |