mirror of
https://github.com/tiennm99/goclaw.git
synced 2026-09-10 00:17:37 +00:00
viettranx
24717b0f51
Extract wake_heartbeat and stateless from JSON payload into first-class columns on cron_jobs. Adds migration 000033 with backfill from existing payload data. Updates PG + SQLite stores, RPC handlers, and UI i18n.
16 lines
774 B
SQL
16 lines
774 B
SQL
ALTER TABLE cron_jobs ADD COLUMN stateless BOOLEAN NOT NULL DEFAULT false;
|
|
ALTER TABLE cron_jobs ADD COLUMN deliver BOOLEAN NOT NULL DEFAULT false;
|
|
ALTER TABLE cron_jobs ADD COLUMN deliver_channel TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE cron_jobs ADD COLUMN deliver_to TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE cron_jobs ADD COLUMN wake_heartbeat BOOLEAN NOT NULL DEFAULT false;
|
|
|
|
UPDATE cron_jobs SET
|
|
deliver = COALESCE((payload->>'deliver')::boolean, false),
|
|
deliver_channel = COALESCE(payload->>'channel', ''),
|
|
deliver_to = COALESCE(payload->>'to', ''),
|
|
wake_heartbeat = COALESCE((payload->>'wake_heartbeat')::boolean, false)
|
|
WHERE payload IS NOT NULL;
|
|
|
|
UPDATE cron_jobs SET payload = payload - 'deliver' - 'channel' - 'to' - 'wake_heartbeat'
|
|
WHERE payload IS NOT NULL;
|