Files
interactive-story/backend/tests/test_history_window.py
parththakkar106andClaude Opus 5 f1bebe18d0 Drop the eight legacy columns SP8 left behind
Migrations 66 to 73 drop `actions.index`, `variants`, `variant_index`,
`variant_count`, `state_before`, and `world_state_before`, plus
`adventures.memory_cursor` and `summary_cursor`. `index` is a keyword in
SQLite, so migration 71 quotes it.

Nothing outside the migrations read these. `models.py`, `schemas.py`, and
`ACTION_LIST_COLUMNS` lose the same eight fields, `Adventure.actions` orders
by `id`, and `attempts.renumber`, `context.history.max_action_index`, and
`nodes.next_index` are deleted.

Two changes keep the migration replayable on a `create_all` database:

- `_split_variants_into_siblings` wrote through the live ORM table, so it
  stopped compiling once migration 66 removed five of its columns. It now
  writes through `_ACTIONS_AT_60`, a frozen `Table` with its own `MetaData`.
- Five data passes read columns these migrations drop. Each now calls
  `_has_columns` and returns early when the columns are absent.

`bootstrap` takes a `through` version so a migration test can stop at the
schema it asserts on.

555 tests pass, up from 549. Eight of the new cases assert each column is
gone after a real schema-45 database migrates all the way.

Co-Authored-By: Claude Opus 5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_0198qDK3gmgSo7EtQ4GTPqqK
2026-08-29 17:15:49 +05:30

258 lines
10 KiB
Python

"""The context builder reads a window of the story, not all of it.
Walking `adventure.actions` every turn made the turn cost O(story length).
A long adventure read hundreds of KB to use only the tail of it, and the
cost grew with every turn played. `app.context.history` serves tails,
slices, and counts from SQL instead.
Two things must hold, and both are easy to break by accident:
* The window must produce exactly the prompt the full story produced.
Otherwise, the change alters behavior even though it looks like a pure
optimization.
* The helpers must agree with the old list arithmetic, because
memorybank's cursors are positions in that list. A cursor off by one
silently summarizes the wrong actions.
python -m pytest tests/test_history_window.py -v
"""
import pytest
from sqlalchemy import event
from app import memorybank, models
from app.context import builder, history
from app.database import Base, SessionLocal, engine
# Long enough that a window is much smaller than the whole story.
ACTION_COUNT = 200
NARRATION = (
"The scrub gives way to a shallow bowl of land where woodsmoke hangs in "
"flat grey layers, and somewhere behind the largest tent a woman is "
"arguing, low and fast. "
) * 3
SCHEMA = {
"player": {"hp": {"min": 0, "max": 100, "initial": 100, "desc": "Health"}},
"npcs": {
"gwen": {"name": "Gwen", "keys": ["gwen"], "desc": "A scout.",
"stats": {"trust": {"min": 0, "max": 100, "initial": 30}}},
},
}
@pytest.fixture()
def story():
"""An adventure with ACTION_COUNT actions, plus its settings."""
Base.metadata.create_all(bind=engine)
db = SessionLocal()
user = models.User(is_guest=False, email="window@example.com")
db.add(user)
db.flush()
settings = models.Settings(user_id=user.id, api_key="enc:dummy", model="m")
db.add(settings)
scenario = models.Scenario(user_id=user.id, title="S", stat_schema=SCHEMA,
prompt="A long road." * 50)
db.add(scenario)
db.flush()
adventure = models.Adventure(
user_id=user.id, title="Long", scenario_id=scenario.id, script_state={},
memory="The hero is hunting bandits. " * 20,
world_state={"player": {"hp": 100}, "npc": {"gwen": {"trust": 30}},
"milestones": {}, "flags": {}, "_meta": {"last_changed": {}}},
)
db.add(adventure)
db.flush()
db.add(models.StoryCard(adventure_id=adventure.id, name="Gwen", keys="gwen",
entry="A scout with sharp eyes.", type="lore"))
for i in range(ACTION_COUNT):
db.add(models.Action(
adventure_id=adventure.id,
type="ai" if i % 2 else "do",
text=f"[{i}] {NARRATION}",
world_delta={"delta": {"player.hp": -1},
"applied": [{"path": "player.hp", "old": 100, "new": 99}]},
))
db.commit()
db.expire_all()
adventure = db.get(models.Adventure, adventure.id)
settings = db.get(models.Settings, settings.id)
try:
yield db, adventure, settings
finally:
db.close()
Base.metadata.drop_all(bind=engine)
def full_window(adventure, budget_tokens, token_counter, exclude_action_id=None):
"""Stand-in for `window_covering` that returns the entire story. This is
the behavior this module replaced."""
return history.story_actions(adventure, exclude_action_id)
@pytest.fixture()
def actions_loaded():
"""Counts the `Action` rows the ORM materializes, which shows how much of
the story was actually fetched. `rowcount` is meaningless for a SELECT
on SQLite, so this counts the objects the mapper builds instead."""
loaded = {"n": 0}
def on_load(target, context):
loaded["n"] += 1
event.listen(models.Action, "load", on_load)
try:
yield loaded
finally:
event.remove(models.Action, "load", on_load)
# ------------------------------------------------------- the prompt is equal
@pytest.mark.parametrize("budget", [1024, 4096, 8192, 16384, 65536])
def test_window_builds_the_same_prompt_as_the_whole_story(story, budget, monkeypatch):
db, adventure, settings = story
settings.context_token_budget = budget
windowed = builder.build_context(adventure, settings)
monkeypatch.setattr(builder.history, "window_covering", full_window)
db.expire(adventure)
everything = builder.build_context(adventure, settings)
assert windowed[0] == everything[0], "system prompt differs"
assert windowed[1] == everything[1], "story prompt differs"
assert windowed[2]["history"] == everything[2]["history"]
assert windowed[2]["cards"] == everything[2]["cards"]
def test_window_matches_on_the_retry_shape(story, monkeypatch):
"""Retry excludes the action being regenerated. The exclusion must reach
the window query, not just the in-memory filter."""
db, adventure, settings = story
last = history.tail(adventure, 1)[0]
windowed = builder.build_context(adventure, settings, exclude_action_id=last.id)
assert f"[{last.depth}]" not in windowed[1]
monkeypatch.setattr(builder.history, "window_covering", full_window)
db.expire(adventure)
everything = builder.build_context(adventure, settings, exclude_action_id=last.id)
assert windowed[1] == everything[1]
def test_reported_total_is_the_whole_story_not_the_window(story):
"""Insights reports "N of M actions included." M must not become the
window size."""
db, adventure, settings = story
settings.context_token_budget = 4096
report = builder.build_context(adventure, settings)[2]
assert report["history"]["total"] == ACTION_COUNT
assert report["history"]["included"] < ACTION_COUNT
# ------------------------------------------------------------ it is bounded
def test_building_context_reads_far_less_than_the_whole_story(story, actions_loaded):
db, adventure, settings = story
# Expire first. Expiring afterward would discard the unflushed change and
# silently put the budget back to its default.
db.expire_all()
# Small enough that the budget, not the length of the story, decides.
settings.context_token_budget = 4096
actions_loaded["n"] = 0
report = builder.build_context(adventure, settings)[2]
included = report["history"]["included"]
assert included < ACTION_COUNT, "fixture is too short to prove anything"
# The window targets a margin past the budget and requests more if it
# falls short, so it reads somewhat more than it includes. What matters
# is that the read depends on the token budget, not on the length of
# the story.
assert actions_loaded["n"] < ACTION_COUNT // 2, (
f"read {actions_loaded['n']} action rows out of {ACTION_COUNT} to "
f"include {included} — the window is not bounding the read"
)
def test_window_is_ordered_and_free_of_duplicates(story):
"""The window grows by fetching only what it does not already hold, so an
off-by-one in the offset would show up as a repeated or missing action."""
db, adventure, settings = story
window = history.window_covering(adventure, 16384, builder.count_tokens)
ids = [a.id for a in window]
assert len(ids) == len(set(ids)), "the same action appeared twice in the window"
assert ids == sorted(ids), "window must be oldest-first"
# ------------------------------------------- the node-anchored reads agree
def test_helpers_agree_with_the_full_list(story):
db, adventure, settings = story
actions = history.story_actions(adventure)
assert len(actions) == ACTION_COUNT
assert history.count(adventure) == len(actions)
assert [a.id for a in history.tail(adventure, 4)] == [a.id for a in actions[-4:]]
assert [a.id for a in history.slice_(adventure, 10, 6)] == [a.id for a in actions[10:16]]
assert [a.id for a in history.tail_range(adventure, 5, 3)] == \
[a.id for a in actions[-8:-5]]
assert history.newest(adventure).id == actions[-1].id
for probe in (0, 1, ACTION_COUNT // 2, ACTION_COUNT - 1):
boundary = actions[probe].depth
assert history.count_after(adventure, boundary) == ACTION_COUNT - probe - 1
assert [a.id for a in history.after(adventure, boundary, 3)] == \
[a.id for a in actions[probe + 1:probe + 4]]
def test_a_depth_boundary_survives_a_middle_action_being_deleted(story):
"""The case that broke the cursors twice before. This is the reason the
cursors are depths now.
A position answers "how much story is past this point?" by counting
from the start. Deleting anything in front of the mark changes which
action the mark names. A depth names the same node either way. The
only thing that changes is the count of what comes after, and that
count is the one thing that should change here.
"""
db, adventure, settings = story
actions = history.story_actions(adventure)
mark = actions[30].depth
before = history.count_after(adventure, mark)
next_three = [a.id for a in history.after(adventure, mark, 3)]
victim = actions[10] # in front of the mark
db.delete(victim)
db.commit()
db.expire(adventure)
assert history.count(adventure) == ACTION_COUNT - 1
assert history.count_after(adventure, mark) == before, "the mark moved"
assert [a.id for a in history.after(adventure, mark, 3)] == next_three
# Deleting something after the mark is the one change that does affect
# the count, because that count reflects the story, not the coordinate
# system.
db.delete(history.after(adventure, mark, 1)[0])
db.commit()
db.expire(adventure)
assert history.count_after(adventure, mark) == before - 1
def test_blank_actions_are_excluded_the_same_way_in_sql_and_python(story):
"""SQL and Python must agree on membership or a cursor points elsewhere."""
db, adventure, settings = story
for blank in ("", " ", "\n", "\t\n "):
db.add(models.Action(adventure_id=adventure.id,
type="story", text=blank))
db.commit()
db.expire(adventure)
# SQL path (relationship not loaded)
from_sql = history.count(adventure)
# Python path (relationship loaded)
adventure.actions # noqa: B018 - force the collection into memory
from_python = history.count(adventure)
assert from_sql == from_python == ACTION_COUNT