Architecture

export default async function DashboardPage({
  params,
}: {
  params: Promise<{ projectId: string }>
}) {
  const session = await auth()
  const { projectId } = await params
  
  // Direct database query in Server Component
  const project = await prisma.project.findUnique({
    where: { id: projectId },
    include: {
      widgets: true,
      dbconnections: true,
    },
  })
  
  return <DashboardLayout project={project} />
}

"use server"

import { auth } from "@/lib/auth/auth"
import { encrypt } from "@/lib/crypto/crypto"
import prisma from "@/lib/db/prisma"
import { validateProject } from "@/lib/projects/schemas"
import { revalidatePath } from "next/cache"

export async function createProjectWithConnections(input) {
  // 1. Authentication check
  const session = await auth()
  if (!session?.user) {
    redirect("/login")
  }
  
  // 2. Input validation with Zod
  const validationResult = validateProject(input)
  if (!validationResult.success) {
    return { success: false, error: validationResult.error }
  }
  
  // 3. Database transaction
  const project = await prisma.$transaction(async (tx) => {
    const createdProject = await tx.project.create({
      data: { ...validatedData }
    })
    
    // Encrypt and save connections
    for (const conn of connections) {
      const encryptedAccess = encrypt(JSON.stringify(conn))
      await tx.dbConnection.create({
        data: { projectId: createdProject.id, dbAccess: encryptedAccess }
      })
    }
    
    return createdProject
  })
  
  // 4. Revalidate cached paths
  revalidatePath("/projects")
  
  return { success: true, projectId: project.id }
}