feat(bot): bump stale tickets in the internal channel#132
Merged
Conversation
Nullskulls
requested changes
last weekJun 8, 2026
Comment on lines
+1
to
+15
| """ | ||
| Migration: add last_bumped_at to tickets | ||
| Run once: python migrate_add_last_bumped_at.py | ||
| """ | ||
| import db | ||
|
|
||
| with db.get_db() as conn: | ||
| with conn.cursor() as cur: | ||
| cur.execute( | ||
| """ | ||
| ALTER TABLE tickets | ||
| ADD COLUMN IF NOT EXISTS last_bumped_at TIMESTAMPTZ DEFAULT NULL; | ||
| """ | ||
| ) | ||
| print("Migration complete: last_bumped_at added to tickets.") |
Member
Perhaps having a migrations folder might be worthwhile Though optional
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
2 participants
This adds an automatic daily bumps for stale tickets (over 24h) in the internal channel for shipwrights tickets