Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db.createCollection("Company2",{"validator":
- {$jsonschema:
- {"bsonType":"object",
- "properties":{"_id":{"bsonType":"string"},
- "Company":{"$bsonType":"object",
- "description":"Company data",
- "required":["cname","city","street","bldg","budget"],
- "properties":{"cname":{"bsonType":"string"},
- "city":{"bsonType":"string"},
- "street":{"bsonType":"string"},
- "bldg":{"bsonType":"int"},
- "minimum":1,
- "maximum":499,
- "budget":{"bsonType":"double"},
- "minimum":1,
- "Department":{"bsonType":"array",
- "depts":{"bsonType":"object",
- "required":["dname","floor","enumber"],
- "properties":{"dname":{"bsonType":"string"},
- "floor":{"bsonType":"int"},
- "Employee":{"bsonType":"array"},
- "emps":{"bsonType":"object",
- "required":["enumber","first_name","last_name","date_of_birth","salary"],
- "properties":{"enumber":{"bsonType":"int"},
- "first_name":{"bsonType":"string"},
- "last_name":{"bsonType":"string"},
- "date_of_birth":{"bsonType":"string"},
- "positon":{"bsonType":"string"},
- "salary":{"bsonType":"double"},
- "minimum":1,
- }
- }
- }
- }
- }
- }
- }
- }
- }}});
- // passes validation
- db.Company2.insert({"_id":"Big Business",
- "Company":{"cname":"Big Business",
- "city":"Sydney",
- "street":"123 fake st",
- "bldg":NumberInt(200),
- "budget":"500"
- "Departments":[{"dname":"Sales",
- "floor":NumberInt(2),
- "Employees":[{"enumber":01,
- "first_name":"James",
- "last_name":"Smith",
- "date_of_birth":"20/01/1990",
- "Positon":"Manager",
- "salary":10000
- }]
- }]
- }
- });
- //fails
- db.Company2.insert({"_id":"Big Business",
- "Company":{"cname":"Big Business",
- "city":"Sydney",
- "street":"153 fake st",
- "bldg":NumberInt(600),
- "budget":"200"
- "Departments":[{"dname":"Marketing",
- "floor":NumberInt(2),
- "Employees":[{"enumber":02,
- "first_name":"Max",
- "last_name":"Payne",
- "date_of_birth":"25/03/1987",
- "Positon":"Manager",
- "salary":170000
- }]
- }]
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement