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

from typing import Any

import mysql.connector


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


cnx = mysqlclient_docker()

cursor = cnx.cursor()
cursor.execute(
    'ALTER TABLE account_payment_term DROP FOREIGN KEY fk_signing_entity_payment_term;'
)

cnx.close()

print('Foreign keys were deleted from tables')