conn

File to define/manage PgSQL connection

Functions:

• check_session_status –

  Function to check a given Session object status

• get_database_url –

  Function to get database connection URL

• get_db_session –

  Function to get a valid DB session

• get_engine –

  Function to create and return a valid SQLAlchemy Engine instance

• is_active_session –

  Function to check a given Session object status

check_session_status

check_session_status(session_: Session) -> bool

Function to check a given Session object status

Parameters:

• session_

  (Session) –

  Session object

Returns:

• bool –

  True if session is valid, False otherwise

get_database_url

get_database_url() -> str

Function to get database connection URL

Returns:

• str –

  Database URL

get_db_session

get_db_session() -> Generator[Session, None, None]

Function to get a valid DB session (Session object from SQLAlchemy module)

Returns:

• Generator[Session, None, None] –

  Generator of a Session object

get_engine

get_engine() -> Engine

Function to create and return a valid SQLAlchemy Engine instance

Returns:

• Engine –

  Valid engine

Raises:

• EngineCreationFailed –

  Engine creation failed

is_active_session

is_active_session(session_: Session) -> bool

Function to check a given Session object status

Parameters:

• session_

  (Session) –

  Session object

Returns:

• bool –

  True if session is valid, False otherwise