@scaleleap/typeorm NPM

npm.io

📦 @scaleleap/typeorm

Enhanced and pre-configured TypeORM version with helpers included.

Download & Installation

$ npm i -s typeorm @scaleleap/typeorm

Create a config file in src/ormconfig.ts:

import { createConnectionOptions } from '@scaleleap/typeorm'

export = createConnectionOptions({
  // ... your config
})

Add the following to package.json:

{
  "scripts": {
    "typeorm": "typeorm-cli -f src/ormconfig.ts"
  }
}

Add the following to tsconfig.json:

{
  "compilerOptions": {
    "emitDecoratorMetadata": true,
    "experimentalDecorators": true,
  },
}

Usage

Our package is a superset of typeorm, and thus you can use it exactly the same way as you would use typeorm directly.

import { createConnection } from '@scaleleap/typeorm'

Enhancements

`typeorm-cli` CLI replacement that supports TypeScript config files

typeorm-cli migration:generate ...

Here is a list of features and enhancements over stock typeorm:

`createConnectionOptions` factory function

Factory function for creating TypeORM configuration object. Suitable to be passed to createConnection function or inside ormconfig.ts.

Logger

You can pass an instance of @scaleleap/logger to createConnectionOptions factory to be used as a custom logger for TypeORM.

Naming Strategy

This package is pre-configured to use a custom naming strategy that is more descriptive and sane than TypeORM default. It uses meaningful identity naming. E.g. instead of PK_adc83b19e793491b1c6ea0fd8b46cd9f32e592fc it will use pk_user_id_a4378d.

`createConnection` factory function

The stock createConnection is amended to return a connection with enhanced type that exposes PostgreSQL connection Pool via connection.driver.master. The prop was already there, we are just casting the connection and driver to the right type to expose it correctly.

`createEncryptionTransformer` factory function

Creates a column transformer which can then be used to encrypt data.

export class Encrypted {
  // ...

  @Column({ transformer: createEncryptionTransformer(encryptionKey) })
  public secret!: string
}

`migration:generate`

The migration:generate command has been enhanced to create prettified SQL.

`TestDatabaseConnection` class for tests

// pass the same params as `createConnectionOptions`
const tdc = new TestDatabaseConnection({
  connectionOptions: {
    entities: [User],
  },
})

// 1. Creates a test database
// 2. Returns TypeORM connection
const connection = await tdc.setup()

//
// run the tests here...
//

// 1. Destroys the test database
// 2. Disconnects
await tdc.teardown()