Skip to content

Write an SQL query to identify any overlapping vc_events #154

@dudeofawesome

Description

@dudeofawesome
  • Should identify events whose connection_start and connection_end intervals overlap
  • Should look at vc_events per user & guild. (vc_events contains events from multiple users, not just a single user, but multiple users could reasonably have overlapping events.
    • This could either look at all users in a single query, or just a single user in a single query.
  • Should ideally return a list of overlapping events, but a count of overlapping events would also be good.
  • Should be optionally timeboxed to prevent looking at very old events (maybe default to looking at events newer than guild.last_reset).

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or requestp2Priority 2 (Medium)

    Type

    No type

    Projects

    Status

    🔖 Ready

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions