Coding Period Week-4 meeting-3

Attendees

Created scancode_copyright and scancode_author table in the FOSSology database.
Copyright and author information coming from scancode scan result is inserted in these newly created tables.
Improved license data insertion in the license_file and highlight tables by inserting only unique entries based upon rf_fk, agent_fk, and pfile_fk. It solved UI glitch in license relevant text highlighting for scancode.
Latest commit having code to create tables.

Using 'S' instead of 'L' for ScanCode type field in the highlight table where 'S' will be match property of the highlight class in HighlightDao.php.
Added a new type 'S' in the HighlightDao.php also changed type from signature to match as like monk agent ScanCode matches text.
Gaurav explained about identical displayed on the UI by monk scanner as, It highlight those text which are identical with the license text in the license_ref table. Whereas license relevant text means the highlighted text has been matched with license text or rules written for the license.
So license relevant text is suitable for the ScanCode highlight.
Also Gaurav suggested to reuse the resources already present and no need to add a new type for scancode highlight, nomos type could be reused.
Sarita(Me) shows newly created tables for scancode_copyright and scancode_author. Gaurav approved changes.
Added a function in the scancode database to insert no license in the license_file table for a code zip have no license.

bool ScancodeDatabaseHandler::insertNoResultInDatabase(int agentId, long pFileId )
{
  return saveLicenseMatch(agentId, pFileId, 320, NULL);
}

Gaurav clarified that '320' is not constant licenseId for no-license. So instead leave licenseId null.
There is still a discussion needed (with other mentors) to decide is no license case is needed to take care for ScanCode or not.