-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmongoUtil.js
123 lines (111 loc) · 3.88 KB
/
mongoUtil.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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
const MongoClient = require("mongodb").MongoClient;
const url = "mongodb://localhost:27017/session1db";
let collectionName = "testCollection";
let dbInstance;
let connectDB = (cb)=>{
MongoClient.connect(url, (err, db)=>{
if(err) return cb(err, 'Error');
console.log('DB connected!');
dbInstance = db;
cb(null, 'DB Connected!');
});
};
let insertDB = (data)=>{
db.collection.insertOne(data,(err)=>{
if(err) console.log(err);
});
};
let getData = (data, cb)=>{
let queryData = data.split('&');
let userName = queryData[0].split('=')[1];
let Id = queryData[1].split('=')[1];
let query = '{"name" : "'+userName+'", "id" : "'+Id+'"}';
query = JSON.parse(query);
let dbCollection = dbInstance.collection(collectionName);
dbCollection.find(query).toArray((err, res)=>{
if(err) return cb(err, 'Error');
cb(null, res);
});
// MongoClient.connect(url, (err, db)=>{
// if(err) return console.log(err);
// console.log('DB connected!');
// let dbCollection = db.collection(collectionName);
// dbCollection.find(query).toArray((err, res)=>{
// if(err) return cb(err, 'Error');
// db.close();
// cb(null, res);
// });
// });
};
let insertData = (data, cb)=>{
let dbCollection = dbInstance.collection(collectionName);
dbCollection.insert(data,(err, res)=>{
if(err) return cb(err, 'Error');
cb(null, res);
});
// MongoClient.connect(url,(err, db)=>{
// if(err) return console.log(err);
// console.log('DB connected!');
// let dbCollection = db.collection(collectionName);
// dbCollection.insert(data,(err, res)=>{
// if(err) return cb(err, 'Error');
// db.close();
// cb(null, res);
// });
// });
};
let updateData = (id, name, cb)=>{
let dbCollection = dbInstance.collection(collectionName);
let selector = '{"id" : "'+id+'"}';
selector = JSON.parse(selector);
let newValue = '{"name" : "'+name+'", "id" : "'+id+'"}';
newValue = JSON.parse(newValue);
let multi = JSON.parse('{"multi" : "true"}');
dbCollection.update(selector,newValue,multi, (err, res)=>{
if(err) return cb(err, 'Error');
cb(null, res);
});
// MongoClient.connect(url,(err, db)=>{
// if(err) return console.log(err);
// console.log('DB connected!');
// let dbCollection = db.collection(collectionName);
// let selector = '{"id" : "'+id+'"}';
// selector = JSON.parse(selector);
// let newValue = '{"name" : "'+name+'", "id" : "'+id+'"}';
// newValue = JSON.parse(newValue);
// let multi = JSON.parse('{"multi" : "true"}');
// dbCollection.update(selector,newValue,multi, (err, res)=>{
// if(err) return cb(err, 'Error');
// db.close();
// cb(null, res);
// });
// });
};
let deleteData = (id, cb) => {
let dbCollection = dbInstance.collection(collectionName);
let selector = '{"id" : "'+id+'"}';
selector = JSON.parse(selector);
dbCollection.deleteMany(selector, (err, res)=>{
if(err) return cb(err, 'Error');
cb(null, res);
});
// MongoClient.connect(url, (err, db)=>{
// if(err) return console.log(err);
// console.log('DB connected!');
// let dbCollection = db.collection(collectionName);
// let selector = '{"id" : "'+id+'"}';
// selector = JSON.parse(selector);
// dbCollection.deleteMany(selector, (err, res)=>{
// if(err) return cb(err, 'Error');
// db.close();
// cb(null, res);
// });
// });
};
module.exports.mongoUtil = {
connectDB,
insertData,
getData,
updateData,
deleteData
};