sea_connector_test.py

"""
Main script to run all SEA connector tests.

This script runs all the individual test modules and displays
a summary of test results with visual indicators.

In order to run the script, the following environment variables need to be set:
- DATABRICKS_SERVER_HOSTNAME: The hostname of the Databricks server
- DATABRICKS_HTTP_PATH: The HTTP path of the Databricks server
- DATABRICKS_TOKEN: The token to use for authentication
"""

import os
import sys
import logging
import subprocess
from typing import List, Tuple

logging.basicConfig(level=logging.DEBUG)
logger = logging.getLogger(__name__)

TEST_MODULES = [
    "test_sea_session",
    "test_sea_sync_query",
    "test_sea_async_query",
    "test_sea_metadata",
]


def run_test_module(module_name: str) -> bool:
    """Run a test module and return success status."""
    module_path = os.path.join(
        os.path.dirname(os.path.abspath(__file__)), "tests", f"{module_name}.py"
    )

    # Simply run the module as a script - each module handles its own test execution
    result = subprocess.run(
        [sys.executable, module_path], capture_output=True, text=True
    )

    # Log the output from the test module
    if result.stdout:
        for line in result.stdout.strip().split("\n"):
            logger.info(line)

    if result.stderr:
        for line in result.stderr.strip().split("\n"):
            logger.error(line)

    return result.returncode == 0


def run_tests() -> List[Tuple[str, bool]]:
    """Run all tests and return results."""
    results = []

    for module_name in TEST_MODULES:
        try:
            logger.info(f"\n{'=' * 50}")
            logger.info(f"Running test: {module_name}")
            logger.info(f"{'-' * 50}")

            success = run_test_module(module_name)
            results.append((module_name, success))

            status = "✅ PASSED" if success else "❌ FAILED"
            logger.info(f"Test {module_name}: {status}")

        except Exception as e:
            logger.error(f"Error loading or running test {module_name}: {str(e)}")
            import traceback

            logger.error(traceback.format_exc())
            results.append((module_name, False))

    return results


def print_summary(results: List[Tuple[str, bool]]) -> None:
    """Print a summary of test results."""
    logger.info(f"\n{'=' * 50}")
    logger.info("TEST SUMMARY")
    logger.info(f"{'-' * 50}")

    passed = sum(1 for _, success in results if success)
    total = len(results)

    for module_name, success in results:
        status = "✅ PASSED" if success else "❌ FAILED"
        logger.info(f"{status} - {module_name}")

    logger.info(f"{'-' * 50}")
    logger.info(f"Total: {total} | Passed: {passed} | Failed: {total - passed}")
    logger.info(f"{'=' * 50}")


if __name__ == "__main__":
    # Check if required environment variables are set
    required_vars = [
        "DATABRICKS_SERVER_HOSTNAME",
        "DATABRICKS_HTTP_PATH",
        "DATABRICKS_TOKEN",
    ]
    missing_vars = [var for var in required_vars if not os.environ.get(var)]

    if missing_vars:
        logger.error(
            f"Missing required environment variables: {', '.join(missing_vars)}"
        )
        logger.error("Please set these variables before running the tests.")
        sys.exit(1)

    # Run all tests
    results = run_tests()

    # Print summary
    print_summary(results)

    # Exit with appropriate status code
    all_passed = all(success for _, success in results)
    sys.exit(0 if all_passed else 1)