0.1.151 • Published 1 year ago

@azbake/ingredient-sqldb v0.1.151

Weekly downloads
-
License
MIT
Repository
github
Last release
1 year ago

Changelogs

Overview

The SQLServer Logical ingredient is a plugin for bake. When included in a recipe, this will create a SQL Database.

Usage

name: SQL SB
shortName: sqldbdeployment
version: 1.0.0
ingredients:
  - "@azbake/ingredient-sqldb@0~"
resourceGroup: true
rgOverride: HCHB_DataAdmins_DataWarehouse_Dev
variables:
  collation : "SQL_Latin1_General_CP1_CI_AS"
  databaseName : "testdb"
  tier : "Basic"
  skuName : "Basic"
  maxSizeBytes : 2147483648
  serverName : "testsqlserverlogical"
  serverLocation : "centralus"
  sampleName : 
  zoneRedundant : False
  licenseType : 
  readScaleOut : "Disabled"
  numberOfReplicas : 0
  minCapacity : 
  autoPauseDelay : 
  databaseTags :  {}
  enableADS : False
  enableVA : False
recipe:
  sqlserverlogical:
    properties:
      type: "@azbake/ingredient-sqldb"
      parameters:
        serverName : "[coreutils.variable('serverName')]"
        collation : "[coreutils.variable('collation')]"
        databaseName : "[coreutils.variable('databaseName')]"
        tier : "[coreutils.variable('tier')]"
        skuName : "[coreutils.variable('skuName')]"
        maxSizeBytes : "[coreutils.variable('maxSizeBytes')]"
        serverLocation : "[coreutils.variable('serverLocation')]"
        sampleName : "[coreutils.variable('sampleName')]"
        zoneRedundant : "[(coreutils.variable('zoneRedundant') == true)]" #this is only available in premium
        licenseType : "[coreutils.variable('licenseType')]"
        readScaleOut : "[coreutils.variable('readScaleOut')]"
        databaseTags : "[coreutils.variable('databaseTags')]"
        minCapacity : "[coreutils.variable('minCapacity')]"
        #numberOfReplicas : "[coreutils.variable('numberOfReplicas')]" #this is only available in premium
        autoPauseDelay : "[coreutils.variable('autoPauseDelay')]"
        enableADS : "[(coreutils.variable('enableADS') == true)]"
        enableVA : "[(coreutils.variable('enableVA') == true)]"
   
propertyrequireddescription
collationyesDatabase collation defines the rules that sort and compare data, and cannot be changed after database creation. The default database collation is SQL_Latin1_General_CP1_CI_AS
databaseNameYesName of the Azure SQL Database
tierYesTiers are Basic, Standard, Premium, etc...
skuNameno (default:false)Sku refers to DTU.
maxSizeBytesno (default:true)Database size in kilobytes
serverNameYesLogical Sql Server name.
serverLocationYesResource Group of Logical SQL Server.
sampleNameNoValid options are AdventureWorksLIT
zoneRedundantNo (default:False)Available to SQL single databases and elastic pools in the Premium service tier at no extra cost. Meaning replicas of this database will be spread across multiple availability zones
licenseTypeNo (default:BasePrice)License type to apply for this database. Valid options are LicenseIncluded, BasePrice
readScaleOutNo (default:Disabled)Connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica
numberOfReplicasNo (default:0)Number of SQL Server Database replicas.
minCapacityNo (default:null)Minimal capacity that database will always have allocated
autoPauseDelayNo (default:null)Minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled
databaseTagsNo (default:{})Azure resource tags
enableADSNo (default:False)Protect your data using Advanced Data Security, a unified security package including Data Classification, Vulnerability Assessment and Advanced Threat Protection for your server.
enableVANo (default:False)Enable database vulnerability assessment.

Utilities

Utility classes can be used inside of the bake.yaml file for parameter and source values.

SqlServerLogicalUtils class

| function | description | | create_resource_name() | Returns the name created for the Service Bus Namespace when deployed |

Function Details

create_resource_name()

Gets the name created for the App Service Plan when deployed.

...
parameters:
    planName: "[SqlServerLogicalUtils.create_resource_name()]"
...
Returns

string

0.1.151

1 year ago

0.1.150

1 year ago

0.1.147

2 years ago

0.1.146

2 years ago

0.1.149

2 years ago

0.1.148

2 years ago

0.1.144

2 years ago

0.1.143

4 years ago

0.1.142

4 years ago

0.1.141

4 years ago

0.1.140

4 years ago

0.1.139

4 years ago

0.1.138

4 years ago

0.1.137

4 years ago

0.1.136

4 years ago

0.1.135

4 years ago

0.1.134

4 years ago

0.1.133

4 years ago

0.1.132

4 years ago

0.1.131

4 years ago

0.1.129

4 years ago

0.1.130

4 years ago

0.1.128

4 years ago

0.1.127

4 years ago

0.1.126

4 years ago

0.1.125

4 years ago

0.1.124

4 years ago

0.1.123

4 years ago

0.1.122

4 years ago

0.1.119

4 years ago

0.1.121

4 years ago

0.1.120

4 years ago

0.1.118

4 years ago

0.1.117

4 years ago

0.1.116

4 years ago

0.1.115

4 years ago

0.1.114

4 years ago

0.1.113

4 years ago

0.1.112

4 years ago

0.1.110

4 years ago

0.1.111

4 years ago

0.1.109

4 years ago

0.1.108

4 years ago

0.1.107

4 years ago

0.1.106

4 years ago

0.1.105

4 years ago

0.1.104

4 years ago

0.1.103

4 years ago

0.1.102

4 years ago

0.1.101

4 years ago

0.1.100

4 years ago

0.1.99

4 years ago

0.1.98

4 years ago

0.1.97

4 years ago

0.1.96

4 years ago

0.1.95

4 years ago

0.1.94

4 years ago

0.1.93

4 years ago

0.1.92

4 years ago

0.1.91

4 years ago

0.1.90

4 years ago

0.1.89

4 years ago

0.1.88

4 years ago

0.1.87

4 years ago

0.1.86

4 years ago

0.1.84

4 years ago

0.1.83

4 years ago

0.1.82

5 years ago

0.1.81

5 years ago