Schema validation en MongoDB con JSON Schema

Schema validation en MongoDB con JSON Schema | Nicolás Garzón

mongosh

JavaScript

db.createCollection('orders', {
  validator: {
    $jsonSchema: {
      bsonType: 'object',
      required: [
        '_id',
        'businessId',
        'items',
        'status',
        'total',
        'createdAt'
      ],
      properties: {
        _id: {
          bsonType: 'objectId'
        },
        businessId: {
          bsonType: 'objectId'
        },
        status: {
          enum: ['draft', 'pending', 'confirmed', 'cancelled']
        },
        total: {
          bsonType: 'decimal'
        },
        createdAt: {
          bsonType: 'date'
        },
        items: {
          bsonType: 'array',
          minItems: 1,
          items: {
            bsonType: 'object',
            required: [
              'productId',
              'nameAtPurchase',
              'quantity',
              'unitPrice'
            ],
            properties: {
              productId: {
                bsonType: 'objectId'
              },
              nameAtPurchase: {
                bsonType: 'string'
              },
              quantity: {
                bsonType: 'int',
                minimum: 1
              },
              unitPrice: {
                bsonType: 'decimal'
              }
            }
          }
        }
      }
    }
  },
  validationLevel: 'strict',
  validationAction: 'error'
});

JavaScript

validator: {
  $and: [
    {
      $jsonSchema: {
        bsonType: 'object',
        required: ['total'],
        properties: {
          total: { bsonType: 'decimal' }
        }
      }
    },
    {
      $expr: {
        $gte: ['$total', Decimal128('0')]
      }
    }
  ]
}

JavaScript

db.runCommand({
  collMod: 'orders',
  validator: {
    $jsonSchema: {
      bsonType: 'object',
      required: ['businessId', 'status'],
      properties: {
        businessId: { bsonType: 'objectId' },
        status: {
          enum: ['draft', 'pending', 'confirmed', 'cancelled']
        }
      }
    }
  },
  validationLevel: 'moderate',
  validationAction: 'warn'
});

JavaScript

db.orders.aggregate([
  {
    $project: {
      statusType: { $type: '$status' },
      totalType: { $type: '$total' }
    }
  },
  {
    $group: {
      _id: {
        statusType: '$statusType',
        totalType: '$totalType'
      },
      count: { $sum: 1 }
    }
  }
]);