| | |
| | | |
| | | mysqlClient.connect(function(error) { |
| | | if (error) return; |
| | | console.log("connected to MySQL"); |
| | | //console.log("connected to MySQL"); |
| | | }); |
| | | |
| | | |
| | | 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++) { |
| | | var date = moment(start_date).add(i, "days"); |