Task 4 rewrote src/db.js and src/jobs/jobRepository.js to use Prisma instead of the hand-rolled mariadb pool. This updates every remaining call site (app.js, server.js, worker.js, cleanup.js) and the 5 test files that still referenced getPool/closePool/pool.query, so the app and full test suite compile and run against Prisma Client. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
117 lines
4.0 KiB
JavaScript
117 lines
4.0 KiB
JavaScript
import { describe, it, expect, beforeAll, afterAll, beforeEach } from 'vitest';
|
|
import request from 'supertest';
|
|
import fs from 'node:fs/promises';
|
|
import path from 'node:path';
|
|
import os from 'node:os';
|
|
import { createApp } from '../../src/app.js';
|
|
import { getPrismaClient, closePrismaClient } from '../../src/db.js';
|
|
import { loadConfig } from '../../src/config.js';
|
|
import { createJob, getJobByUuid, markDone } from '../../src/jobs/jobRepository.js';
|
|
import { ensureStorageDirs, outputPath } from '../../src/storage.js';
|
|
|
|
let app;
|
|
let prisma;
|
|
let config;
|
|
|
|
beforeAll(async () => {
|
|
config = { ...loadConfig(), storageDir: await fs.mkdtemp(path.join(os.tmpdir(), 'converter-status-')) };
|
|
await ensureStorageDirs(config);
|
|
prisma = getPrismaClient(config);
|
|
app = createApp(config, prisma);
|
|
});
|
|
|
|
afterAll(async () => {
|
|
await closePrismaClient();
|
|
await fs.rm(config.storageDir, { recursive: true, force: true });
|
|
});
|
|
|
|
beforeEach(async () => {
|
|
await prisma.conversionJob.deleteMany();
|
|
});
|
|
|
|
function baseJob(uuid) {
|
|
return {
|
|
uuid,
|
|
family: 'image',
|
|
sourceFormat: 'png',
|
|
targetFormat: 'webp',
|
|
originalFilename: 'holiday photo.png',
|
|
inputPath: `${uuid}.png`,
|
|
inputMimeType: 'image/png',
|
|
inputSizeBytes: 11,
|
|
expiresAt: new Date(Date.now() + 3600 * 1000),
|
|
};
|
|
}
|
|
|
|
describe('GET /api/jobs/:id', () => {
|
|
it('returns job status without the error log field', async () => {
|
|
const uuid = '66666666-6666-4666-8666-666666666666';
|
|
await createJob(prisma, baseJob(uuid));
|
|
|
|
const response = await request(app).get(`/api/jobs/${uuid}`);
|
|
|
|
expect(response.status).toBe(200);
|
|
expect(response.body.id).toBe(uuid);
|
|
expect(response.body.status).toBe('pending');
|
|
expect(response.body.originalFilename).toBe('holiday photo.png');
|
|
expect(response.body.errorLog).toBeUndefined();
|
|
});
|
|
|
|
it('returns 404 for an unknown id', async () => {
|
|
const response = await request(app).get('/api/jobs/00000000-0000-4000-8000-000000000000');
|
|
expect(response.status).toBe(404);
|
|
});
|
|
});
|
|
|
|
describe('GET /api/jobs/:id/download', () => {
|
|
it('streams the converted file with correct headers once done', async () => {
|
|
const uuid = '77777777-7777-4777-8777-777777777777';
|
|
await createJob(prisma, baseJob(uuid));
|
|
const filePath = outputPath(config, uuid, 'webp');
|
|
await fs.writeFile(filePath, Buffer.from('fake webp bytes'));
|
|
const created = await getJobByUuid(prisma, uuid);
|
|
await markDone(prisma, created.id, {
|
|
outputPath: `${uuid}.webp`,
|
|
outputMimeType: 'image/webp',
|
|
outputSizeBytes: 16,
|
|
conversionDurationSeconds: 0.2,
|
|
});
|
|
|
|
const response = await request(app).get(`/api/jobs/${uuid}/download`);
|
|
|
|
expect(response.status).toBe(200);
|
|
expect(response.headers['content-type']).toBe('image/webp');
|
|
expect(response.headers['content-disposition']).toContain('holiday photo.webp');
|
|
expect(response.body ?? response.text).toBeDefined();
|
|
});
|
|
|
|
it('returns 409 when the job is not done yet', async () => {
|
|
const uuid = '88888888-8888-4888-8888-888888888888';
|
|
await createJob(prisma, baseJob(uuid));
|
|
|
|
const response = await request(app).get(`/api/jobs/${uuid}/download`);
|
|
|
|
expect(response.status).toBe(409);
|
|
});
|
|
|
|
it('returns 404 for an unknown id', async () => {
|
|
const response = await request(app).get('/api/jobs/00000000-0000-4000-8000-000000000000/download');
|
|
expect(response.status).toBe(404);
|
|
});
|
|
});
|
|
|
|
describe('unexpected server errors', () => {
|
|
it('returns a generic 500 without leaking internal error details', async () => {
|
|
const originalFindUnique = prisma.conversionJob.findUnique.bind(prisma.conversionJob);
|
|
prisma.conversionJob.findUnique = () => Promise.reject(new Error('connection reset by peer'));
|
|
|
|
const response = await request(app).get('/api/jobs/99999999-9999-4999-8999-999999999999');
|
|
|
|
prisma.conversionJob.findUnique = originalFindUnique;
|
|
|
|
expect(response.status).toBe(500);
|
|
expect(response.body.error).toBe('Internal server error');
|
|
expect(JSON.stringify(response.body)).not.toContain('connection reset by peer');
|
|
});
|
|
});
|