The Complete NestJS & Prisma Backend Masterclass Part 1

Connect Prisma ORM with NestJS to leverage a schema-first, type-safe workflow that delivers natural queries, easy migrations, and a modern TypeScript developer experience.

Set up the Prisma ORM in our NestJS application and install Prisma as a dev dependency after installing Postgres with Docker.

Install the Prisma client to enable CRUD operations against a Postgres database table. Note that it is not a dev dependency.

Initialize Prisma in your project by running the npx prisma init command, which will initialize Prisma in your project.

start a postgres docker container with postgres user and password, map port 5432 to p-management-db, then run npx prisma generate and sync with prisma db pool.

Diagnose and fix a missing introspected database by connecting to a docker-hosted Postgres, creating the correct management db, and running Prisma db pull to sync with models.

Learn how Prisma reads an existing database to reverse engineer it, generates models and updates schema.prisma, and uses db push, migrate, and generate to manage evolution and the Prisma client.

discover how docker compose simplifies running multiple containers, replacing tedious docker run commands for postgres. manage several services in a single file to streamline development.

Create a docker compose file (version 3.9) to define a Postgres service with environment variables and a persistent volume, map ports, and set a restart policy for reliable development.

Register users via a NestJS Prisma backend, encrypt passwords with bcrypt, validate input with class-validator in a register dto, and enforce a default member role.

Fix prisma client initialization by regenerating client, import Prisma module in the auth module, install class transformer, then test user creation with postman for email validation and duplicate user handling.

This lecture builds the login feature using the password js module and installs the NestJS JWT package, Passport JWT, and typings for Passport JWT to enable secure authentication.

Define a role enum with admin, manager, and member, update the Prisma schema, and implement a JWT strategy to authenticate users and restrict access to endpoints.

Install NestJS Passport and JWT dependencies, create a JWT strategy with authorization header extraction, configure the secret via config service, and implement validate to return id, email, and role.

Learn how to implement a passport jwt strategy, attach the token in the authorization header, and set request.user after token verification using a jwt auth guard in NestJS.

Implement a roles guard and decorator in NestJS by creating a custom roles decorator, a roles guard, and using Reflector to enforce role-based access with JWT authentication.

Create the admin module and controller inside the main directory. Apply JWT auth guard and roles guard to a get admin stats endpoint, and test the admin access flow.

Explore the team module where an admin creates teams (back end, Android, front end, DevOps) and assigns members with member or manager roles, establishing a one-to-many team membership.

Build a NestJS teams module with a create team route for admins, using a create team dto with a name and request.user.id to invoke the team service.

Implement create team method in the team service, enforcing admin role checks and using Prisma to create a team from a DTO and user ID after defining the team model.

Create a prisma team model for a nestjs backend, defining id, name, created at, updated at, and owner id as a string, linked to the user model for admin-created teams.

Create a team member model to relate users to multiple teams. Implement a team role enum (admin, member, manager) and enforce unique user-to-team pairs via foreign keys.

Learn how unique constraints stop a user from joining the same team twice, while enabling many-to-many teams via Prisma client, including owner setup and admin members.

Learn to create a new team and a new team member in a single Prisma query using include, returning the team and the member in one response.

Test the api with postman, fix missing prisma module import and guards, log in as admin to obtain an access token, and run migrations to resolve server errors.

Fix a prisma service issue causing a foreign key violation on team owner id; set up postgres with pgadmin, create admin, login token, and enable team creation and member invites.

Enable admins to update a team member's role via a dedicated patch route, using an update role DTO and a team role enum with validations.

Implement an email notification flow that triggers when an admin invites a team member, using Node Mailer for production-ready emails, and options like SendGrid, Mailgun, or Mandrill.

Learn to test emails with Nodemailer using Ethereal fake accounts, set up SMTP host and port, and integrate a mailer module in a NestJS app.

Register the mailer module in a NestJS project using root async and useFactory for dynamic config, create an Ethereal test account, and configure host, port 587, secure false, and auth.

Implement a dedicated team invite table with a separate invite model to store invites, track status (in progress to accepted), and automate cleanup with a cron job.

Design a Prisma team invite model with a string id, unique token, email field, status (pending, accepted, expired), createdAt and updatedAt, and a team relation via teamId.

Fix the missing comma to generate the Prisma client, create and apply a migration named team invite with Prisma migrate dev, and reset the schema to synchronize with migration history.

Explain building a send invite method in a NestJS backend, wiring a mailer service to send invitation emails with HTML content and a tokenized invite link via NodeMailer.

Refactors send invite flow to rename invite member DTO to send invite DTO, adds post route, and generates a crypto token with 24-hour expiry for admin invitations and email notifications.

Implement the accept invite flow in a NestJS and Prisma backend by creating a public route with a public decorator and validating token and user id via accept invite DTO.

Create a project and task data models with id, name, description, team relations, and user links for created by and assigned, plus a task status enum and due dates.

Learn to implement prisma.transaction to atomically create a project and its members, ensuring rollback on failure and enforcing admin guards for project creation.

Test api endpoints in a NestJS and Prisma backend by running the project, registering admin and members, inviting team members, and validating project creation with transactions and class validator.

Add indexes on team ID, user ID, and project ID to support queries for teams, members, and projects; use composite keys and run Prisma migrations to sync the database.

Build the task module with create and assign. Implement create and update task DTOs and wire controller and service using Prisma, with default status to do.

Learn to implement the update task method in a NestJS and Prisma backend, updating status, title, or description using the update task DTO and handling task IDs.

Diagnose update task dto issues in the controller by validating the project id type and implement updating the status (with optional title) as needed.

Execute and verify updating a task by sending a patch request to set its status to in progress, using the task id and bearer token, and confirm the update.

Admins or users can assign tasks to project members with create-time validation and a separate assign-task method; verify project existence and assignee membership before creating the task.

Implement a get task filter dto to enable pagination and filtering of tasks, including title search, status, assign id, and project, and build find all method that uses this dto.

Implement a dto-based find all with a where clause and skip-limit pagination, returning latest tasks with assignee, member, and project details, plus total pages.