dynamic schema imports

[blak1984]

is it possible to somehow dynamically import schema modules and have it recognized by db.query.X?

e.g.:

const glob = new Glob("./db/schema/**/*.ts");

const scannedFiles = await Array.fromAsync(glob.scan({ absolute: true }));

const schemaModules = await Promise.all(
  scannedFiles.map(async (file) => await import(file))
);

const schema = schemaModules.reduce((acc, module) => {
  return { ...acc, ...module };
}, {});

const client = postgres(process.env.DB_URL as string);

const db = drizzle(client, { schema });

[kravetsone]

is it possible to somehow dynamically import schema modules and have it recognized by db.query.X?

e.g.:

const glob = new Glob("./db/schema/**/*.ts");

const scannedFiles = await Array.fromAsync(glob.scan({ absolute: true }));

const schemaModules = await Promise.all(
  scannedFiles.map(async (file) => await import(file))
);

const schema = schemaModules.reduce((acc, module) => {
  return { ...acc, ...module };
}, {});

const client = postgres(process.env.DB_URL as string);

const db = drizzle(client, { schema });

it is useless + zero typings

[blak1984]

I figured out another way to do it by just having an index.ts file and putting all my schema exports in there

[cannap]

this could also be usefull https://marketplace.visualstudio.com/items?itemName=eliostruyf.vscode-typescript-exportallmodules

[Kokleng-Dev]

i have this problem too? how to solve ? it is can not put in index.ts and call to use because that is the method with dynamic schema.
so can u make this work? is it could? i can solve auto dynamic import with it too.

const users = (name: string) => pgSchema(name).table('users', {
        id: serial('id').primaryKey(),
        name: text('name').notNull(),
        invitedBy: integer('invited_by').references((): AnyPgColumn => users.id),
    });
const db = drizzle({ users("tenant_1") });
await db.query.users.findMany(...);

db.query.X

typescript doesn't pop up "users" when i try to type " db.query. " .

i am buiding multi-tenant with the same database but difference schema.

please help me !!! thanks alot !!!