From d28e393c134e12e131a26740ef99cb76278ef907 Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Wed, 24 Jan 2018 14:38:38 +0800
Subject: [PATCH] updated
---
create_minutely_data.js | 15 ++++++---------
1 files changed, 6 insertions(+), 9 deletions(-)
diff --git a/create_minutely_data.js b/create_minutely_data.js
index fa8149f..fdfb3db 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-11';
-var end_date = '2018-01-03';
+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++) {
@@ -48,12 +50,7 @@
time: moment(moment(start, 'YYYY-MM-DD HH:mm:00').valueOf() + 8*60*60*1000).toDate()
};
}
- devices[mac][key] = val;
-
- if(devices[mac]["ext"] == null) {
- devices[mac]["ext"] = {};
- }
- devices[mac]["ext"][key] = [data.min_val, data.max_val]
+ devices[mac][key] = [val, data.min_val, data.max_val];
});
var device_data = [];
--
Gitblit v1.8.0