Svelte, Hono, and D1 database

This is my middleware:

import { drizzle, type DrizzleD1Database } from "drizzle-orm/d1";
import { createMiddleware } from "hono/factory";

type Env = {
  Bindings: {
    DB: D1Database;
  };
  Variables: {
    db: DrizzleD1Database;
  };
};

export const middleware = createMiddleware<Env>(async (c, next) => {
  const db = drizzle(c.env.DB);

  c.set("db", db);

  await next();
});

import { drizzle, type DrizzleD1Database } from "drizzle-orm/d1";
import { createMiddleware } from "hono/factory";

type Env = {
  Bindings: {
    DB: D1Database;
  };
  Variables: {
    db: DrizzleD1Database;
  };
};

export const middleware = createMiddleware<Env>(async (c, next) => {
  const db = drizzle(c.env.DB);

  c.set("db", db);

  await next();
});

This is how I used:

.get("/getAll", middleware, async (c) => {
    const db = c.get("db");

    try {
      const subscriptions = await db.select().from(SubscriptionTable);

      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

.get("/getAll", middleware, async (c) => {
    const db = c.get("db");

    try {
      const subscriptions = await db.select().from(SubscriptionTable);

      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

I also set like this in my wrangler.json file:

"d1_databases": [
    {
      "binding": "DB",
      "database_name": "*****",
      "database_id": "*****"
    }
  ]

"d1_databases": [
    {
      "binding": "DB",
      "database_name": "*****",
      "database_id": "*****"
    }
  ]

Why I am getting this error in my svlete project?

TypeError: Cannot read properties of undefined (reading 'DB')
    at eval (/Users/sithu/ht-saas/recurrify/src/lib/features/subscriptions/route.ts:32:40)

TypeError: Cannot read properties of undefined (reading 'DB')
    at eval (/Users/sithu/ht-saas/recurrify/src/lib/features/subscriptions/route.ts:32:40)

7 Replies

Bonadio•2mo ago

Create a file called InitDb.ts

export let db: DrizzleD1Database;

export const initDb = (c: Context) => {
    db =  drizzle(c.env.DB);
}

export let db: DrizzleD1Database;

export const initDb = (c: Context) => {
    db =  drizzle(c.env.DB);
}

Then in your middleware do

export const middleware = createMiddleware<Env>(async (c, next) => {
    initDb(c)
    await next()
});

export const middleware = createMiddleware<Env>(async (c, next) => {
    initDb(c)
    await next()
});

In your routes

import {db} from InitDb

.get("/getAll", middleware, async (c) => {

    try {
      const subscriptions = await db.select().from(SubscriptionTable);
      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

import {db} from InitDb

.get("/getAll", middleware, async (c) => {

    try {
      const subscriptions = await db.select().from(SubscriptionTable);
      return c.json({ data: subscriptions });
    } catch (error) {
      const message = handleError(error);
      return c.json({ message }, 500);
    }
  })

I apply my middeware in the beginning with app.use('*', dbMiddleware) Before I define the routes

Sithu KhantOP•2mo ago

hey that is really helpful btw, how do you handle multiple d1 db in wrangler file? I mean I kinda want to use one for prod and one for dev.

Bonadio•2mo ago

You define a single DB, when you run on dev the DB is a local sqlite in your hard drive. On the server is D1

Sithu KhantOP•2mo ago

really...? That is so cool, I didn't know that so, I would only need to define one db instance in wrangler file, am I right? btw, @Bonadio how about drizzle config file?

Bonadio•2mo ago

Yes, only one db instance in wangler. and this is my drizzle config import type { Config } from 'drizzle-kit' export default { schema: './app/db/customerSchema.ts', out: './drizzle', } satisfies Config At you project there will be a hidden folder .wrangler if you expand it there will be a d1 subfolder and the sqlite file will be there. You need to run wrangler dev and access any route that make a call to the database the first time it will be blank and the call will fail but it will create the sqlite file. them you can open it and create the tables. In dev I create my tables using drizzle generate than I copy and paste the SQL in "DB Browser Sqlite" to create the tables

Bonadio•2mo ago

Sithu KhantOP•2mo ago

okay... that is helpful

Gaming

Programming

Svelte, Hono, and D1 database

Did you find this page helpful?