List of Common Queries - SCCapstone/EZBag GitHub Wiki

• Create

db.product.insertMany([
{ _id: "9d8f57s56776d7", barcode: “1295783859843”, barcodeType: “ean13”, name: “apples”, price: 1.99, description: “produce”, businessID: 1, time:  19748736847 },
{ _id: "97f57s8646s45a", barcode: “3948689743743”, barcodeType: “ean13”, name: “steak”, price: 10.99, description: “meat”, businessID: 2, time: 349879728743 },
{ _id: "3jh5k24546k6n3", barcode: “2947849385445”, barcodeType: “ean13”, name: “oreos”, price: 3.99, description: “cookies”, businessID: 2, time: 478373846384 }
]);

db.product.insertOne(
{ _id: "3jh5k24546k6n3", barcode: “2947849385445”, barcodeType: “ean13”, name: “oreos”, price: 3.99, description: “cookies”, businessID: 2, time: 478373846384 }
);

• Read

db.cart.find(
{ _id: “9d8f57s56776d7” },
{ time: “129472478”, total: 10.54 }
); 

• Update

db.info.updateOne(
{ _id: “9d8f57s56776d7” },
{ $set: { phone: “7845291093”} }
);

• Delete

db.info.deleteMany([
{ _id: “9d8f57s56776d7”, email: “[email protected]”, phone: 8513271443, time: 028492839 },
{ _id: “97f57s8646s45a”, email: “[email protected]”, phone: 8724351234, time: 129472478 },
{ _id: “3jh5k24546k6n3”, email: “[email protected]” , phone: 3057618882, time: 376857393 }
]);

db.info.deleteOne([
{ _id: “9d8f57s56776d7”, email: “[email protected]”, phone: 8513271443, time: 028492839 }
]);

• Search

db.product.find(
{ barcode: “1295783859843” }
);

db.product.find(
{ name: /.*"apple".*/ }
);

Create and Update will need to join tables.