"""目録（SQLite）の接続・マイグレーションの適用・各表の操作.

SQL はこのパッケージの中にだけ書く（他のモジュールはここの関数を呼ぶ）．
対応表（`identity`）の操作は `tiasdata.catalog.identity` にあり，取り込みの処理からだけ使う．
"""

from tiasdata.catalog.connection import connect, write_transaction
from tiasdata.catalog.migrate import (
    MigrationResult,
    Series,
    apply_migrations,
    latest_version,
    require_latest,
    schema_version,
)
from tiasdata.catalog.queries import (
    count_annotation_values,
    count_assets_by_kind,
    count_broken_dataset_members,
    count_captures,
    count_dangling_annotations,
    count_kinds,
    count_subjects,
    count_subjects_with_multiple_captures,
    count_superseded_annotations,
    list_asset_files,
)

__all__ = [
    "MigrationResult",
    "Series",
    "apply_migrations",
    "connect",
    "count_annotation_values",
    "count_assets_by_kind",
    "count_broken_dataset_members",
    "count_captures",
    "count_dangling_annotations",
    "count_kinds",
    "count_subjects",
    "count_subjects_with_multiple_captures",
    "count_superseded_annotations",
    "latest_version",
    "list_asset_files",
    "require_latest",
    "schema_version",
    "write_transaction",
]