Utils for Prisma

Install

1npm install prisma-utils

To Use

The clearAllTables clears all tables in a database using a single command, which can be very useful for testing and debugging".

1import {PrismaClient} from "@prisma/client";
2import {clearAllTables} from "prisma-utils";
3
4describe('simple example', () => {
5    const prisma = new PrismaClient()
6    const provider = 'postgres'
7    beforeAll(async () => {
8        // clear all tables
9        await clearAllTables(prisma, {
10            provider,
11            //If you want to exclude some tables
12            exclude: ['user']
13        })
14    })
15
16    it('should clear tables', async () => {
17        const users = await prisma.user.findMany();
18        const posts = await prisma.post.findMany();
19        expect(users).toHaveLength(1);
20        expect(posts).toHaveLength(0);
21    })
22})

Run tests

1# Clone the repo
2git clone https://github.com/rsaryev/prisma-utils.git
3cd prisma-utils
4# Install dependencies
5npm install or yarn
6# Run docker-compose
7docker-compose up
8# Run tests
9npm run test