August 21, 2019
MongoDB - Commands (document database)
show dbs
use myDB
show collections
db.createCollection("users")
db.users.drop()
Insert Documents
db.users.insertOne({ name: "Alice", age: 30 });
db.users.insertMany([
{ name: "Bob", age: 25 },
{ name: "Charlie", age: 35 }
]);
Find (Read Data)
db.users.find();
db.users.find({ age: { $gt: 25 } });
db.users.find({ name: "Alice", age: 30 });
db.users.find({}, { name: 1, _id: 0 });
db.users.find().sort({ age: -1 });
db.users.find().limit(5);
Update Documents
db.users.updateOne({ name: "Alice" }, { $set: { age: 31 } });
db.users.updateMany({ age: { $lt: 30 } }, { $set: { status: "young" } });
db.users.replaceOne({ name: "Alice" }, { name: "Alicia", age: 32 });
Delete Documents
db.users.deleteOne({ name: "Alice" });
db.users.deleteMany({ age: { $lt: 25 } });
Aggregation
db.users.aggregate([
{ $group: { _id: "$age", count: { $sum: 1 } } }
]);
db.users.aggregate([
{ $match: { age: { $gt: 25 } } },
{ $project: { name: 1, age: 1 } }
]);
Comparison Operators
$eq, $ne, $gt, $gte, $lt, $lte, $in, $nin
db.users.find({ age: { $gte: 25, $lte: 35 } });
Logical Operators
$and, $or, $not
db.users.find({ $and: [{age: {$gt: 25}}, {status: "active"}] });
Array Operators
db.users.find({ tags: { $in: ["admin"] } });
db.users.find({ tags: ["admin", "user"] });
db.users.find({ tags: { $size: 2 } });
db.users.updateOne({ name: "Alice" }, { $push: { tags: "newbie" } });
Indexes
db.users.createIndex({ name: 1 });
db.users.dropIndex({ name: 1 });
db.users.getIndexes();
March 4, 2019
RPA Tool evaluation
If you want to evaluate the RPA tool then below things need to be consider
- Pricing
- Type of application can automate
- Ease of use
- Maintenance and support of BOT
- Deployment of Bot and Code synch
- Security
- scalability (number of bots can deploy)
- Vendor experience and use cases
- Time require to develop a BOT
- Number of resources available in the market