From 8b91c89338f54b1d22a5864edcf56ebfd85c4dc8 Mon Sep 17 00:00:00 2001 From: 沈斌 <bluelazysb@hotmail.com> Date: Mon, 08 Jan 2018 16:55:43 +0800 Subject: [PATCH] updated --- create_data.js | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/create_data.js b/create_data.js index 10ac6b3..c30bb27 100644 --- a/create_data.js +++ b/create_data.js @@ -18,7 +18,6 @@ for(var k = 0; k < 60; k++) { var start = moment(date_hour).add(k, 'minutes').format("YYYY-MM-DD HH:mm:00"); var end = moment(date_hour).add(k+1, 'minutes').format("YYYY-MM-DD HH:mm:00"); - //console.log(start + " : " + end); fetchDeviceMinutelyData(start, end); } @@ -32,6 +31,8 @@ //console.log(sql); connection.query(sql, function (error, results, fields) { if (error) throw error; + + //console.log(start + " : " + end); results.forEach(function(data) { var mac = data.mac; @@ -55,8 +56,6 @@ if(device_data.length > 0) { insertDeviceData(device_data, connection); } - - connection.release(); }); }); } @@ -75,5 +74,7 @@ connection.query(sql, function (error, results, fields) { if (error) throw error; + + connection.release(); }); } \ No newline at end of file -- Gitblit v1.8.0