-
Notifications
You must be signed in to change notification settings - Fork 0
/
DAO.js
104 lines (75 loc) · 2.06 KB
/
DAO.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
//mongod --port 27017 --dbpath=./data
var mongo = require('mongoskin');
var MongoClient = mongo.MongoClient;
var db = MongoClient.connect('mongodb://localhost:27017/test');
var DAO = {};
DAO.quickFind = function quickFind(targetCollection, query, callback) {
db.collection(targetCollection).find(query).toArray(function(err, docs) {
if (err) {
throw err;
}
callback(docs);
db.close();
});
}
DAO.quickInsert = function quickInsert(targetCollection, query, doc, callback) {
db.collection(targetCollection).update(query, doc, function(err) {
if (err) {
throw err;
}
callback();
db.close();
});
}
module.exports = DAO
function query(db, targetCollection, query, fields) {
db.collection(targetCollection).find(query, fields).toArray(function(err, docs) {
if (err) {
throw err;
}
console.log(docs);
db.close();
});
}
function insert(db, targetCollection, doc) {
db.collection(targetCollection).c(doc, {
w: 1
}, function(err, data) {
if (err) {
throw err;
}
console.log(JSON.stringify(doc))
db.close();
});
}
function update(db, targetCollection, query, newData) {
db.collection(targetCollection).update(query, newData, function(err) {
if (err) {
throw err;
}
db.close();
});
}
function remove(db, targetCollection, query) {
db.collection(targetCollection).remove(query, function(err) {
if (err) {
throw err;
}
db.close();
});
}
function count(db, targetCollection, query) {
db.collection(targetCollection).count(query, function(err, count) {
if (err) {
throw err;
}
console.log(count);
db.close();
});
}
function aggregate(db, targetCollection, pipelines) {
db.collection(targetCollection).aggregate(pipelines).toArray(function(err, result) {
console.log(result[0].avg.toFixed(2));
db.close();
});
}