namespace CollabDAL.Query.CollabEvent;

public static class CollabEventQB
{
    public const string INSERT_EVENT = @"
        INSERT INTO collab.CollabSessionEvent
               (SessionId, EventType, TriggeredBy, Payload, EventDate, DatabaseName)
        VALUES (@SessionId, @EventType, @TriggeredBy, @Payload, GETUTCDATE(), @DatabaseName)";

    // Index: IX_CollabEvent_Session_Date
    public const string GET_RECENT_EVENTS = @"
        SELECT TOP 20
               e.EventId, e.SessionId, e.EventType,
               e.TriggeredBy, e.Payload, e.EventDate,
               e.DatabaseName
        FROM   collab.CollabSessionEvent e
        WHERE  e.SessionId    = @SessionId
        AND    e.DatabaseName = @DatabaseName
        ORDER BY e.EventDate DESC";
}