5758e603e8
* TP-51013 | incident_jira entity, repo and service * TP-51013 | get jira status api * TP-51013 | added db migration file * TP-51013 | added migration query to migrate existing jira links into new table * TP-51013 | removing linked_jira_issues column from incident table * TP-51013 | removing empty jira fields if no response found for a jira key in jira api response * TP-51013 | handled jira api failure cases, will return empty jira fields * TP-51013 | removed linked_jira_issues field from incident entity * TP-51013 | handled jira link addition and removal in slack action * TP-51013 | resolving PR comments * TP-51013 | adding jira link max length check
19 lines
574 B
SQL
19 lines
574 B
SQL
CREATE TABLE if not exists incident_jira (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
created_at timestamp with time zone,
|
|
incident_id bigint REFERENCES incident(id),
|
|
jira_link TEXT
|
|
);
|
|
|
|
-- Migrate existing jira links -------------------------------------------------------
|
|
|
|
INSERT INTO incident_jira (incident_id, jira_link, created_at)
|
|
SELECT incident_id, jira_link, now()
|
|
FROM (SELECT id AS incident_id, unnest(jira_links) AS jira_link
|
|
FROM incident
|
|
WHERE jira_links IS NOT NULL
|
|
AND array_length(jira_links, 1) > 0) AS subquery
|
|
WHERE jira_link <> '';
|
|
|
|
|