Mensagens de erro aprimoradas para validação de esquema no MongoDB 5.0

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "price": {
5
               "minimum": 0
6
           }
7
       }
8
   }
9
}

1
{
2
   "code": 121,
3
   "errmsg": "Document failed validation",
4
   "errInfo": {
5
       "failingDocumentId": ObjectId("5fe0eb9642c10f01eeca66a9"),
6
       "details": {
7
           "operatorName": "$jsonSchema",
8
           "schemaRulesNotSatisfied": [
9
               {
10
                   "operatorName": "properties",
11
                   "propertiesNotSatisfied": [
12
                       {
13
                           "propertyName": "price",
14
                           "details": [
15
                               {
16
                                   "operatorName": "minimum",
17
                                   "specifiedAs": {
18
                                       "minimum": 0
19
                                   },
20
                                   "reason": "comparison failed",
21
                                   "consideredValue": -2
22
                               }
23
                           ]
24
                       }
25
                   ]
26
               }
27
           ]
28
       }
29
   }
30
}

1
{
2
   "PID": "EV10010A1",
3
   "agents": [ { "name": "Ana Blake", "email": "anab@rcgk.com" } ],
4
   "description": "Spacious 2BR apartment",
5
   "localization": { "description_es": "Espacioso apartamento de 2 dormitorios" },
6
   "type": "Residential",
7
   "address": {
8
       "street1": "235 E 22nd St",
9
       "street2": "Apt 42",
10
       "city": "New York",
11
       "state": "NY",
12
       "zip": "10010"
13
   },
14
   "originalPrice": 990000,
15
   "discountedPrice": 980000,
16
   "geoLocation": [ -73.9826509, 40.737499 ],
17
   "listedDate": "Wed Dec 11 2020 10:05:10 GMT-0500 (EST)",
18
   "saleDate": "Wed Dec 21 2020 12:00:04 GMT-0500 (EST)",
19
   "saleDetails": {
20
       "price": 970000,
21
       "buyer": { "id": "24434" },
22
       "bids": [
23
           {
24
               "price": 950000,
25
               "winner": false,
26
               "bidder": {
27
                   "id": "24432",
28
                   "name": "Sam James",
29
                   "contact": { "email": "sjames@gmail.com" }
30
               }
31
           },
32
           {
33
               "price": 970000,
34
               "winner": true,
35
               "bidder": {
36
                   "id": "24434",
37
                   "name": "Joana Miles",
38
                   "contact": { "email": "jm@gmail.com" }
39
               }
40
           }
41
       ]
42
   }
43
}

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "PID": {
5
               "bsonType": "string",
6
               "pattern": "^[A-Z]{2}[0-9]{5}[A-Z]+[0-9]+$"
7
           }
8
       }
9
   }
10
}

1
{  ...
2
       "schemaRulesNotSatisfied": [
3
         {
4
           "operatorName": "properties",
5
           "propertiesNotSatisfied": [
6
             {
7
               "propertyName": "PID",
8
               "details": [
9
                 {
10
                   "operatorName": "pattern",
11
                   "specifiedAs": {
12
                     "pattern": "^[A-Z]{2}[0-9]{5}[A-Z]+[0-9]+$"
13
                   },
14
                   "reason": "regular expression did not match",
15
                   "consideredValue": "apt1"
16
                 }
17
               ]
18
             }
19
           ]
20
   ...
21
}

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "PID": {...},
5
           "localization": {
6
               "additionalProperties": false,
7
               "patternProperties": {
8
                   "^description_(es|de|fr)+$": {
9
                       "bsonType": "string"
10
                   }
11
               }
12
           }
13
       }
14
   }
15
} 

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "localization": {
5
       "description_es": "Amplio apartamento de 2 dormitorios",
6
       "description_de": "Geräumige 2-Zimmer-Wohnung",
7
   }
8
}

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "localization": {
5
       "description_cz": "Prostorný byt 2 + kk"
6
   }
7
}

1
{ ...
2
   "propertiesNotSatisfied": [
3
       {
4
           "propertyName": "localization",
5
           "details": [
6
               {
7
                   "operatorName": "additionalProperties",
8
                   "specifiedAs": {
9
                       "additionalProperties": false
10
                   },
11
                   "additionalProperties": [
12
                       "description_cz"
13
                   ]
14
               }
15
           ]
16
       }
17
   ]
18
...
19
}

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "type": {
5
               "enum": [ "Residential", "Commercial", "Industrial", "Land" ]
6
           }
7
       }
8
   }
9
}

1
{
2
   "PID": "TS10018A1", "type": "House"
3
}

1
{...
2
   "propertiesNotSatisfied": [
3
       {
4
           "propertyName": "type",
5
           "details": [
6
               {
7
                   "operatorName": "enum",
8
                   "specifiedAs": {
9
                       "enum": [
10
                           "Residential",
11
                           "Commercial",
12
                           "Industrial",
13
                           "Land"
14
                       ]
15
                   },
16
                   "reason": "value was not found in enum",
17
                   "consideredValue": "House"
18
               }
19
           ]
20
       }
21
   ]
22
...
23
}

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "agents": {
5
               "bsonType": "array",
6
               "uniqueItems": true,
7
               "maxItems": 3
8
           }
9
       }
10
   }
11
}

1
{
2
   "PID": "TS10018A1",
3
   "agents": [
4
       { "name": "Ana Blake" },
5
       { "name": "Felix Morin" },
6
       { "name": "Dilan Adams" },
7
       { "name": "Ana Blake" }
8
   ]
9
}

1
{
2
   ...
3
           "propertiesNotSatisfied": [
4
             {
5
               "propertyName": "agents",
6
               "details": [
7
                 {
8
                   "operatorName": "maxItems",
9
                   "specifiedAs": { "maxItems": 3 },
10
                   "reason": "array did not match specified length",
11
                   "consideredValue": [
12
                     { "name": "Ana Blake" },
13
                     { "name": "Felix Morin" },
14
                     { "name": "Dilan Adams" },
15
                     {  "name": "Ana Blake" }
16
                   ]
17
                 },
18
                 {
19
                   "operatorName": "uniqueItems",
20
                   "specifiedAs": { "uniqueItems": true },
21
                   "reason": "found a duplicate item",
22
                   "consideredValue": [
23
                     { "name": "Ana Blake" },
24
                     { "name": "Felix Morin" },
25
                     { "name": "Dilan Adams" },
26
                     { "name": "Ana Blake" }
27
                   ],
28
                   "duplicatedValue": { "name": "Ana Blake" }
29
                 }
30
               ]
31
             ...
32
 }

1
{
2
   "$jsonSchema": {
3
       "properties": {
4
           "agents": {
5
               "bsonType": "array",
6
               "uniqueItems": true,
7
               "maxItems": 3,
8
               "items": {
9
                   "bsonType": "object",
10
                   "required": [ "name" ],
11
                   "anyOf": [ { "required": [ "phone" ] }, { "required": [ "email" ] } ]
12
               }
13
           }
14
       }
15
   }
16
}

1
{
2
   "PID": "TS10018A1",
3
   "agents": [
4
       { "name": "Ana Blake", "email": "anab@rcgk.com" },
5
       { "name": "Felix Morin", "phone": "+12019878749" },
6
       { "name": "Dilan Adams" }
7
   ]
8
}

1
{
2
   ...
3
   "propertiesNotSatisfied": [
4
       {
5
           "propertyName": "agents",
6
           "details": [
7
               {
8
                   "operatorName": "items",
9
                   "reason": "At least one item did not match the sub-schema",
10
                   "itemIndex": 2,
11
                   "details": [
12
                       {
13
                           "operatorName": "anyOf",
14
                           "schemasNotSatisfied": [
15
                               {
16
                                   "index": 0,
17
                                   "details": [
18
                                       {
19
                                           "operatorName": "required",
20
                                           "specifiedAs": { "required": [ "phone" ] },
21
                                           "missingProperties": [ "phone" ]
22
                                       }
23
                                   ]
24
                               },
25
                               {
26
                                   "index": 1,
27
                                   "details": [
28
                                       {
29
                                           "operatorName": "required",
30
                                           "specifiedAs": { "required": [ "email" ] },
31
                                           "missingProperties": [ "email" ]
32
                                       }
33
                                   ]
34
                               }
35
                           ]
36
                       }
37
                   ]
38
               }
39
           ]
40
       }
41
   ]
42
...
43
}

1
{
2
   "$jsonSchema": {
3
       "dependencies": {
4
           "saleDate": [ "saleDetails"],
5
           "saleDetails": [ "saleDate"]
6
       }
7
   }
8
}

1
{
2
   "PID": "TS10018A1",
3
   "saleDate": Date("2020-05-01T04:00:00.000Z")
4
}

1
{ 
2
 ...
3
   "details": {
4
       "operatorName": "$jsonSchema",
5
       "schemaRulesNotSatisfied": [
6
           {
7
               "operatorName": "dependencies",
8
               "failingDependencies": [
9
                   {
10
                       "conditionalProperty": "saleDate",
11
                       "missingProperties": [ "saleDetails" ]
12
                   }
13
               ]
14
           }
15
       ]
16
   }
17
...
18
}

1
{ "operatorName": "dependencies", "failingDependencies": [...]}

1
"$jsonSchema": { "properties": { "price": { "minimum": 0 } } }

1
{ "operatorName": "properties",
2
   "propertiesNotSatisfied": [ { "propertyName": "...", "details": [] } ]
3
}

1
{
2
   "$expr": {
3
       "$lt": [ "$discountedPrice", "$originalPrice" ]
4
   },
5
   "$jsonSchema": {...}
6
}

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "saleDetails": {
5
       "bids": [
6
           {
7
               "price": 500000,
8
               "isWinner": false,
9
               "bidder": {...}
10
           },
11
           {
12
               "price": 530000,
13
               "isWinner": true,
14
               "bidder": {...}
15
           }
16
       ]
17
   }
18
}

1
{
2
   "$and": [
3
       {
4
           "$expr": {
5
               "$lte": [
6
                   {
7
                       "$size": {
8
                           "$filter": {
9
                               "input": "$saleDetails.bids.isWinner",
10
                               "cond": "$$this"
11
                           }
12
                       }
13
                   },
14
                   1
15
               ]
16
           }
17
       },
18
       {
19
           "$expr": {...}
20
       },
21
       {
22
           "$jsonSchema": {...}
23
       }
24
   ]
25
}

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "originalPrice": 600000,
5
   "discountedPrice": 550000,
6
   "saleDetails": {
7
       "bids": [
8
           { "price": 500000, "isWinner": true },
9
           { "price": 530000, "isWinner": true }
10
       ]
11
   }
12
}

1
{
2
...
3
   "details": {
4
       "operatorName": "$expr",
5
       "specifiedAs": {
6
           "$expr": {
7
               "$lte": [
8
                   {
9
                       "$size": {
10
                           "$filter": {
11
                               "input": "$saleDetails.bids.isWinner",
12
                               "cond": "$$this"
13
                           }
14
                       }
15
                   },
16
                   1
17
               ]
18
           }
19
       },
20
       "reason": "expression did not match",
21
       "expressionResult": false
22
   }
23
...
24
}

1
{
2
   "geoLocation": {
3
       "$geoWithin": {
4
           "$geometry": {
5
               "type": "Polygon",
6
               "coordinates": [
7
                   [ [ -73.91326904296874, 40.91091803848203 ],
8
                   [ -74.01626586914062, 40.75297891717686 ],
9
                   [ -74.05677795410156, 40.65563874006115 ],
10
                   [ -74.08561706542969, 40.65199222800328 ],
11
                   [ -74.14329528808594, 40.64417760251725 ],
12
                   [ -74.18724060058594, 40.643656594948524 ],
13
                   [ -74.234619140625, 40.556591288249905 ],
14
                   [ -74.26345825195312, 40.513277131087484 ],
15
                   [ -74.2510986328125, 40.49500373230525 ],
16
                   [ -73.94691467285156, 40.543026009954986 ],
17
                   [ -73.740234375, 40.589449604232975 ],
18
                   [ -73.71826171874999, 40.820045086716505 ],
19
                   [ -73.78829956054686, 40.8870435151357 ],
20
                   [ -73.91326904296874, 40.91091803848203 ] ]
21
               ]
22
           }
23
       }
24
   },
25
   "$jsonSchema": {...}
26
}

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "geoLocation": [ -73.9826509, 40.737499 ],
5
   "originalPrice": 600000,
6
   "discountedPrice": 550000,
7
   "saleDetails": {...}
8
}

1
{
2
   "PID": "TS10018A1",
3
   "type": "Residential",
4
   "geoLocation": [ -73.9826509, 80.737499 ],
5
   "originalPrice": 600000,
6
   "discountedPrice": 550000,
7
   "saleDetails": {...}
8
}

1
{
2
...
3
   "details": {
4
       "operatorName": "$geoWithin",
5
       "specifiedAs": {
6
           "geoLocation": {
7
               "$geoWithin": {...}
8
           }
9
       },
10
       "reason": "none of the considered geometries were contained within the   
11
       expression's geometry",
12
       "consideredValues": [ -73.9826509, 80.737499 ]
13
   }
14
...
15
}