GPT

API Routes

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

Prompt text

Original English text. Replace placeholders with your own details.

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

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 sql`
 INSERT INTO users (name, email)
 VALUES (${name}, ${email})
 RETURNING id, name, email
 `;

 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/delete.ts
export const POST: APIRoute = async ({ request }) => {
 try {
 const formData = await request.formData();
 const id = parseInt(formData.get('id') as string);

 await sql`DELETE FROM users WHERE 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 →