Function inspect_auth_db

mobile_codex_control.py:97–123

(path: Path)

def inspect_auth_db(path: Path) -> tuple[int, set[str]]:
    if not path.exists():
        return -1, set()

    try:
        connection = sqlite3.connect(path)
        try:
            tables = {
                row[0]
                for row in connection.execute("SELECT name FROM sqlite_master WHERE type = 'table'")
            }
            score = 0
            if "users" in tables:
                score += 1
            if "trusted_devices" in tables:
                score += 3
            if "device_approval_requests" in tables:
                score += 3
            if "users" in tables:
                user_count = connection.execute("SELECT COUNT(*) FROM users").fetchone()[0]
                if user_count:
                    score += 2
            return score, tables
        finally:
            connection.close()
    except sqlite3.Error:
        return -1, set()


def resolve_auth_db_path() -> Path: