DAST On-Demand Add uniqueness constraint to DastSiteToken#url
problem
in !67933 (merged) we added an application-level uniqueness constraint on to facilitate token reuse by url
. however we may have existing duplicate tokens in the database and race conditions could result in duplicates being created.
proposal
- prevent new duplicates being added (eg. at application level)
- add a data migration to remove existing duplicates
- add a migration that adds a composite index (
project_id
,url
)
Edited by Marcos Rocha