diff options
Diffstat (limited to 'src/lib/server/db/groceries.test.ts')
| -rw-r--r-- | src/lib/server/db/groceries.test.ts | 21 |
1 files changed, 4 insertions, 17 deletions
diff --git a/src/lib/server/db/groceries.test.ts b/src/lib/server/db/groceries.test.ts index bd14040..2f8baed 100644 --- a/src/lib/server/db/groceries.test.ts +++ b/src/lib/server/db/groceries.test.ts @@ -1,27 +1,14 @@ import { describe, it, expect, beforeEach } from 'vitest'; -import { drizzle } from 'drizzle-orm/libsql'; -import { createClient } from '@libsql/client'; import { groceries, categories } from '$lib/server/db/schema'; import { eq } from 'drizzle-orm'; +import { createTestDb } from './test-helper'; describe('groceries add', () => { - const client = createClient({ url: ':memory:' }); - const db = drizzle(client, { schema: { groceries, categories } }); + let db: Awaited<ReturnType<typeof createTestDb>>['db']; beforeEach(async () => { - await db.run(`DROP TABLE IF EXISTS groceries`); - await db.run(`DROP TABLE IF EXISTS categories`); - await db.run(`CREATE TABLE categories ( - id INTEGER PRIMARY KEY AUTOINCREMENT, - name TEXT NOT NULL - )`); - await db.run(`CREATE TABLE groceries ( - id INTEGER PRIMARY KEY AUTOINCREMENT, - name TEXT NOT NULL, - checked INTEGER NOT NULL DEFAULT 0, - created_at TEXT NOT NULL, - category_id INTEGER REFERENCES categories(id) - )`); + const testDb = await createTestDb(); + db = testDb.db; }); async function addItem(name: string, categoryId?: number | null) { |