Skip to content

Open-source platform for 3D AI agents. Turn text or a photo into a rigged, animated GLB avatar, give it an LLM brain, memory and a wallet, and embed it anywhere with one web component. Remote MCP server, x402 payments, Three.js, browser-native.

1.1 KB
Raw Blame
// POST /api/notifications/read-all: mark all unread notifications as read.

import { sql } from '../_lib/db.js';
import { getRequestUser } from '../_lib/auth.js';
import { cors, json, method, wrap, error } from '../_lib/http.js';
import { requireCsrf } from '../_lib/csrf.js';

export default wrap(async (req, res) => {
	if (cors(req, res, { methods: 'POST,OPTIONS', credentials: true })) return;
	if (!method(req, res, ['POST'])) return;

	const user = await getRequestUser(req);
	if (!user) return error(res, 401, 'unauthorized', 'sign in required');

	if (!(await requireCsrf(req, res, user.id))) return;

	// Count the rows, do not ask Postgres to count them: a window function is
	// illegal in RETURNING ("window functions are not allowed in RETURNING"), so
	// the aggregate form threw on every call and the bell's "mark all read"
	// answered 500 for every user. RETURNING one column per updated row and
	// taking its length is the form Postgres actually allows.
	const rows = await sql`
		update user_notifications
		set read_at = now()
		where user_id = ${user.id} and read_at is null
		returning id
	`;

	return json(res, 200, { marked_read: rows.length });
});