Skip to content

Instantly share code, notes, and snippets.

@am-MongoDB
Last active July 16, 2019 14:58
Show Gist options
  • Save am-MongoDB/094aa61c65a62579a0f255356a98054f to your computer and use it in GitHub Desktop.
Save am-MongoDB/094aa61c65a62579a0f255356a98054f to your computer and use it in GitHub Desktop.
{"collections": [
{
"_comment": "Customer collection",
"customerID": 123456,
"name": {
"title": "Mr",
"first": "Andrew",
"last": "Morgan"
},
"_passwordComment": "No need for user credentials as will use Google auth",
"session": {
"currentSessionId": null,
"sessionExpiryTime": null,
"lastLoggedIn": "Tue Jul 16 2019 11:25:45 GMT+0100 (British Summer Time)"
},
"salesTaxExempt": false,
"contact": {
"email": "[email protected]",
"phone": {
"home": "+4452563783620",
"work": "+443734953453",
"mobile": "+44273647372"
},
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"postalCode": "SE1 8DJ",
"Country": "UK"
}
},
"storedPaymentMethods": [
{
"type": "Visa",
"Card number": "726198269113113",
"expiryMonth": [10, 2022]
},
{
"type": "PayPal",
"email": "[email protected]"
}
],
"marketingPreferences": ["email-offers"],
"shoppingBasket": {
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
},
{
"productId": 7654321,
"productName": "Tile Pro",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/71fnwsWDPsL._SL1500_.jpg",
"price": 29.99,
"quantity": 4
}
],
"totalPrice": {
"listPrice": 140.95,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 131.95
},
"currency": "GBP"
},
"recentOrders": {
"_comment": "the 10 most recent orders",
"overFlowOrders": true,
"orderlist": [
{
"orderId": 66666,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 66666,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 63834,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 36492,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 36489,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 82632,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 23452,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 34252,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 23456,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
},
{
"orderId": 352534,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
}
]
},
"wishLists": [
{
"listName": "Birthday",
"products": [
{
"_comment": "Using reference and not storing the details here as a product could be here for months and so the product details may change",
"productID": 123456,
"quantity": 3
}
]
}
],
"recommendedProducts": [
{
"productID": 9482367,
"productName": "Car-washing sponge",
"image": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/41Nvb6OejBL.jpg"
}
]
},
{
"_comment": "deliveries collection",
"deliveries": [
{
"orderId": 66666,
"status": "Out for delivery",
"deliveryDate": "Wed Jul 17 2019 10:25:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"quantity": 1
}
],
"courier": {
"courierId": 888888,
"trackingID": "JKDJ7267273"
}
}
]
},
{
"_comment": "products collection",
"productID": 1234567,
"productName": "Amazon Echo Dot",
"stockLevel": 412,
"price": {
"currency": "GBP",
"value": 39.99,
"salesTaxApplicable": false
},
"supplierID": 77777,
"description": "Our most popular Echo is now even better. With a new speaker and design, Echo Dot is a voice-controlled smart speaker with Alexa that's perfect for any room. Just ask for music, news, information and more. You can also call almost anyone, and control compatible smart home devices with your voice.",
"productImages": [
"https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg"
],
"reviews": {
"averageReviewScore": 4.5,
"numberOfReviews": 574,
"overflowReviews": true,
"recentReviews": [
{
"stars": 4,
"headline": "Nice",
"reviewText": "Sounds great, would have been 5 stars except Alexa refuses to wash my car.",
"reviewImages": [
"https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/Dirty_car_-_Alamy_trans_NvBQzQNjv4BqNvLtDx75wZSR0MSb26ou_28nGi5dnbzU1Uvp1fqu20E.jpg",
"https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg"
],
"comments": [
{
"commenter": "Andrew Morgan",
"commenterID": 123456,
"commentText": "I had the same problem"
}
]
}
]
},
"category": "Smart speakers",
"categoryHierarchy": [
"Smart speakers",
"Connected home",
"electronics"
],
"attributes": {
"_comment": "Can use a wildcard index here",
"color": ["charcoal", "grey"],
"manufacturer": "Amazon",
"features": ["voice control", "volume controls", "speaker", "microphone"],
"services": ["Amazon Alexa", "Spotify", "BBC", "Hue"],
"specs": {
"dimensions": [43, 99, 99],
"weight": 300
}
},
"relatedProducts": [
{
"productID": 738352,
"productName": "Philips Hue Ambiance E27 Bulb",
"image": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61wGj2ptZbL._SL1500_.jpg"
},
{
"productID": 9482367,
"productName": "Car-washing sponge",
"image": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/41Nvb6OejBL.jpg"
}
],
"usersWaiting": [
123456,
62371,
273711
]
},
{
"_comment": "discountCodes collection",
"name": "fish10",
"applicableProducts": [1234567, 727191, 883722],
"amount": {
"currency": "GBP",
"value": 10,
"expires": "Mon Aug 26 2019 00:00:00 GMT+0100 (British Summer Time)"
}
},
{
"_comment": "orderOverlow collection",
"customerId": 123456,
"order": {
"orderId": 721681,
"status": "Delivered",
"deliveryDate": "Wed Jul 10 2019 8:12:45 GMT+0100 (British Summer Time)",
"deliveryAddress": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"Country": "UK"
},
"currency": "GBP",
"totalPrice": {
"listPrice": 49.99,
"discountCodes": "fish10",
"delivery": 1,
"finalPrice": 40.99
},
"items": [
{
"productId": 1234567,
"productName": "Amazon Echo Dot",
"thumbnail": "https://clusterdb-product-images.s3-eu-west-1.amazonaws.com/61u48FEs0rL._SL1000_.jpg",
"price": 49.99,
"currency": "GBP",
"quantity": 1
}
]
}
},
{
"_comment": "reviewOverlow collection",
"productID": 1234567,
"stars": 5,
"headline": "Luv it!",
"reviewText": "She's my new BFF",
"reviewImages": [],
"comments": []
},
{
"_comment": "courier collection",
"courierId": 888888,
"name": "Barry's Burger Van",
"contact": {
"email": "[email protected]",
"phone": {
"home": "+445258373620",
"work": "+443732323453",
"mobile": "+443677747372"
},
"address": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"postalCode": "SE1 8DJ",
"Country": "UK"
},
"website": "https://barrysburgers.co.uk"
}
},
{
"_comment": "supplier collection",
"supplierID": 77777,
"name": "Amazon",
"contact": {
"email": "[email protected]",
"phone": {
"home": "+445258373620",
"work": "+443732323453",
"mobile": "+443677747372"
},
"address": {
"number": "16",
"street": "Hatfields",
"city": "London",
"state": "London",
"postalCode": "SE1 8DJ",
"Country": "UK"
},
"website": "https://barrysburgers.co.uk"
}
},
{
"_comment": "sales tax collection",
"name": "UK",
"salesTaxIncluded": true,
"salesTax": 0.2,
"stateTaxes": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment