Prisma Documentation

Learn how to use Prisma ORM in your BackendGlitch project.

Installing Prisma

To add Prisma to your project, run the following commands:

npm install prisma --save-dev
npx prisma init

Defining Your Schema

Define your database schema in the `prisma/schema.prisma` file:

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
  posts Post[]
}

model Post {
  id        Int     @id @default(autoincrement())
  title     String
  content   String?
  published Boolean @default(false)
  author    User    @relation(fields: [authorId], references: [id])
  authorId  Int
}

Generating Prisma Client

After defining your schema, generate the Prisma Client:

npx prisma generate

Using Prisma in Your Code

Here's an example of how to use Prisma in your application:

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function main() {
  // Create a new user
  const user = await prisma.user.create({
    data: {
      email: 'alice@example.com',
      name: 'Alice',
    },
  })
  console.log(user)

  // Get all users
  const users = await prisma.user.findMany()
  console.log(users)
}

main()
  .catch((e) => {
    throw e
  })
  .finally(async () => {
    await prisma.$disconnect()
  })