Nest.js dynamic module for node-postgres
npm install nest-pgQuick and easy module for using node-postgres in Nest.js.
``typescript
// database.module.ts
@Module({
imports: [
NestPgModule.register({
user: 'user',
password: 'password',
host: 'host',
database: 'catabase',
port: 5432,
} as NestPgOptions),
],
})
`
`typescript
// app.module.ts
@Module({
imports: [DatabaseModule, CatsModule],
})
`
`typescript`
// cats.module.ts
@Module({
providers: [CatsService]
})
`typescriptSELECT * FROM cats;
// cats.service.ts
@Injectable()
export class CatsService {
constructor(@PgConnection() private readonly db: NestPgPool) {}
async list() {
return this.db.rows();
}
async create(cat) {
return this.db.query(INSERT INTO cats(name, breed) values($1, $2);, [``
cat.name,
cat.breed,
]);
}
}