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('0044_llm_model_prices migration', () => {
beforeEach(() => {
vi.resetModules()
vi.clearAllMocks()
mockConnect.mockResolvedValue({
query: clientQuery,
release: clientRelease,
})
clientQuery.mockResolvedValue({ rows: [], rowCount: 0 })
})
it('creates the table, the active partial unique index, and seeds example prices', async () => {
const { initDb } = await import('../src/db.js')
await initDb()
const sqls = clientQuery.mock.calls.map(([sql]) => String(sql))
expect(sqls).toContainEqual(
expect.stringContaining('CREATE TABLE IF NOT EXISTS llm_model_prices')
)
expect(sqls).toContainEqual(
expect.stringContaining('CREATE UNIQUE INDEX IF NOT EXISTS idx_llm_model_prices_active')
)
// partial index — one active row per (provider, model)
expect(sqls.some(sql => /idx_llm_model_prices_active[\s\S]*WHERE enabled/.test(sql))).toBe(true)
// idempotent seed
expect(
sqls.some(
sql =>
sql.includes('INSERT INTO llm_model_prices') && sql.includes('ON CONFLICT DO NOTHING')
)
).toBe(true)
})
})