Drizzle Team•2y ago

Property 'userTable' does not exist on type 'DrizzleTypeError<"Seems like the schema generic is.. ">

I am trying to run a filter and I am getting this error, PFA

https://github.com/Boby900/lucia-demo

GitHub

GitHub - Boby900/lucia-demo

Contribute to Boby900/lucia-demo development by creating an account on GitHub.

Solution

Hey @Boby
It seems to me that you've not passed your schemas to the function call while create the db instance like following


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });

Jump to solution

Solution

Pradip Chaudhary•7/7/24, 4:38 AM

Hey @Boby
It seems to me that you've not passed your schemas to the function call while create the db instance like following


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });


import * as schema from "./schema";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

const queryClient = postgres(process.env.DATABASE_URL);
export const db = drizzle(queryClient, { schema });

BobyOP•7/7/24, 5:22 AM

hey, thanks @Pradip Chaudhary now it's working

BBoby hey, thanks @Pradip Chaudhary now it's working 🙏

Pradip Chaudhary•7/7/24, 5:24 AM

My pleasure