اتصال به دیتابیس با استفاده از Prisma در برنامه‌های NodeJS

mkdir prisma-liara
cd prisma-liara
npm init -y

npm install prisma @types/node @types/express typescript --save-dev
npm install @prisma/client @prisma/adapter-pg @faker-js/faker express

npx prisma init --datasource-provider postgresql

DATABASE_URL=postgresql://USERNAME:PASSWORD@HOST:PORT/postgres

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

datasource db {
  provider = "postgresql"
}

model User {
  id    Int    @id @default(autoincrement())
  email String @unique
  name  String
}

npx prisma migrate dev --name init

import express, { Request, Response } from "express";
import { PrismaClient } from "@prisma/client";
import { PrismaPg } from "@prisma/adapter-pg";
import { faker } from "@faker-js/faker";
import dotenv from "dotenv";

dotenv.config();

const adapter = new PrismaPg({
  connectionString: process.env.DATABASE_URL!,
});

const prisma = new PrismaClient({ adapter });
const app = express();

function createRandomUser() {
  const firstName = faker.person.firstName();
  const lastName = faker.person.lastName();
  const email = faker.internet.email({ firstName, lastName });

  return {
    name: `${firstName} ${lastName}`,
    email,
  };
}

app.get("/", async (req: Request, res: Response) => {
  try {
    const randomUser = createRandomUser();
    const user = await prisma.user.create({
      data: randomUser,
    });

    res.json({
      success: true,
      user,
    });
  } catch (err: any) {
    console.error(err);
    res.status(500).json({
      success: false,
      error: "Internal Server Error",
    });
  }
});

const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});

{
  "compilerOptions": {
    "target": "ES2020",
    "module": "CommonJS",
    "rootDir": "./",
    "outDir": "dist",
    "esModuleInterop": true,
    "strict": true,
    "skipLibCheck": true
  },
  "include": ["src/**/*.ts", "prisma.config.ts"]
}

"scripts": {
    "build": "npx prisma generate && tsc",
    "start": "node dist/src/server.js"
},

npx prisma migrate deploy

liara deploy --port 3000