nest-pg

Quick and easy module for using node-postgres in Nest.js.

Setup

``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]
})
`

`typescript
// cats.service.ts
@Injectable()
export class CatsService {
constructor(@PgConnection() private readonly db: NestPgPool) {}
async list() {
return this.db.rows(SELECT * FROM cats;);
}

async create(cat) {
return this.db.query(INSERT INTO cats(name, breed) values($1, $2);, [
cat.name,
cat.breed,
]);
}
}
``