blob: d19aec244e3a49a64a7c2d4a9c15d745812e1977 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
import { describe, it, expect, beforeEach } from 'vitest';
import { groceries, categories } from '$lib/server/db/schema';
import { eq } from 'drizzle-orm';
import { createTestDb, type TestDb } from '$lib/server/db/test-helper';
import { isUniqueViolation } from './errors';
describe('isUniqueViolation', () => {
let db: TestDb['db'];
beforeEach(async () => {
db = (await createTestDb()).db;
await db.insert(categories).values({ name: 'Épices' });
await db
.insert(groceries)
.values({ name: 'olives', createdAt: '2026-01-01T00:00:00.000Z' });
});
it('detects a duplicate insert on a unique column', async () => {
const error = await db
.insert(categories)
.values({ name: 'Épices' })
.catch((e: unknown) => e);
expect(isUniqueViolation(error)).toBe(true);
});
it('detects a duplicate name on update', async () => {
await db
.insert(groceries)
.values({ name: 'pain', createdAt: '2026-01-02T00:00:00.000Z' });
const error = await db
.update(groceries)
.set({ name: 'olives' })
.where(eq(groceries.name, 'pain'))
.catch((e: unknown) => e);
expect(isUniqueViolation(error)).toBe(true);
});
it('leaves other failures alone', () => {
expect(isUniqueViolation(new Error('network is unreachable'))).toBe(false);
expect(isUniqueViolation(undefined)).toBe(false);
});
});
|
