78 lines
3.3 KiB
Python
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()
|