public static void copySpreadsheetToSPDXAnalysis(SPDXSpreadsheet ss, SPDXDocument analysis)
throws SpreadsheetException, InvalidSPDXAnalysisException {
analysis.createSpdxAnalysis(
ss.getPackageInfoSheet().getPackageInfo(1).getUrl() + "#SPDXANALYSIS");
copyOrigins(ss.getOriginsSheet(), analysis);
analysis.createSpdxPackage();
copyNonStdLicenses(ss.getNonStandardLicensesSheet(), analysis);
// note - non std licenses must be added first so that the text is available
copyPackageInfo(ss.getPackageInfoSheet(), analysis.getSpdxPackage());
copyPerFileInfo(ss.getPerFileSheet(), analysis.getSpdxPackage());
copyReviewerInfo(ss.getReviewersSheet(), analysis);
}
private static void copyNonStdLicenses(
NonStandardLicensesSheet nonStandardLicensesSheet, SPDXDocument analysis)
throws InvalidSPDXAnalysisException {
int numNonStdLicenses = nonStandardLicensesSheet.getNumDataRows();
int firstRow = nonStandardLicensesSheet.getFirstDataRow();
SPDXNonStandardLicense[] nonStdLicenses = new SPDXNonStandardLicense[numNonStdLicenses];
for (int i = 0; i < nonStdLicenses.length; i++) {
nonStdLicenses[i] =
new SPDXNonStandardLicense(
nonStandardLicensesSheet.getIdentifier(firstRow + i),
nonStandardLicensesSheet.getExtractedText(firstRow + i));
}
analysis.setExtractedLicenseInfos(nonStdLicenses);
}
private static void copyReviewerInfo(ReviewersSheet reviewersSheet, SPDXDocument analysis)
throws InvalidSPDXAnalysisException {
int numReviewers = reviewersSheet.getNumDataRows();
int firstRow = reviewersSheet.getFirstDataRow();
SPDXReview[] reviewers = new SPDXReview[numReviewers];
for (int i = 0; i < reviewers.length; i++) {
reviewers[i] =
new SPDXReview(
reviewersSheet.getReviewer(firstRow + i),
format.format(reviewersSheet.getReviewerTimestamp(firstRow + i)),
reviewersSheet.getReviewerComment(firstRow + i));
}
analysis.setReviewers(reviewers);
}
private static void copyOrigins(OriginsSheet originsSheet, SPDXDocument analysis)
throws InvalidSPDXAnalysisException {
Date createdDate = originsSheet.getCreated();
String created = format.format(createdDate);
String[] createdBys = originsSheet.getCreatedBy();
String creatorComment = originsSheet.getAuthorComments();
SPDXCreatorInformation creator =
new SPDXCreatorInformation(createdBys, created, creatorComment);
String specVersion = originsSheet.getSPDXVersion();
analysis.setSpdxVersion(specVersion);
String dataLicenseId = originsSheet.getDataLicense();
if (dataLicenseId == null
|| dataLicenseId.isEmpty()
|| dataLicenseId.equals(RdfToSpreadsheet.NOT_SUPPORTED_STRING)) {
if (specVersion.equals(SPDXDocument.ONE_DOT_ZERO_SPDX_VERSION)) {
dataLicenseId = SpdxRdfConstants.SPDX_DATA_LICENSE_ID_VERSION_1_0;
} else {
dataLicenseId = SpdxRdfConstants.SPDX_DATA_LICENSE_ID;
}
}
SPDXStandardLicense dataLicense = null;
try {
dataLicense =
(SPDXStandardLicense) SPDXLicenseInfoFactory.parseSPDXLicenseString(dataLicenseId);
} catch (Exception ex) {
try {
dataLicense =
(SPDXStandardLicense)
SPDXLicenseInfoFactory.parseSPDXLicenseString(
SpdxRdfConstants.SPDX_DATA_LICENSE_ID);
} catch (InvalidLicenseStringException e) {
throw (new InvalidSPDXAnalysisException("Unable to get document license"));
}
}
analysis.setDataLicense(dataLicense);
analysis.setCreationInfo(creator);
}
/** @param args */
public static void main(String[] args) {
if (args.length < MIN_ARGS) {
usage();
return;
}
if (args.length > MAX_ARGS) {
usage();
return;
}
File spdxSpreadsheetFile = new File(args[0]);
if (!spdxSpreadsheetFile.exists()) {
System.out.printf("Spreadsheet file %1$s does not exists.\n", args[0]);
return;
}
File spdxRdfFile = new File(args[1]);
if (spdxRdfFile.exists()) {
System.out.printf("Error: File %1$s already exists - please specify a new file.\n", args[1]);
return;
}
try {
if (!spdxRdfFile.createNewFile()) {
System.out.println("Could not create the new SPDX RDF file " + args[1]);
usage();
return;
}
} catch (IOException e1) {
System.out.println("Could not create the new SPDX RDF file " + args[1]);
System.out.println("due to error " + e1.getMessage());
usage();
return;
}
FileOutputStream out;
try {
out = new FileOutputStream(spdxRdfFile);
} catch (FileNotFoundException e1) {
System.out.println("Could not write to the new SPDX RDF file " + args[1]);
System.out.println("due to error " + e1.getMessage());
usage();
return;
}
Model model = ModelFactory.createDefaultModel();
SPDXDocument analysis = null;
try {
analysis = new SPDXDocument(model);
} catch (InvalidSPDXAnalysisException ex) {
System.out.print("Error creating SPDX Analysis: " + ex.getMessage());
return;
}
SPDXSpreadsheet ss = null;
try {
ss = new SPDXSpreadsheet(spdxSpreadsheetFile, false, true);
copySpreadsheetToSPDXAnalysis(ss, analysis);
ArrayList<String> verify = analysis.verify();
if (verify.size() > 0) {
System.out.println(
"Warning: The following verification errors were found in the resultant SPDX Document:");
for (int i = 0; i < verify.size(); i++) {
System.out.println("\t" + verify.get(i));
}
}
model.write(out, "RDF/XML-ABBREV");
} catch (SpreadsheetException e) {
System.out.println("Error creating or writing to spreadsheet: " + e.getMessage());
} catch (InvalidSPDXAnalysisException e) {
System.out.println("Error translating the RDF file: " + e.getMessage());
} finally {
if (ss != null) {
try {
ss.close();
} catch (SpreadsheetException e) {
System.out.println("Error closing spreadsheet: " + e.getMessage());
}
}
if (out != null) {
try {
out.close();
} catch (IOException e) {
System.out.println("Error closing RDF file: " + e.getMessage());
}
}
}
}
/**