saltbo__agent-kanban/server/db/index.ts

import { customAlphabet } from "nanoid";

const alphabet = "0123456789abcdefghijklmnopqrstuvwxyz";
const nanoid = customAlphabet(alphabet, 8);
const nanoid12 = customAlphabet(alphabet, 12);

export function newId(): string {
  return nanoid();
}

export function newLongId(): string {
  return nanoid12();
}

export type D1 = D1Database;

// Hard ceiling on rows returned from a single task partition (actions or
// actions). Protects D1 read budget against tasks with runaway row counts.
// Any fetch that returns exactly this many rows is at the cap — callers
// must assume older/newer rows beyond this point were silently truncated.
export const MAX_TASK_PARTITION_ROWS = 500;

export function parseJsonFields<T>(row: T, fields: (keyof T)[]): T {
  for (const f of fields) {
    if (typeof row[f] === "string") row[f] = JSON.parse(row[f] as string);
  }
  return row;
}