Implement API endpoint to cancel database triggers

[coderabbitai]

Description

Add a dedicated API endpoint to cancel pending/triggering database triggers and set their expires_at field for cleanup.

Context

The TriggerStatusEnum includes a CANCELLED status, but there is currently no code path that sets triggers to this status or assigns an expires_at timestamp for cancelled triggers. This capability should be implemented via a new API endpoint.

Requirements

• Implement API endpoint to cancel triggers
• Add mark_as_cancelled() function (similar to mark_as_failed and mark_as_triggered) to update trigger status to CANCELLED and set expires_at
• Ensure TTL-based cleanup applies to cancelled triggers (already configured in the index)

References

• Related PR: feat: add TTL-based cleanup strategy for DatabaseTriggers collection #464
• Discussion: feat: add TTL-based cleanup strategy for DatabaseTriggers collection #464 (comment)
• Requested by: @NiveditJain

[Kalra-V]

Hey Nivedit, can I pick up this issue?

[NiveditJain]

@Kalra-V yes please. Feel free to take this up.

[Brijesh-Thakkar]

@Kalra-V are u still working on it??
if not @NiveditJain then please assign it to me, i am ready to work on it

[Kalra-V]

Hey @Brijesh-Thakkar, I've raised a PR for this issue and it has been reviewed by @NiveditJain as well - I'm sure he'll merge whenever he gets a chance and this issue will be closed

[Brijesh-Thakkar]

@Kalra-V okayy!!
Thanks for informing