node.js健壮性问题及打印错误日志

来源：互联网发布：传感器 java 编辑：程序博客网时间：2024/06/05 16:34
var moment  =  require('moment'); var express = require('express');var bodyparser = require('body-parser');var app = express();//var router = express.Router();var mysql = require('mysql');var querystring = require('querystring');var port = process.env.PORT || 8080;var domain = require('domain');var d = domain.create();app.use(bodyparser.urlencoded({    extended: true}));//本地请求跨域app.all('*', function(req, res, next) {    res.header("Access-Control-Allow-Origin", "*");    res.header("Access-Control-Allow-Headers", "X-Requested-With");    res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS");    res.header("X-Powered-By", ' 3.2.1')    res.header("Content-Type", "application/json;charset=utf-8");    next();});var mysql = require('mysql');//打印错误日志var log4js = require('log4js'); //注意log4js的module位置引用是否正确//log the cheese logger messages to a file, and the console ones as well.//通过configure()配置log4jslog4js.configure({    appenders: {        cheeseLogs: {            type: 'file',            filename: 'cheese.log'        },        console: {            type: 'console'        }    },    categories: {        cheese: {            appenders: ['cheeseLogs'],            level: 'error'        },        another: {            appenders: ['console'],            level: 'info'        },        default: {            appenders: ['console', 'cheeseLogs'],            level: 'trace'        }    }});const logger = log4js.getLogger('anotner');//应用级路由//--------------------------------------新版WIFI运营监控--------------------------------------d.on('error', function(err) {    console.log("68行" + err);});d.run(function() {    app.post("/newwifi", function(req, res) {        var connection = mysql.createConnection({            host: '10.1.0.25',            user: 'mysql',            password: 'mysql123',            port: '3306',            database: 'wifi20dw'        });        d.on('error', function(err) {            console.log("80行" + err);        });        d.run(function() {            connection.connect();        });        var begintime = moment(req.body.begintime, "MM/DD/YYYY").format('YYYY-MM-DD');        var endtime = moment(req.body.endtime, "MM/DD/YYYY").format('YYYY-MM-DD');        let getList = "select WIFINO,DATE_FORMAT(min(mindaytime),'%Y-%m-%d %T') as `MIN TIME`,DATE_FORMAT(max(maxdaytime),'%Y-%m-%d %T') as `MAX TIME` from wifi20dw.wifidaystatic where recday between '" + begintime + "' and '" + endtime + "' group by wifino";        connection.query(getList, function(err, rows, fields) {            if(err) {                logger.info("90行" + err);            }            logger.info(rows);            var a = rows;            var obj = {                data: [],                cols: []            }            var ending = false;            a.forEach(function(v, i) {                var arr = []                for(var i in v) {                    arr.push(v[i]);                    if(ending == false) {                        obj.cols.push({                            title: i                        });                    }                }                ending = true;                obj.data.push(arr);            });            res.send(obj);        });        connection.end(function(err) {            if(err) {                console.log("118行"+err);            } else {                console.log("断开连接");            }        });    });});//var newwifi = require('../../routes/newwifi');//app.use('/newwifi', newwifi);//--------------------------------------新版路由器功能监控--------------------------------------d.on('error', function(err) {    console.log(err);});d.run(function() {    app.post("/newroutermon", function(req, res) {        var connection = mysql.createConnection({            host: '10.1.0.25',            user: 'mysql',            password: 'mysql123',            port: '3306',            database: 'wifi20dw'        });        d.on('error', function(err) {            console.log("145行" + err);        });        d.run(function() {            connection.connect();        });        let getList = "select wifino,DATE_FORMAT(maxdaytime,'%Y-%m-%d %T')as maxdaytime,TIMESTAMPDIFF(DAY,now(),maxdaytime) as DIFFDAYS from wifi20dw.wifidaystatic group by wifino order by DIFFDAYS desc;";        connection.query(getList, function(err, rows, fields) {            if(err) {                logger.info(err);            }            logger.info(rows);            var a = rows;            var obj = {                data: [],                cols: []            }            var ending = false;            a.forEach(function(v, i) {                var arr = []                for(var i in v) {                    arr.push(v[i]);                    if(ending == false) {                        obj.cols.push({                            title: i                        });                    }                }                ending = true;                obj.data.push(arr);            });            res.send(obj);          });        connection.end(function(err) {            if(err) {                console.log("180行"+err);            } else {                console.log("断开连接");            }        });    });});//--------------------------------------旧版WIFI运营监控--------------------------------------d.on('error', function(err) {    console.log(err);});d.run(function() {    app.post("/oldwifi", function(req, res) {        var connection = mysql.createConnection({            host: '10.1.0.25',            user: 'mysql',            password: 'mysql123',            port: '3306',            database: 'wifi20dw'        });        d.on('error', function(err) {            console.log("203行" + err);        });        d.run(function() {            connection.connect();        });        var begintime = moment(req.body.begintime, "MM/DD/YYYY").format('YYYY-MM-DD');        var endtime = moment(req.body.endtime, "MM/DD/YYYY").format('YYYY-MM-DD');        let getList = "select WIFINO,DATE_FORMAT(min(mindaytime),'%Y-%m-%d %T') as `MIN TIME`,DATE_FORMAT(max(maxdaytime),'%Y-%m-%d %T') as `MAX TIME` from wifi20dw.wifidaystatv1 where recday between '" + begintime + "' and '" + endtime + "' group by wifino";        connection.query(getList, function(err, rows, fields) {            if(err) {                logger.info(err);            }            logger.info(rows);            var a = rows;            var obj = {                data: [],                cols: []            }            var ending = false;            a.forEach(function(v, i) {                var arr = []                for(var i in v) {                    arr.push(v[i]);                    if(ending == false) {                        obj.cols.push({                            title: i                        });                    }                }                ending = true;                obj.data.push(arr);            });            res.send(obj);           });        connection.end(function(err) {            if(err) {                console.log("242行"+err);            } else {                console.log("断开连接");            }        });    });});//--------------------------------------旧版路由器功能监控--------------------------------------d.on('error', function(err) {    console.log(err);});d.run(function() {    app.post("/oldroutermon", function(req, res) {        var connection = mysql.createConnection({            host: '10.1.0.25',            user: 'mysql',            password: 'mysql123',            port: '3306',            database: 'wifi20dw'        });        d.on('error', function(err) {            console.log("145行" + err);        });        d.run(function() {            connection.connect();        });        let getList = "select wifino,DATE_FORMAT(maxdaytime,'%Y-%m-%d %T')as maxdaytime,TIMESTAMPDIFF(DAY,now(),maxdaytime) as DIFFDAYS from wifi20dw.wifidaystatv1 group by wifino order by DIFFDAYS desc;";        connection.query(getList, function(err, rows, fields) {            if(err) {                logger.info(err);            }            logger.info(rows);            var a = rows;            var obj = {                data: [],                cols: []            }            var ending = false;            a.forEach(function(v, i) {                var arr = []                for(var i in v) {                    arr.push(v[i]);                    if(ending == false) {                        obj.cols.push({                            title: i                        });                    }                }                ending = true;                obj.data.push(arr);            });            res.send(obj);          });        connection.end(function(err) {            if(err) {                console.log("180行"+err);            } else {                console.log("断开连接");            }        });    });});//端口监听app.listen(8282);
阅读全文
0 0