xxg-db-query

mysql: CREATE TABLE querys ( id int(11) NOT NULL AUTO_INCREMENT,

path varchar(128) DEFAULT NULL,

sqlStr varchar(512) DEFAULT NULL,

params varchar(128) DEFAULT NULL,

callback varchar(1024) DEFAULT NULL,

description varchar(128) DEFAULT NULL,

aviable int(11) DEFAULT '1',

PRIMARY KEY (id),

UNIQUE KEY querys_id_uindex (id)

) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8

{ id:1,

path:'/querys'

sqlStr:'select * from querys where id=?',

params:'id',//id,path

callback:" //if callback=null or callback='' then callback:"callback(error,results);"

      var err=false;

        var newResults='';

        if(!error){

          err=true;

        }else{

          newResults='new results';

        };

        callback(err,newResults)

      ",//function(error,results,callback){}

aviable:1 //if aviable>0 then you can query this path ,otherwise this is not effect

}

var db_query=require('xxg-db-query');

var mysql = require('mysql');

var mysqlConfig={};

var pool=mysql.createPool(mysqlConfig);

var queryTest=db_query(pool,'querys');

var server = http.createServer((request,response)=>{

response.setHeader('content-type', 'text/html;charset=utf-8');


var urlParse=url.parse(request.url,true,true);

var pathname=urlParse.pathname;

var p=queryTest(pathname,urlParse.query);

p.then(res=>response.end('success:'+JSON.stringify(res)));

p.catch(res=>response.end('catch:'+JSON.stringify(res)));

}).listen(3000);

http://localhost:3000/querys?id=1

http://localhost:3000/cmd/update?id=1

http://localhost:3000/cmd/delete?id=1