Trey Posts - Answer Overflow

Trey

•Created by Trey on 1/26/2024 in #help

Drizzle Typescript Init with Schema Type Error

I am testing Drizzle as an alternative to Prisma (which is our current implementation). Thanks to Drizzle's query composability it fits with some of the stuff we want to do much better. During the process of setting up Drizzle, something is going wrong. Looking through the docs (https://orm.drizzle.team/docs/rqb) and trying to replicate the setup is failing with a typescript error (which prevents me from accessing the query interface. This is my current initialization:

export const db = drizzle(connection, {schema});

export const db = drizzle(connection, {schema});

schema is imported as per the documentation:

import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2/promise";
import * as schema from "./schema";

import { drizzle } from "drizzle-orm/mysql2";
import mysql from "mysql2/promise";
import * as schema from "./schema";

And the schema file being referenced is generated via introspection from drizzle-kit. The typescript error that comes out of it is odd:

Type 'typeof import(".../db/schema")' is not assignable to type 'Record<string, never>'.

Type 'typeof import(".../db/schema")' is not assignable to type 'Record<string, never>'.

I've looked through the types, I'm not 100% sure how to correct it. As far as I can tell it's matching the documentation for query. Have I done something silly?

4 replies

Gaming

Programming