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

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', '18089'),
    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 ledger_general DROP FOREIGN KEY fk_abacus_event_ledger_general;')

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

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

cnx.close()

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