Snippet to get csv-output from MySQL-Client

sql_client_tmpfile_snippet.py

import shutil

def read_sql_client_tmpfile(query, connection):
    df = None

    tmp_dir = tempfile.mkdtemp()
    try:
        local_tmp_file = f'{tmp_dir}/sql_tmpfile'
        cmd = f"mysql -u {username} -p{password} -h {db_server} -D {dbname} -e '{query}' >{local_tmp_file}"
        if not os.system(cmd):
            df = pd.read_csv(local_tmp_file)
    finally:
        shutil.rmtree(tmp_dir)

    return df