Setting container environment variable with SQL Server host

[paulomorgado]

I need to set environment variables on a container with the SQL Server host and port.

I can get the port with:

ctx.EnvironmentVariables[$"PORT_{connectionName}"] = sqlServerServerResource.PrimaryEndpoint.Property(EndpointProperty.Port);

But:

ctx.EnvironmentVariables[$"SERVER_{connectionName}"] = sqlServerServerResource.PrimaryEndpoint.Property(EndpointProperty.IPV4Host);

will always get me 127.0.0.1.

I have to resort to:

ctx.EnvironmentVariables[$"SERVER_{connectionName}"] = sqlServerServerResource.PrimaryEndpoint.ContainerHost;

I guess that's because ApplicationExecutor.ReplaceLocalhostWithContainerHost is never invoked on this value.

Is there a workaround to this?

[paulomorgado]

This works:

ctx.EnvironmentVariables[$"SERVER_{connectionName}"] = new HostUrl(sqlServerServerResource.PrimaryEndpoint.Host);

But it feels like it's missing a HostReference type:

/// <summary>
/// Represents a host reference on the host machine. When referenced in a container resource, localhost will be
/// replaced with the configured container host name.
/// </summary>
public record HostReference(IValueProvider HostReference) : IValueProvider, IManifestExpressionProvider
{
    // Goes into the manifest as a value, not an expression
    string IManifestExpressionProvider.ValueExpression => "host";

    // Returns the url
    ValueTask<string?> IValueProvider.GetValueAsync(System.Threading.CancellationToken cancellationToken)
        => HostReference.GetValueAsync(cancellationToken);
}

[davidfowl]

See #3735. This is a gap.