@hashirrao/postgresql-general-backend NPM

PostgreSQL Query Utility: `@hashirrao/postgresql-general-backend`

A simple and efficient Node.js utility for performing CRUD operations on PostgreSQL databases. This package simplifies database interaction by abstracting common query patterns, making development faster and cleaner.

Installation

npm install @hashirrao/postgresql-general-backend

yarn add @hashirrao/postgresql-general-backend

Insert Data

Quickly add new rows to a table.

Retrieve Data

Fetch records with filtering, sorting, pagination, and column selection.

Update Data

Modify rows based on specified conditions.

Hard Delete

Remove rows from the database.

Usage

Import the Package

const { insertData, getData, updateData, deleteData, hardDeleteData } = require('@hashirrao/postgresql-general-backend');

Set Up Connection

const connectionObj = {
    user: 'your-username',
    host: 'your-host',
    database: 'your-database',
    password: 'your-password',
    port: 5432,
};

Examlples

Insert Data

const tableName = 'users';
const data = { name: 'John Doe', email: 'john.doe@example.com' };

insertData(connectionObj, tableName, data)
    .then(response => console.log(response))
    .catch(error => console.error(error));

Retrieve Data

getData(connectionObj, 'users', ['id', 'name'], [{ column_name: 'is_deleted', operation: '=', value: false }], 'name', 10, 0)
    .then(response => console.log(response))
    .catch(error => console.error(error));

Update Data

updateData(connectionObj, 'users', { name: 'Jane Doe' }, [{ column_name: 'id', operation: '=', value: 1 }])
    .then(response => console.log(response))
    .catch(error => console.error(error));

Delete

deleteData(connectionObj, 'users', [{ column_name: 'id', operation: '=', value: 1 }])
    .then(response => console.log(response))
    .catch(error => console.error(error));