GPT

API Routes

// src/pages/api/users/create.ts import type { APIRoute } from 'astro'; import { db } from '../../../db'; import { users } from '../../../db/schema'; export const POST: APIRoute = async ({ request }) = { try { const f

Prompt text

Original English text. Replace placeholders with your own details.

// src/pages/api/users/create.ts
import type { APIRoute } from 'astro';
import { db } from '../../../db';
import { users } from '../../../db/schema';

export const POST: APIRoute = async ({ request }) => {
 try {
 const formData = await request.formData();
 const name = formData.get('name') as string;
 const email = formData.get('email') as string;

 const [user] = await db
 .insert(users)
 .values({ name, email })
 .returning();

 return new Response(JSON.stringify(user), {
 status: 201,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 } catch (error: any) {
 return new Response(JSON.stringify({ error: error.message }), {
 status: 500,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }
};

// src/pages/api/users/[id].ts
import type { APIRoute } from 'astro';
import { db } from '../../../db';
import { users } from '../../../db/schema';
import { eq } from 'drizzle-orm';

export const GET: APIRoute = async ({ params }) => {
 try {
 const id = parseInt(params.id!);
 const [user] = await db
 .select()
 .from(users)
 .where(eq(users.id, id));

 if (!user) {
 return new Response(JSON.stringify({ error: 'User not found' }), {
 status: 404,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }

 return new Response(JSON.stringify(user), {
 status: 200,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 } catch (error: any) {
 return new Response(JSON.stringify({ error: error.message }), {
 status: 500,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }
};

export const PUT: APIRoute = async ({ request, params }) => {
 try {
 const id = parseInt(params.id!);
 const formData = await request.formData();
 const name = formData.get('name') as string;
 const email = formData.get('email') as string;

 const [user] = await db
 .update(users)
 .set({ name, email })
 .where(eq(users.id, id))
 .returning();

 if (!user) {
 return new Response(JSON.stringify({ error: 'User not found' }), {
 status: 404,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }

 return new Response(JSON.stringify(user), {
 status: 200,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 } catch (error: any) {
 return new Response(JSON.stringify({ error: error.message }), {
 status: 500,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }
};

export const DELETE: APIRoute = async ({ params }) => {
 try {
 const id = parseInt(params.id!);
 await db.delete(users).where(eq(users.id, id));
 return new Response(null, { status: 204 });
 } catch (error: any) {
 return new Response(JSON.stringify({ error: error.message }), {
 status: 500,
 headers: {
 'Content-Type': 'application/json'
 }
 });
 }
};

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 →