mysqliter v1.0.6

mysqliter

mysql wrapper for object query builder(dev stage)

Initiate Mysql Database

const config = {
  server: 'localhost',
  port: '3306',
  database: 'database_name',
  user: 'root',
  password: 'pass'
};

const mysqliter  =require('mysqliter');
mysqliter.connect(config , {
    //useFindAndModify: false
});

Create Model

const modelName = 'vender';
const mysqliter = require('mysqliter');

const schema = {};

module.exports = mysqliter.model(modelName,schema);

Select Query

const vender = require('../../../common/models/vender');
vender.find()
      .where('contactNumber').equals('0703032901')
      .select('firstName lastName')
      .limit(1)
      .exec(function (err, result){       
         if(err){
            console.log("find error : ", err);
         }else{
             console.log("find result : ", result);
         }
      });

Update Query

const vender = require('../../../common/models/vender');
vender.update({firstName: 'ppd'})
      .where('contactNumber').equals('0703032901')
      .exec(function (err, result){
         if(err){
            console.log("update error : ", err);
         }else{
             console.log("update result : ", result);
         }
});

Insert Query

const vender = require('../../../common/models/vender');


const insertdata={
    firstName:"samadhi",
    lastName:"laksahan",
    contactNumber:"0713664198",
    password:"12345",
}

vender.insert(insertdata)
      .exec(function (err, result){
        if(err){
           console.log("test error : ", err);
        }else{
            console.log("test result : ", result);
        }
      });

Use Native Query Condition

const vender = require('../../../common/models/vender');

vender.find('contactNumber= "0703032901" ')
      .select('firstName lastName')
      .limit(1)
      .exec(function (err, result){       
         if(err){
            console.log("find error : ", err);
         }else{
             console.log("find result : ", result);
         }
      });

selecting conditions