Skip to content

Add database columns for 7+30+60 day PAT expiry notification

What does this MR do and why?

Add database columns for 7+30+60 day PAT expiry notification

Part 1 of 3, this adds db columns to use for 7, 30, and 60 day notifications for expiring access tokens. The end goal is to replace the existing boolean expire_notification_delivered column with the new datetime *_notification_sent_at columns.

The next two MRs will backfill data for the new columns, then make use of them in new workers for handling expiring token notifications.

Broken out from !163818 (closed)

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

  1. Run migrations
  2. Check for column existence on rails console: PersonalAccessToken.last.seven_days_notification_sent_at # should be nil

Related to #464040 (closed)

Merge request reports

Loading