From e95ed70d69c32e2e3892486f7c3365919b14adec Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Mon, 08 Jan 2018 21:29:29 +0800
Subject: [PATCH] updated
---
create_minutely_data.js | 16 +++++++++-------
1 files changed, 9 insertions(+), 7 deletions(-)
diff --git a/create_minutely_data.js b/create_minutely_data.js
index de315ec..4d8be93 100644
--- a/create_minutely_data.js
+++ b/create_minutely_data.js
@@ -7,12 +7,14 @@
mysqlClient.connect(function(error) {
if (error) return;
- console.log("connected to MySQL");
+ //console.log("connected to MySQL");
});
-var start_date = '2017-11-12';
-var end_date = '2017-11-12';
+var start_date = moment().add(-1, 'days').format('YYYY-MM-DD');//'2017-11-11';
+var end_date = moment().add(-1, 'days').format('YYYY-MM-DD');//'2018-01-03';
+
+console.log(moment().format('YYYY-MM-DD HH:mm:ss') + " => sync minutely data from " + start_date + " to " + end_date);
var days = moment(end_date).diff(moment(start_date), 'days');
for (var i = 0; i <= days; i++) {
@@ -22,7 +24,7 @@
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);
+ //console.log(start + " : " + end);
fetchDeviceMinutelyData(start, end);
}
@@ -50,10 +52,10 @@
}
devices[mac][key] = val;
- if(devices[mac]["wave"] == null) {
- devices[mac]["wave"] = {};
+ if(devices[mac]["ext"] == null) {
+ devices[mac]["ext"] = {};
}
- devices[mac]["wave"][key] = [data.min_val, data.max_val]
+ devices[mac]["ext"][key] = [data.min_val, data.max_val]
});
var device_data = [];
--
Gitblit v1.8.0