Available on npmjs.org : @slickteam/nestjs-pg-typeorm
- Install dependency
npm i -S @slickteam/nestjs-pg-typeorm
- In your environment file, add these lines :
POSTGRESQL_ADDON_HOST=localhost
POSTGRESQL_ADDON_PORT=5432
POSTGRESQL_ADDON_USER=user
POSTGRESQL_ADDON_PASSWORD=password
POSTGRESQL_ADDON_DB=db_name
POSTGRESQL_MAX_POOL_SIZE=25
# Optionnel
POSTGRESQL_SYNCHRONIZE=false
POSTGRESQL_LOGGER=
POSTGRESQL_ENTITY_PATH=dist/**/*.entity.js,dist/**/*Entity.js,dist/**/**/*.entity.js,dist/**/**/*Entity.js
POSTGRESQL_MIGRATION_PATH=dist/migration/*.js
POSTGRESQL_LOGGING=
- In module where you want use this module, add this :
@Module({
imports: [Warp10Module],
controllers: [],
providers: [],
exports: [],
})
class ExempleModule {}
{
"scripts": {
"migration:drop": "typeorm-ts-node-commonjs schema:drop -d ./node_modules/@slickteam/nestjs-pg-typeorm/dist/database-config.js",
"migration:show": "typeorm-ts-node-commonjs migration:show -d ./node_modules/@slickteam/nestjs-pg-typeorm/dist/database-config.js",
"migration:create": "typeorm-ts-node-commonjs migration:create",
"migration:run": "typeorm-ts-node-commonjs migration:run -d ./node_modules/@slickteam/nestjs-pg-typeorm/dist/database-config.js",
"migration:revert": "typeorm-ts-node-commonjs migration:revert -d ./node_modules/@slickteam/nestjs-pg-typeorm/dist/database-config.js"
}
}
Nestjs
-
@nestjs/common
:^11.0.10
-
@nestjs/config
:^4.0.0
Pg
-
pg
:^8.13.3
Typeorm
-
@nestjs/typeorm
:^11.0.0
-
typeorm
:^0.3.20