Assess impact of CI Decomposition on DAST On-Demand

assess impact of !62092 (closed) and #334670 (closed) on dast on-demand scans. this may be relevant because we expresses relations between dast entities and ci entities at the database level.

summary

• uses dast_profiles_pipelines to capture which dast_profile was used to trigger a pipeline (previously used for variable delivery to pipelines)
• uses dast_scanner_profiles_builds and dast_site_profiles_pipelines to deliver dast configuration to jobs
• does not currently use dast_site_profiles_pipelines and will be dropped

schema

builds

gitlabhq_development=# \d dast_scanner_profiles_builds
 Table "public.dast_scanner_profiles_builds"
 Column | Type | Collation | Nullable | Default
-------------------------+--------+-----------+----------+---------
 dast_scanner_profile_id | bigint | | not null |
 ci_build_id | bigint | | not null |
Indexes:
 "dast_scanner_profiles_builds_pkey" PRIMARY KEY, btree (dast_scanner_profile_id, ci_build_id)
 "dast_scanner_profiles_builds_on_ci_build_id" UNIQUE, btree (ci_build_id)
Foreign-key constraints:
 "fk_5d46286ad3" FOREIGN KEY (dast_scanner_profile_id) REFERENCES dast_scanner_profiles(id) ON DELETE CASCADE
 "fk_e4c49200f8" FOREIGN KEY (ci_build_id) REFERENCES ci_builds(id) ON DELETE CASCADE

gitlabhq_development=# \d dast_site_profiles_builds
 Table "public.dast_site_profiles_builds"
 Column | Type | Collation | Nullable | Default
----------------------+--------+-----------+----------+---------
 dast_site_profile_id | bigint | | not null |
 ci_build_id | bigint | | not null |
Indexes:
 "dast_site_profiles_builds_pkey" PRIMARY KEY, btree (dast_site_profile_id, ci_build_id)
 "dast_site_profiles_builds_on_ci_build_id" UNIQUE, btree (ci_build_id)
Foreign-key constraints:
 "fk_94e80df60e" FOREIGN KEY (dast_site_profile_id) REFERENCES dast_site_profiles(id) ON DELETE CASCADE
 "fk_a325505e99" FOREIGN KEY (ci_build_id) REFERENCES ci_builds(id) ON DELETE CASCADE

pipelines

gitlabhq_development=# \d dast_profiles_pipelines
 Table "public.dast_profiles_pipelines"
 Column | Type | Collation | Nullable | Default
-----------------+--------+-----------+----------+---------
 dast_profile_id | bigint | | not null |
 ci_pipeline_id | bigint | | not null |
Indexes:
 "dast_profiles_pipelines_pkey" PRIMARY KEY, btree (dast_profile_id, ci_pipeline_id)
 "index_dast_profiles_pipelines_on_ci_pipeline_id" UNIQUE, btree (ci_pipeline_id)
Foreign-key constraints:
 "fk_a60cad829d" FOREIGN KEY (ci_pipeline_id) REFERENCES ci_pipelines(id) ON DELETE CASCADE
 "fk_cc206a8c13" FOREIGN KEY (dast_profile_id) REFERENCES dast_profiles(id) ON DELETE CASCADE

gitlabhq_development=# \d dast_site_profiles_pipelines
 Table "public.dast_site_profiles_pipelines"
 Column | Type | Collation | Nullable | Default
----------------------+--------+-----------+----------+---------
 dast_site_profile_id | bigint | | not null |
 ci_pipeline_id | bigint | | not null |
Indexes:
 "dast_site_profiles_pipelines_pkey" PRIMARY KEY, btree (dast_site_profile_id, ci_pipeline_id)
 "index_dast_site_profiles_pipelines_on_ci_pipeline_id" UNIQUE, btree (ci_pipeline_id)
Foreign-key constraints:
 "fk_53849b0ad5" FOREIGN KEY (ci_pipeline_id) REFERENCES ci_pipelines(id) ON DELETE CASCADE
 "fk_cf05cf8fe1" FOREIGN KEY (dast_site_profile_id) REFERENCES dast_site_profiles(id) ON DELETE CASCADE

notes

once !64882 (merged) is merged, only dast_site_profiles_builds and dast_scanner_profiles_builds will be relevant.