สร้าง CRUD API ด้วย Bun + Elysia + Prisma 7 + Supabase

powershell -c "irm bun.sh/install.ps1|iex"

curl -fsSL https://bun.sh/install | bash

brew install oven-sh/bun/bun

bun --version

mkdir bun-elysia-crud
cd bun-elysia-crud
bun init -y

bun add elysia
bun add @prisma/client @prisma/adapter-pg pg
bun add -d prisma

bunx prisma init

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider = "prisma-client-js"
  output   = "../src/generated/prisma"
}

datasource db {
  provider = "postgresql"
}

model Product {
  id     String   @id @default(cuid())
  name   String   @unique
  detail String
  price  Decimal?
}

import "dotenv/config";
import { defineConfig } from "prisma/config";

export default defineConfig({
  schema: "prisma/schema.prisma",
  migrations: {
    path: "prisma/migrations",
    seed: 'bun ./prisma/seed.ts',
  },
  datasource: {
    url: process.env["DATABASE_URL"],
  },
});

DATABASE_URL="postgresql://postgres.xxx:[PASSWORD]@aws-0-ap-southeast-1.pooler.supabase.com:6543/postgres?pgbouncer=true"

bunx prisma generate

bunx prisma db push

bun add -d prismabox

generator client {
  provider = "prisma-client-js"
  output   = "../src/generated/prisma"
}

datasource db {
  provider = "postgresql"
}

generator prismabox {
  provider                    = "prismabox"
  typeboxImportDependencyName = "elysia"
  typeboxImportVariableName   = "t"
  inputModel                  = true
  output                      = "../generated/prismabox"
}

model Product {
  id     String   @id @default(cuid())
  name   String   @unique
  detail String
  price  Decimal?
}

bunx prisma generate

import { Elysia, t } from 'elysia'
import { PrismaPg } from '@prisma/adapter-pg'
import { Pool } from 'pg'

import { PrismaClient } from '../generated/prisma/client'
import {
  ProductPlain,
  ProductPlainInputCreate,
  ProductPlainInputUpdate
} from '../generated/prismabox/Product'

const pool = new Pool({ connectionString: process.env.DATABASE_URL })
const adapter = new PrismaPg(pool)

const prisma = new PrismaClient({ adapter })

// แปลง Decimal เป็น number สำหรับ JSON response
const toResponse = (product: { id: string; name: string; detail: string; price: { toNumber: () => number } | null }) => ({
  id: product.id,
  name: product.name,
  detail: product.detail,
  price: product.price?.toNumber() ?? null
})

const app = new Elysia()

// CREATE - สร้างสินค้าใหม่
  .post(
    '/products',
    async ({ body }) => {
      const product = await prisma.product.create({ data: body })
      return toResponse(product)
    },
    {
      body: ProductPlainInputCreate,
      response: ProductPlain
    }
  )

// READ - ดึงสินค้าทั้งหมด
  .get(
    '/products',
    async () => {
      const products = await prisma.product.findMany()
      return products.map(toResponse)
    },
    {
      response: t.Array(ProductPlain)
    }
  )

// READ - ดึงสินค้าตาม ID
  .get(
    '/products/:id',
    async ({ params: { id }, status }) => {
      const product = await prisma.product.findUnique({ where: { id } })
      if (!product) return status(404, 'Product not found')
      return toResponse(product)
    },
    {
      response: {
        200: ProductPlain,
        404: t.String()
      }
    }
  )

// UPDATE - อัปเดตสินค้า
  .patch(
    '/products/:id',
    async ({ params: { id }, body, set }) => {
      try {
        const product = await prisma.product.update({
          where: { id },
          data: body
        })
        return toResponse(product)
      } catch {
        set.status = 404
        return 'Product not found'
      }
    },
    {
      body: ProductPlainInputUpdate,
      response: {
        200: ProductPlain,
        404: t.String()
      }
    }
  )

// DELETE - ลบสินค้า
  .delete(
    '/products/:id',
    async ({ params: { id }, set }) => {
      try {
        await prisma.product.delete({ where: { id } })
        return { message: 'Product deleted' }
      } catch {
        set.status = 404
        return { message: 'Product not found' }
      }
    },
    {
      response: t.Object({ message: t.String() })
    }
  )

// For Vercel: export as default
export default app

// For local dev: start server
if (import.meta.main || process.env.NODE_ENV !== 'production') {
  app.listen(3000)
  console.log(
    `🦊 Elysia is running at ${app.server?.hostname}:${app.server?.port}`
  )
}

import { PrismaClient } from '../generated/prisma/client'
import { PrismaPg } from '@prisma/adapter-pg'
import { Pool } from 'pg'

const pool = new Pool({ connectionString: process.env.DATABASE_URL })
const adapter = new PrismaPg(pool)
const prisma = new PrismaClient({ adapter })

async function main() {
  console.log('Start seeding...')

  await prisma.product.createMany({
    data: [
      {
        name: 'Wireless Headphones',
        detail: 'Noise-cancelling over-ear headphones with 30hr battery life',
        price: 299.99,
      },
      {
        name: 'Mechanical Keyboard',
        detail: 'RGB backlit mechanical keyboard with brown switches',
        price: 149.50,
      },
      {
        name: 'USB-C Hub',
        detail: '7-in-1 multiport adapter with HDMI, USB 3.0, and SD card reader',
        price: 49.99,
      },
      {
        name: 'Laptop Stand',
        detail: 'Aluminum adjustable laptop stand for better ergonomics',
        price: 79.00,
      },
      {
        name: 'Wireless Mouse',
        detail: 'Ergonomic wireless mouse with precision tracking',
        price: 35.99,
      },
    ],
    skipDuplicates: true,
  })

  console.log('Seeding finished.')
}

main()
  .then(async () => {
    await prisma.$disconnect()
  })
  .catch(async (e) => {
    console.error(e)
    await prisma.$disconnect()
    process.exit(1)
  })

bun run seed

{
  "scripts": {
    "dev": "bun run --watch src/index.ts"
  }
}

bun run dev

curl -X POST http://localhost:3000/products \
  -H "Content-Type: application/json" \
  -d '{"name":"Gaming Mouse","detail":"RGB gaming mouse with 16000 DPI","price":89.99}'

curl http://localhost:3000/products

curl http://localhost:3000/products/[PRODUCT_ID]

curl -X PATCH http://localhost:3000/products/[PRODUCT_ID] \
  -H "Content-Type: application/json" \
  -d '{"price":79.99}'

curl -X DELETE http://localhost:3000/products/[PRODUCT_ID]

Invoke-RestMethod -Uri http://localhost:3000/products -Method POST -ContentType "application/json" -Body '{"name":"Gaming Mouse","detail":"RGB gaming mouse with 16000 DPI","price":89.99}'

Invoke-RestMethod -Uri http://localhost:3000/products -Method GET

Invoke-RestMethod -Uri http://localhost:3000/products/[PRODUCT_ID] -Method GET

Invoke-RestMethod -Uri http://localhost:3000/products/[PRODUCT_ID] -Method PATCH -ContentType "application/json" -Body '{"price":79.99}'

Invoke-RestMethod -Uri http://localhost:3000/products/[PRODUCT_ID] -Method DELETE

{
  "buildCommand": "bunx prisma generate",
  "bunVersion": "1.x",
  "rewrites": [{ "source": "/(.*)", "destination": "/src" }]
}

{
  "compilerOptions": {
    "target": "ES2021",
    "module": "ES2022",
    "moduleResolution": "node",
    "types": ["bun-types"],
    "esModuleInterop": true,
    "forceConsistentCasingInFileNames": true,
    "strict": true,
    "skipLibCheck": true
  }
}

DATABASE_URL = postgresql://postgres.xxx:[PASSWORD]@aws-0-ap-southeast-1.pooler.supabase.com:6543/postgres?pgbouncer=true

bunx vercel