strHeadings = ",".join( [repr(i).replace("'", '"') for i in headings]) fh.write(strHeadings + "\n") for row in RS: row = ",".join( tuple([ '"' + str(val).replace('"', "") + '"' if val is not None else '""' for val in row ])) fh.write(row + "\n") if _WRITE_CSV_TO_DISK: log.info("Writing {name} to disk.".format(**locals())) fh.seek(0) with open(name, 'w') as csvFile: csvFile.write(fh.read()) _FilesAndData.append([name, fh.getvalue()]) else: errors += 1 log.critical( "No data retrieved for '{_ShortName}'".format(**locals())) except Exception as e: errors += 1 log.critical("Exception on getting data: " + str(e)) # ~ # GENERATE ZIP # ~ if not errors: log.info("Generating zip file...")