Function exportQueryAsCSV

frontend/src/utils/queryExport.ts:21–50

(
  results: any[][] = [],
  columns: string[] = [],
  filename: string = 'Query_Results'
)

 * Export query results as CSV
 */
export const exportQueryAsCSV = (
  results: any[][] = [],
  columns: string[] = [],
  filename: string = 'Query_Results'
): void => {
  try {
    if (results.length === 0 || columns.length === 0) {
      throw new Error('No data to export');
    }

    // Create CSV content
    const csvContent = [
      // Header row
      columns.map(col => `"${col.replace(/"/g, '""')}"`).join(','),
      // Data rows
      ...results.map(row => 
        row.map(cell => {
          const cellValue = cell === null || cell === undefined ? '' : String(cell);
          return `"${cellValue.replace(/"/g, '""')}"`;
        }).join(',')
      )
    ].join('\n');

    downloadText(csvContent, filename, 'csv');

  } catch (error) {
    console.error('Failed to export CSV:', error);
    throw new Error('CSV export failed. Please try again.');
  }
};

/**
 * Export query results as JSON