A Better Way To Run Integration Tests With Prisma and PostgresQL

Prisma, the TypeScript ORM, has taken the development community by storm. It provides a fully type-safe interface with PostgresQL (and other SQL and no-SQL DBMS) which makes it a no-brainer for us to use at ludicrous. The Prisma team recently release...

ludicrous-blog-archive.hashnode.dev6 min read

#postgresql #typescript #nodejs #databases

Responses1

Markdown supported · ⌘↵ to post

NM

Nemanja Mitic

Apr 24, 2022

Interesting method. I don't understand only how do you switch dev and test database urls, I don't see two .env files in your example repo? You don't run tests locally, only in Github Actions?

Hello, the test suite works locally as well! It uses the same connection as your dev database, however, it uses a different (random) postgres schema each time. When you're using prisma in a web server you'll likely be using the "default" schema so your data will not be affected since we generate a random UUID for the schema name. See this code: github.com/ludicroushq/prisma-integration-test-ex…mocks/index.ts#L16-L19

MM

Manthan Mallikarjun

Apr 24, 2022

Search Hashnode

A Better Way To Run Integration Tests With Prisma and PostgresQL

Responses1