Speisekarte/lib/db/settings.ts

import "server-only";
import { queryOne } from "@/lib/db";

export type LabelingMode = "detailed" | "notice";

export interface Settings {
  colors: Record<string, string>;
  logo_path: string | null;
  favicon_path: string | null;
  labeling_mode: LabelingMode;
  labeling_notice: string;
  labeling_notice_en: string | null;
  labeling_notice_pl: string | null;
}

export async function getSettings(): Promise<Settings | null> {
  return queryOne<Settings>(
    `select colors, logo_path, favicon_path, labeling_mode,
            labeling_notice, labeling_notice_en, labeling_notice_pl
     from settings where id = 1`
  );
}