Skip to content

devnesthq/mysqlr

Repository files navigation

This package will ease your task with mysql

It manage all the data processing issue. Build on top of mysql. So you will get all the basic function

Not Ready, Developing Actully :D

Doc v-1

Basic Init

Import mysqlr
const mysqlr = require('mysqlr');
At the startup u have to init the mysqlr
mysqlr.init({
    host: "localhost",
    user: "root",
    password: "mysql",
    database: "mysqlrTesting"
})

This is for my local database. You can use your own details

Simple right !!!

Oparations

Supporse you have a mysql database and table like below

Database Name mysqlrTesting

Table name: table_1

COL1 COL2 COL3 COL4
dt11 dt12 dt13 dt14
dt21 dt22 dt23 dt24
dt31 dt32 dt33 dt34
dt41 dt42 dt43 dt44
dt51 dt52 dt53 dt54

##Then the query be like

Select Query

with promise

mysqlr.query('SELECT * FROM test1').then(response => {
    consle.log(response)
}):

or with async/await

let qry = await mysqlr.query('SELECT * FROM test1');

Insert Query

let qry = await mysqlr.query("INSERT INTO test1(t1,t2) VALUES ('dt61','dt64')");

Using mysqlr you can just insert a json object like as

   const data = {
                    test1:
                    {
                        t1: 'Hello',
                        t4: 'Hello'
                    },
                }
    mysqlr.jsonInsert(data).then(response => console.log(response))

or

    let qry = await mysqlr.jsonInsert(data));

and... that's it. The Data will be inserted into the database. No Need to take any extra measure. It works like sequelize but at the behide works as normal mysql lib.

Clean table data

Clean all data from a table

let basic_1 = await mysqlr.del('test1')

Remove Specific data/item from table

Here peramitter are

mysqlr.cleanByItem(table_name, colume name, item name)

let basic_1 = await mysqlr.delByItem('test1', 't1', "Hello")

Sample Code 1

mysqlr init will use memory to remember the config. so no needed to init every time. Just init it at the start of the code.

const mysqlr = require('mysqlr');

mysqlr.init({
    host: "localhost",
    user: "root",
    password: "mysql",
    database: "mysqlrTesting"
})

mysqlr.query('SELECT * FROM test1').then(response => {
    consle.log(response)
})

Sample Code 2

filename: start.js

const mysqlr = require('mysqlr');

mysqlr.init({
    host: "localhost",
    user: "root",
    password: "mysql",
    database: "mysqlrTesting"
})

..... other codes

filename: searchQuery.js

const mysqlr = require('mysqlr');

mysqlr.query('SELECT * FROM test1').then(response => {
    consle.log(response)
})

Simple :D




More are coming. Hope this will be AWESOME at the END

About

This package will easy your task with mysql, see npm module

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published