# SCPP DB Auditor

This is a script to audit the SCPP DB based on an list of verified SCPP ID's from SCPP.

It requires an Excel (.xlsx) file which contains worksheets consisting of SCPPID's and ISRC's. in separate columns

## Usage
1. Setup environment in your preferred way, and pip install requirements.
1. Copy .env.shadow to .env
1. Edit .env to provide the appropriate values
1. Run the script.

## `.env` Values
### SCPP_AUDIT_FILE
This is the location and file name of the verified SCPP ID list Excel file.

## Data Structures

### Input
The script expects an Excel .XLSX file with data separated into 2 columns:
* The first column being SCPPID's
* The second column being ISRC's

This data can be spread over as many worksheets as possible, as long as they 
are all in the same workbook. 

The script (currently) does not support CSV files.

## Output - [WIP]

full_audit_dict
* **scpp_ids_with_dupe_isrc** - *All SCPPID's that are assigned to more than one ISRC*
  * [ List of ISRC's ]
<br/><br/>

* **isrcs_with_dupe_scpp_id** - *ALL ISRC's that are assigned to more than one SCPPID*
  * [ List of SCPPID's ] 
<br/><br/>

* **deduped_file_scpp_id_list** - *Unique list of SCPPID's*
  * [ List of SCPPID's ]
<br/><br/>

* **deduped_file_isrc_list** -  *Unique list of ISRC's*
  * [ List of ISRC's ] 
<br/><br/>

* **verified_file_scpp_ids** - *List of all SCPPID's in the input file*
  * [  ]
<br/><br/>

* **verified_file_isrcs** - *List of all ISRC's in the input file*
<br/><br/>

* **db_item_count** - *Number of SCPPID's in the DB*
<br/><br/>