From faee6ac6ffe07e430dcd40d6a2127c17b8295f1b Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Mon, 08 Jan 2018 21:59:43 +0800
Subject: [PATCH] updated
---
create_data.js | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/create_data.js b/create_data.js
index ae8d104..bf83636 100644
--- a/create_data.js
+++ b/create_data.js
@@ -30,7 +30,10 @@
var sql = "SELECT mac, mac_key, avg(mac_value) as avg_val, min(mac_value) as min_val, max(mac_value) as max_val FROM history WHERE time >= '" + start + "' AND time < '" + end + "' GROUP BY mac, mac_key ORDER BY mac";
//console.log(sql);
mysqlClient.query(sql, function (error, results, fields) {
- if (error) throw error;
+ if (error) {
+ console.log("error1: " + error.message);
+ return;
+ }
//console.log(start + " : " + end);
@@ -70,7 +73,10 @@
var connection = mysql.createConnection(config.mysql);
connection.query("INSERT INTO data (mac, time, json) VALUES ?", [data], function (error, results, fields) {
- if (error) throw error;
+ if (error) {
+ console.log("error2: " + error.message);
+ return;
+ }
connection.destroy();
});
--
Gitblit v1.8.0