Advertisement
Guest User

Untitled

a guest
Dec 31st, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. import psycopg2
  2. from sshtunnel import SSHTunnelForwarder
  3.  
  4.  
  5.  
  6. with SSHTunnelForwarder(
  7. ('159.203.11.90', 22),
  8. ssh_username="megan",
  9. ssh_password="***secret password***",
  10. remote_bind_address=('localhost', 5432)) as server:
  11.  
  12. server.start()
  13. print "server connected"
  14.  
  15. params = {
  16. 'database': 'qar',
  17. 'user': 'megan',
  18. 'host': 'localhost',
  19. 'port': server.local_bind_port,
  20. 'password':"????"
  21. }
  22.  
  23.  
  24. conn = psycopg2.connect(**params)
  25. curs = conn.cursor()
  26. print "database connected"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement