This creates an example postgres instance using docker.

Check out [test/terraform_database_example_test.go](/test/terraform_database_example_test.go) to see how you can write automated tests for database. In order to make go test code work, you need to provide host, port, username, password and database name of a existing database, which you have already created on cloud platform or using docker before testing. Only Microsoft SQL Server, PostgreSQL and MySQL are supported.

1. Install [Terraform](https://www.terraform.io/) and make sure it's on your `PATH`.

2. Run `terraform init`.

3. Run `terraform apply`.

4. When you're done, run `terraform destroy`.

1. Install [Terraform](https://www.terraform.io/) and make sure it's on your `PATH`.

2. Install [Golang](https://golang.org/) and make sure this code is checked out into your `GOPATH`.

3. `go mod tidy`

4. `go test -v test/terraform_database_example_test.go`

terraform {

required_providers {

docker = {

source = "kreuzwerker/docker"

version = "~> 3.0"

}

}

required_version = ">= 1.3.0"

}

provider "docker" {

}

resource "docker_network" "postgres_network" {

name = "postgres_network"

}

resource "docker_volume" "postgres_volume" {

name = "postgres_data"

}

resource "docker_container" "postgres" {

name = "postgres"

image = "postgres:15"

env = [

"POSTGRES_USER=${var.username}",

"POSTGRES_PASSWORD=${var.password}",

"POSTGRES_DB=${var.database_name}"

]

ports {

internal = 5432

external = var.port

}

networks_advanced {

name = docker_network.postgres_network.name

}

restart = "always"

}

output "host" {

value = var.host

}

output "port" {

value = var.port

}

output "username" {

value = var.username

}

output "password" {

value = var.password

}

output "database_name" {

value = var.database_name

}

variable "host" {

default = "localhost"

}

variable "port" {

default = "32768"

}

variable "username" {

default = "docker"

}

variable "password" {

default = "docker"

}

variable "database_name" {

default = "docker"

}

github.com/stretchr/testify v1.10.0

golang.org/x/crypto v0.32.0

golang.org/x/net v0.34.0

github.com/Azure/azure-sdk-for-go/sdk/azcore v1.17.0

github.com/Azure/azure-sdk-for-go/sdk/azidentity v1.7.0

github.com/denisenkom/go-mssqldb v0.12.3

github.com/lib/pq v1.10.9

github.com/golang-sql/civil v0.0.0-20190719163853-cb61b32ac6fe // indirect

github.com/golang-sql/sqlexp v0.1.0 // indirect

golang.org/x/sys v0.29.0 // indirect

golang.org/x/term v0.28.0 // indirect