Skip to content

Add body to finding evidence responses

What does this MR do?

This MR adds the body column to Vulnerability Finding Evidence Responses, in accordance with issue #267489.

Screenshots (strongly suggested)

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Database

Migration

== 20210512183309 AddBodyToFindingsEvidencesResponse: migrating ===============
-- add_column(:vulnerability_finding_evidence_responses, :body, :text)
   -> 0.0027s
== 20210512183309 AddBodyToFindingsEvidencesResponse: migrated (0.0027s) ======

== 20210512183310 AddLimitToFindingsEvidencesResponseBody: migrating ==========
-- transaction_open?()
   -> 0.0000s
-- current_schema()
   -> 0.0003s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nADD CONSTRAINT check_76bac0c32b\nCHECK ( char_length(body) <= 2048 )\nNOT VALID;\n")
   -> 0.0013s
-- current_schema()
   -> 0.0003s
-- execute("SET statement_timeout TO 0")
   -> 0.0005s
-- execute("ALTER TABLE vulnerability_finding_evidence_responses VALIDATE CONSTRAINT check_76bac0c32b;")
   -> 0.0010s
-- execute("RESET ALL")
   -> 0.0006s
== 20210512183310 AddLimitToFindingsEvidencesResponseBody: migrated (0.0151s) =

Rollback

== 20210512183310 AddLimitToFindingsEvidencesResponseBody: reverting ==========
-- execute("ALTER TABLE vulnerability_finding_evidence_responses\nDROP CONSTRAINT IF EXISTS check_76bac0c32b\n")
   -> 0.0015s
== 20210512183310 AddLimitToFindingsEvidencesResponseBody: reverted (0.0110s) =

== 20210512183309 AddBodyToFindingsEvidencesResponse: reverting ===============
-- remove_column(:vulnerability_finding_evidence_responses, :body)
   -> 0.0026s
== 20210512183309 AddBodyToFindingsEvidencesResponse: reverted (0.0027s) ======

Related to #267489

Edited by Jonathan Schafer

Merge request reports