Node.js Database Layer with Prisma ORM & PostgreSQL

Interactive Prisma Transactions

const { PrismaClient } = require('@prisma/client');
const prisma = new PrismaClient();

async function enrollUserInCourse(userId, courseId) {
    return await prisma.$transaction(async (tx) => {
        const course = await tx.course.findUnique({ where: { id: courseId } });
        const enrollment = await tx.enrollment.create({
            data: { userId, courseId }
        });
        return enrollment;
    });
}