#!/bin/bash
# Test script for MCP Excel Workbook Processor
set -e
echo "Building Docker image..."
docker compose build
echo ""
echo "Testing MCP server with sample file..."
echo ""
# Test reading sample.xlsx - all sheets
echo "Test 1: Extracting all sheets from sample.xlsx"
docker compose run --rm mcp-excel-server python -c "
import sys
sys.path.insert(0, '/app')
from src.excel_reader_server.file_handler import ExcelFileResolver, WorkbookParser
import json
path = ExcelFileResolver.locate_file('sample.xlsx')
result = WorkbookParser.extract_all_sheets(path)
print(json.dumps(result, indent=2, ensure_ascii=False))
"
echo ""
echo "Test 2: Extracting 'Sales' sheet from sample.xlsx"
docker compose run --rm mcp-excel-server python -c "
import sys
sys.path.insert(0, '/app')
from src.excel_reader_server.file_handler import ExcelFileResolver, WorkbookParser
import json
path = ExcelFileResolver.locate_file('sample.xlsx')
result = WorkbookParser.extract_sheet_by_name(path, 'Sales')
print(json.dumps(result, indent=2, ensure_ascii=False))
"
echo ""
echo "Test 3: Extracting sheet at position 1 from sample.xlsx"
docker compose run --rm mcp-excel-server python -c "
import sys
sys.path.insert(0, '/app')
from src.excel_reader_server.file_handler import ExcelFileResolver, WorkbookParser
import json
path = ExcelFileResolver.locate_file('sample.xlsx')
result = WorkbookParser.extract_sheet_by_position(path, 1)
print(json.dumps(result, indent=2, ensure_ascii=False))
"
echo ""
echo "All tests completed successfully!"
