[EDIT] FILE: .dbshell
use KoolDerby use KoolDerby db.users.find().pretty(); show collections; show databases; use KoolDerby db.users.find().count(); show dbs use KoolDerby use KoolDerby db.classes.find().preety() show dbs use Koolderby db.classes.find().pretty() db.classes.find() db.collections() db.collections use KoolDerby db.classes.find() db.classes.find().pretty() db.classes.find({contents}).find().pretty() db.classes.find({"segments.title":"WorkShop")) db.classes.find({"segments.title":"WorkShop"}) db.classes.find({"segments.title":"WorkShop"}).pretty() db.classes.find({"segments.title":"Pre-WorkShop"}).pretty() db.classes.find({"segments.title":"Pre-WorkShop"},{"segments.$":1}).pretty() db.classes.find({"segments.title":"Pre-WorkShop"},{"segments.title":1}).pretty() use KoolDerby db.classes.find().pretty(); db.classes.find({className:/pmt/i}).pretty(); db.classes.find({className:/project ma/i}).pretty(); db.classes.find({className:/project ma/i}).count(); db.classes.find(Objectid("5fec1e5fb454ec0faaa03868")).count(); db.classes.find(ObjectId("5fec1e5fb454ec0faaa03868")).count(); db.classes.find(ObjectId("5fec1e5fb454ec0faaa03868")).pretty(); db.classes.find( {_id:ObjectId("5fec1e5fb454ec0faaa03868")}).forEach(function(elem,i) { if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ if(seg.title.contains("WorkShop")){ eval(printjson(seg.title)); seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find( {_id:ObjectId("5fec1e5fb454ec0faaa03868")}).forEach(function(elem,i) { eval(printjson(elem.className)); if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ if(seg.title.contains("WorkShop")){ eval(printjson(seg.title)); seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find(ObjectId("5fec1e5fb454ec0faaa03868")).forEach(function(elem,i) { eval(printjson(elem.className)); if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ if(seg.title.contains("WorkShop")){ eval(printjson(seg.title)); seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find({className:/project management/i}).pretty(); db.classes.find({className:/project management/i}).count(); db.classes.find( {className:/project management/i}).forEach(function(elem,i) { eval(printjson(elem.className)); if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ if(seg.title.contains("WorkShop")){ eval(printjson(seg.title)); seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find( {className:/project management/i}).forEach(function(elem,i) { eval(printjson(elem.className)); if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ if(seg.title.includes("WorkShop")){ eval(printjson(seg.title)); seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find( {className:/project management/i}).forEach(function(elem,i) { if(elem.segments && elem.segments.length > 0){ elem.segments.forEach(function(seg, i){ eval(printjson(seg.title)); if(seg.title.includes("WorkShop")){ seg.title = seg.title.replace("WorkShop","Workshop"); eval(printjson(seg.title)); } }); db.classes.save(elem); } }); db.classes.find({className:/project management/i}).pretty(); use KoolDerby db.classes.find({className:/project management/i}).pretty(); use KoolDerby db.classes.find({className:/project management/i}).pretty(); use KoolDerby db.classes.find({className:/project management/i}).pretty(); show databases; use KoolDerby show collections; db.classes.find().pretty(); use KoolDerby db.classes.find({parentItemId:{$exists:false}}).count(); use KoolDerby db.classes.find().pretty(); show databases; use KoolDerby show collections; db.users.find().pretty(); use KoolDerby db.users.updateMany({},{$set:{isActive :true}}); db.users.find().pretty(); use KoolDerby show collections db.classes.find({},{"sections"}).pretty(); db.classes.find({},{"sections":1}).pretty(); db.classes.find({}).pretty(); pwd use KoolDerby db.classes.find({}).pretty(); show collections; db.classes.find({title:/pm essen/i}).pretty(); db.classes.find({title:/pmessen/i}).pretty(); db.classes.find({className:/pmessen/i}).pretty(); db.classes.find({className:/pm essen/i}).pretty(); db.classes.find({className:/pme/i}).pretty(); db.classes.find({className:/pme/i}).count(); db.classes.find({className:/pme/i,categories:{$ne:[]}}).count(); db.classes.find({className:/pme/i,categories:{$ne:[]}}).pretty(); db.classes.find({className:/pme/i},{className:1, status:1, schedules:1, categories:1}).pretty(); db.classes.find({className:/pme/i},{className:1, status:1, schedules:1, categories:1,sections:1}).pretty(); db.classes.find({className:/pme/i},{className:1, status:1, schedules:1, categories:1,segments:1}).pretty(); db.classes.find({className:/pme/i},{className:1, status:1, schedules:1, categories:1,sections:1}).pretty(); db.classes.find({className:/pme/i},{className:1, status:1, schedules:1, categories:1,"segments.sections":1}).pretty(); use KoolDerby db.studentclasses.find().count(); db.studentclasses.remove({}); show collections; db.quizhistories.find().pretty(); show collections; db.quizhistories.find().count(); db.quizhistories.remove({}); use KoolDerby db.studentclasses.find().pretty(); db.studentclasses.find().count(); db.studentclasses.remove({}); show dbs use KoolDerby show collections db.payments.find().pretty() db.payments.remove({}) db.payments.find().pretty() show databases; use KoolDerby; show collections; db.users.find().pretty(); show dbs use KoolDerby show collections show dbs; show dbs; use KoolDerby; show collections; db.classes.find(); show collections; show dbs;
SAVE
CANCEL