Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- import sshtunnel
- sshtunnel.SSH_TIMEOUT = 5.0
- sshtunnel.TUNNEL_TIMEOUT = 5.0
- with sshtunnel.SSHTunnelForwarder(
- ('ssh.pythonanywhere.com'),
- ssh_username='karlduckett',
- ssh_password='mypythonanywherepassword',
- remote_bind_address=('karlduckett-1045.postgres.pythonanywhere-services.com', 11045)
- ) as tunnel:
- params = { "dbname": 'mydatabasename',
- "user": 'super',
- "password": 'mysuperpassword',
- "host": 'localhost',
- "port": tunnel.local_bind_port,
- }
- connection = psycopg2.connect(**params)
- cursor = connection.cursor()
- cursor.execute("SELECT * FROM lead;")
- rows = cursor.fetchall()
- print(rows);
- cursor.close()
- connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement