Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.79 KB | None | 0 0
  1. from sshtunnel import SSHTunnelForwarder #Run pip install sshtunnel
  2. from sqlalchemy.orm import sessionmaker #Run pip install sqlalchemy
  3. from sqlalchemy import create_engine
  4. import time
  5.  
  6. with SSHTunnelForwarder(
  7.     ('93.95.101.20', 41331), #Remote server IP and SSH port
  8.     ssh_username = "shapr",
  9.     ssh_password = "test",
  10.     remote_bind_address=('127.0.0.1', 50869)
  11.     ) as server:
  12.  
  13.     server.start() #start ssh sever
  14.     print ('Server connected via SSH')
  15.     time.sleep(1)
  16.  
  17.     #connect to PostgreSQL
  18.     local_port = str(server.local_bind_port)
  19.     print(local_port)
  20.     engine = create_engine('mysql+pymysql://shapr:test@127.0.0.1:' + local_port +'/<имя таблицы>')
  21.  
  22.     Session = sessionmaker(bind=engine)
  23.     session = Session()
  24.  
  25.     print ('Database session created')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement