How to handle database locking

[markwylde]

I feel like locking won't be implemented until later on in the project, but a potential solution could be this:

{
  "name": "orders",

  "schema": {
    "productId": ["required", "number"],
    "customerId": ["required", "number"],
    "timestamp": ["required", "number"]
  },

  "hooks": {
    "POST": {
      "before": [
        "collection('products').get(body.productId).lock()"
      ],
      "after": [
        "collection('products').get(body.productId).pluck('stock').subtract(1)"
      ],
      "finally": [
        "collection('products').get(body.productId).unlock()"
      ]
    }
  }
}