DT
Drizzle Team•15mo ago
1lluz10n

is not assignable to type 'DrizzleD1Database'

Hello This last release was amazing. Making joins simple was the missing piece for me. However, I'm trying to upgrade https://race-stack.pages.dev to the new API (it previously used the joins). I'm getting the error from the screenshot. Not sure what's going on, created a PR with it. Here's the PR - https://github.com/jose-donato/race-stack/pull/2 schema - https://github.com/jose-donato/race-stack/blob/f5ce04cdae134302c94e2de671c7a272274dab36/app/lib/schema.ts db initialization - https://github.com/jose-donato/race-stack/blob/f5ce04cdae134302c94e2de671c7a272274dab36/app/lib/db.service.server.ts
GitHub
Converting to new drizzle version (queries) by jose-donato · Pull R...
GitHub
race-stack/schema.ts at f5ce04cdae134302c94e2de671c7a272274dab36 · ...
Remix run stack built for the edge (cloudflare pages and d1) - race-stack/schema.ts at f5ce04cdae134302c94e2de671c7a272274dab36 · jose-donato/race-stack
GitHub
race-stack/db.service.server.ts at f5ce04cdae134302c94e2de671c7a272...
Remix run stack built for the edge (cloudflare pages and d1) - race-stack/db.service.server.ts at f5ce04cdae134302c94e2de671c7a272274dab36 · jose-donato/race-stack
4 Replies
Andrii Sherman
Andrii Sherman•15mo ago
Will try to check and fix it asap
1lluz10n
1lluz10n•15mo ago
no rush, thanks for the help 🤟
Maston
Maston•15mo ago
not a bug with drizzle, you explicitly type the return type of that function as DrizzleD1Database which is not assignable, try DrizzleD1Database<typeof schema> 
export const getDbFromContext = (
  context: Record<string, unknown>
): DrizzleD1Database<typeof schema> => {
  if (!contextWithDb(context)) {
    throw new Error("No database in context");
  }

  return drizzle(context.DB, {
    schema,
  });
};
export const getDbFromContext = (
  context: Record<string, unknown>
): DrizzleD1Database<typeof schema> => {
  if (!contextWithDb(context)) {
    throw new Error("No database in context");
  }

  return drizzle(context.DB, {
    schema,
  });
};
works for me, i cloned your pr looks like a nice project you got also SeemsGood
1lluz10n
1lluz10n•15mo ago
ohhhh I'm dumb 🫣🫣🫣 sorry for wasting your time with this 😅 thank you! drizzle has been amazing to work with. using on several projects
Want results from more Discord servers?
Add your server
More Posts
Drizzle kit generate gives error after upgradeI have updated drizzle-orm to 0.26.0 and drizzle-kit to 018.0. I have defined relations according toIntrospection error with pgHello, I am trying to introspect my already created DB but when I run the cli command I get: ``` > dHow to declare PostgreSQL extensions/plugin?Reference: https://www.prisma.io/docs/concepts/components/prisma-schema/postgresql-extensions Is thHow to consume existing supabase migration?I have a supabase migrations and would like to reuse them as a starter for drizzle. When trying to pPrisma Studio style db explorerHey there! Anyone aware of a prisma studio style db-playground / db-admin-dashboard that works withIncorrect return type findFristHi! I just upgraded to `26.0` and I'm refactoring queries to `findFirst` where needed. But the retuRelations module - or conditionHi there! I have a teams table, an users table, and a team_members table that connects these two. AAre foreign key polyfills for PlanetScale supported by Drizzle?Hi Prisma supports this (although slow). See: https://www.prisma.io/docs/guides/database/planetscalTS error: Argument of type PgTableWithColumns is not assignable to parameter of type AnyPgTableHi all, after updating to latest i'm getting this TS error. This is my db creation and schema. ``` Many-to-many relational query issuesschema, relations, statements: https://gist.github.com/kylewardnz/37104f989807e96555ea856294a2b670