Delete bulk subscriptions using script

[ArqamFarooqui110719]

Bug description
I have thousands of subscription created in my orion setup.
Is there any script available, using which I can delete all subscriptions using IDs.

If not, shouldn't we have a script (python/shell) which can delete multiple subscription on single click.

[fgalan]

Maybe this can be useful:

https://github.com/telefonicaid/fiware-orion/blob/master/scripts/utils/delete_entities_by_list.py
https://github.com/telefonicaid/fiware-orion/blob/master/scripts/utils/delete_entities_by_query.py

I think the code is pretty straightforward, but if you some doubt, just ask it :)

[fgalan]

Ah, sorry... those scripts are for entities and you are asking for subscriptions

I think we don't have such script. Maybe a delete_subscriptions.py script (based on the previous ones) could be useful. It would be an interesting contribution :)

[ArqamFarooqui110719]

Ah, sorry... those scripts are for entities and you are asking for subscriptions

Yes, for subscriptions:)

I think we don't have such script. Maybe a delete_subscriptions.py script (based on the previous ones) could be useful. It would be an interesting contribution :)

Yes, I am looking into it.

[ArqamFarooqui110719]

Before starting, I want to confirm few point:

1. Currently we are able to delete subscriptions one by one using subscription ID.
2. So, for deleting the subscriptions in bulk, we need to collect the subscriptions IDs of each subscription (may be, in any variable)
3. then process delete operation for each subscription one by one.

@fgalan, Please confirm above steps. And if you have any suggestion please let me know.

[fgalan]

That's correct!

I'd suggest to implement the script in Python, with his the tooling language that we use in this repository.

Regarding step 2, to collect subscription IDs, the GET /v2/subscriptions operation has to be used. Note that you could have a large number of subscription, so you should use the pagination options, as delete_entities_by_query.py does. Details of the API operation can be found at https://github.com/telefonicaid/fiware-orion/blob/master/doc/manuals/orion-api.md#list-subscriptions-get-v2subscriptions

Finally, as an extra feature of your script it would be interesting to include filtering capabilities, based in the JSON of each subscription obtained. For instance, delete subscription which match a given description, etc.

[ArqamFarooqui110719]

PR #4626

[fgalan]

Now that PR #4626 has been merged, should this issue be closed?

[ArqamFarooqui110719]

Yes. Closed as completed.