MYSQL Query Utility: @hashirrao/mysql-general-backend

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

Installation

npm install @hashirrao/mysql-general-backend

or

yarn add @hashirrao/mysql-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.

Delete

Permanently remove rows from the database.

Usage

Import the Package

const { insertData, getData, updateData, deleteData } = require('@hashirrao/mysql-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: '[email protected]' };

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));