function SelectDB(table,query,fields) { return new Promise(function(resolve,reject){ if (client.isConnected()) { client.db(dbName).collection(table).find(query).project(fields).toArray(function(err,res){ if (err) { reject(err); }else{ resolve(res); } }); }else{ reject("Not Connected!"); } }); }
MongoClient.connect(dbUrl, function (err, dbs) { if (err) throw err; const db = dbs.db('webstore2'); db.collection('products') // .find({ name: /^Super/ }) .find() .project({name: 1, price: 1}) .sort({price: -1}) .toArray(function (err, res) { if (err) throw err; console.log(res); dbs.close(); }) console.log("Database created!"); });
MongoClient.connect(config.mongodbUri, {useNewUrlParser: true}, (err, client) => { assert.equal(null, err); const db = client.db('test'); let contestCount = 0; db.collection('contests').find({}).each((err, contest) => { assert.equal(null, err); if (!contest) { return; } contestCount++; db.collection('names') .find({ id: { $in: contest.nameIds }}) .project({ _id: 1 }) .toArray() .then(_ids => { const newIds = _ids.map(o => o._id); db.collection('contests').updateOne( { id: contest.id }, { $set: { nameIds: newIds } } ).then(() => { console.info('Updated', contest._id); contestCount--; if (contestCount === 0) { client.close(); } }); }) .catch(console.error); }); });
MongoClient.connect(dbUrl, function (err, con) { if (err) throw err; const db = con.db('webstore2'); db.collection('products') .updateOne({ name: 'Super Keyboard' }, { $set: { price: 125.3 } }) .then(res => { console.log(res); db.collection('products') .find({ name: /^Super/ }) .project({ name: 1, price: 1 }) .sort({ price: 1 }) .toArray(function (err, res) { if (err) throw err; console.log(res); }); }).catch(err => { console.log("Error: Update unsuccessfull.") }).finally(() => { con.close(); }) });
MongoClient.connect(dbUrl, function (err, dbs) { if (err) throw err; const db = dbs.db('myblog9'); db.collection('posts') .find({ title: /React/ }) // .find() .limit(3) .project({title: 1, authors: 1}) .sort({author: 1}) .toArray(function (err, res) { if (err) throw err; console.log(res); dbs.close(); }) console.log("Database created!"); });
client.connect(function (err) { if (err == null) { console.log("Connection Success!"); /* console.log("Lets Close After 4 seconds"); setTimeout(() => { client.close(function (err) { if (err == null) { console.log("Disconnection Success!"); } else { console.log(err); } }); }, 4000); */ client.db(dbName).collection("users").find({}).project({}).toArray(function(err,res){ if (err) { console.log("Selection Error! " + err); }else{ console.log(JSON.stringify(res)); } }); } else { console.log("Connection Error! " + err); } });
function SelectDB(table,query,fields) { return new Promise(function(resolve,reject){ if (client.isConnected()) { client.db(dbName).collection(table).find(query).project(fields).toArray(function(err,res){ if (err) { reject(err); }else{ resolve(res); } }); }else{ reject("Not Connected!"); } }); }
function SelectDB(table,query,fields) { return new Promise(function(resolve,reject){ if (client.isConnected()) { client.db(dbName).collection(table).find(query).project(fields).toArray(function(err,res){ if (err) { reject(err); }else{ resolve(res); } }); }else{ reject("Not Connected!"); } }); }