azure_tf_sql_database/main.tf at 8487bb1f9990e78f4d0fa8a78c35d71d30dbafce · stackgen-demo/azure_tf_sql_database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
resource "azurerm_mssql_server" "this" {
  name                         = var.server_name
  resource_group_name          = var.resource_group_name
  location                     = var.location
  version                      = "12.0"
  administrator_login          = var.admin_login
  administrator_login_password = var.admin_password
  minimum_tls_version          = "1.2"

  tags = var.tags
}

module "long_term_retention" {
  source = "./modules/long_term_retention"

  enabled           = var.long_term_retention_enabled
  weekly_retention  = var.long_term_retention_weekly
  monthly_retention = var.long_term_retention_monthly
  yearly_retention  = var.long_term_retention_yearly
  week_of_year      = var.long_term_retention_week_of_year
}

resource "azurerm_mssql_database" "this" {
  name        = var.database_name
  server_id   = azurerm_mssql_server.this.id
  sku_name    = var.sku_name
  max_size_gb = var.max_size_gb

  dynamic "long_term_retention_policy" {
    for_each = module.long_term_retention.enabled ? [module.long_term_retention.policy] : []
    content {
      weekly_retention  = long_term_retention_policy.value.weekly_retention
      monthly_retention = long_term_retention_policy.value.monthly_retention
      yearly_retention  = long_term_retention_policy.value.yearly_retention
      week_of_year      = long_term_retention_policy.value.week_of_year
    }
  }

  tags = var.tags
}

resource "azurerm_mssql_firewall_rule" "allow_azure_services" {
  name             = "AllowAzureServices"
  server_id        = azurerm_mssql_server.this.id
  start_ip_address = "0.0.0.0"
  end_ip_address   = "0.0.0.0"
}