Create numeric cves - Githubissues

canonical / ubuntu-com-security-api

The API for CVEs and USNs data.

16 stars 9 forks source link

Create numeric cves #169

Closed samhotep closed 1 month ago

samhotep commented 1 month ago

Done

Added a new column numerical_ids to the cves table
Added a flask cli command to update numerical_ids for each cve
Added cves field to /security/notices
- i.e /security/notices?cves=<cve-id>,<cve-id2>
Updated details field by removing cve_ids from details search

QA

Check out this feature branch
Run the site using the command ./run serve
After running the site locally, and migrations pass, update the new column with values using
```
flask insert_numerical_cve_ids
```
View the site locally in your web browser at: http://0.0.0.0:8030/
Run through the following QA steps
Make a request to /security/notices?cves=<cve-id>,<cve-id2> and confirm that the result has notices that include the specified cve-ids

Fixes