how does this work with the kysely-codegen

[the-vampiire]

hey i used the kysely-codegen to generate the types. it seems like it worked fine but i'm wondering do i need to apply this plugin somewhere for D1 specific stuff?

the steps i took were:

1. run migrations on local D1 db
2. run codegen pointing at the sqlite file

sorry if its a dumb question, i'm new to using kysely.

[thebrownfox]

I use it like this in package.json:

"db:generate": "DB_PATH=$(find ./.wrangler/state/v3/d1/miniflare-D1DatabaseObject -type f -name \"*.sqlite\" -print -quit) && kysely-codegen --dialect=sqlite --url=$DB_PATH --out-file=types/db.d.ts",

[the-vampiire]

ah thank you. i ended up making this

script

"generate:db-types": "pnpm run migrate:local && pnpm kysely-codegen && pnpm format",
"generate:db-types:clean": "rm -rf .wrangler && pnpm run generate:db-types",

the scripts read this config file by default

.kysely-codegenrc.ts (in project root, same level as .wrangler/ dir)

import type { Config } from 'kysely-codegen';
import { readdirSync } from 'fs';
import { join } from 'path';

// Dynamically get the local D1 database path
const wranglerDir = join(
  __dirname,
  '.wrangler',
  'state',
  'v3',
  'd1',
  'miniflare-D1DatabaseObject'
);
const sqliteFile = readdirSync(wranglerDir).find((file) =>
  file.endsWith('.sqlite')
);
if (!sqliteFile) {
  throw new Error('No .sqlite file found. Run: npm run migrate:local');
}
const dbPath = join(wranglerDir, sqliteFile);

const config: Config = {
  camelCase: true,
  dialect: 'sqlite',
  runtimeEnums: 'screaming-snake-case',
  url: dbPath,
  outFile: 'src/types/db.d.ts',
};

export default config;