sailfork / t3code-github / .repos/ alchemy-effect/ examples/ prisma-tanstack-start/ src/ prisma/ queries.ts

import { getDb } from "./db";

export async function getLatestPosts(limit = 10) {
  const db = getDb();
  const runtime = db.runtime();

  return runtime.query(
    db.sql.public.post
      .select("title", "excerpt")
      .orderBy("createdAt", { direction: "desc" })
      .limit(limit)
      .build(),
  );
}

export async function checkDatabaseReady() {
  const db = getDb();
  const runtime = db.runtime();
  await runtime.query(db.sql.public.user.select("id").limit(1).build());
}