Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sshtunnel import SSHTunnelForwarder #Run pip install sshtunnel
- from sqlalchemy.orm import sessionmaker #Run pip install sqlalchemy
- from sqlalchemy import create_engine
- import time
- with SSHTunnelForwarder(
- ('93.95.101.20', 41331), #Remote server IP and SSH port
- ssh_username = "shapr",
- ssh_password = "test",
- remote_bind_address=('127.0.0.1', 50869)
- ) as server:
- server.start() #start ssh sever
- print ('Server connected via SSH')
- time.sleep(1)
- #connect to PostgreSQL
- local_port = str(server.local_bind_port)
- print(local_port)
- engine = create_engine('mysql+pymysql://shapr:test@127.0.0.1:' + local_port +'/<имя таблицы>')
- Session = sessionmaker(bind=engine)
- session = Session()
- print ('Database session created')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement