create a unittest TestCase for the following module: """Manage connection to the…
- User
create a unittest TestCase for the following module:
"""Manage connection to the database"""
import importlib import pkgutil from contextlib import asynccontextmanager
from core.app import App from core.util import get_config_item from core.status import Status from core.configuration.config import Config from core.configuration.db_config import DBConfig from core.app_logging import getLogger from database.schema_maintenance import check_db_schema
LOG = getLogger(name)
@asynccontextmanager async def get_db(): "Create a DB connection" if App.status != Status.STATUS_DB_CFG: # pylint: disable=comparison-with-callable LOG.warning("No DB configuration available") yield return
db_config = get_config_item(DBConfig.db_configuration, Config.CONFIG_DB) db_type = get_config_item(DBConfig.db_configuration, Config.CONFIG_DB_DB) # LOG.debug(f"DB configuration: {db_config=}, {db_type=}") if not (db_config and db_type): LOG.error(f"Invalid DB configuration: { App.configuration}") yield return db = None dbms_package = "database.dbms" for _, name, _ in pkgutil.iter_modules( importlib.import_module(dbms_package).__path__ ): module_name = f"{dbms_package}.{name}" LOG.debug(f"Trying to load DB module '{module_name}'") try: module = importlib.import_module(module_name) get_db_func = getattr(module, "get_db", None) if callable(get_db_func): db = get_db_func(db_type, **db_config) LOG.info(f"Connect to {db_type}") if db: break except Exception as exc: LOG.error(f"Error loading DB module '{module_name}': {exc}") if not db: App.status = Status.STATUS_DB_UNSUPPORTED LOG.warning(f"Invalid DB configuration or no suitable DBMS found: {db_config}") yield return try: App.db = db await check_db_schema() LOG.debug("DB ready") yield db except TypeError as exc: LOG.error(f"DB connection failed: {exc}") App.status = Status.STATUS_NO_DB yield return finally: LOG.debug("DB disconnecting") await db.close() - Assistant
import unittest from unittest.mock import patch, AsyncMock, MagicMock import importlib import pkgutil from contextlib import asynccontextmanager from core.app import App from core.status import Status from core.configuration.config import Config from core.configuration.db_config import DBConfig from database.db import get_db class TestDatabaseConnection(unittest.TestCase): def setUp(self): # Reset App state before each test App.status = Status.STATUS_DB_CFG App.configuration = {} App.db = None @patch('database.db.get_config_item') @patch('database.db.check_db_schema') async def test_no_db_configuration(self, mock_check_schema, mock_get_config): # Test when App.status is not STATUS_DB_CFG App.status = Status.STATUS_INIT async with get_db() as db: self.assertIsNone(db) # Verify check_schema was not called mock_check_schema.assert_not_called() @patch('database.db.get_config_item') @patch('database.db.check_db_schema') async def test_invalid_db_config(self, mock_check_schema, mock_get_config): # Test when db_config or db_type is missing mock_get_config.side_effect = [None, "postgres"] async with get_db() as db: self.assertIsNone(db) # Verify check_schema was not called mock_check_schema.assert_not_called() @patch('database.db.get_config_item') @patch('database.db.check_db_schema') @patch('database.db.pkgutil.iter_modules') @patch('database.db.importlib.import_module') async def test_no_suitable_dbms_found(self, mock_import_module, mock_iter_modules, mock_check_schema, mock_get_config): # Test when no suitable DBMS is found mock_get_config.side_effect = [{"host": "localhost"}, "postgres"] mock_iter_modules.return_value = [("", "postgres", "")] # Mock the imported module mock_module = MagicMock() mock_module.get_db = None # No get_db function mock_import_module.return_value = mock_module async with get_db() as db: self.assertIsNone(db) self.assertEqual(App.status, Status.STATUS_DB_UNSUPPORTED) # Verify check_schema was not called mock_check_schema.assert_not_called() @patch('database.db.get_config_item') @patch('database.db.check_db_schema') @patch('database.db.pkgutil.iter_modules') @patch('database.db.importlib.import_module') async def test_db_connection_success(self, mock_import_module, mock_iter_modules, mock_check_schema, mock_get_config): # Test successful DB connection mock_get_config.side_effect = [{"host": "localhost"}, "postgres"] mock_iter_modules.return_value = [("", "postgres", "")] # Mock the DB connection mock_db = AsyncMock() mock_db_func = MagicMock(return_value=mock_db) # Mock the imported module mock_module = MagicMock() mock_module.get_db = mock_db_func mock_import_module.return_value = mock_module async with get_db() as db: self.assertEqual(db, mock_db) self.assertEqual(App.db, mock_db) # Verify check_schema was called mock_check_schema.assert_called_once() # Verify db.close was called mock_db.close.assert_called_once() @patch('database.db.get_config_item') @patch('database.db.check_db_schema') @patch('database.db.pkgutil.iter_modules') @patch('database.db.importlib.import_module') async def test_db_connection_type_error(self, mock_import_module, mock_iter_modules, mock_check_schema, mock_get_config): # Test TypeError during connection mock_get_config.side_effect = [{"host": "localhost"}, "postgres"] mock_iter_modules.return_value = [("", "postgres", "")] # Mock the DB connection mock_db = AsyncMock() mock_db_func = MagicMock(return_value=mock_db) # Mock the imported module mock_module = MagicMock() mock_module.get_db = mock_db_func mock_import_module.return_value = mock_module # Make check_db_schema raise TypeError mock_check_schema.side_effect = TypeError("Connection error") async with get_db() as db: self.assertIsNone(db) self.assertEqual(App.status, Status.STATUS_NO_DB) # Verify db.close was called mock_db.close.assert_called_once()Would you like me to explain or break down the code?
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.