[feat] populate password for command output

[a1994sc]

I have a postgresql connection that I would like to look at, but it has a randomly generated password.

The config looks like this:

[[database]]
Name = 'cluster-coder'
Provider = 'postgres'
DBName = 'coder'
URL = 'postgres://postgres:<password>@localhost:${port}/coder?sslmode=disable'
Commands = [
  { Command = 'kubectl --context cluster port-forward -n coder svc/cluster-pooler ${port}:5432', WaitForPort = '${port}' }
]

It would be nice to be able to populate the <password> the same we do for ${port}.

Commands = [
  { Command = 'kubectl --context cluster get secrets blah | yq .data.password | base64 -d', <password identifier> },
  { Command = 'kubectl --context cluster port-forward -n coder svc/cluster-pooler ${port}:5432', WaitForPort = '${port}' }
]

I'm not sure what it should look like for <password identifier> to say I want the output of this command to be used as the password... this might be able to be extend to allow arbitrary variable substitution, but at least MVP for this issue would be able to populate the password dynamically.

[jorgerojas26]

@svanharmelen Hi mate, i hope you are doing well. You are the one who did the commands feature, would you mind to check this and maybe help with a PR?

[svanharmelen]

Hi @jorgerojas26 I'm super busy at the moment, so don't really have time to look into this one...

[svanharmelen]

@jorgerojas26 and @a1994sc I think I can come up with a solution, just not sure in what time frame as I'm a bit overloaded at the moment. But will keep this one in the back of my head to take a look at later when things have settled down again...

[a1994sc]

@svanharmelen please work at your own place, this is a nice to have not a requirement so take your time