[Improvement][V1] Delete all entities for a given type

[alexd6631]

In order to run automatic integration testing of an app using Orion CB, it would be useful to be able to delete all entities (for instance before installing fixtures), so the test can run in a deterministic environment.

In V1 it is not possible to delete multiple entities in a single operation

POST /v1/updateContext HTTP/1.1
Content-Type: application/json
Accept: application/json

{
    "contextElements": [
        {
            "type": "MyEntity",
            "isPattern": "true",
            "id": ".*"
        }
    ],
    "updateAction": "DELETE"
} 

Fails with

{
  "contextResponses": [
    {
      "contextElement": {
        "type": "MyEntity",
        "isPattern": "true",
        "id": ".*"
      },
      "statusCode": {
        "code": "501",
        "reasonPhrase": "Not Implemented"
      }
    }
  ]
}

[fgalan]

Thank for the feedback. We acknowledgue this issue as part of our backlog (note the "backlog" label) and eventually we will deal with it.

On the meanwhile, a workaround (easy to implement in integrated testing) is to cleanup the Orion DB entities collection before each test, e.g.;

echo 'db.entities.remove({})' | mongo orion --quiet

[fgalan]

(Semi offtopic: note that "*" is not a valid pattern as it is not a valid regex, i.e. * is a qualifier meaning "zero or more" which only makes sense when prefixed by a characters. I understand that you probably wanted to use ".*" which measn "zero or more times any character").

[jmcanterafonseca]

+1 to this feature. I would suggest adding to v2 API features

[fgalan]

+1 to this feature. I would suggest adding to v2 API features

It has been explicetly mentioned in the issue about NGSIv2 POST /v2/op/update operation (see #1715).

[fgalan]

This issue is related with #1503, which is more general about updates using id pattern for entities.

[fgalan]

The following SOF question may need update after completing this issue: http://stackoverflow.com/questions/39732799/orion-context-broker-delete-several-entities-at-one-call/39776195#39776195

[gtorodelvalle]

Definitely a +1 :)

[cdupont]

+1

[fgalan]

The following SOF question has to be updated after completing this issue: https://stackoverflow.com/questions/47889912/fiware-orion-remove-all-entities-of-the-same-type

[fgalan]

The following script can be useful to delete all entities (of a given type and/or matching a given filter) while this issue gets implemented: https://github.com/telefonicaid/fiware-orion/blob/master/scripts/utils/delete_entities.py

[cdupont]

I was wondering about the status? Thanks.

[fgalan]

No news as far as I know. The issue is waiting a brave developer to take care of it :)