Use the EdgeSpark database

import { integer, sqliteTable, text } from "drizzle-orm/sqlite-core";

export const posts = sqliteTable("posts", {
  id: integer("id").primaryKey({ autoIncrement: true }),
  title: text("title").notNull(),
  content: text("content"),
  authorId: text("author_id").notNull(),
  createdAt: text("created_at").notNull().default("(datetime('now'))"),
});

import { db } from "edgespark";
import { auth } from "edgespark/http";
import { desc, eq } from "drizzle-orm";
import { Hono } from "hono";
import { posts } from "@defs";

const app = new Hono()
  .get("/api/posts", async (c) => {
    const rows = await db
      .select()
      .from(posts)
      .orderBy(desc(posts.createdAt));

    return c.json(rows);
  })
  .get("/api/posts/:id", async (c) => {
    const id = Number(c.req.param("id"));
    const [post] = await db.select().from(posts).where(eq(posts.id, id));

    if (!post) return c.json({ error: "Not found" }, 404);
    return c.json(post);
  })
  .post("/api/posts", async (c) => {
    const body = await c.req.json<{ title: string; content?: string }>();

    const [post] = await db
      .insert(posts)
      .values({
        title: body.title,
        content: body.content ?? null,
        authorId: auth.user.id,
      })
      .returning();

    return c.json(post, 201);
  });

export default app;

import { db } from "edgespark";
import { auth } from "edgespark/http";
import { eq } from "drizzle-orm";
import { Hono } from "hono";
import { posts } from "@defs";

const app = new Hono()
  .patch("/api/posts/:id", async (c) => {
    const id = Number(c.req.param("id"));
    const body = await c.req.json<{ title?: string; content?: string }>();

    const [post] = await db
      .update(posts)
      .set(body)
      .where(eq(posts.id, id))
      .returning();

    return c.json(post);
  })
  .delete("/api/posts/:id", async (c) => {
    const id = Number(c.req.param("id"));

    await db
      .delete(posts)
      .where(eq(posts.id, id))
      .returning({ authorId: posts.authorId });

    return c.body(null, 204);
  });

export default app;