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.10.tar.gz
(14.0 kB
view hashes)
Built Distribution
Close
Hashes for connection_helper-0.8.10-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2b4ec2d07b6389fcbe41d6782d741aaf1f85f5c49d3f8d4987457173c37b9a66 |
|
MD5 | 31132e2db05087cd1622ffdf51d55521 |
|
BLAKE2b-256 | 653f7a5688c47efb508bb45fb3d9f1547304ef5e3f09976768c71d2b2be8af7c |