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

import os

import mysql.connector

cnx = mysql.connector.connect(
    host=os.environ.get('MYSQL_DB_HOST', '127.0.0.1'),
    port=os.environ.get('MYSQL_DB_PORT', '6053'),
    database=os.environ.get('MYSQL_DB_NAME', 'royalty_accounting'),
    user=os.environ.get('MYSQL_DB_USER', 'royalties'),
    password=os.environ.get('MYSQL_DB_PASS', '1234'),
)

fks = [
    """ALTER TABLE ledger_account
    DROP FOREIGN KEY fk_ledger_account_account;""",
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_abacus_event_ledger;""",
    """ALTER TABLE ledger_account_current_balance
    DROP FOREIGN KEY fk_ledger_account_current_balance_account;""",
    """ALTER TABLE ledger_deposit
    DROP FOREIGN KEY fk_abacus_event_ledger_deposit;""",
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_contract_ledger;""",
    """ALTER TABLE ledger_account
    DROP FOREIGN KEY fk_ledger_account_abacus_event;""",
    """ALTER TABLE account_payee
    DROP FOREIGN KEY fk_account_payee_account;""",
    """ALTER TABLE ledger_deposit
    DROP FOREIGN KEY fk_ledger_deposit_account;""",
    """ALTER TABLE contract_exclusion
    DROP FOREIGN KEY fk_contract_exclusion_contract;""",
    """ALTER TABLE ledger_deposit
    DROP FOREIGN KEY fk_contract_ledger_deposit;""",
    """ALTER TABLE contract_term
    DROP FOREIGN KEY fk_contract_term_contract;""",
    """ALTER TABLE ledger_account
    DROP FOREIGN KEY fk_ledger_account_contract;""",
    """ALTER TABLE run_controller_contract
    DROP FOREIGN KEY fk_run_controller_contract_contract;""",
    """ALTER TABLE ledger_account_current_balance
    DROP FOREIGN KEY fk_ledger_account_current_balance_ledger_account_;""",
    """ALTER TABLE accounting_run
    DROP FOREIGN KEY fk_acc_run_run_ctrl;""",
    """ALTER TABLE account_payment_term
    DROP FOREIGN KEY fk_account_payment_term_account_id;""",
    """ALTER TABLE legacy_contract
    DROP FOREIGN KEY fk_legacy_contract_contract;""",
    """ALTER TABLE account_contract
    DROP FOREIGN KEY fk_account_contract_account_id;""",
    """ALTER TABLE account_contract
    DROP FOREIGN KEY fk_account_contract_contract_id;""",
    """ALTER TABLE account_tax_info
    DROP FOREIGN KEY fk_account_tax_info_account_id;""",
    """ALTER TABLE payment_group_payment_account
    DROP FOREIGN KEY fk_group_account_account;""",
    """ALTER TABLE ledger_accounting_run_vat
    DROP FOREIGN KEY fk_ledger_accounting_run_vat_event;""",
    """ALTER TABLE ledger_accounting_run_vat
    DROP FOREIGN KEY fk_ledger_accounting_run_vat_contract;""",
    """ALTER TABLE ledger_accounting_run_vat
    DROP FOREIGN KEY fk_ledger_accounting_run_vat_acc_run;""",
    """ALTER TABLE accounting_period
    DROP FOREIGN KEY fk_statement_period_acct_period;""",
    """ALTER TABLE statement_attachment
    DROP FOREIGN KEY fk_statement_attachment_account;""",
    """ALTER TABLE payment_hold
    DROP FOREIGN KEY fk_account_payment_hold;""",
    """ALTER TABLE payment_hold_history
    DROP FOREIGN KEY fk_account_payment_hold_history;""",
    """ALTER TABLE account_payment_term_history
    DROP FOREIGN KEY fk_account_payment_term_history_account;""",
    """ALTER TABLE account_payment_term_history
    DROP FOREIGN KEY fk_account_payment_term_history_payment_term_id;""",
    """ALTER TABLE payment_hold_history
    DROP FOREIGN KEY fk_payment_hold_payment_hold_history;""",
    """ALTER TABLE account_tax_info_history
    DROP FOREIGN KEY fk_account_tax_info_history_account;""",
    """ALTER TABLE ledger_reserve_taken
    DROP FOREIGN KEY fk_ledger_reserve_taken_statement_period_id;""",
    """ALTER TABLE account_tax_info_history
    DROP FOREIGN KEY fk_account_tax_info_id;""",
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_accounting_run_ledger;""",
    """ALTER TABLE ledger_adjustment_applied
    DROP FOREIGN KEY fk_ledger_adjustment_applied_ledger_adjustment;""",
    """ALTER TABLE abacus_event
    DROP FOREIGN KEY fk_abacus_event_statement_period;""",
    """ALTER TABLE ledger_contract_advance_applied
    DROP FOREIGN KEY fk_statement_period_contract_advance_applied;""",
    """ALTER TABLE ledger_contract_advance_applied
    DROP FOREIGN KEY fk_contract_advance_contract_advance_applied;""",
    """ALTER TABLE ledger_contract_advance_applied
    DROP FOREIGN KEY fk_abacus_event_contract_advance_applied;""",
    """ALTER TABLE ledger_contract_advance_applied
    DROP FOREIGN KEY fk_account_contract_advance_applied;""",
    """ALTER TABLE ledger_contract_advance_applied
    DROP FOREIGN KEY fk_contract_contract_advance_applied;""",
    """ALTER TABLE ledger_reserve_release_schedule
    DROP FOREIGN KEY fk_release_schedule_statement_period_taken;""",
    """ALTER TABLE ledger_reserve_release_schedule
    DROP FOREIGN KEY fk_release_schedule_statement_period_release;""",
    """ALTER TABLE ledger_adjustment_applied
    DROP FOREIGN KEY fk_ledger_adjustment_applied_statement_period;""",
    """ALTER TABLE ledger_adjustment
    DROP FOREIGN KEY fk_ledger_adjustment_activity_statement_period;""",
    """ALTER TABLE ledger_adjustment
    DROP FOREIGN KEY fk_ledger_adjustment_applied_to_statement_period;""",
    """ALTER TABLE ledger_adjustment
    DROP FOREIGN KEY fk_ledger_adjustment_reference_adjustment_type;""",
    """ALTER TABLE ledger_adjustment_detail_applied
    DROP FOREIGN KEY
    fk_ledger_adjustment_detail_applied_ledger_adjustment_detail_id;""",
]

cursor = cnx.cursor()
for i in fks:
    cursor.execute(i)
cnx.close()