"""Misc db_helper methods."""

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',
    )


def fetch_single_db_entry(query: str) -> dict[str, Any]:
    """Check whether table is empty."""
    cnx = mysqlclient_docker()

    cursor = cnx.cursor()

    try:
        cursor = cnx.cursor()
        cursor.execute(query)
        for row in cursor:
            return dict(
                (column[0], row[index])
                for index, column in enumerate(cursor.description)
            )
        return {}
    finally:
        cursor.close()
        cnx.close()