GPT

Server Routes

// server/api/users/index.ts import { db } from '../../db'; import { users } from '../../db/schema'; import { eq } from 'drizzle-orm'; export default defineEventHandler(async (event) = { const method = getMethod(event)

Prompt text

Original English text. Replace placeholders with your own details.

// server/api/users/index.ts
import { db } from '../../db';
import { users } from '../../db/schema';
import { eq } from 'drizzle-orm';

export default defineEventHandler(async (event) => {
 const method = getMethod(event);

 try {
 switch (method) {
 case 'GET':
 return await db.select().from(users).orderBy(users.name);

 case 'POST': {
 const body = await readBody(event);
 const [user] = await db
 .insert(users)
 .values(body)
 .returning();
 return user;
 }

 default:
 throw createError({
 statusCode: 405,
 message: 'Method not allowed',
 });
 }
 } catch (error: any) {
 throw createError({
 statusCode: 500,
 message: error.message,
 });
 }
});

// server/api/users/[id].ts
export default defineEventHandler(async (event) => {
 const method = getMethod(event);
 const id = parseInt(event.context.params.id);

 try {
 switch (method) {
 case 'GET': {
 const [user] = await db
 .select()
 .from(users)
 .where(eq(users.id, id));

 if (!user) {
 throw createError({
 statusCode: 404,
 message: 'User not found',
 });
 }

 return user;
 }

 case 'PUT': {
 const body = await readBody(event);
 const [user] = await db
 .update(users)
 .set(body)
 .where(eq(users.id, id))
 .returning();

 if (!user) {
 throw createError({
 statusCode: 404,
 message: 'User not found',
 });
 }

 return user;
 }

 case 'DELETE': {
 await db.delete(users).where(eq(users.id, id));
 return { success: true };
 }

 default:
 throw createError({
 statusCode: 405,
 message: 'Method not allowed',
 });
 }
 } catch (error: any) {
 throw createError({
 statusCode: 500,
 message: error.message,
 });
 }
});

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 →