Definitions for @turbot/azure-postgresql

{
  "type": "string",
  "pattern": "^(?!azure_superuser|azure_pg_admin|admin|adminstrator|root|guest|publlic)^(?!pg_|-.*$).*([a-zA-Z0-9_]+){1,63}$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "test-04"
    },
    {
      "description": "invalid - Hyphen can use after two letter",
      "input": "-test",
      "expected": false
    },
    {
      "description": "invalid - azure_superuser,azure_pg_admin,admin,adminstrator,root,guest,public these words can not be admin user name",
      "input": "admin",
      "expected": false
    },
    {
      "description": "invalid - should not start with pg_",
      "input": "pg_test",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/adminUserName",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "object",
  "properties": {
    "name": {
      "$ref": "#/definitions/dbName"
    },
    "id": {
      "type": "string"
    },
    "charset": {
      "type": "string"
    },
    "collation": {
      "type": "string"
    },
    "turbot": {
      "type": "object",
      "properties": {
        "akas": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/databaseAka"
          }
        },
        "title": {
          "$ref": "#/definitions/dbName"
        },
        "custom": {
          "type": "object",
          "properties": {
            "createTimestamp": {
              "$ref": "turbot#/definitions/isoTimestamp"
            },
            "serverName": {
              "$ref": "#/definitions/serverName"
            },
            "azure": {
              "$ref": "azure#/definitions/azureMetadata"
            }
          }
        }
      }
    }
  },
  "additionalProperties": true,
  "tests": [
    {
      "description": "Base - All valid Properties",
      "input": {
        "name": "myDb",
        "id": "/subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-server/databases/postgres",
        "serverName": "test01",
        "charset": "UTF8",
        "collation": "English_United States.1252",
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-server/databases/postgres"
          ],
          "title": "test01",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    },
    {
      "description": "Invalid - Name is missing",
      "input": {
        "serverName": "test01",
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01/databases/myDb"
          ],
          "title": "test01",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    },
    {
      "description": "Invalid - db name missing",
      "input": {
        "serverName": "test01",
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01/databases/myDb"
          ],
          "title": "test01",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/database",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^azure:///subscriptions/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}/resourceGroups/[A-Za-z0-9-_().]*[A-Za-z0-9-_()]/providers/Microsoft.DBforPostgreSQL/servers/(?!-.*$).*([a-zA-Z0-9-]+)([a-z0-9]){1,63}/databases/[a-zA-Z0-9_]{1,66}$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01/databases/test01"
    },
    {
      "description": "invalid - Wrong Account id",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2chkjfhhdshfkndjfjkdsjh77f7/resourceGroups/dev/providers/Microsoft.Search/searchServices/test01/databases/test01",
      "expected": false
    },
    {
      "description": "invalid - Wrong database Name",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2chkjfhhdshfkndjfjkdsjh77f7/resourceGroups/dev/providers/Microsoft.Search/searchServices/test01/databases/test@01",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/databaseAka",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^[A-Za-z-0-9_-]{1,127}[a-zA-Z0-9_-]$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "test_04"
    },
    {
      "description": "invalid - must contaion 1 to 128 character",
      "input": "dskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsj",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/dbName",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "object",
  "properties": {
    "administratorLogin": {
      "type": "string"
    },
    "administratorLoginPassword": {
      "type": "string"
    },
    "authConfig": {
      "type": "object",
      "properties": {
        "activeDirectoryAuth": {
          "type": "string"
        },
        "passwordAuth": {
          "type": "string"
        },
        "tenantId": {
          "type": "string"
        }
      }
    },
    "availabilityZone": {
      "type": "string"
    },
    "backup": {
      "type": "object",
      "properties": {
        "backupRetentionDays": {
          "type": "integer"
        },
        "earliestRestoreDate": {
          "$ref": "turbot#/definitions/isoTimestamp"
        },
        "geoRedundantBackup": {
          "type": "string"
        }
      }
    },
    "createMode": {
      "type": "string"
    },
    "dataEncryption": {
      "type": "object",
      "properties": {
        "primaryKeyUri": {
          "type": "string"
        },
        "primaryUserAssignedIdentityId": {
          "type": "string"
        },
        "type": {
          "type": "string"
        }
      }
    },
    "fullyQualifiedDomainName": {
      "type": "string"
    },
    "highAvailability": {
      "type": "object",
      "properties": {
        "mode": {
          "type": "string"
        },
        "standbyAvailabilityZone": {
          "type": "string"
        },
        "state": {
          "type": "string"
        }
      }
    },
    "id": {
      "$ref": "#/definitions/serverId"
    },
    "identity": {
      "type": "string"
    },
    "location": {
      "type": "string"
    },
    "maintenanceWindow": {
      "type": "object",
      "properties": {
        "customWindow": {
          "type": "string"
        },
        "dayOfWeek": {
          "type": "integer"
        },
        "startHour": {
          "type": "number"
        },
        "startMinute": {
          "type": "number"
        }
      }
    },
    "minorVersion": {
      "type": "string"
    },
    "name": {
      "$ref": "#/definitions/flexiServerName"
    },
    "network": {
      "type": "object",
      "properties": {
        "delegatedSubnetResourceId": {
          "type": "string"
        },
        "privateDnsZoneArmResourceId": {
          "type": "string"
        },
        "publicNetworkAccess": {
          "type": "string"
        }
      }
    },
    "replicaCapacity": {
      "type": "integer"
    },
    "replicationRole": {
      "type": "string"
    },
    "resourceGroup": {
      "type": "string"
    },
    "sku": {
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "tier": {
          "type": "string"
        }
      }
    },
    "sourceServerResourceId": {
      "type": "string"
    },
    "state": {
      "$ref": "#/definitions/serveState"
    },
    "storage": {
      "type": "object",
      "properties": {
        "storageSizeGb": {
          "type": "integer"
        }
      }
    },
    "systemData": {
      "type": "object",
      "properties": {
        "createdAt": {
          "$ref": "turbot#/definitions/isoTimestamp"
        },
        "createdBy": {
          "type": "string"
        },
        "createdByType": {
          "type": "object"
        },
        "lastModifiedAt": {
          "$ref": "turbot#/definitions/isoTimestamp"
        },
        "lastModifiedBy": {
          "type": "string"
        },
        "lastModifiedByType": {
          "type": "object"
        }
      }
    },
    "firewallRules": {
      "type": "array"
    },
    "configurations": {
      "type": "array",
      "items": {
        "$ref": "#/definitions/serverConfigurations"
      }
    },
    "tags": {
      "$ref": "azure#/definitions/tags"
    },
    "type": {
      "type": "string"
    },
    "version": {
      "type": "string"
    },
    "turbot": {
      "type": "object",
      "properties": {
        "akas": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/flexibleServerAka"
          }
        },
        "title": {
          "$ref": "#/definitions/flexiServerName"
        },
        "custom": {
          "type": "object",
          "properties": {
            "createTimestamp": {
              "$ref": "turbot#/definitions/isoTimestamp"
            },
            "azure": {
              "$ref": "azure#/definitions/azureMetadata"
            }
          }
        }
      }
    }
  },
  "additionalProperties": true,
  "tests": [
    {
      "description": "Base - All valid Properties",
      "input": {
        "name": "test01",
        "id": "/subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/flexibleServers/partha-server",
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/flexibleServers/partha-server"
          ],
          "title": "test01",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    },
    {
      "description": "Invalid - Name is missing",
      "input": {
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/test01"
          ],
          "title": "test01",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/flexibleServer",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^azure:///subscriptions/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}/resourceGroups/[A-Za-z0-9-_().]*[A-Za-z0-9-_()]/providers/Microsoft.DBforPostgreSQL/flexibleServers/[a-z0-9][a-z0-9-]{1,61}[a-z0-9]$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/test01"
    },
    {
      "description": "invalid - Wrong Subs id",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2chkjfhhdshfkndjfjkdsjh77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/test01",
      "expected": false
    },
    {
      "description": "invalid - Wrong server Name",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/_test01",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/flexibleServerAka",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "defaultColumns": {
    "region": {
      "column": "enabled",
      "path": "data.location"
    },
    "resource_group": {
      "type": "string",
      "size": 200,
      "column": "enabled",
      "path": "metadata.azure.resourceGroupName"
    },
    "subscription_id": {
      "column": "enabled",
      "label": "Subscription ID",
      "path": "metadata.azure.subscriptionId"
    },
    "id": {
      "column": "enabled",
      "label": "ID"
    },
    "flexible_server_configurations": {
      "column": "enabled",
      "path": "data.configurations",
      "type": "string",
      "size": 1000
    },
    "postgresql_flexible_server_name": {
      "column": "enabled",
      "path": "data.name"
    },
    "sku": {
      "column": "enabled",
      "label": "SKU",
      "type": "string",
      "size": 1000
    },
    "tags": {
      "column": "enabled",
      "type": "string",
      "size": 1000
    },
    "type": {
      "column": "enabled"
    }
  },
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/flexibleServerServiceNow",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^[a-z0-9][a-z0-9-]{1,61}[a-z0-9]$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "test-04"
    },
    {
      "description": "invalid - must contaion 3 to 63 character",
      "input": "dskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsjdskhsfjdsldfjkjslfjlkdsfkchfnjkhdsj",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/flexiServerName",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "$ref": "azure#/definitions/regionNameMatcherList",
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/location",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "allOf": [
    {
      "$ref": "turbot#/definitions/service"
    },
    {
      "type": "object",
      "properties": {
        "name": {
          "const": "PostgreSQL"
        },
        "turbot": {
          "type": "object",
          "properties": {
            "akas": {
              "type": "array",
              "items": {
                "$ref": "#/definitions/postgreSqlAka"
              }
            },
            "title": {
              "const": "PostgreSQL"
            },
            "custom": {
              "type": "object",
              "properties": {
                "azure": {
                  "$ref": "azure#/definitions/azureMetadata"
                }
              }
            }
          }
        }
      },
      "required": [
        "name",
        "turbot"
      ],
      "additionalProperties": true,
      "tests": [
        {
          "description": "Base - All valid Properties",
          "input": {
            "name": "PostgreSQL",
            "turbot": {
              "akas": [
                "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/providers/Microsoft.DBforPostgreSQL/postgresql"
              ],
              "title": "PostgreSQL",
              "custom": {
                "azure": {
                  "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7"
                }
              }
            }
          }
        },
        {
          "description": "Invalid - Incorrect name",
          "input": {
            "name": "Searching",
            "turbot": {
              "akas": [
                "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/providers/Microsoft.DBforPostgreSQL/postgresql"
              ],
              "title": "PostgreSQL",
              "custom": {
                "azure": {
                  "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7"
                }
              }
            }
          },
          "expected": false
        },
        {
          "description": "Invalid - Service name missing",
          "input": {
            "turbot": {
              "akas": [
                "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/providers/Microsoft.DBforPostgreSQL/postgresql"
              ],
              "title": "PostgreSQL",
              "custom": {
                "azure": {
                  "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7"
                }
              }
            }
          },
          "expected": false
        }
      ]
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/postgreSql",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^azure:///subscriptions/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}/providers/Microsoft.DBforPostgreSQL/postgresql",
  "tests": [
    {
      "descritpion": "base case",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/providers/Microsoft.DBforPostgreSQL/postgresql"
    },
    {
      "description": "invalid - account ID too long",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7jfhsjkds/provider",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/postgreSqlAka",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "object",
  "properties": {
    "name": {
      "$ref": "#/definitions/serverName"
    },
    "tags": {
      "$ref": "azure#/definitions/tags"
    },
    "id": {
      "type": "string"
    },
    "sku": {
      "type": "object"
    },
    "administratorLogin": {
      "type": "string"
    },
    "version": {
      "type": "string"
    },
    "sslEnforcement": {
      "type": "string"
    },
    "userVisibleState": {
      "type": "string"
    },
    "fullyQualifiedDomainName": {
      "type": "string"
    },
    "earliestRestoreDate": {
      "type": "string"
    },
    "storageProfile": {
      "type": "object"
    },
    "replicationRole": {
      "type": "string"
    },
    "masterServerId": {
      "type": "string"
    },
    "replicaCapacity": {
      "type": "integer"
    },
    "firewallRules": {
      "type": "array"
    },
    "configurations": {
      "type": "array",
      "items": {
        "$ref": "#/definitions/serverConfigurations"
      }
    },
    "turbot": {
      "type": "object",
      "properties": {
        "akas": {
          "type": "array",
          "items": {
            "$ref": "#/definitions/serverAka"
          }
        },
        "title": {
          "$ref": "#/definitions/serverName"
        },
        "tags": {
          "$ref": "azure#/definitions/tags"
        },
        "custom": {
          "type": "object",
          "properties": {
            "createTimestamp": {
              "$ref": "turbot#/definitions/isoTimestamp"
            },
            "azure": {
              "$ref": "azure#/definitions/azureMetadata"
            }
          }
        }
      }
    }
  },
  "additionalProperties": true,
  "tests": [
    {
      "description": "Base - All valid Properties",
      "input": {
        "name": "test01",
        "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45",
        "location": "eastus",
        "tags": {
          "ting": "tong"
        },
        "sku": {
          "name": "GP_Gen5_2",
          "tier": "GeneralPurpose",
          "capacity": 2,
          "family": "Gen5"
        },
        "administratorLogin": "partha",
        "version": "10",
        "sslEnforcement": "Enabled",
        "userVisibleState": "Ready",
        "fullyQualifiedDomainName": "partha-servert45.postgres.database.azure.com",
        "earliestRestoreDate": "2019-08-27T12:45:16.943Z",
        "storageProfile": {
          "backupRetentionDays": 7,
          "geoRedundantBackup": "Disabled",
          "storageMB": 5120,
          "storageAutoGrow": "Enabled"
        },
        "replicationRole": "None",
        "masterServerId": "",
        "replicaCapacity": 5,
        "firewallRules": [],
        "configurations": [
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/log_checkpoints",
            "name": "log_checkpoints",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "on",
            "description": "Logs each checkpoint.",
            "defaultValue": "on",
            "dataType": "Boolean",
            "allowedValues": "on,off",
            "source": "system-default"
          },
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/log_connections",
            "name": "log_connections",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "on",
            "description": "Logs each successful connection.",
            "defaultValue": "on",
            "dataType": "Boolean",
            "allowedValues": "on,off",
            "source": "system-default"
          },
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/log_disconnections",
            "name": "log_disconnections",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "off",
            "description": "Logs end of a session, including duration.",
            "defaultValue": "off",
            "dataType": "Boolean",
            "allowedValues": "on,off",
            "source": "system-default"
          },
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/log_duration",
            "name": "log_duration",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "off",
            "description": "Logs the duration of each completed SQL statement.",
            "defaultValue": "off",
            "dataType": "Boolean",
            "allowedValues": "on,off",
            "source": "system-default"
          },
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/connection_throttling",
            "name": "connection_throttling",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "on",
            "description": "Enables temporary connection throttling per IP for too many invalid password login failures.",
            "defaultValue": "on",
            "dataType": "Boolean",
            "allowedValues": "on,off",
            "source": "system-default"
          },
          {
            "id": "/subscriptions/3510ae4d-530b-497d-8f30-53b9616fc6c1/resourceGroups/test/providers/Microsoft.DBforPostgreSQL/servers/partha-servert45/configurations/log_retention_days",
            "name": "log_retention_days",
            "type": "Microsoft.DBforPostgreSQL/servers/configurations",
            "value": "3",
            "description": "Sets how many days a log file is saved for.",
            "defaultValue": "3",
            "dataType": "Integer",
            "allowedValues": "1-7",
            "source": "system-default"
          }
        ],
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01"
          ],
          "title": "test01",
          "tags": {
            "ting": "tong"
          },
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    },
    {
      "description": "Invalid - Name is missing",
      "input": {
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01"
          ],
          "title": "test",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    },
    {
      "description": "Invalid - Service name missing",
      "input": {
        "turbot": {
          "akas": [
            "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test-02"
          ],
          "title": "test-02",
          "custom": {
            "azure": {
              "subscriptionId": "9e3548cf-17e2-4751-b87e-b72bdd2c77f7",
              "resourceGroupName": "dev"
            }
          }
        }
      }
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/server",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^azure:///subscriptions/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}/resourceGroups/[A-Za-z0-9-_().]*[A-Za-z0-9-_()]/providers/Microsoft.DBforPostgreSQL/servers/(?!-.*$).*([a-zA-Z0-9-]+)([a-z0-9]){1,63}$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/servers/test01"
    },
    {
      "description": "invalid - Wrong Account id",
      "input": "azure:///subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2chkjfhhdshfkndjfjkdsjh77f7/resourceGroups/dev/providers/Microsoft.Search/searchServices/test01",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serverAka",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "object",
  "properties": {
    "id": {
      "type": "string"
    },
    "name": {
      "type": "string"
    },
    "type": {
      "type": "string"
    },
    "value": {
      "type": "string"
    },
    "source": {
      "type": "string"
    },
    "dataType": {
      "type": "string"
    },
    "description": {
      "type": "string"
    },
    "defaultValue": {
      "type": "string"
    },
    "allowedValues": {
      "type": "string"
    }
  },
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serverConfigurations",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^/subscriptions/[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{4}-[a-f0-9]{12}/resourceGroups/[A-Za-z0-9-_().]*[A-Za-z0-9-_()]/providers/Microsoft.DBforPostgreSQL/flexibleServers/[a-z0-9][a-z0-9-]{1,61}[a-z0-9]$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "/subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/server010"
    },
    {
      "description": "invalid - Wrong flexible server Name",
      "input": "/subscriptions/9e3548cf-17e2-4751-b87e-b72bdd2c77f7/resourceGroups/dev/providers/Microsoft.DBforPostgreSQL/flexibleServers/-test01",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serverId",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "pattern": "^^(?!-.*$).*([a-zA-Z0-9-]+)([a-z0-9]){1,63}$",
  "tests": [
    {
      "descritpion": "base case",
      "input": "test-04"
    },
    {
      "description": "invalid - Hyphen can use first",
      "input": "-test",
      "expected": false
    },
    {
      "description": "invalid - Hyphen can not be at last position",
      "input": "test-",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serverName",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "defaultColumns": {
    "administrator_login": {
      "column": "enabled",
      "label": "Administrator Login"
    },
    "backup_retention_days": {
      "column": "enabled",
      "path": "data.storageProfile.backupRetentionDays"
    },
    "earliest_restore_date": {
      "column": "enabled"
    },
    "firewall_rules": {
      "column": "enabled",
      "type": "string",
      "size": 1000
    },
    "fully_qualified_domain_name": {
      "column": "enabled"
    },
    "geo_redundant_backup": {
      "column": "enabled",
      "path": "data.storageProfile.geoRedundantBackup"
    },
    "id": {
      "column": "enabled",
      "label": "ID"
    },
    "master_server_id": {
      "column": "enabled",
      "label": "Master Server ID"
    },
    "minimal_tls_version": {
      "column": "enabled",
      "label": "Minimal TLS Version"
    },
    "server_name": {
      "column": "enabled",
      "path": "data.name"
    },
    "region": {
      "column": "enabled",
      "path": "data.location"
    },
    "replica_capacity": {
      "column": "enabled"
    },
    "replication_role": {
      "column": "enabled"
    },
    "resource_group": {
      "type": "string",
      "size": 200,
      "column": "enabled",
      "path": "metadata.azure.resourceGroupName"
    },
    "server_configurations": {
      "column": "enabled",
      "path": "data.configurations",
      "type": "string",
      "size": 1000
    },
    "sku_capacity": {
      "column": "enabled",
      "path": "data.sku.capacity",
      "label": "SKU Capacity"
    },
    "sku_family": {
      "column": "enabled",
      "path": "data.sku.family",
      "label": "SKU Family"
    },
    "sku_name": {
      "column": "enabled",
      "path": "data.sku.name",
      "label": "SKU Name"
    },
    "sku_size": {
      "column": "enabled",
      "path": "data.sku.size",
      "label": "SKU Size"
    },
    "sku_tier": {
      "column": "enabled",
      "path": "data.sku.tier",
      "label": "SKU Tier"
    },
    "ssl_enforcement": {
      "column": "enabled",
      "label": "SSL Enforcement"
    },
    "storage_auto_grow": {
      "column": "enabled",
      "path": "data.storageProfile.storageAutogrow"
    },
    "storage_mb": {
      "column": "enabled",
      "path": "data.storageProfile.storageMB",
      "label": "Storage MB"
    },
    "subscription_id": {
      "column": "enabled",
      "label": "Subscription ID",
      "path": "metadata.azure.subscriptionId"
    },
    "tags": {
      "column": "enabled",
      "type": "string",
      "size": 1000
    },
    "type": {
      "column": "enabled"
    },
    "user_visible_state": {
      "column": "enabled"
    },
    "version": {
      "column": "enabled"
    }
  },
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serverServiceNow",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "enum": [
    "Disabled",
    "Dropping",
    "Ready",
    "Starting",
    "Stopped",
    "Stopping",
    "Updating"
  ],
  "tests": [
    {
      "input": "Ready"
    },
    {
      "input": "Stopped"
    },
    {
      "describe": "invalid - value not allowed",
      "input": "vaid",
      "expected": false
    }
  ],
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/serveState",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}

{
  "type": "string",
  "enum": [
    11,
    10,
    9.6,
    9.5
  ],
  "default": 11,
  ".turbot": {
    "uri": "tmod:@turbot/azure-postgresql#/definitions/version",
    "modUri": "tmod:@turbot/azure-postgresql"
  }
}