31 lines
897 B
TypeScript
31 lines
897 B
TypeScript
import { neon } from "@neondatabase/serverless";
|
|
|
|
export async function POST(request: Request) {
|
|
try {
|
|
const sql = neon(process.env.DATABASE_URL as string);
|
|
const { name, email, clerkId } = await request.json();
|
|
|
|
if (!name || !email || !clerkId) {
|
|
return Response.json({ error: "Miss required fields" }, { status: 400 });
|
|
}
|
|
|
|
const response = await sql`
|
|
INSERT INTO users (
|
|
name,
|
|
email,
|
|
clerk_id
|
|
)
|
|
VALUES (
|
|
${name},
|
|
${email},
|
|
${clerkId}
|
|
)
|
|
`;
|
|
|
|
return new Response(JSON.stringify({ data: response }), { status: 201 });
|
|
} catch (error) {
|
|
console.log("DataBase Error:", error);
|
|
return new Response(JSON.stringify({ error: error }), { status: 500 });
|
|
}
|
|
}
|