Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Licenses export #1121

Open
bxf12315 opened this issue Dec 31, 2024 · 1 comment
Open

Licenses export #1121

bxf12315 opened this issue Dec 31, 2024 · 1 comment

Comments

@bxf12315
Copy link

Translate the license export functionality, which has already been implemented in version 1, to version 2.

@bxf12315
Copy link
Author

bxf12315 commented Jan 5, 2025

The license export has two parts: the first part is obtaining all licenses, and the second part is generating the license CSV file. The second part can completely reuse version1's code. The first part needs to be reconsidered.
Based on my understanding over these days, I think there are currently two possible approaches:
1 Completely reuse version1's code, which means obtaining all license information through the SBOM source file.
2 Retrieve from version2's database.
Second approach currently has two issues:
2.1 First, we need to get all packages for an SBOM [similar functionality code], then right join with cpe_license_assertion and purl_license_assertion, followed by another right join with license.
2.2 Currently, I see that version2's license does not support the LicenseRef functionality.
Problems faced with approach two:
To obtain all licenses, too many tables need to be joined and two union operations are required.
Additionally, LicenseRef support needs to be implemented.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant