Manager Postgres Database
🏁 Content
Install
npm install @obi-tec/manager-postgres-databaseSee all tags clicking here.
# How to Use In your file.js, import the dependency and extract the DatabaseConnection.
const { DatabaseConnection } = require('@obi-tec/manager-postgres-database');Setup Connection
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
);Using DatabaseConnection
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:
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();