DT
Drizzle Team•2mo ago
TGTGamer

db.query error: TS2339: Property priceRules does not exist on type {}

So when using drizzle schema's imported from a node package (we do this as we are in a mono-repository and it's easier to manage versioning this way), I get this error, which claims the property doesn't exist, even through the tooltip has the value and I've verified the package does export the schema with this value on. Any advice? db.ts 
import { CombinedSchemaType, schema } from "@encircle-marketing/crm.utilities.drizzle";
import { Logger } from "drizzle-orm/logger";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import { env } from "~/env";

const globalForDb = globalThis as unknown as {
    primary: ReturnType<typeof drizzle<CombinedSchemaType>> | undefined;
};

const primary = drizzle<CombinedSchemaType>(postgres(env.DATABASE_URL), {
    schema,
    logger: new ConsoleLogger(`Primary: ${env.DATABASE_URL}`),
});

if (env.NODE_ENV !== "production" && env.NODE_ENV !== "staging") {
    globalForDb.primary = primary;
}

export const db = primary;
import { CombinedSchemaType, schema } from "@encircle-marketing/crm.utilities.drizzle";
import { Logger } from "drizzle-orm/logger";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";
import { env } from "~/env";

const globalForDb = globalThis as unknown as {
    primary: ReturnType<typeof drizzle<CombinedSchemaType>> | undefined;
};

const primary = drizzle<CombinedSchemaType>(postgres(env.DATABASE_URL), {
    schema,
    logger: new ConsoleLogger(`Primary: ${env.DATABASE_URL}`),
});

if (env.NODE_ENV !== "production" && env.NODE_ENV !== "staging") {
    globalForDb.primary = primary;
}

export const db = primary;
I'm using my exported Type CombinedSchema here which is just a typeof schema 
import { DrizzleAspect } from './drizzle.aspect.js'
import * as CombinedSchema from './schema.js'

export * from 'drizzle-orm'
export * from './drizzle.node.runtime.js'
export * from './schema.js'
export const schema = CombinedSchema

export type CombinedSchemaType = typeof CombinedSchema
export default DrizzleAspect
export { DrizzleAspect }
import { DrizzleAspect } from './drizzle.aspect.js'
import * as CombinedSchema from './schema.js'

export * from 'drizzle-orm'
export * from './drizzle.node.runtime.js'
export * from './schema.js'
export const schema = CombinedSchema

export type CombinedSchemaType = typeof CombinedSchema
export default DrizzleAspect
export { DrizzleAspect }
No description
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?