strukto-ai--mirage/python/tests/core/gsheets/test_read.py

# ========= Copyright 2026 @ Strukto.AI All Rights Reserved. =========
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
# ========= Copyright 2026 @ Strukto.AI All Rights Reserved. =========

from unittest.mock import AsyncMock, patch

import pytest

from mirage.accessor.gsheets import GSheetsAccessor
from mirage.cache.index.ram import RAMIndexCacheStore
from mirage.core.gsheets.read import read
from mirage.types import PathSpec
from mirage.utils.key_prefix import mount_key


@pytest.fixture
def accessor():
    return GSheetsAccessor(config=None, token_manager=None)


@pytest.fixture
def index():
    return RAMIndexCacheStore()


@pytest.mark.asyncio
async def test_read_auto_bootstraps_from_empty_index(accessor, index):
    files = [{
        "id": "sheet1",
        "name": "Budget",
        "modifiedTime": "2026-04-01T00:00:00.000Z",
        "owners": [{
            "me": True
        }],
    }]
    with (
            patch(
                "mirage.core.gsheets.readdir.list_all_files",
                new_callable=AsyncMock,
                return_value=files,
            ),
            patch(
                "mirage.core.gsheets.read.read_spreadsheet",
                new_callable=AsyncMock,
                return_value=b'{"spreadsheetId":"sheet1"}',
            ),
    ):
        path = PathSpec(
            resource_path=mount_key(
                "/gsheets/owned/2026-04-01_Budget__sheet1.gsheet.json",
                "/gsheets"),
            virtual="/gsheets/owned/2026-04-01_Budget__sheet1.gsheet.json",
            directory="/gsheets/owned/2026-04-01_Budget__sheet1.gsheet.json",
        )
        result = await read(accessor, path, index)
        assert b"sheet1" in result


@pytest.mark.asyncio
async def test_read_missing_file_raises_after_recursion(accessor, index):
    with (
            patch(
                "mirage.core.gsheets.readdir.list_all_files",
                new_callable=AsyncMock,
                return_value=[],
            ),
            patch(
                "mirage.core.gsheets.read.read_spreadsheet",
                new_callable=AsyncMock,
                side_effect=AssertionError("should not call read_spreadsheet"),
            ),
    ):
        path = PathSpec(
            resource_path=mount_key("/gsheets/owned/Missing__xyz.gsheet.json",
                                    "/gsheets"),
            virtual="/gsheets/owned/Missing__xyz.gsheet.json",
            directory="/gsheets/owned/Missing__xyz.gsheet.json",
        )
        with pytest.raises(FileNotFoundError):
            await read(accessor, path, index)