Schema Information in drizzle

[bolqqq]

Hey,

we setup a Database class that initializes Drizzle for us (everything is work in progress)

import { Pool, PoolConnection } from 'mysql2/promise';

class DatabaseClient {
  private readonly _migrationFolderName = 'migrations';
  constructor(
    private readonly _pool: Pool
  ) {}

  getDatabase = (client: Pool | PoolConnection = this._pool) => {
    return drizzle(client, { mode: 'default', schema: databaseSchemas, casing: 'snake_case' });
  };
  async executeMigrations(): Promise<void> {
    let connection: PoolConnection | undefined;

    try {
      connection = await this._pool.getConnection();
      const db = this.getDatabase(connection);
      await migrate(db, { migrationsFolder: this._migrationFolderName });

    } finally {
      if (connection) connection.release();
    }
  }
}

export type Database = ReturnType<DatabaseClient['getDatabase']>;
export default DatabaseClient;

We setup the db like this

const pool = createPool({
  uri: config.DATABASE_URL,
  connectionLimit: config.DATABASE_POOL_CONNECTION_LIMIT
});
const database = new DatabaseClient(pool);

and want to use it in repository classes similar to this

class SomeRepository {
  constructor(private readonly _db: Database) {}

  createSomething = async (data: CreateSomethingDto) => {
    return await this._db.transaction(async (tx) => {
      const something = await tx.insert(this._db._.fullSchema.something).values(data);
      await tx.insert(this._db._.fullSchema.somethingElse).values({something: 123});
      return something;
    });
  };
}

export default SomeRepository;

I removed various unnecessary info here to reduce code to a minimum.
My question now is if this._db._.fullSchema.somethingElse is a good way to access the drizzle schema (it may or may not contains relations) as I don't want to use a direct import of the schema due to the fact that all dependencies should only be injected via the constructor or is there a better way to do this?