Python library to connect to SQLAlchemy with SSH Tunnel
Project description
py-sqlalchemy-ssh-connector
Python library to connect to SQLAlchemy with SSH Tunnel.
Where to get it
The source code is currently hosted on GitHub at: https://github.com/pualien/py-sqlalchemy-ssh-connector
Binary installers for the latest released version are available at the Python package index
pip install sqlalchemy-connector
Example 1
from alchemy_connector import SQLAlchemySession
session = SQLAlchemySession('db.example.com')
result = session.execute('''select * from ecommerce_transactions limit 1''')
session.stop()
# session.start()
Example 2
session = SQLAlchemySession(
host='db.example.com',
uri='mongodb://user:password@127.0.0.1/?authSource=admin&authMechanism=SCRAM-SHA-256'
)
...
session.stop()
Example 3
session = SQLAlchemySession(
host='db.example.com',
user='myuser',
password='mypassword',
)
...
session.stop()
Example 4
session = SQLAlchemySession(
host='db.example.com',
port='21',
user='myuser',
key='/home/myplace/.ssh/id_rsa2',
to_port='37017',
to_host='0.0.0.0'
)
...
session.stop()
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
Built Distribution
Close
Hashes for sqlalchemy-connector-0.1.26.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6c7e1b1bab82aab2c9ceea5a6d91b4f511602ec70688ebcaed9fe12a648d3302 |
|
MD5 | a83f0dc5401bf189bb371016fcd86267 |
|
BLAKE2b-256 | cbee8223169c413e7b851b1fbfb9f089158c4016bba425668f362257bf72580f |
Close
Hashes for sqlalchemy_connector-0.1.26-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6848da9a9735ca3a28aa352357d01f154a95ea74840994ef76cb3275a6f8bd39 |
|
MD5 | c3de2668320b65dae034a69267160ff0 |
|
BLAKE2b-256 | a52c72c85d2cbb2ea876b4cb27d1c326fa2b40ea5467142909323409f3d9f8e2 |