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
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 parquets - 🆕
load_files_to_duckdb()
to get all files of a dir (csv or parquet) into high performance duckdb objects ⚡ - 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- ...
💡 These methods require a pgp public/private key in the keyring
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.7.1.tar.gz
(10.7 kB
view hashes)
Built Distribution
Close
Hashes for connection_helper-0.7.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 67245f8c4bf55e41f29a6c8035b4218dbebf388be780b0a4fec1707d8c3103d8 |
|
MD5 | b764ee0d925831b44a98841f0a575cb7 |
|
BLAKE2b-256 | c3c54f6678411454a06b08b4576b51b8bd21c88b0e36737b4f79c1ae9bb52f8f |