Advertisement
Guest User

Untitled

a guest
Mar 1st, 2019
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.78 KB | None | 0 0
  1. import psycopg2
  2. import sshtunnel
  3.  
  4. sshtunnel.SSH_TIMEOUT = 5.0
  5. sshtunnel.TUNNEL_TIMEOUT = 5.0
  6.  
  7. with sshtunnel.SSHTunnelForwarder(
  8.     ('ssh.pythonanywhere.com'),
  9.     ssh_username='karlduckett',
  10.     ssh_password='mypythonanywherepassword',
  11.     remote_bind_address=('karlduckett-1045.postgres.pythonanywhere-services.com', 11045)
  12. ) as tunnel:
  13.  
  14.     params = { "dbname": 'mydatabasename',
  15.                 "user": 'super',
  16.                "password": 'mysuperpassword',
  17.                "host": 'localhost',
  18.                "port": tunnel.local_bind_port,
  19.                }
  20.     connection = psycopg2.connect(**params)
  21.     cursor = connection.cursor()
  22.  
  23.     cursor.execute("SELECT * FROM lead;")
  24.     rows = cursor.fetchall()
  25.     print(rows);
  26.     cursor.close()
  27.     connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement