forked from PrattJena/Instacart_Project_CSCI_620
-
Notifications
You must be signed in to change notification settings - Fork 0
/
MongoCreation.txt
58 lines (56 loc) · 1.17 KB
/
MongoCreation.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
db.createCollection("Products",
{validator:{
"$and": [
{"$jsonSchema": {
required: [ "_id", "name" ],
properties: {
name: {bsonType: "string"},
aisle: {bsonType: "string"},
department: {bsonType: "string"}
}
}
}
]
}
});
db.createCollection("Users",
{validator:{
"$and": [
{"$jsonSchema": {
required: [ "_id", "user_name" ],
properties: {
user_name: {bsonType: "string"},
address: {bsonType: "string"},
city: {bsonType: "string"},
state: {bsonType: "string"},
pincode: {bsonType: "int",
minimum: 0
},
user_email: {bsonType: "string"}
}
}
}
]
}
});
db.createCollection("Orders",
{validator:{
"$and": [
{"$jsonSchema": {
required: [ "_id", "user_id", "products" ],
properties: {
user_id: {bsonType: "int",
minimum: 0
},
order_number: {bsonType: "int",
minimum: 0
},
datetime: {bsonType: "object"},
days_since_prior_order: {bsonType: "int"},
products: {bsonType: "array"}
}
}
}
]
}
});