Skip to content

Instantly share code, notes, and snippets.

@Mike-F362
Mike-F362 / sql_client_tmpfile_snippet.py
Created January 23, 2023 08:22
Snippet to get csv-output from MySQL-Client
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}"