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

import mysql.connector

cnx = mysql.connector.connect(
    host='commit-royalties-mysql',
    port='3306',
    database='royalty_accounting',
    user='db_user',
    password='db_pass'
)

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 ledger_deposit DROP FOREIGN KEY fk_contract_ledger_deposit;')
cursor.execute(
    'ALTER TABLE ledger_deposit DROP FOREIGN KEY fk_ledger_deposit_account;')

cursor.execute('ALTER TABLE ledger_account DROP FOREIGN KEY fk_ledger_account_account;')
cursor.execute(
    'ALTER TABLE ledger_account DROP FOREIGN KEY fk_ledger_account_contract;'
)

cursor.execute(
    """
    ALTER TABLE ledger_account_current_balance
    DROP FOREIGN KEY fk_ledger_account_current_balance_ledger_account_;
    """
)
cursor.execute(
    """
    ALTER TABLE ledger_account_current_balance
    DROP FOREIGN KEY fk_ledger_account_current_balance_account;
    """
)

cursor.execute(
    """
    ALTER TABLE ledger_account_contract
    DROP FOREIGN KEY fk_ledger_account_contract_contract;
    """
)
cursor.execute(
    """
    ALTER TABLE ledger_account_contract
    DROP FOREIGN KEY fk_ledger_account_contract_account;
    """
)

cursor.execute(
    """
    ALTER TABLE ledger_account_contract_current_balance
    DROP FOREIGN KEY fk_ledger_account_contract_current_balance_contract;
    """
)
cursor.execute(
    """
    ALTER TABLE ledger_account_contract_current_balance
    DROP FOREIGN KEY fk_ledger_account_contract_current_balance_account;
    """
)
cursor.execute(
    """
    ALTER TABLE ledger_account_contract_current_balance
    DROP FOREIGN KEY fk_ledger_account_contract_current_balance_ledger_;
    """
)

cnx.close()

print('Foreign keys were deleted from ledger tables')