34 lines
1017 B
TypeScript
34 lines
1017 B
TypeScript
import type { NextApiRequest, NextApiResponse } from "next";
|
|
import { getDb } from "@/lib/db";
|
|
import { randomUUID } from "crypto";
|
|
|
|
export default function handler(req: NextApiRequest, res: NextApiResponse) {
|
|
const db = getDb();
|
|
|
|
if (req.method === "GET") {
|
|
const lists = db
|
|
.prepare(
|
|
`SELECT l.*, COUNT(lt.target_id) as target_count
|
|
FROM lists l
|
|
LEFT JOIN list_targets lt ON lt.list_id = l.id
|
|
GROUP BY l.id
|
|
ORDER BY l.created_at DESC`
|
|
)
|
|
.all();
|
|
return res.json(lists);
|
|
}
|
|
|
|
if (req.method === "POST") {
|
|
const { name, description } = req.body;
|
|
if (!name) return res.status(400).json({ error: "name required" });
|
|
const id = randomUUID();
|
|
db
|
|
.prepare("INSERT INTO lists (id, name, description) VALUES (?, ?, ?)")
|
|
.run(id, name, description ?? null);
|
|
return res.status(201).json(db.prepare("SELECT * FROM lists WHERE id = ?").get(id));
|
|
}
|
|
|
|
res.setHeader("Allow", ["GET", "POST"]);
|
|
res.status(405).end();
|
|
}
|