from __future__ import annotations
import argparse
import json
from typing import Sequence
from ..config import Settings
from .db import Database, DatabaseError
from .importer import database_counts, import_file_repository
from .parity import compare_repositories
def _database_settings(args: argparse.Namespace) -> Settings:
base = Settings()
database_url = args.database_url or base.database_url
if not database_url:
raise SystemExit(
"Set GNEXUS_BOOK_DATABASE_URL or pass --database-url "
"(for example postgresql+psycopg://gmikcon@127.0.0.1:5433/gnexus_book)"
)
return Settings(
repo_root=base.repo_root,
database_url=database_url,
storage_backend="db",
)
def _add_common(parser: argparse.ArgumentParser) -> None:
parser.add_argument(
"--database-url",
default=None,
help="PostgreSQL URL; defaults to GNEXUS_BOOK_DATABASE_URL",
)
def build_parser() -> argparse.ArgumentParser:
parser = argparse.ArgumentParser(
prog="python -m app.storage.cli",
description="Import and compare the file-backed knowledge base and PostgreSQL.",
)
subparsers = parser.add_subparsers(dest="command", required=True)
import_parser = subparsers.add_parser("import", help="Import the file repository into PostgreSQL")
_add_common(import_parser)
import_parser.add_argument("--replace", action="store_true", help="Clear existing data first")
import_parser.add_argument("--dry-run", action="store_true", help="Count without writing")
parity_parser = subparsers.add_parser("parity", help="Compare file and database read results")
_add_common(parity_parser)
parity_parser.add_argument(
"--query",
action="append",
default=None,
help="Search query to compare; repeatable",
)
counts_parser = subparsers.add_parser("counts", help="Print database row counts")
_add_common(counts_parser)
return parser
def main(argv: Sequence[str] | None = None) -> int:
parser = build_parser()
args = parser.parse_args(argv)
settings = _database_settings(args)
database = Database.from_settings(settings)
try:
if args.command == "import":
report = import_file_repository(
settings,
database,
replace=args.replace,
dry_run=args.dry_run,
)
print(json.dumps(report.as_dict(), indent=2))
return 0
if args.command == "counts":
print(json.dumps(database_counts(database), indent=2))
return 0
if args.command == "parity":
result = compare_repositories(settings, database, queries=args.query)
print(json.dumps(result, indent=2, ensure_ascii=False))
return 0 if result["ok"] else 1
except (DatabaseError, ValueError) as exc:
print(f"error: {exc}")
return 2
parser.error(f"unknown command {args.command}")
if __name__ == "__main__":
raise SystemExit(main())