← Files Codex SecurityARCHIVED FILE

scripts/snapshot_sqlite.py

1.7 KB · Nov 18, 2026 · 06:11 UTC

↓ Download file

See the change to this file →

#!/usr/bin/env python3
"""Create a transactionally consistent SQLite database snapshot."""

from __future__ import annotations

import argparse
import os
import sqlite3
from pathlib import Path
from urllib.parse import quote


def readonly_sqlite_uri(path: Path) -> str:
    """Escape the native filename, including separators, without introducing a URI authority."""
    filename = os.fsencode(path) if os.name == "posix" else str(path)
    return f"file:{quote(filename, safe='')}?mode=ro"


def main() -> None:
    """Back up the read-only source database into a separate destination using SQLite’s backup API."""
    parser = argparse.ArgumentParser(description=__doc__)
    parser.add_argument("source", type=Path)
    parser.add_argument("destination", type=Path)
    args = parser.parse_args()
    source = args.source.expanduser().resolve(strict=True)
    destination = args.destination.expanduser().absolute()
    # SQLite backup cannot make progress when both connections use the same file.
    if destination.exists() and destination.samefile(source):
        parser.error(f"Destination must not be the same file as source: {destination}")
    destination.parent.mkdir(parents=True, exist_ok=True)
    with sqlite3.connect(readonly_sqlite_uri(source), uri=True) as source_connection:
        creation_destination = destination.resolve()
        try:
            creation_destination.touch(mode=0o600, exist_ok=False)
        except FileExistsError:
            pass
        else:
            creation_destination.chmod(0o600)
        with sqlite3.connect(destination) as destination_connection:
            source_connection.backup(destination_connection)
    destination.chmod(0o600)


if __name__ == "__main__":
    main()

SHA-256: 9f3c4835730e2e766c3b082242594bd773a3cae2cc76aa9be47a7faab96c3947