( query: string, filename: string = 'Query' )
| 98 | * Export query as SQL file |
| 99 | */ |
| 100 | export const exportQueryAsSQL = ( |
| 101 | query: string, |
| 102 | filename: string = 'Query' |
| 103 | ): void => { |
| 104 | try { |
| 105 | if (!query.trim()) { |
| 106 | throw new Error('No query to export'); |
| 107 | } |
| 108 | |
| 109 | const sqlContent = `-- DataKit SQL Query |
| 110 | -- Generated on: ${new Date().toLocaleDateString()} |
| 111 | |
| 112 | ${query}`; |
| 113 | |
| 114 | downloadText(sqlContent, filename, 'sql'); |
| 115 | |
| 116 | } catch (error) { |
| 117 | console.error('Failed to export SQL:', error); |
| 118 | throw new Error('SQL export failed. Please try again.'); |
| 119 | } |
| 120 | }; |
| 121 | |
| 122 | /** |
| 123 | * Generate HTML content for query results PDF |
no test coverage detected