const mongoUrl = ‘mongodb://username:password@IP:27017/mongoDB’;
const MongoClient = require(‘mongodb’).MongoClient;
MongoClient.connect(mongoUrl, {useNewUrlParser: true, useUnifiedTopology: true},
async function(err, db) {
if (err) throw err;
console.log(‘Mongo connect OK!’);
const dbo = db.db(dbConfig.mongoDB);
// setInterval(function() {
transferData(db, dbo);
// }, 60000);
});
function transferData(db, dbo) {
const myDate = new Date();
const minute = myDate.getMinutes();
console.log(‘now time:’+myDate);
if (minute%1 != 0) return;
// 获取最新数据
return getNewRawData(db, dbo);
}
// 获取最新数据
function getNewRawData(db, dbo) {
let startdateStr = ‘2021-02-17 01:00:00’;
let enddateStr = ‘2021-02-17 09:10:22’;
const startDate = new Date(startdateStr);
const endDate = new Date(enddateStr);
const whereStr = {‘ts’:{‘
g
t
e
′
:
s
t
a
r
t
D
a
t
e
,
′
gte': startDate, '
gte′:startDate,′lt’: endDate}};
dbo.collection(‘XXcollection’).find(whereStr).toArray(
function(err, result) { // 返回mongo中符合条件的数据
if (err) throw err;
function logRawTmp(item, index) {
console.log(item[’_id’]);
}
result.forEach(logRawTmp);
});
}