Function formatExportToZip

backend/api/v1/sql_service.go:1287–1314

formatExportToZip formats query results and writes them directly to a ZIP entry. This function streams the formatted data to minimize memory usage.

(
	ctx context.Context,
	zipw *zip.Writer,
	filename string,
	stores *store.Store,
	instance *store.InstanceMessage,
	database *store.DatabaseMessage,
	result *v1pb.QueryResult,
	request *v1pb.ExportRequest,
)

// formatExportToZip formats query results and writes them directly to a ZIP entry.
// This function streams the formatted data to minimize memory usage.
func formatExportToZip(
	ctx context.Context,
	zipw *zip.Writer,
	filename string,
	stores *store.Store,
	instance *store.InstanceMessage,
	database *store.DatabaseMessage,
	result *v1pb.QueryResult,
	request *v1pb.ExportRequest,
) error {
	writer, err := export.CreateZipWriter(zipw, filename, request.GetPassword())
	if err != nil {
		return err
	}

	switch request.Format {
	case v1pb.ExportFormat_CSV:
		return export.CSVToWriter(writer, result)
	case v1pb.ExportFormat_JSON:
		return export.JSONToWriter(writer, result)
	case v1pb.ExportFormat_SQL:
		return exportSQLWithContext(ctx, writer, stores, instance, database, result, request)
	case v1pb.ExportFormat_XLSX:
		return export.XLSXToWriter(writer, result)
	default:
		return errors.Errorf("unsupported export format: %s", request.Format.String())
	}
}

// exportSQLWithContext exports SQL INSERT statements with proper context.
func exportSQLWithContext(