from urllib.parse import quote_plus
from sqlalchemy import create_engine
from sqlalchemy import create_engine, inspect

#password = quote_plus("gQube1_#@96740")  # Encode special chars
print(quote_plus("gQube1_#@96740"))
engine = create_engine("postgresql://postgres:{password}@139.59.87.82:5432/paddy_carbon_pr_53158")
print(engine.url)
inspector = inspect(engine)

def get_tables():
    return inspector.get_table_names()

def get_columns():
    return {
        table: [col['name'] for col in inspector.get_columns(table)]
        for table in get_tables()
    }

def get_relationships():
    edges = []
    for table in get_tables():
        for fk in inspector.get_foreign_keys(table):
            edges.append((table, fk['referred_table']))
    return edges