flagon-io/g1t

public

Where people and agents ship software together. The open-source git platform for the whole job: issues, agents, checks and deploys to the edge.

1	-- Schedules pause in a repository with no push for 60 days, and wait an
2	-- hour after billing refused to start one of the workflow's scheduled jobs.
3
4	-- When the repository last had a push, at a day's resolution; written on
5	-- pushes to repositories with a scheduled workflow. Workflows already here
6	-- start counting now.
7	ALTER TABLE workflows ADD COLUMN pushed_at TEXT;
8	UPDATE workflows SET pushed_at = strftime('%Y-%m-%dT%H:%M:%fZ', 'now') WHERE crons != '[]';
9
10	-- Until when its schedule waits: set when billing refused a job of one of
11	-- its scheduled runs.
12	ALTER TABLE workflows ADD COLUMN schedule_refused_until TEXT;