GPT

API Routes (alternative Approach)

// app/api/users/route.ts import { sql } from '@/lib/db'; import { NextResponse } from 'next/server'; interface User { id: number; name: string; email: string; } export async function GET() { try { const users = a

Prompt text

Original English text. Replace placeholders with your own details.

// app/api/users/route.ts
import { sql } from '@/lib/db';
import { NextResponse } from 'next/server';

interface User {
 id: number;
 name: string;
 email: string;
}

export async function GET() {
 try {
 const users = await sql<User[]>`
 SELECT id, name, email
 FROM users
 ORDER BY name ASC
 `;
 return NextResponse.json(users);
 } catch (error: any) {
 return NextResponse.json(
 { error: `Failed to fetch users: ${error.message}` },
 { status: 500 }
 );
 }
}

export async function POST(request: Request) {
 try {
 const { name, email } = await request.json();
 
 const [user] = await sql<User[]>`
 INSERT INTO users (name, email)
 VALUES (${name}, ${email})
 RETURNING id, name, email
 `;
 
 return NextResponse.json(user, { status: 201 });
 } catch (error: any) {
 return NextResponse.json(
 { error: `Failed to create user: ${error.message}` },
 { status: 500 }
 );
 }
}

// app/api/users/[id]/route.ts
export async function GET(
 request: Request,
 { params }: { params: { id: string } }
) {
 try {
 const id = parseInt(params.id);
 const [user] = await sql<User[]>`
 SELECT id, name, email
 FROM users
 WHERE id = ${id}
 `;

 if (!user) {
 return NextResponse.json(
 { error: 'User not found' },
 { status: 404 }
 );
 }

 return NextResponse.json(user);
 } catch (error: any) {
 return NextResponse.json(
 { error: `Failed to fetch user: ${error.message}` },
 { status: 500 }
 );
 }
}

export async function PUT(
 request: Request,
 { params }: { params: { id: string } }
) {
 try {
 const id = parseInt(params.id);
 const { name, email } = await request.json();

 const [user] = await sql<User[]>`
 UPDATE users
 SET name = ${name}, email = ${email}
 WHERE id = ${id}
 RETURNING id, name, email
 `;

 if (!user) {
 return NextResponse.json(
 { error: 'User not found' },
 { status: 404 }
 );
 }

 return NextResponse.json(user);
 } catch (error: any) {
 return NextResponse.json(
 { error: `Failed to update user: ${error.message}` },
 { status: 500 }
 );
 }
}

export async function DELETE(
 request: Request,
 { params }: { params: { id: string } }
) {
 try {
 const id = parseInt(params.id);
 await sql`DELETE FROM users WHERE id = ${id}`;
 return new NextResponse(null, { status: 204 });
 } catch (error: any) {
 return NextResponse.json(
 { error: `Failed to delete user: ${error.message}` },
 { status: 500 }
 );
 }
}

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →