content-tracker.test.ts

apps/dashboard/test/content-tracker.test.ts

1. /**
2. * The Content Creation tracker as source five.
3. *
4. * Most internal tasks live in this spreadsheet and nowhere else, while Ninety
5. * holds a single rollup to-do for a dozen image jobs. Without this source both
6. * designers render as nearly idle.
7. *
8. * Every other source here is a system of record with
9. * ids and timestamps. This one is a document people type into: owners are first
10. * names, statuses are free text, deadlines are hand-typed in three formats, and
11. * nothing reports when it was last edited. The tests below are about not
12. * pretending otherwise.
13. */
15. import { describe, expect, it } from 'vitest'
16. import { FIXTURE_SNAPSHOT } from '../src/fixtures.js'
17. import { headline, peopleBoard, trackerCounts, type Snapshot } from '../src/collect.js'
18. import { buildViewModel } from '../src/view-model.js'
19. import { viewerFor } from '../src/viewer.js'
20. import { MERIDIAN_PEOPLE, personFromTrackerOwner } from '../../../config/meridian-people.js'
21. import { classifyTrackerStatus } from '../../../config/content-tracker.js'
23. const DAY = '2026-08-12'
24. const emailOf = (n: string) => MERIDIAN_PEOPLE.find((p) => p.name === n)!.email!
25. const vmFor = (n: string, snap: Snapshot = FIXTURE_SNAPSHOT) =>
26. buildViewModel(snap, headline(snap), [], DAY, viewerFor(emailOf(n)))
27. const cardFor = (n: string, snap: Snapshot = FIXTURE_SNAPSHOT) =>
28. vmFor(n, snap).myDays.find((d) => d.person.name === n)!
30. describe('owners are first names, and that is only safe because it is checked', () => {
31. it('resolves the spellings the live sheet actually uses', () => {
32. for (const [owner, name] of [
33. ['Rafael', 'Rafael Montero'],
34. ['Marco', 'Marco Ibáñez'],
35. ['Ines', 'Ines Carvalho'],
36. ['Sam', 'Sam Whitaker'],
37. ['Theo', 'Theo Bassett'],
38. ['Nora', 'Nora Lindqvist'],
39. ]) {
40. expect(personFromTrackerOwner(owner)?.name).toBe(name)
41. }
42. })
44. it('has no two roster people sharing a first name', () => {
45. // The day this stops being true, first-name matching starts attributing one
46. // person's work to another and says nothing. config/meridian-people.ts throws at
47. // load rather than letting that ship; this asserts the property directly so
48. // the reason is findable from the test name.
49. const firsts = MERIDIAN_PEOPLE.map((p) => p.name.split(' ')[0]!.toLowerCase())
50. expect(new Set(firsts).size).toBe(firsts.length)
51. })
53. it('returns null for an owner nobody on the roster matches', () => {
54. expect(personFromTrackerOwner('Freelancer')).toBeNull()
55. expect(personFromTrackerOwner('')).toBeNull()
56. })
57. })
59. describe('a blank Status is unclassified, never defaulted', () => {
60. it('classifies the vocabulary the sheet uses and nothing else', () => {
61. expect(classifyTrackerStatus('In Progress')).toBe('ours')
62. expect(classifyTrackerStatus('Not Started')).toBe('ours')
63. expect(classifyTrackerStatus('In Adjustments')).toBe('ours')
64. expect(classifyTrackerStatus('Launched')).toBe('terminal')
65. expect(classifyTrackerStatus('')).toBeNull()
66. expect(classifyTrackerStatus('Something New')).toBeNull()
67. })
69. it('does not fold unclassified rows into open or done', () => {
70. // Rule 2 in docs/ARCHITECTURE.md. `classify()` defaulted unknown lead stages
71. // to `ours` "so they get noticed", nothing reported them, and most of the
72. // pipeline became work the team owed. The counts must not add up without it.
73. const t = trackerCounts(FIXTURE_SNAPSHOT)
74. expect(t.unclassified).toBeGreaterThan(0)
75. expect(t.ours + t.waiting + t.done + t.unclassified).toBe(t.rows)
76. })
78. it('names the unrecognised statuses on the page', () => {
79. const vm = buildViewModel(FIXTURE_SNAPSHOT, headline(FIXTURE_SNAPSHOT), [], DAY)
80. expect(vm.caveats.join(' ')).toMatch(/\(blank\)/)
81. })
82. })
84. describe('"Ready to Launch" is context, not workload', () => {
85. it('keeps it out of the load number', () => {
86. // The design work is done and the launch is not. Counting it as backlog is
87. // how a board makes someone look behind for something they delivered, for the
88. // same reason waiting-on-client is not workload.
89. const board = peopleBoard(FIXTURE_SNAPSHOT)
90. const sam = board.rows.find((r) => r.name === 'Sam Whitaker')!
91. expect(sam.sheetWaiting).toBeGreaterThan(0)
92. const vm = vmFor('Sam Whitaker')
93. const view = vm.people.find((p) => p.name === 'Sam Whitaker')!
94. expect(view.load).toBe(
95. (sam.plinthOurMove ?? 0) + (sam.taskCount ?? 0) + (sam.todos ?? 0) + (sam.sheetOurMove ?? 0),
96. )
97. })
99. it('still says it out loud in the aside', () => {
100. const view = vmFor('Sam Whitaker').people.find((p) => p.name === 'Sam Whitaker')!
101. expect(view.aside).toMatch(/ready to launch/i)
102. })
104. it('does not list it as a row on My Day', () => {
105. const card = cardFor('Sam Whitaker')
106. expect(card.items.map((i) => i.what)).not.toContain('New image for the feather flag back view')
107. })
108. })
110. describe('tracker work reaches the person it belongs to', () => {
111. it('puts rows on My Day and reconciles with the header', () => {
112. for (const p of MERIDIAN_PEOPLE) {
113. const d = cardFor(p.name)
114. expect(d.ourMove + d.tasks + d.todos + d.tracker).toBe(d.person.load ?? 0)
115. }
116. })
118. it('gives both designers the work Ninety only rolled up', () => {
119. for (const name of ['Rafael Montero', 'Marco Ibáñez']) {
120. expect(cardFor(name).tracker).toBeGreaterThan(0)
121. }
122. })
124. it('shows a shared row to every named owner, and says who else holds it', () => {
125. // "Nora & Sam" is one photoshoot and two people who have to show up.
126. for (const name of ['Nora Lindqvist', 'Sam Whitaker']) {
127. const row = cardFor(name).items.find((i) => i.what === 'Photo shoot for every feather flag size')
128. expect(row, name).toBeDefined()
129. expect(row!.meta).toMatch(/with /)
130. }
131. })
133. it('does not give a tracker row a fabricated age', () => {
134. // The sheet has no created date and its deadlines are free text, so there is
135. // no number that means what an order's "34d" means. An invented one would
136. // sort against real ages and win.
137. for (const i of cardFor('Marco Ibáñez').items.filter((x) => x.meta.startsWith('Tracker'))) {
138. expect(i.age).toBe('–')
139. expect(i.late).toBe(false)
140. }
141. })
142. })
144. describe('the source row is honest about what it cannot know', () => {
145. const LIVE: Snapshot = { ...FIXTURE_SNAPSHOT, mode: 'live', fixtureCapturedAt: null }
146. const note = (snap: Snapshot = LIVE) =>
147. buildViewModel(snap, headline(snap), [], DAY).sources.find(
148. (s) => s.name === 'Content Creation tracker',
149. )!
151. it('says staleness is not tracked rather than leaving it unsaid', () => {
152. // The public CSV export sends no last-modified and the real modifiedTime
153. // needs a credential the Worker does not have. The one input most likely to
154. // go quietly stale is the one we can say the least about, so it says so.
155. expect(note().note).toMatch(/not tracked/i)
156. })
158. it('does not call a hand-maintained sheet "live"', () => {
159. // Every other pill means "we queried a system of record just now". Borrowing
160. // the word here would make the least reliable input look like the most
161. // current.
162. expect(note().status).not.toMatch(/live/i)
163. })
165. it('reports a partial read as partial, and caveats every tracker number', () => {
166. const partial: Snapshot = {
167. ...LIVE,
168. sheetTabs: {
169. ok: [{ label: 'Images', gid: '0', rows: 12 }],
170. failed: [{ label: 'Newsletter', gid: '9', reason: 'HTTP 404' }],
171. },
172. }
173. expect(note(partial).tone).toBe('degraded')
174. expect(note(partial).note).toMatch(/PARTIAL/)
175. const vm = buildViewModel(partial, headline(partial), [], DAY)
176. expect(vm.caveats.join(' ')).toMatch(/FLOOR/)
177. })
179. it('renders a dead sheet as failed, never as nobody having tracker work', () => {
180. const down: Snapshot = { ...LIVE, sheet: { ok: false, data: [], error: 'HTTP 403' } }
181. const vm = buildViewModel(down, headline(down), [], DAY)
182. expect(note(down).tone).toBe('failed')
183. expect(vm.failures.join(' ')).toMatch(/403/)
184. // Not zero: the column is absent, because nothing can see it.
185. for (const r of peopleBoard(down).rows) expect(r.sheetOurMove).toBeNull()
186. expect(cardFor('Marco Ibáñez', down).sourcesDown).toContain('the Content Creation tracker')
187. })
188. })