Forums

from sqlalchemy import create_engine, Column, Integer, String, DateTime, ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import sessionmaker
from datetime import datetime
from flask_login import UserMixin
import hashlib
import psycopg2
import sshtunnel

sshtunnel.SSH_TIMEOUT = 5.0
sshtunnel.TUNNEL_TIMEOUT = 5.0

postgres_hostname = "ASSIGNED_URL_PREFIX.postgres.pythonanywhere-services.com" 
postgres_host_port = ASSIGNED_PORT

with sshtunnel.SSHTunnelForwarder(
        ('ssh.pythonanywhere.com'),
        ssh_username='ACCOUNT_USERNAME',
        ssh_password='ACCOUNT_PASSWORD',
        remote_bind_address=(postgres_hostname, postgres_host_port)
) as tunnel:
    connection = psycopg2.connect(
        user='DB_USERNAME', password='DB_PASSWORD',
        host='HOST', port=tunnel.local_bind_port,
        database='DB_NAME',
    )
    # Do stuff inside the context manager block

    connection.close()

...same imports...

sshtunnel.SSH_TIMEOUT = 5.0
sshtunnel.TUNNEL_TIMEOUT = 5.0

postgres_hostname = "ASSIGNED_URL_PREFIX.postgres.pythonanywhere-services.com"
postgres_host_port = ASSIGNED_PORT

with sshtunnel.SSHTunnelForwarder(
        ('ssh.pythonanywhere.com'),
        ssh_username='ACCOUNT_USERNAME,
        ssh_password='ACCOUNT_PASSWORD',
        remote_bind_address=(postgres_hostname, postgres_host_port)
) as tunnel:
    # PostgreSQL connection through the tunnel
    connection = psycopg2.connect(
        user='DB_USERNAME', password='DB_PASSWORD',
        host='ASSIGNED_HOST', port=tunnel.local_bind_port,
        database='DB_NAME',
    )

    # Create SQLAlchemy engine
    db_url = f"postgresql+psycopg2://DB_USERNAME:DB_PASSWORD@ASSIGNED_URL_PREFIX.postgres.pythonanywhere-services.com:ASSIGNED_PORT/DB_NAME"
    engine = create_engine(db_url)

    # Define Base and models
    Base = declarative_base() .... the rest of my script ....

postgresql+psycopg2://DB_USERNAME:DB_PASSWORD@ASSIGNED_URL_PREFIX.postgres.pythonanywhere-services.com:ASSIGNED_PORT/DB_NAME

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name "ASSIGNED_URL_PREFIX.postgres.pythonanywhere-services.com" to address: nodename nor servname provided, or not known

   # Create SQLAlchemy engine
    db_url = f"postgresql+psycopg2://DB_USERNAME:DB_PASSWORD@LOCALHOST:LOCALPORT/DB_NAME"
    engine = create_engine(db_url)

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server failed: FATAL:  role "DB_USERNAME" does not exist

 # Create SQLAlchemy engine
    db_url = f"postgresql+psycopg2://DB_USERNAME:DB_PASSWORD@LOCALHOST:{tunnel.local_bind_port}/DB_NAME"
    engine = create_engine(db_url)

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) connection to server failed: Connection refused
        Is the server running on that host and accepting TCP/IP connections?

# Create SQLAlchemy engine
db_url = "postgresql+psycopg2://DB_USERNAME:DB_PASSWORD@127.0.0.1:{}/tfftt".format(local_bind_port)
engine = create_engine(db_url)