Manager Postgres Database

🚀 A simple library to help developers to manage connections and queries on postgres database

$3

Install

bash
npm install @obi-tec/manager-postgres-database


See all tags clicking  here.



How to Use

In your file.js, import the dependency and extract the DatabaseConnection.

`javascript const { DatabaseConnection } = require('@obi-tec/manager-postgres-database');`

`$3`

 javascript
  DatabaseConnection.getInstance(
    'default',
    true,
    connectionSettings : {
      application_name : '',
      min              : 0,
      max              : 1,
      host             : 'localhost',
      port             : '5432',
      user             : 'postgres',
      password         : 'postgres',
      database         : 'postgres'
    },
    enableLogs   : false,
    camelizeKeys : true
  );



$3

We are used to using two types of instances: read and write. By the way, when you will use this function, remember to inform which of the options you wanna use.

Example:`javascript const query = 'SELECT * FROM user WHERE id = $1'; const userId = 1;

await DatabaseConnection.getInstance().connect();

// passing true value if you want to use database read-only // await DatabaseConnection.getInstance(true).connect();

const user = await DatabaseConnection.getInstance().queryFirstOrNull('getUserById', query, [userId]); await DatabaseConnection.getInstance().closeConnection();``

Status

🚧 Open for contribuitions... 🚧