github.com/darmach/terratest@v0.34.8-0.20210517103231-80931f95e3ff/examples/azure/terraform-azure-sqldb-example/main.tf (about)

     1  # ---------------------------------------------------------------------------------------------------------------------
     2  # DEPLOY AN AZURE SQL Database
     3  # This is an example of how to deploy an Azure sql database.
     4  # See test/terraform_azure_example_test.go for how to write automated tests for this code.
     5  # ---------------------------------------------------------------------------------------------------------------------
     6  
     7  
     8  # ---------------------------------------------------------------------------------------------------------------------
     9  # CONFIGURE OUR AZURE CONNECTION
    10  # ---------------------------------------------------------------------------------------------------------------------
    11  
    12  provider "azurerm" {
    13    version = "~>2.29"
    14    features {}
    15  }
    16  
    17  # ---------------------------------------------------------------------------------------------------------------------
    18  # DEPLOY A RESOURCE GROUP
    19  # ---------------------------------------------------------------------------------------------------------------------
    20  
    21  resource "azurerm_resource_group" "sql_rg" {
    22    name     = "terratest-rg-${var.postfix}"
    23    location = var.location
    24  }
    25  
    26  # ---------------------------------------------------------------------------------------------------------------------
    27  # DEPLOY AZURE SQL SERVER
    28  # ---------------------------------------------------------------------------------------------------------------------
    29  
    30  resource "random_password" "password" {
    31    length           = 16
    32    override_special = "_%@"
    33    min_upper        = "1"
    34    min_lower        = "1"
    35    min_numeric      = "1"
    36    min_special      = "1"
    37  }
    38  
    39  resource "azurerm_sql_server" "sqlserver" {
    40    name                         = "mssqlserver-${var.postfix}"
    41    resource_group_name          = azurerm_resource_group.sql_rg.name
    42    location                     = azurerm_resource_group.sql_rg.location
    43    version                      = "12.0"
    44    administrator_login          = var.sqlserver_admin_login
    45    administrator_login_password = random_password.password.result
    46  
    47    tags = {
    48      environment = var.tags
    49    }
    50  }
    51  
    52  # ---------------------------------------------------------------------------------------------------------------------
    53  # DEPLOY AZURE SQL DATA BASE
    54  # ---------------------------------------------------------------------------------------------------------------------
    55  
    56  resource "azurerm_sql_database" "sqldb" {
    57    name                = "sqldb-${var.postfix}"
    58    resource_group_name = azurerm_resource_group.sql_rg.name
    59    location            = azurerm_resource_group.sql_rg.location
    60    server_name         = azurerm_sql_server.sqlserver.name
    61    tags = {
    62      environment = var.tags
    63    }
    64  }