"""
Accounting Run ISRC Allocation.

Validate that all tracks in accountingflat.dig_sales_detail have an ISRC.
In the case where a track does not already have an ISRC,
one will be provisioned.

"""

from dotenv import load_dotenv
import MySQLdb

load_dotenv()

from royalties import config  # noqa E402
from royalties.isrc import allocate_track_isrc  # noqa E402
from royalties.isrc import get_track_id_list  # noqa E402


def isrc_validation():
    """ISRC validation."""
    db = MySQLdb.connect(**config.ar_read_write_config)
    cursor = db.cursor()
    for item in get_track_id_list(cursor):
        allocate_track_isrc(cursor, item[0])
    db.commit()
    cursor.close()
    db.close()


if __name__ == '__main__':
    isrc_validation()