"""Delete foreign keys from payment_group_payment table."""

import mysql.connector


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


cnx = mysqlclient_docker()

cursor = cnx.cursor()
cursor.execute(
    'ALTER TABLE payment_group_payment DROP FOREIGN KEY fk_payment_group_id;')

cursor.execute(
    'ALTER TABLE ledger_account_contract DROP FOREIGN KEY fk_ledger_account_contract_abacus_event;')  # noqa: E501

cursor.execute(
    'ALTER TABLE payment_group_payment_account DROP FOREIGN KEY fk_group_account_account;')  # noqa: E501

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

cnx.close()

print('Foreign keys were deleted from payment_group_payment table')