From f0610ab8711aaa2a4eab1e0249cbf4f46225dbb4 Mon Sep 17 00:00:00 2001
From: 沈斌 <bluelazysb@hotmail.com>
Date: Mon, 08 Jan 2018 16:48:54 +0800
Subject: [PATCH] updated
---
create_hourly_data.js | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/create_hourly_data.js b/create_hourly_data.js
index 5df6052..eed5e7b 100644
--- a/create_hourly_data.js
+++ b/create_hourly_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-02';
+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-02';
+
+console.log(moment().format('YYYY-MM-DD HH:mm:ss') + " => sync hourly data from " + start_date + " to " + end_date);
var days = moment(end_date).diff(moment(start_date), 'days');
for (var i = 0; i <= days; i++) {
@@ -41,6 +43,7 @@
var val = data.mac_value;
if(devices[mac] == null) {
devices[mac] = {
+ mac: mac,
time: moment(moment(start, 'YYYY-MM-DD HH:00:00').valueOf() + 8*60*60*1000).toDate()
};
}
--
Gitblit v1.8.0