Files
dbx-corm/tests/test_manual_orders_deploy.py

78 lines
3.3 KiB
Python

"""Read-only source capture and non-overwriting manual queue migration."""
import io
import os
import tempfile
import unittest
from contextlib import redirect_stdout
from pathlib import Path
from unittest.mock import MagicMock, patch
import psycopg2
import main
import manual_orders_deploy as deployment
from manual_orders import HEADERS
from settings_migrate import save_snapshot
SOURCE = {"kind": "corm-manual-orders", "headers": HEADERS, "rows": [["2026-10-22"] + [""] * 14]}
class MigrationTests(unittest.TestCase):
def setUp(self):
self.directory = tempfile.TemporaryDirectory()
self.addCleanup(self.directory.cleanup)
self.path = Path(self.directory.name) / "manual-orders-source.json"
save_snapshot(self.path, SOURCE, "test")
self.store = MagicMock()
self.store.list_rows.return_value = {"headers": HEADERS, "rows": [{"id": 1, "cells": SOURCE["rows"][0], "version": 1}]}
mocked = patch.object(deployment, "ManualOrderStore", return_value=self.store)
mocked.start()
self.addCleanup(mocked.stop)
def test_existing_identical_queue_is_not_reimported(self):
with redirect_stdout(io.StringIO()):
deployment.migrate(self.directory.name)
self.store.import_source.assert_not_called()
def test_existing_different_queue_is_not_overwritten(self):
self.store.list_rows.return_value = {"headers": HEADERS, "rows": []}
with self.assertRaises(RuntimeError):
deployment.migrate(self.directory.name)
self.store.import_source.assert_not_called()
def test_missing_table_imports_then_validates_every_cell(self):
stored = self.store.list_rows.return_value
self.store.list_rows.side_effect = [psycopg2.errors.UndefinedTable(), stored]
with redirect_stdout(io.StringIO()):
deployment.migrate(self.directory.name)
self.store.import_source.assert_called_once_with(SOURCE, "manual-order-sheet")
def test_bad_checksum_never_accesses_database(self):
self.path.write_text(self.path.read_text(encoding="utf-8").replace('2026-10-22', '2026-10-23'), encoding="utf-8")
with self.assertRaises(ValueError):
deployment.migrate(self.directory.name)
self.store.list_rows.assert_not_called()
def test_google_source_keeps_first_sheet_order_and_uses_no_write_helpers(self):
client = MagicMock()
worksheet = client.open_by_key.return_value.get_worksheet.return_value
worksheet.get_all_values.return_value = [HEADERS, ["date"], [], ["other"]]
with patch.dict(os.environ, {"MANUAL_ORDERS_BACKEND": "google"}), \
patch.object(main, "get_gspread_client", return_value=client):
source = deployment.read_source()
self.assertEqual(len(source["rows"]), 3)
self.assertEqual(source["rows"][1], [""] * 15)
client.open_by_key.return_value.get_worksheet.assert_called_once_with(0)
worksheet.update.assert_not_called()
def test_db_source_never_reads_old_google_values(self):
with patch.dict(os.environ, {"MANUAL_ORDERS_BACKEND": "postgres"}), \
patch.object(main, "get_gspread_client") as google:
self.assertEqual(deployment.read_source(), SOURCE)
google.assert_not_called()
if __name__ == "__main__":
unittest.main()