Where agent teams gather. Cross-platform team chat where AI agents are first-class teammates — with cloud or bring-your-own (Claude Code / Codex) brains.
TypeScript
import { test } from 'node:test'
import assert from 'node:assert/strict'
import type { QueryResult, QueryResultRow } from 'pg'
import {
type AppliedMigration,
MAX_SUPPORTED_SCHEMA_VERSION,
MigrationHistoryError,
SCHEMA_MIGRATIONS,
validateMigrationHistory,
} from '../db/migrations/manifest.js'
process.env.CUMORA_RUNTIME_CLIENT = 'http'
process.env.OPENAI_API_KEY ??= 'test-key'
const { computedBaselineMigrationChecksum } = await import('../db/migrate.js')
const { normalizedConversationMembersChecksum } = await import('../db/migrations/0002-normalized-conversation-members.js')
const { workspaceCleanupJobsChecksum } = await import('../db/migrations/0003-workspace-cleanup-jobs.js')
const { agentRuntimeAssignmentChecksum } = await import('../db/migrations/0004-agent-runtime-assignment.js')
const { searchTrigramIndexChecksum } = await import('../db/migrations/0005-search-trigram-index.js')
const { emailMessagesCompanySmtpIdChecksum } = await import('../db/migrations/0006-email-messages-company-smtp-id.js')
const { engineDefaultsChecksum } = await import('../db/migrations/0007-engine-defaults.js')
const { agentProviderProfileChecksum } = await import('../db/migrations/0008-agent-provider-profile.js')
const { agentRoutingClaimsChecksum } = await import('../db/migrations/0009-agent-routing-claims.js')
const { boardCardDueOnChecksum } = await import('../db/migrations/0010-board-card-due-on.js')
const { agentNativeFastModeChecksum } = await import('../db/migrations/0011-agent-native-fast-mode.js')
const { messageAttachmentsChecksum } = await import('../db/migrations/0012-message-attachments.js')
const { attachmentGrantsChecksum } = await import('../db/migrations/0013-attachment-grants.js')
const { verifySchemaCompatibility } = await import('../db/schema-version.js')
type SchemaVersionQueryable = import('../db/schema-version.js').SchemaVersionQueryable
const current = (): AppliedMigration[] => SCHEMA_MIGRATIONS.map((migration) => ({ ...migration }))
test('the frozen baseline SQL matches its immutable manifest checksum', () => {
assert.equal(computedBaselineMigrationChecksum(), SCHEMA_MIGRATIONS[0].checksum)
})
test('the normalized membership migration matches its immutable manifest checksum', () => {
assert.equal(normalizedConversationMembersChecksum(), SCHEMA_MIGRATIONS[1].checksum)
})
test('the workspace cleanup migration matches its immutable manifest checksum', () => {
assert.equal(workspaceCleanupJobsChecksum(), SCHEMA_MIGRATIONS[2].checksum)
})
test('the runtime assignment migration matches its immutable manifest checksum', () => {
assert.equal(agentRuntimeAssignmentChecksum(), SCHEMA_MIGRATIONS[3].checksum)
})
test('the search trigram migration matches its immutable manifest checksum', () => {
assert.equal(searchTrigramIndexChecksum(), SCHEMA_MIGRATIONS[4].checksum)
})
test('the email messages company smtp id migration matches its immutable manifest checksum', () => {
assert.equal(emailMessagesCompanySmtpIdChecksum(), SCHEMA_MIGRATIONS[5].checksum)
})
test('the engine defaults migration matches its immutable manifest checksum', () => {
assert.equal(engineDefaultsChecksum(), SCHEMA_MIGRATIONS[6].checksum)
})
test('the agent provider profile migration matches its immutable manifest checksum', () => {
assert.equal(agentProviderProfileChecksum(), SCHEMA_MIGRATIONS[7].checksum)
})
test('the agent routing claims migration matches its immutable manifest checksum', () => {
assert.equal(agentRoutingClaimsChecksum(), SCHEMA_MIGRATIONS[8].checksum)
})
test('the board card due date migration matches its immutable manifest checksum', () => {
assert.equal(boardCardDueOnChecksum(), SCHEMA_MIGRATIONS[9].checksum)
})
test('the native Fast Mode migration matches its immutable manifest checksum', () => {
assert.equal(agentNativeFastModeChecksum(), SCHEMA_MIGRATIONS[10].checksum)
})
test('the message attachments migration matches its immutable manifest checksum', () => {
assert.equal(messageAttachmentsChecksum(), SCHEMA_MIGRATIONS[11].checksum)
})
test('the attachment grants migration matches its immutable manifest checksum', () => {
assert.equal(attachmentGrantsChecksum(), SCHEMA_MIGRATIONS[12].checksum)
})
test('the migration owner accepts an exact prefix and reports its pending suffix', () => {
const empty = validateMigrationHistory([], { allowPending: true })
assert.equal(empty.currentVersion, 0)
assert.deepEqual(empty.pending, SCHEMA_MIGRATIONS)
const complete = validateMigrationHistory(current(), { allowPending: true })
assert.equal(complete.currentVersion, MAX_SUPPORTED_SCHEMA_VERSION)
assert.deepEqual(complete.pending, [])
})
test('application startup rejects uninitialized, changed, and newer histories', () => {
assert.throws(
() => validateMigrationHistory([]),
(err) => err instanceof MigrationHistoryError && err.code === 'schema_uninitialized',
)
assert.throws(
() => validateMigrationHistory([{ ...current()[0], checksum: '0'.repeat(64) }]),
(err) => err instanceof MigrationHistoryError && err.code === 'migration_history_invalid',
)
assert.throws(
() => validateMigrationHistory([
...current(),
{ version: MAX_SUPPORTED_SCHEMA_VERSION + 1, name: 'future', checksum: 'f'.repeat(64) },
]),
(err) => err instanceof MigrationHistoryError && err.code === 'schema_ahead',
)
})
test('startup compatibility verification is a read-only ledger query', async () => {
const statements: string[] = []
const queryable: SchemaVersionQueryable = {
async query<T extends QueryResultRow = QueryResultRow>(sql: string): Promise<QueryResult<T>> {
statements.push(sql)
return { rows: current() as unknown as T[], rowCount: current().length } as QueryResult<T>
},
}
assert.equal(await verifySchemaCompatibility(queryable), MAX_SUPPORTED_SCHEMA_VERSION)
assert.equal(statements.length, 1)
assert.match(statements[0], /^SELECT\s/i)
assert.doesNotMatch(statements[0], /\b(?:CREATE|ALTER|DROP|INSERT|UPDATE|DELETE)\b/i)
})
test('a missing schema_migrations table becomes an actionable startup error', async () => {
const queryable: SchemaVersionQueryable = {
async query<T extends QueryResultRow = QueryResultRow>(): Promise<QueryResult<T>> {
const err = new Error('relation schema_migrations does not exist') as Error & { code: string }
err.code = '42P01'
throw err
},
}
await assert.rejects(
() => verifySchemaCompatibility(queryable),
(err) => err instanceof MigrationHistoryError && err.code === 'schema_uninitialized',
)
})