Skip to content

Implement API endpoint to cancel database triggers #500

Description

@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

Activity

  1. Kalra-V commented on Oct 25, 2025

    @Kalra-V
    Contributor

    Hey Nivedit, can I pick up this issue?

  2. NiveditJain commented on Oct 25, 2025

    @NiveditJain
    Member

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

  3. Brijesh-Thakkar commented on Dec 1, 2025

    @Brijesh-Thakkar
    Contributor

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

  4. Kalra-V commented on Dec 1, 2025

    @Kalra-V
    Contributor

    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

  5. Brijesh-Thakkar commented on Dec 1, 2025

    @Brijesh-Thakkar
    Contributor

    @Kalra-V okayy!!
    Thanks for informing

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions