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