nest-pg v0.3.5

nest-pg

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

Setup

// database.module.ts

@Module({
  imports: [
    NestPgModule.register({ 
      user: 'user',
      password: 'password',
      host: 'host',
      database: 'catabase',
      port: 5432,
    } as NestPgOptions),
  ],
})

// app.module.ts
@Module({
  imports: [DatabaseModule, CatsModule],
})

// cats.module.ts
@Module({
  providers: [CatsService]
})

// 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,
    ]);
  }
}