Evenfire is an intelligence layer platform for running LLM agents that take real actions, on your infrastructure
TypeScript
import { beforeEach, describe, expect, it, vi } from 'vitest'
const clientQuery = vi.fn()
const clientRelease = vi.fn()
const mockConnect = vi.fn()
const mockPoolCtor = vi.fn(function MockPool() {
return { connect: mockConnect, query: vi.fn() }
})
vi.mock('pg', () => ({ Pool: mockPoolCtor }))
describe('runtime access migrations', () => {
beforeEach(() => {
vi.resetModules()
vi.clearAllMocks()
mockConnect.mockResolvedValue({ query: clientQuery, release: clientRelease })
clientQuery.mockResolvedValue({ rows: [], rowCount: 0 })
})
it('0069 grants only the required member-registration table access to Control API', async () => {
const { initDb } = await import('../src/db.js')
await initDb()
const sqls = clientQuery.mock.calls.map(([sql]) => String(sql))
const accessBoundary = sqls.find(sql =>
sql.includes('GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE member_registration_credentials')
)
expect(accessBoundary).toBeDefined()
expect(accessBoundary).toContain(
'FROM PUBLIC, control_api_runtime, trace_maintenance_runtime, workflow_recipes_runtime'
)
expect(accessBoundary).toContain('TO control_api_runtime')
expect(accessBoundary).not.toMatch(/TO trace_maintenance_runtime|TO workflow_recipes_runtime/)
expect(accessBoundary).toContain(
'REVOKE ALL ON SEQUENCE member_registration_credentials_id_seq'
)
expect(accessBoundary).toContain(
'GRANT USAGE, SELECT ON SEQUENCE member_registration_credentials_id_seq'
)
})
it('0070 revokes DELETE while retaining the control-api runtime table boundary', async () => {
const { initDb } = await import('../src/db.js')
await initDb()
const sqls = clientQuery.mock.calls.map(([sql]) => String(sql))
const deleteRevocation = sqls.find(sql =>
sql.includes('REVOKE DELETE ON TABLE member_registration_credentials')
)
const recordedVersions = clientQuery.mock.calls
.filter(([sql]) => String(sql).includes('INSERT INTO schema_migrations'))
.map(([, params]) => (Array.isArray(params) ? params[0] : undefined))
expect(deleteRevocation).toContain('FROM control_api_runtime')
expect(recordedVersions).toContain('0070_member_registration_runtime_delete_revoke')
})
it('0120 grants the control-api runtime S/I/U/D on dynamic_clients and USAGE/SELECT/UPDATE on its sequence', async () => {
const { initDb } = await import('../src/db.js')
await initDb()
const sqls = clientQuery.mock.calls.map(([sql]) => String(sql))
const grant = sqls.find(sql => sql.includes('ON TABLE dynamic_clients TO control_api_runtime'))
// The DML store (dynamicClientStore) does INSERT ... ON CONFLICT DO UPDATE,
// SELECT and DELETE, so the runtime role needs the full legacy_dml envelope
// on the table and legacy_rw (USAGE/SELECT/UPDATE) on its identity sequence.
expect(grant, 'the dynamic_clients runtime-access grant was applied').toBeDefined()
expect(grant).toContain(
'GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE dynamic_clients TO control_api_runtime'
)
expect(grant).toContain(
'GRANT USAGE, SELECT, UPDATE ON SEQUENCE dynamic_clients_id_seq TO control_api_runtime'
)
const recordedVersions = clientQuery.mock.calls
.filter(([sql]) => String(sql).includes('INSERT INTO schema_migrations'))
.map(([, params]) => (Array.isArray(params) ? params[0] : undefined))
expect(recordedVersions).toContain('0120_dynamic_clients_runtime_access')
})
})