"""Delete foreign keys from tables."""

import mysql.connector


def mysqlclient_docker():
    """Initialize mysql client for docker image."""
    return mysql.connector.connect(
        host='reserves-release-mysql',
        port='3306',
        database='royalty_accounting',
        user='db_user',
        password='db_pass'
    )


cnx = mysqlclient_docker()

cursor = cnx.cursor()
cursor.execute(
    'ALTER TABLE accounting_run DROP FOREIGN KEY fk_acct_run_acct_period;')
cursor.execute(
    'ALTER TABLE accounting_run DROP FOREIGN KEY fk_acc_run_run_ctrl;')
cursor.execute(
    'ALTER TABLE sales_file DROP FOREIGN KEY fk_sales_file_acct_period;')
cursor.execute(
    """ALTER TABLE accounting_period_report
    DROP FOREIGN KEY fk_accounting_period_report_acc_period;""")
cursor.execute('TRUNCATE TABLE accounting_period;')

cnx.close()

print('Foreign keys were deleted from tables')