timeadd interpolation function

[saint1991]

Added a interpolation function timeadd(time, duration).

There is no way to designate relative time to the field expiration_time of google_sql_database_instance.

In our case, we want to allow access from the host which executes terraform only while provisioning steps (e.g. grant users' privileges, create tables) and deny any access after that because it can be access via CloudSQL proxy.

With this function, we can specify expiration time e.g. after 1 hour as follows:

ip_configuration {
      require_ssl = true

      authorized_networks {
        expiration_time = "${timeadd(timestamp(), "1h")}"
        name            = "provisioner"
        value           = "${var.provisioner_global_ip}"
      }
}

[apparentlymart]

Hi @saint1991! Thanks for working on this and sorry for the delay in responding.

[saint1991]

@apparentlymart
No problem. Thank you for reviewing and merging!!

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.