import { beforeAll, describe, expect, it } from 'vitest'; import { eq } from 'drizzle-orm'; import { db, tables } from './db/index.ts'; import { createBook, createChapter, createScene } from './structure.ts'; import { CardMoveRefused, createStoryline, deleteCard, deleteStoryline, ensureCard, loadPlotGrid, moveCard, renameStoryline, updateCard } from './plot.ts'; import { listTrash, restoreTrash } from './recovery.ts'; import { listItemVersions, loadItemVersion } from './item-history.ts'; import { databaseRows } from './database-fixtures.ts'; function fixture() { const projectId = crypto.randomUUID(); db.insert(tables.project).values({ id: projectId, ownerId: 'writer', title: 'Grid' }).run(); const bookId = createBook(projectId, 'Book'); const { chapterId, sceneId } = createChapter(projectId, { bookId, partId: null }, 'Chapter'); const secondSceneId = createScene(projectId, chapterId, 'Second scene'); const lineId = createStoryline(projectId, 'The Bell', 'dead-thread'); const otherLineId = createStoryline(projectId, 'The Debt', 'blue-screen'); const cardId = ensureCard(projectId, lineId, { kind: 'scene', id: sceneId })!; return { projectId, bookId, chapterId, sceneId, secondSceneId, lineId, otherLineId, cardId }; } function cellFixture(kind: 'scene' | 'chapter') { const own = fixture(); const column = { kind, id: kind === 'scene' ? own.sceneId : own.chapterId }; const secondColumn = { kind, id: kind === 'scene' ? own.secondSceneId : createChapter(own.projectId, { bookId: own.bookId }, 'Second chapter').chapterId }; const cardId = ensureCard(own.projectId, own.lineId, column)!; return { ...own, cardId, column, secondColumn }; } function card(id: string) { return db.select().from(tables.plotCard).where(eq(tables.plotCard.id, id)).get()!; } beforeAll(() => { db.delete(tables.project).run(); }); describe('storyline maintenance', () => { it('renames a row and refuses a foreign one', () => { const mine = fixture(); const theirs = fixture(); expect(renameStoryline(mine.projectId, mine.lineId, ' The Debt Bell ')).toBe(true); expect(loadPlotGrid(mine.projectId, 'scene').rows[0].title).toBe('The Debt Bell'); expect(renameStoryline(mine.projectId, theirs.lineId, 'Stolen')).toBe(false); expect(renameStoryline(mine.projectId, mine.lineId, ' ')).toBe(false); }); it('removes a row and its cards together, and trash brings both back', () => { const { projectId, lineId, cardId } = fixture(); expect(loadPlotGrid(projectId, 'scene').rows).toHaveLength(2); expect(deleteStoryline(projectId, lineId)).toBe(true); expect(loadPlotGrid(projectId, 'scene').rows).toHaveLength(1); // The card keeps its row, so restoring the storyline restores the grid. expect(card(cardId).deletedAt).toBeNull(); expect(listTrash(projectId).map((entry) => entry.kind)).toContain('storyline'); restoreTrash(projectId, 'storyline', lineId); expect(loadPlotGrid(projectId, 'scene').rows).toHaveLength(2); }); it('refuses a storyline from another project', () => { const mine = fixture(); const theirs = fixture(); expect(deleteStoryline(mine.projectId, theirs.lineId)).toBe(false); expect(loadPlotGrid(theirs.projectId, 'scene').rows).toHaveLength(2); }); }); describe('card maintenance', () => { it.each(['scene', 'chapter'] as const)( 'reuses an occupied %s cell without changing words or history', (kind) => { const own = cellFixture(kind); expect( updateCard(own.projectId, own.cardId, { title: 'Existing card', body: 'Keep these words' }) ).toBe(true); expect(card(own.cardId)).toMatchObject({ title: 'Existing card', body: 'Keep these words' }); const before = databaseRows(db.$client); expect(ensureCard(own.projectId, own.lineId, own.column)).toBe(own.cardId); expect(databaseRows(db.$client)).toEqual(before); } ); it.each(['scene', 'chapter'] as const)( 'saves edited words and a %s destination together with one version', (kind) => { const own = cellFixture(kind); expect( moveCard( own.projectId, own.cardId, { storylineId: own.otherLineId, column: own.secondColumn }, { title: 'New title', body: 'New notes' } ) ).toBe(true); expect(card(own.cardId)).toMatchObject({ storylineId: own.otherLineId, sceneId: kind === 'scene' ? own.secondColumn.id : null, chapterId: kind === 'chapter' ? own.secondColumn.id : null, title: 'New title', body: 'New notes' }); const versions = listItemVersions(own.projectId, 'plot_card', own.cardId); expect(versions).toHaveLength(1); expect(loadItemVersion(own.projectId, versions[0].id)).toMatchObject({ title: '', body: '' }); } ); it.each(['scene', 'chapter'] as const)( 'saves words when the %s destination is unchanged', (kind) => { const own = cellFixture(kind); expect( moveCard( own.projectId, own.cardId, { storylineId: own.lineId, column: own.column }, { title: 'Same cell', body: 'Still saved' } ) ).toBe(true); expect(card(own.cardId)).toMatchObject({ title: 'Same cell', body: 'Still saved' }); const versions = listItemVersions(own.projectId, 'plot_card', own.cardId); expect(versions).toHaveLength(1); expect(loadItemVersion(own.projectId, versions[0].id)).toMatchObject({ title: '', body: '' }); } ); it.each(['scene', 'chapter'] as const)( 'keeps both cards and history unchanged when an edited %s move is refused', (kind) => { const own = cellFixture(kind); const taken = ensureCard(own.projectId, own.otherLineId, own.secondColumn)!; expect( updateCard(own.projectId, own.cardId, { title: 'Moving card', body: 'Original words' }) ).toBe(true); expect(updateCard(own.projectId, taken, { title: 'Neighbour', body: 'Other words' })).toBe( true ); expect(listItemVersions(own.projectId, 'plot_card', own.cardId)).toHaveLength(1); expect(listItemVersions(own.projectId, 'plot_card', taken)).toHaveLength(1); const before = databaseRows(db.$client); expect(() => moveCard( own.projectId, own.cardId, { storylineId: own.otherLineId, column: own.secondColumn }, { title: 'Must not save', body: 'Must not save either' } ) ).toThrow(CardMoveRefused); expect(databaseRows(db.$client)).toEqual(before); } ); it('refuses edited moves with foreign cards, rows, scenes, or chapters', () => { const own = fixture(); const other = fixture(); const before = card(own.cardId); const foreignBefore = card(other.cardId); for (const [id, target] of [ [other.cardId, { storylineId: own.lineId, column: { kind: 'scene', id: own.secondSceneId } }], [own.cardId, { storylineId: other.lineId, column: { kind: 'scene', id: own.secondSceneId } }], [own.cardId, { storylineId: own.lineId, column: { kind: 'scene', id: other.sceneId } }], [own.cardId, { storylineId: own.lineId, column: { kind: 'chapter', id: other.chapterId } }] ] as const) { expect(moveCard(own.projectId, id, target, { title: 'Foreign', body: 'Refused' })).toBe( false ); } expect(card(own.cardId)).toEqual(before); expect(card(other.cardId)).toEqual(foreignBefore); expect(listItemVersions(own.projectId, 'plot_card', own.cardId)).toHaveLength(0); }); it('moves a card to another row and column', () => { const { projectId, cardId, otherLineId, secondSceneId } = fixture(); expect( moveCard(projectId, cardId, { storylineId: otherLineId, column: { kind: 'scene', id: secondSceneId } }) ).toBe(true); const moved = card(cardId); expect(moved.storylineId).toBe(otherLineId); expect(moved.sceneId).toBe(secondSceneId); }); it.each(['scene', 'chapter'] as const)( 'refuses an occupied %s cell for an unedited move', (kind) => { const { projectId, cardId, lineId, secondColumn } = cellFixture(kind); const taken = ensureCard(projectId, lineId, secondColumn)!; expect(taken).not.toBe(cardId); expect(card(taken)).toMatchObject({ id: taken, deletedAt: null }); const before = databaseRows(db.$client); expect(() => moveCard(projectId, cardId, { storylineId: lineId, column: secondColumn }) ).toThrow(CardMoveRefused); expect(databaseRows(db.$client)).toEqual(before); } ); it('refuses a foreign row and a foreign column', () => { const mine = fixture(); const theirs = fixture(); expect( moveCard(mine.projectId, mine.cardId, { storylineId: theirs.lineId, column: { kind: 'scene', id: mine.secondSceneId } }) ).toBe(false); expect( moveCard(mine.projectId, mine.cardId, { storylineId: mine.lineId, column: { kind: 'scene', id: theirs.sceneId } }) ).toBe(false); expect(card(mine.cardId).sceneId).toBe(mine.sceneId); }); it.each(['scene', 'chapter'] as const)( 'restores a %s card only when its cell is empty', (kind) => { const { projectId, lineId, cardId, column } = cellFixture(kind); expect( updateCard(projectId, cardId, { title: 'Recovered card', body: 'Words to keep' }) ).toBe(true); expect(deleteCard(projectId, cardId)).toBe(true); expect( loadPlotGrid(projectId, kind) .rows.flatMap((row) => row.cards) .map((row) => row.id) ).not.toContain(cardId); restoreTrash(projectId, 'plot_card', cardId); expect(card(cardId)).toMatchObject({ deletedAt: null, title: 'Recovered card', body: 'Words to keep' }); expect(deleteCard(projectId, cardId)).toBe(true); const replacement = ensureCard(projectId, lineId, column)!; expect(replacement).not.toBe(cardId); expect(updateCard(projectId, replacement, { title: 'Replacement', body: 'New words' })).toBe( true ); expect(card(cardId).deletedAt).toBeInstanceOf(Date); const before = databaseRows(db.$client); expect(() => restoreTrash(projectId, 'plot_card', cardId)).toThrow(/already has a card/); expect(databaseRows(db.$client)).toEqual(before); expect(deleteCard(projectId, replacement)).toBe(true); restoreTrash(projectId, 'plot_card', cardId); expect(card(cardId)).toMatchObject({ deletedAt: null, title: 'Recovered card', body: 'Words to keep' }); expect(card(replacement).deletedAt).toBeInstanceOf(Date); } ); it('keeps a malformed card out of the grid and its write paths', () => { const own = fixture(); for (const damaged of [ { sceneId: own.sceneId, chapterId: own.chapterId }, { sceneId: null, chapterId: null } ]) { db.update(tables.plotCard).set(damaged).where(eq(tables.plotCard.id, own.cardId)).run(); expect(deleteCard(own.projectId, own.cardId)).toBe(false); expect( loadPlotGrid(own.projectId, 'scene') .rows.flatMap((row) => row.cards) .map((row) => row.id) ).not.toContain(own.cardId); } }); it('refuses a card from another project', () => { const mine = fixture(); const theirs = fixture(); expect(deleteCard(mine.projectId, theirs.cardId)).toBe(false); expect(card(theirs.cardId).deletedAt).toBeNull(); }); });