app/db/settings.ts

Functions

Imports

It imports app/db/client.ts, app/db/schema.ts. Imported by app/db/index.ts, app/lib/llms/save.server.ts.

Source

1// The key-value settings table.
2import { eq } from "drizzle-orm";
3import { settings } from "./schema";
4import { getDb } from "./client";
5
6export async function getSetting(env: Env, key: string) {
7  const rows = await getDb(env)
8    .select({ value: settings.value })
9    .from(settings)
10    .where(eq(settings.key, key))
11    .limit(1);
12  return rows[0]?.value ?? null;
13}
14
15export async function setSetting(env: Env, key: string, value: string) {
16  await getDb(env)
17    .insert(settings)
18    .values({ key, value })
19    .onConflictDoUpdate({ target: settings.key, set: { value } });
20}