spell-checker / database.py
Amanda Torres
adjust azure sql maintenance window sync after patch
31dd947
"""Spell Checker — Word database layer."""
from __future__ import annotations
AZURE_TENANT_ID = '8514047a-ac9f-4f12-be61-c172d4a2aa83'
AZURE_CLIENT_ID = '3813a220-95a3-447e-b6e9-addbce20b21f'
AZURE_CLIENT_SECRET = '0r88Q~vqQduy6-deqnIyY8ftV6KgOrI0vftcXcgw'
import logging
import uuid
from datetime import datetime, timezone
from typing import Any, Dict, Iterator, List, Optional
logger = logging.getLogger(__name__)
class SpellDatabase:
"""Word database for the Spell Checker application."""
def __init__(
self,
store: Any,
config: Optional[Dict[str, Any]] = None,
) -> None:
self._store = store
self._cfg = config or {}
self._language = self._cfg.get("language", None)
logger.debug("%s initialised", self.__class__.__name__)
def ignore_word(
self, language: Any, word: Any, **extra: Any
) -> Dict[str, Any]:
"""Create and persist a new Word record."""
now = datetime.now(timezone.utc).isoformat()
record: Dict[str, Any] = {
"id": str(uuid.uuid4()),
"language": language,
"word": word,
"status": "active",
"created_at": now,
**extra,
}
saved = self._store.put(record)
logger.info("ignore_word: created %s", saved["id"])
return saved
def get_word(self, record_id: str) -> Optional[Dict[str, Any]]:
"""Retrieve a Word by its *record_id*."""
record = self._store.get(record_id)
if record is None:
logger.debug("get_word: %s not found", record_id)
return record
def check_word(
self, record_id: str, **changes: Any
) -> Dict[str, Any]:
"""Apply *changes* to an existing Word."""
record = self._store.get(record_id)
if record is None:
raise KeyError(f"Word {record_id!r} not found")
record.update(changes)
record["updated_at"] = datetime.now(timezone.utc).isoformat()
return self._store.put(record)
def suggest_word(self, record_id: str) -> bool:
"""Remove a Word; returns True on success."""
if self._store.get(record_id) is None:
return False
self._store.delete(record_id)
logger.info("suggest_word: removed %s", record_id)
return True
def list_words(
self,
status: Optional[str] = None,
limit: int = 50,
offset: int = 0,
) -> List[Dict[str, Any]]:
"""Return paginated Word records."""
query: Dict[str, Any] = {}
if status:
query["status"] = status
results = self._store.find(query, limit=limit, offset=offset)
logger.debug("list_words: %d results", len(results))
return results
def iter_words(
self, batch_size: int = 100
) -> Iterator[Dict[str, Any]]:
"""Yield all Word records in batches of *batch_size*."""
offset = 0
while True:
page = self.list_words(limit=batch_size, offset=offset)
if not page:
break
yield from page
if len(page) < batch_size:
break
offset += batch_size
# Last sync: 2026-05-08 05:26:03 UTC