Backend Database about sbom-in-a-box HOT 3 CLOSED

Finishing up for the day, all API endpoints now work with the backend and files are persistently stored in the database. However, MySQL's size limit on strings either truncates the file contents (as seen below) or throws an error.

The way around this is to possibly declare the field as a BLOB instead of a string? I will need to do further research. Once this is taken care of, the endpoints will fully work as intended and all that's left is fixing the API unit tests.

from sbom-in-a-box.

Unit tests completed in 0359b6e

from sbom-in-a-box.

Finishing up for the day, all API endpoints now work with the backend and files are persistently stored in the database. However, MySQL's size limit on strings either truncates the file contents (as seen below) or throws an error.

The way around this is to possibly declare the field as a BLOB instead of a string? I will need to do further research. Once this is taken care of, the endpoints will fully work as intended and all that's left is fixing the API unit tests.

Fixed in 376da0a by changing the attribute type of contents to LONGTEXT (about 4GB of text worth)

from sbom-in-a-box.