File size: 623 Bytes
6751ba4
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
import psycopg2
from psycopg2 import OperationalError


# Neon database connection string

def create_connection(CONN_STRING):
    """Create a connection to the Neon PostgreSQL database."""
    try:
        connection = psycopg2.connect(CONN_STRING, sslmode="require")
        print("โœ… Connection to Neon PostgreSQL DB successful")
        return connection
    except OperationalError as e:
        print(f"โŒ The error '{e}' occurred")
        return None

def close_connection(connection):
    """Close the database connection."""
    if connection:
        connection.close()
        print("๐Ÿ”’ Connection closed")