strukto-ai--mirage/python/mirage/commands/builtin/gsheets/gws_sheets_append.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. =========

import json

from mirage.accessor.gsheets import GSheetsAccessor
from mirage.commands.registry import command
from mirage.commands.spec.types import CommandSpec, OperandKind, Option
from mirage.core.gsheets.write import append_values
from mirage.io.stream import yield_bytes
from mirage.io.types import ByteSource, IOResult
from mirage.types import PathSpec

SPEC = CommandSpec(options=(
    Option(long="--spreadsheet", value_kind=OperandKind.TEXT),
    Option(long="--range", value_kind=OperandKind.TEXT),
    Option(long="--values", value_kind=OperandKind.TEXT),
    Option(long="--json-values", value_kind=OperandKind.TEXT),
), )


@command("gws-sheets-append",
         resource=["gsheets", "gdrive"],
         spec=SPEC,
         write=True)
async def gws_sheets_append(
    accessor: GSheetsAccessor,
    paths: list[PathSpec],
    *texts: str,
    **_extra: object,
) -> tuple[ByteSource | None, IOResult]:
    sheet_id = _extra.get("spreadsheet", "")
    range_ = _extra.get("range", "A1")
    values_csv = _extra.get("values", "")
    json_values = _extra.get("json-values", _extra.get("json_values", ""))
    if not sheet_id or not isinstance(sheet_id, str):
        raise ValueError("--spreadsheet is required")
    if json_values and isinstance(json_values, str):
        values_json = json_values
    elif values_csv and isinstance(values_csv, str):
        row = values_csv.split(",")
        values_json = json.dumps([row])
    else:
        raise ValueError("--values or --json-values is required")
    if not isinstance(range_, str):
        range_ = "A1"
    result = await append_values(accessor.token_manager, sheet_id, range_,
                                 values_json)
    out = json.dumps(result, ensure_ascii=False,
                     separators=(",", ":")).encode()
    return yield_bytes(out), IOResult()