Cloudflare D1 Database

import { getCloudflareContext } from "@opennextjs/cloudflare";

export function getDB(): D1Database {
  return (getCloudflareContext().env as Env).DB;
}

"use server";
import { getDB } from "@/lib/db";
import { revalidatePath } from "next/cache";

export async function createItem(formData: FormData) {
  const name = formData.get("name") as string;
  const db = getDB();
  await db.prepare("INSERT INTO items (name) VALUES (?)")
    .bind(name).run();
  revalidatePath("/d1-database");
}

export async function listItems() {
  const db = getDB();
  const { results } = await db
    .prepare("SELECT * FROM items ORDER BY id DESC")
    .all();
  return results;
}