app/lib/projects.server.ts

Functions

Imports

It imports app/db/schema.ts, app/lib/people.server.ts, app/lib/roles.ts, app/lib/sites.server.ts. Imported by app/lib/ai.server.ts, app/lib/bulk.server.ts, app/lib/content.server.ts, app/lib/google/drive.server.ts, app/lib/google/search-console.server.ts, app/lib/history.server.ts, app/lib/legal.server.ts, app/lib/mcp/tools.ts, app/lib/media.server.ts, app/lib/mentions.server.ts, app/lib/voice.server.ts, app/routes/ai-draft.preview.ts, app/routes/ai-draft.tsx, app/routes/editor.tsx, app/routes/history.tsx, app/routes/legal.tsx, app/routes/media.api.ts, app/routes/media.bulk.ts, app/routes/media.tsx, app/routes/mentions.api.ts, app/routes/mentions.tsx, app/routes/preview.ts, app/routes/project.bulk.ts, app/routes/project.flags.tsx, app/routes/project.new.tsx, app/routes/project.tsx, app/routes/project.voice.tsx, app/routes/unpublish.tsx.

Source

1import { eq } from "drizzle-orm";
2import { drizzle } from "drizzle-orm/d1";
3
4import { projects } from "~/db/schema";
5import { requireAction, type Viewer } from "~/lib/people.server";
6import type { Action, Role } from "~/lib/roles";
7import { isSiteId, type SiteId } from "~/lib/sites.server";
8
9export type SiteProject = {
10  id: number;
11  slug: string;
12  name: string;
13  site: SiteId;
14  role: Role;
15};
16
17/**
18 * The project behind a URL, for a viewer allowed `action` on it. A project that does not exist, is
19 * not shared with the viewer, or is not a site all answer 404, so a URL reveals nothing.
20 */
21export async function requireSiteProject(
22  db: D1Database,
23  viewer: Viewer,
24  slug: string | undefined,
25  action: Action,
26): Promise<SiteProject> {
27  const row = slug
28    ? await drizzle(db)
29        .select({ id: projects.id, slug: projects.slug, name: projects.name, site: projects.site })
30        .from(projects)
31        .where(eq(projects.slug, slug))
32        .get()
33    : undefined;
34  if (!row) throw new Response("Not found", { status: 404 });
35  const role = await requireAction(db, viewer, row.id, action);
36  if (!isSiteId(row.site)) throw new Response("Not found", { status: 404 });
37  return { id: row.id, slug: row.slug, name: row.name, site: row.site, role };
38}