Function exportSQLResult

src/utils/sqlExport.ts:38–66

(
  data: SQLExportData,
  format: SQLExportFormat
)

 * 导出 SQL 结果到文件
 */
export async function exportSQLResult(
  data: SQLExportData,
  format: SQLExportFormat
): Promise<{ success: boolean; filePath?: string; error?: string }> {
  if (data.rows.length === 0) {
    return { success: false, error: 'No data to export' }
  }

  const timestamp = dayjs().format('YYYYMMDD_HHmmss')
  const filename = `sql_result_${timestamp}.${format}`

  let content: string
  let mimeType: string

  if (format === 'json') {
    content = formatAsJSON(data)
    mimeType = 'application/json'
  } else {
    content = formatAsCSV(data)
    mimeType = 'text/csv'
  }

  // 转换为 data URL 并保存
  const dataUrl = `data:${mimeType};charset=utf-8,${encodeURIComponent(content)}`
  const { useCacheService } = await import('@/services/cache/service')
  const result = await useCacheService().saveToDownloads(filename, dataUrl)

  return result
}