Writing

import * as Effect from "effect/Effect";
import { DatabaseWriter } from "./confect/_generated/services";

Effect.gen(function* () {
  const writer = yield* DatabaseWriter;

  return yield* writer.table("notes").insert({
    title: "My first note",
    text: "This is my first note",
  });
});

writer.table("notes").insert({
  title: "My first note",
  text: "This is my first note",
});

writer.table("notes").patch(noteId, {
  title: "Patched title",
  author: "John Doe",
  text: undefined,
});

writer.table("notes").replace(noteId, {
  title: "Replaced title",
  text: "I'm replacing the whole document",
});

writer.table("notes").delete(noteId);