"""Drop foreign keys in db."""

import os

import mysql.connector

cnx = mysql.connector.connect(
    host=os.environ.get('MYSQL_HOST', '127.0.0.1'),
    port=os.environ.get('MYSQL_PORT', '6500'),
    database=os.environ.get('MYSQL_DB', 'royalty_accounting'),
    user=os.environ.get('MYSQL_USER', 'royalties'),
    password=os.environ.get('MYSQL_PASS', '1234'))

cursor = cnx.cursor()
cursor.execute(
    """ALTER TABLE statement_attachment
    DROP FOREIGN KEY fk_statement_attachment_statement_period;""")

cursor.execute(
    """ALTER TABLE account_contract
    DROP FOREIGN KEY fk_account_contract_account_id;""")

cursor.execute(
    """ALTER TABLE contract
    DROP FOREIGN KEY fk_contract_reference_signing_entity;""")

cursor.execute(
    """ALTER TABLE account_payment_term
    DROP FOREIGN KEY fk_account_payment_term_account_id;""")

cursor.execute(
    """ALTER TABLE account_payee
    DROP FOREIGN KEY fk_account_payee_account;""")

cursor.execute(
    """ALTER TABLE account_tax_info
    DROP FOREIGN KEY fk_account_tax_info_account_id;""")

cursor.execute(
    """ALTER TABLE payment_group_payment_account
    DROP FOREIGN KEY fk_group_account_account;""")

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

cursor.execute(
    """ALTER TABLE statement_attachment
    DROP FOREIGN KEY fk_statement_attachment_account;""")

cursor.execute(
    """ALTER TABLE abacus_event
    DROP FOREIGN KEY fk_abacus_event_statement_period;""")

cursor.execute(
    """ALTER TABLE accounting_period
    DROP FOREIGN KEY fk_statement_period_acct_period;""")

cursor.execute(
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_abacus_event_ledger;""")

cursor.execute(
    """ALTER TABLE accounting_run
    DROP FOREIGN KEY fk_acc_run_run_ctrl;""")

cursor.execute(
    """ALTER TABLE contract_template
    DROP FOREIGN KEY fk_contract_template_run_controller;""")

cursor.execute(
    """ALTER TABLE run_controller_contract
    DROP FOREIGN KEY fk_run_controller_contract_run_controller;""")

cursor.execute(
    """ALTER TABLE accounting_period_report
    DROP FOREIGN KEY fk_accounting_period_report_acc_period;""")

cursor.execute(
    """ALTER TABLE accounting_run
    DROP FOREIGN KEY fk_acct_run_acct_period;""")

cursor.execute(
    """ALTER TABLE sales_file
    DROP FOREIGN KEY fk_sales_file_acct_period;""")

cursor.execute(
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_accounting_run_ledger;""")

cursor.execute(
    """ALTER TABLE ledger_accounting_run_vat
    DROP FOREIGN KEY fk_ledger_accounting_run_vat_acc_run;""")

cursor.execute(
    """ALTER TABLE account_contract
    DROP FOREIGN KEY fk_account_contract_contract_id;""")

cursor.execute(
    """ALTER TABLE contract_exclusion
    DROP FOREIGN KEY fk_contract_exclusion_contract;""")

cursor.execute(
    """ALTER TABLE ledger_accounting_run_balance
    DROP FOREIGN KEY fk_contract_ledger;""")

cursor.execute(
    """ALTER TABLE contract_term
    DROP FOREIGN KEY fk_contract_term_contract;""")

cursor.execute(
    """ALTER TABLE ledger_accounting_run_vat
    DROP FOREIGN KEY fk_ledger_accounting_run_vat_contract;""")

cursor.execute(
    """ALTER TABLE run_controller_contract
    DROP FOREIGN KEY fk_run_controller_contract_contract;""")

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

cursor.execute(
    """ALTER TABLE payment_hold
    DROP FOREIGN KEY fk_account_payment_hold;""")

cursor.execute(
    """ALTER TABLE payment_hold_history
    DROP FOREIGN KEY fk_account_payment_hold_history;""")

cursor.execute(
    """ALTER TABLE account_payment_term_history
    DROP FOREIGN KEY fk_account_payment_term_history_account;""")

cursor.execute(
    """ALTER TABLE account_payment_term_history
    DROP FOREIGN KEY fk_account_payment_term_history_payment_term_id;""")

cursor.execute(
    """ALTER TABLE account_tax_info_history
    DROP FOREIGN KEY fk_account_tax_info_history_account;""")

cursor.execute(
    """ALTER TABLE account_payee_history
    DROP FOREIGN KEY fk_account_account_payee_history;""")

cnx.close()

print('Foreign keys were deleted from tables')