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

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', '18087'),
    database=os.environ.get('MYSQL_DB', 'royalty_accounting'),
    user=os.environ.get('MYSQL_USER', 'db_user'),
    password=os.environ.get('MYSQL_PASS', 'db_pass'))

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

cursor.execute(
    'ALTER TABLE ledger_payee DROP FOREIGN KEY fk_abacus_event_ledger_payee;')

cursor.execute(
    'ALTER TABLE payment_group_payment_payee DROP FOREIGN KEY fk_group_payee_payee;')

cnx.close()

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