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