Function ExportSQLDialog

src/dialogs/export-sql-dialog/export-sql-dialog.tsx:41–342

({
    dialog,
    targetDatabaseType,
})

}

export const ExportSQLDialog: React.FC<ExportSQLDialogProps> = ({
    dialog,
    targetDatabaseType,
}) => {
    const { closeExportSQLDialog } = useDialog();
    const { currentDiagram } = useChartDB();
    const { filter } = useDiagramFilter();
    const { t } = useTranslation();
    const [script, setScript] = React.useState<string>();
    const [error, setError] = React.useState<boolean>(false);
    const [isScriptLoading, setIsScriptLoading] =
        React.useState<boolean>(false);
    const [useAIExport, setUseAIExport] = React.useState<boolean>(false);
    const abortControllerRef = useRef<AbortController | null>(null);

    // Check if a deterministic export path is available
    const hasDeterministicPath = useMemo(() => {
        return (
            targetDatabaseType === DatabaseType.GENERIC ||
            currentDiagram.databaseType === targetDatabaseType ||
            hasCrossDialectSupport(
                currentDiagram.databaseType,
                targetDatabaseType
            )
        );
    }, [targetDatabaseType, currentDiagram.databaseType]);

    // Show toggle only for cross-dialect exports where both options are available
    const showExportModeToggle = useMemo(() => {
        return (
            hasDeterministicPath &&
            currentDiagram.databaseType !== targetDatabaseType &&
            targetDatabaseType !== DatabaseType.GENERIC
        );
    }, [hasDeterministicPath, currentDiagram.databaseType, targetDatabaseType]);

    const exportSQLScript = useCallback(async () => {
        const filteredDiagram: Diagram = {
            ...currentDiagram,
            tables: currentDiagram.tables?.filter((table) =>
                filterTable({
                    table: {
                        id: table.id,
                        schema: table.schema,
                    },
                    filter,
                    options: {
                        defaultSchema: defaultSchemas[targetDatabaseType],
                    },
                })
            ),
            relationships: currentDiagram.relationships?.filter((rel) => {
                const sourceTable = currentDiagram.tables?.find(
                    (t) => t.id === rel.sourceTableId
                );
                const targetTable = currentDiagram.tables?.find(
                    (t) => t.id === rel.targetTableId
                );