app/db/client.ts

Functions

Imports

It imports app/db/schema.ts, app/lib/search/visibility.mjs. Imported by app/db/cv.ts, app/db/dictionary.ts, app/db/index.ts, app/db/media.ts, app/db/members.ts, app/db/pages.ts, app/db/phages.ts, app/db/posts.ts, app/db/procedure-versions.ts, app/db/procedures.ts, app/db/publications.ts, app/db/registry.ts, app/db/roster.ts, app/db/settings.ts, app/db/webmentions.ts, app/lib/citations.server.ts.

Source

1// The connection and the predicates more than one table module composes.
2// Only `getDb` and `publiclyVisible` are re-exported from `~/db`.
3import { PUBLISHED_STATUS } from "~/lib/search/visibility.mjs";
4import { and, eq, isNull, lte, or } from "drizzle-orm";
5import { drizzle } from "drizzle-orm/d1";
6import * as schema from "./schema";
7import { media, posts } from "./schema";
8
9export function getDb(env: Env) {
10  return drizzle(env.DB, { schema: schema });
11}
12
13export type DB = ReturnType<typeof getDb>;
14
15export function publiclyVisible() {
16  return and(
17    eq(posts.status, PUBLISHED_STATUS),
18    or(isNull(posts.publishAt), lte(posts.publishAt, new Date())),
19  );
20}
21
22export function isBlogPost() {
23  return and(eq(posts.kind, "post"), publiclyVisible());
24}
25
26/** Reconciliation readers must not use this filter, or a rebuild restores trashed rows. */
27export function notTrashed() {
28  return isNull(media.trashedAt);
29}