redbook v0.1.6

redBook

RedBook is mysql helper. redBook make script a simple and easy to use

##How to Use

  var redBook      = require('redbook');

First, define resource of database

  var resInf={
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : 'dbname'
 };
 
 

##Example redbook function Get Row of table data

new redBook(resInf).table('users').where('id',1).andWhere('group','mygroup').getRow(function (err,users) {
  if(typeof users != "undefined" && users.length >= 1){
    console.log(users);
  }
});

Inset Table

new redBook(resInf).table('users').insert({name:'myname',groupID: 1});

Update

new redBook(resInf).table('users').updateRaw('gamestart=? WHERE groupID=?',['yes',1]);

Delete

new redBook(resInf).table('users').where('groupID',1).delete();

Other Operator

new redBook(resInf).table('users').where('groupID',1).operator('AND WHERE city LIKE "s%"').getRow(function (err,users) {
    // row result
});

Join

new redBook(resInf).table('users').innerJoin('group','users.id = group.userid').where('users.money','>=',2000)
.select('group.*, SUM(group.user) AS maxUser').getRow(function (err,users){
    // row result
});

Other function

orWhere, orderBy, leftJoin,  rightJoin, fullJoin