آموزش ساخت REST API با Prisma و PostgreSQL در Node.js

mkdir my-blog
cd my-blog
npm init -y

npm install typescript ts-node @types/node --save-dev

nano tsconfig.json

{
  "compilerOptions": {
    "sourceMap": true,
    "outDir": "dist",
    "strict": true,
    "lib": ["esnext"],
    "esModuleInterop": true
  }
}

npm install prisma --save-dev

nano docker-compose.yml

version: '3.8'
services:
  postgres:
    image: postgres:10.3
    restart: always
    environment:
      - POSTGRES_USER=sammy
      - POSTGRES_PASSWORD=your_password
    volumes:
      - postgres:/var/lib/postgresql/data
    ports:
      - '5432:5432'
volumes:
  postgres:

docker-compose up -d

npx prisma init

DATABASE_URL="postgresql://sammy:your_password@localhost:5432/my-blog?schema=public"

nano prisma/schema.prisma

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?
}

npx prisma migrate dev --name init

npm install @prisma/client

mkdir src
nano src/index.ts

npm install express
npm install @types/express --save-dev

import { PrismaClient } from '@prisma/client'
import express from 'express'

const prisma = new PrismaClient()
const app = express()

app.use(express.json())

app.listen(3000, () => {
  console.log('Server running at http://localhost:3000')
})

app.get('/users', async (req, res) => {
  const users = await prisma.user.findMany()
  res.json(users)
})

app.get('/feed', async (req, res) => {
  const posts = await prisma.post.findMany({
    where: { published: true },
    include: { author: true }
  })
  res.json(posts)
})

app.get('/post/:id', async (req, res) => {
  const post = await prisma.post.findUnique({
    where: { id: Number(req.params.id) }
  })
  res.json(post)
})

app.post('/user', async (req, res) => {
  const user = await prisma.user.create({ data: req.body })
  res.json(user)
})

app.post('/post', async (req, res) => {
  const { title, content, authorEmail } = req.body
  const post = await prisma.post.create({
    data: {
      title,
      content,
      author: { connect: { email: authorEmail } }
    }
  })
  res.json(post)
})

app.put('/post/publish/:id', async (req, res) => {
  const post = await prisma.post.update({
    where: { id: Number(req.params.id) },
    data: { published: true }
  })
  res.json(post)
})

app.delete('/post/:id', async (req, res) => {
  const post = await prisma.post.delete({
    where: { id: Number(req.params.id) }
  })
  res.json(post)
})