Convert SQL Query to CSV File in Python

sql_to_csv.py

# Generic reader method
# Reads data, prints columns, and prints each row to file
def do_query_to_csv_file(cursor, sql, csv_file):
    try:
        cursor.execute(sql)
        file_header = ''
        f = open(file_dir + csv_file + '.csv', 'w')
        columns = [column[0] for column in cursor.description]
        for col in columns:
            file_header = file_header + col + ','
        f.write(file_header[:-1] + '\n')
        for row in cursor:
            file_row = ''
            for element in row:
                if element is None:
                    element = ''
                file_row = file_row + element.__str__().replace(',', ' ') + ','
            f.write(file_row[:-1] + '\n')
        f.close()
        print 'report completed: {}'.format(csv_file)
    except Exception, e:
        print e

thanks, really helpful.

PS: check print commands. in python3 print function works as print()

I actually can't remember what I was using this for, but it was Python 2.

Can you also post the main function of this script as well? @keshavbahadoor
Thanks in advance!!